<%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="adminstrative.aspx.cs" Inherits="admin_adminstrative" %>
<%@ Register Assembly="DevExpress.Web.ASPxHtmlEditor.v18.2, Version=18.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web.ASPxHtmlEditor" TagPrefix="dx" %>

<%@ Register Assembly="DevExpress.Web.ASPxRichEdit.v18.2, Version=18.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web.ASPxRichEdit" TagPrefix="dx" %>
<%@ Register Assembly="CKEditor.NET" Namespace="CKEditor.NET" TagPrefix="CKEditor" %>

<%@ Register Assembly="DevExpress.Web.v18.2, Version=18.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>

<%@ Register assembly="DevExpress.Web.ASPxSpellChecker.v18.2, Version=18.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxSpellChecker" tagprefix="dx" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
     <script src="../ckeditor/_Samples/ckeditor/ckeditor.js"></script>
    <div class="content-wrapper" style=" background-image:url(adminimages/bg11.jpg); background-repeat:no-repeat; background-size:cover; height:100%;">
              <!-- Content Header (Page header) -->
    <section class="content-header" style="background-color: #ecf0f5;padding-bottom:10px;">
      <h1>
        Dashboard
        <small>Control panel</small>
      </h1>
      <ol class="breadcrumb">
        <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
        <li class="active">News</li>
      </ol>
    </section>
               <div id="lblsucess"  runat="server" class="alert alert-success" role="alert" visible="false">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Success!</strong> Message Saved successfully!
</div>
            <div id="lblfailed"  runat="server" class="alert alert-danger" role="alert" visible="false">
  <button type="button" class="close" data-dismiss="alert" aria-label="Close"><span aria-hidden="true">&times;</span></button>
  <strong>Failed!</strong> Please try again!
