protected void DetailsView1_ItemInserting(object sender, DetailsViewInsertEventArgs e)
    {
        FileUpload imageUpload = (FileUpload)DetailsView1.FindControl("FileUpload1");

        e.Values["CategoryAvatarUrl"] = imageUpload.FileName;
        e.Values["AddedDate"] = DateTime.Now;
        

    }

<%@ Page Title="Ruby Admin | Cateogries" Language="C#" MasterPageFile="~/Masters/AdminMaster.master" AutoEventWireup="true" CodeFile="Categories.aspx.cs" Inherits="Admin_Categories" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .addCategory
        {}
        </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="CpReadable" Runat="Server">
    <div class="pageContent">
    <h1>Categories Administration</h1>
    <p>
    On this page, you can create new or edit existing categories. You can even delete categories you don't want to use 
    anymore; however, before deleting an category, you <strong>MUST</strong> delete all the services that belong to that 
    category.
    </p>

    <h1>Edit Categories</h1>

    List of all available categories: 
    <br />
    <asp:UpdatePanel ID="UpdatePanel1" runat="server">
    <ContentTemplate>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True" 
            AutoGenerateColumns="False" DataKeyNames="ServiceCategoryID" 
            DataSourceID="CategorySqlDataSource" CssClass="gridView">
        <AlternatingRowStyle CssClass="alteringRows" />
        <Columns>
            <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
            <asp:BoundField DataField="ServiceCategoryID" HeaderText="CategoryID" 
                InsertVisible="False" ReadOnly="True" SortExpression="ServiceCategoryID" />
            <asp:BoundField DataField="Category" HeaderText="Category" 
                SortExpression="Category" />
            <asp:BoundField DataField="CategoryAvatarUrl" HeaderText="Category Image" 
                SortExpression="CategoryAvatarUrl" />
            <asp:BoundField DataField="Description" HeaderText="Description" 
                SortExpression="Description" />
            <asp:BoundField DataField="AddedDate" DataFormatString="{0:d}" 
                HeaderText="AddedDate" SortExpression="AddedDate" />
        </Columns>
    </asp:GridView>

       
        <asp:SqlDataSource ID="CategorySqlDataSource" runat="server" 
            ConflictDetection="CompareAllValues" 
            ConnectionString="<%$ ConnectionStrings:RubyDBConnectionString %>" 
            DeleteCommand="DELETE FROM [ServiceCategoryTable] WHERE [ServiceCategoryID] = @original_ServiceCategoryID AND [Category] = @original_Category AND [CategoryAvatarUrl] = @original_CategoryAvatarUrl AND (([Description] = @original_Description) OR ([Description] IS NULL AND @original_Description IS NULL)) AND [AddedDate] = @original_AddedDate" 
            InsertCommand="INSERT INTO [ServiceCategoryTable] ([Category], [CategoryAvatarUrl], [Description], [AddedDate]) VALUES (@Category, @CategoryAvatarUrl, @Description, @AddedDate)" 
            OldValuesParameterFormatString="original_{0}" 
            SelectCommand="SELECT * FROM [ServiceCategoryTable]" 
            UpdateCommand="UPDATE [ServiceCategoryTable] SET [Category] = @Category, [CategoryAvatarUrl] = @CategoryAvatarUrl, [Description] = @Description, [AddedDate] = @AddedDate WHERE [ServiceCategoryID] = @original_ServiceCategoryID AND [Category] = @original_Category AND [CategoryAvatarUrl] = @original_CategoryAvatarUrl AND (([Description] = @original_Description) OR ([Description] IS NULL AND @original_Description IS NULL)) AND [AddedDate] = @original_AddedDate">
            <DeleteParameters>
                <asp:Parameter Name="original_ServiceCategoryID" Type="Int32" />
                <asp:Parameter Name="original_Category" Type="String" />
                <asp:Parameter Name="original_CategoryAvatarUrl" Type="String" />
                <asp:Parameter Name="original_Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="original_AddedDate" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="CategoryAvatarUrl" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="AddedDate" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="Category" Type="String" />
                <asp:Parameter Name="CategoryAvatarUrl" Type="String" />
                <asp:Parameter Name="Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="AddedDate" />
                <asp:Parameter Name="original_ServiceCategoryID" Type="Int32" />
                <asp:Parameter Name="original_Category" Type="String" />
                <asp:Parameter Name="original_CategoryAvatarUrl" Type="String" />
                <asp:Parameter Name="original_Description" Type="String" />
                <asp:Parameter DbType="DateTime2" Name="original_AddedDate" />
            </UpdateParameters>
        </asp:SqlDataSource>

       
        <br />

       
        <h1>Add Categories</h1>
       
        <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
            DataKeyNames="ServiceCategoryID" DataSourceID="CategorySqlDataSource" 
            DefaultMode="Insert" Height="50px" oniteminserting="DetailsView1_ItemInserting" 
            Width="125px">
            <Fields>
                <asp:BoundField DataField="ServiceCategoryID" HeaderText="ServiceCategoryID" 
                    InsertVisible="False" ReadOnly="True" SortExpression="ServiceCategoryID" />
                <asp:BoundField DataField="Category" HeaderText="Category" 
                    SortExpression="Category" />
                <asp:TemplateField HeaderText="CategoryAvatarUrl" 
                    SortExpression="CategoryAvatarUrl">
                    <InsertItemTemplate>
                        <asp:FileUpload ID="FileUpload1" runat="server" />
                    </InsertItemTemplate>
                    <EditItemTemplate>
                        <asp:TextBox ID="TextBox1" runat="server" 
                            Text='<%# Bind("CategoryAvatarUrl") %>'></asp:TextBox>
                    </EditItemTemplate>
                    <ItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryAvatarUrl") %>'></asp:Label>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="Description" HeaderText="Description" 
                    SortExpression="Description" />
                <asp:BoundField DataField="AddedDate" HeaderText="AddedDate" 
                    SortExpression="AddedDate" />
                <asp:CommandField ShowInsertButton="True" />
            </Fields>
        </asp:DetailsView>
       
        <br />
        <br />
        
        <br />
        </ContentTemplate>
      </asp:UpdatePanel>
</div>
</asp:Content>