</div>
          <div style="margin:0px auto 0px; max-width:95%; padding:20px; background-color:rgba(255, 255, 255, 0.46);text-align:center; border-radius:0px 0px 10px 10px">
            
      <div style="background-color:rgba(255, 255, 255, 0.80); border:dashed;padding:10px;border-radius:10px 10px 10px 10px">
    <div class="row" style="text-align:center; font-size:30px; font-family:'Lucida Sans', 'Lucida Sans Regular', 'Lucida Grande', 'Lucida Sans Unicode', Geneva, Verdana, sans-serif;font-weight:bold;">
        <div class="form-group">
            <div class="col-lg-12">
         Department
                  
            </div>
        </div>
    </div>
            
              <div class="row" style="font-family:'Lucida Sans', 'Lucida Sans Regular', 'Lucida Grande', 'Lucida Sans Unicode', Geneva, Verdana, sans-serif;padding:0px; text-align:left;font-weight:bold">
             <div class="form-group">
              <div class="col-lg-4">
                  <asp:Label ID="lblfileupload" runat="server" Text="Image Upload"></asp:Label>
                  <asp:FileUpload ID="FileUpload1" runat="server" />
              </div>
                  <div class="col-lg-4">
                 <asp:Label ID="Label1" runat="server" Text="Name"></asp:Label>
                      <dx:ASPxTextBox ID="txtname" runat="server" CssClass="form-control" NullText="Name..." Width="100%">
                          <ValidationSettings>
                              <RequiredField IsRequired="true" ErrorText="Name is Required" />
                          </ValidationSettings>
                      </dx:ASPxTextBox>
              </div>
                  <div class="col-lg-4">
                 <asp:Label ID="Label2" runat="server" Text="DOJ"></asp:Label>
                      
                      <dx:ASPxDateEdit ID="txtdoj" runat="server" CssClass="form-control" Width="100%">
                            <ValidationSettings>
                              <RequiredField IsRequired="true" ErrorText="DOJ is Required" />
                          </ValidationSettings>
                      </dx:ASPxDateEdit>
              </div>
               
             </div>
          </div>  
              <div class="row" style="font-family:'Lucida Sans', 'Lucida Sans Regular', 'Lucida Grande', 'Lucida Sans Unicode', Geneva, Verdana, sans-serif;padding:0px; text-align:left;font-weight:bold">
              <div class="form-group">
                  <div class="col-lg-4">
                  <asp:Label ID="Label3" runat="server" Text="Designation/Qualfication"></asp:Label>
                        <dx:ASPxTextBox ID="txtdesignation" runat="server" CssClass="form-control" NullText="Designation..." Width="100%">
                              <ValidationSettings>
                              <RequiredField IsRequired="true" ErrorText="Designation is Required"/>  
                          </ValidationSettings>
                        </dx:ASPxTextBox>
              </div>
                        <div class="col-lg-4">
                  <asp:Label ID="Label4" runat="server" Text="Father/Husband Name"></asp:Label>
                        <dx:ASPxTextBox ID="txtfather" runat="server" CssClass="form-control" NullText="Father/Husband Name..." Width="100%">
                              <ValidationSettings>
                              <RequiredField IsRequired="true" ErrorText="Father/Husband Name is Required"/>  
                          </ValidationSettings>
                        </dx:ASPxTextBox>
              </div>
                  <div class="col-lg-4">
                  <asp:Label ID="Label5" runat="server" Text="Choose Department"></asp:Label>
                      <dx:ASPxComboBox ID="txtcombo" runat="server" ValueType="System.String" Width="100%" CssClass="form-control">
                        <Items>
                            <dx:ListEditItem Text="Administrative"/>
                             <dx:ListEditItem Text="Nursing"/>
                             <dx:ListEditItem Text="Physiotherapy"/>
                        </Items>
                      
                      </dx:ASPxComboBox>

              </div>
                  </div>
          </div>

          <div class="row" style="text-align:center; font-size:30px; font-family:'Lucida Sans', 'Lucida Sans Regular', 'Lucida Grande', 'Lucida Sans Unicode', Geneva, Verdana, sans-serif;font-weight:bold;">
        <div class="form-group">
            <div class="col-lg-12">
                <dx:ASPxButton ID="btnsubmit" runat="server" Text="Submit" OnClick="btnsubmit_Click" CssClass="submit"></dx:ASPxButton>
            </div>
        </div>
    </div>  
        
      </div>
        <div class="clearfix"></div>
  <div class="row">
      <div class="col-lg-12" style="text-align:left">
             <dx:ASPxGridView ID="ASPxGridView1" runat="server" Width="100%" Theme="Aqua" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" EnableTheming="True" KeyFieldName="ID">
             <Toolbars>
                 <dx:GridViewToolbar>
                     <Items>
                         <dx:GridViewToolbarItem Command="Refresh"></dx:GridViewToolbarItem>
                     </Items>
                 </dx:GridViewToolbar>
             </Toolbars>
              <SettingsSearchPanel Visible="True" />
              <Columns>

                  <dx:GridViewCommandColumn ShowEditButton="True" VisibleIndex="0" ShowDeleteButton="True"></dx:GridViewCommandColumn>
                  <dx:GridViewDataTextColumn FieldName="Title" VisibleIndex="2"></dx:GridViewDataTextColumn>
                  <dx:GridViewDataTextColumn FieldName="Father" VisibleIndex="3"></dx:GridViewDataTextColumn>
                  <dx:GridViewDataTextColumn FieldName="Designation" VisibleIndex="4"></dx:GridViewDataTextColumn>


                  <dx:GridViewDataTextColumn FieldName="Doj" VisibleIndex="5">
                  </dx:GridViewDataTextColumn>

                  <dx:GridViewDataImageColumn FieldName="imagePath" VisibleIndex="1"></dx:GridViewDataImageColumn>
                  <dx:GridViewDataTextColumn FieldName="Department" VisibleIndex="6">
                  </dx:GridViewDataTextColumn>

                  <dx:GridViewDataDateColumn FieldName="Datetime" VisibleIndex="7"></dx:GridViewDataDateColumn>
              </Columns>
          </dx:ASPxGridView>
          <asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:con %>' SelectCommand="SELECT * FROM [tbl_Department]" DeleteCommand="DELETE FROM [tbl_Department] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tbl_Department] ([Title], [Father], [Designation], [Doj], [imagePath], [Department], [Datetime]) VALUES (@Title, @Father, @Designation, @Doj, @imagePath, @Department, @Datetime)" UpdateCommand="UPDATE [tbl_Department] SET [Title] = @Title, [Father] = @Father, [Designation] = @Designation, [Doj] = @Doj, [imagePath] = @imagePath, [Department] = @Department, [Datetime] = @Datetime WHERE [ID] = @ID">
              <DeleteParameters>
                  <asp:Parameter Name="ID" Type="Int32" />
              </DeleteParameters>
              <InsertParameters>
                  <asp:Parameter Name="Title" Type="String" />
                  <asp:Parameter Name="Father" Type="String" />
                  <asp:Parameter Name="Designation" Type="String" />
                  <asp:Parameter Name="Doj" Type="String" />
                  <asp:Parameter Name="imagePath" Type="String" />
                  <asp:Parameter Name="Department" Type="String"></asp:Parameter>
                  <asp:Parameter Name="Datetime" Type="DateTime"></asp:Parameter>
              </InsertParameters>
              <UpdateParameters>
                  <asp:Parameter Name="Title" Type="String" />
                  <asp:Parameter Name="Father" Type="String" />
                  <asp:Parameter Name="Designation" Type="String" />
                  <asp:Parameter Name="Doj" Type="String" />
                  <asp:Parameter Name="imagePath" Type="String" />
                  <asp:Parameter Name="Department" Type="String" />
                  <asp:Parameter Name="Datetime" Type="DateTime"></asp:Parameter>
                  <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
              </UpdateParameters>
          </asp:SqlDataSource>
      </div>
  </div>
           </div>
        </div>
</asp:Content>