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

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <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">Founder</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> 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">
         Founder
            </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">
             <div class="form-group">
              <div class="col-lg-12">
                  <table style="width:100%;margin-left:auto;margin-right:auto">
                      
                        <tr>
                          <td>
                               <div class="col-lg-6" style="text-align:left">
                                   <asp:Label ID="lbl1" runat="server" Text="Choose Title"></asp:Label>
                                   <dx:ASPxTextBox ID="txttitle" runat="server" Width="100%" CssClass="form-control"></dx:ASPxTextBox>
                                 </div>
                           
                                <div class="col-lg-6" style="text-align:left">
                                     <asp:Label ID="lblchoosefile" runat="server" Text="Choose File"></asp:Label>
                                        <asp:FileUpload ID="filUpload2" runat="server" CssClass="form-control"/>
                                   <asp:RequiredFieldValidator ErrorMessage="Required" ControlToValidate="filUpload2"
    runat="server" Display="Dynamic" ForeColor="Red" />
<asp:RegularExpressionValidator ID="RegularExpressionValidator1" ValidationExpression="([a-zA-Z0-9\s_\\.\-:])+(.jpg|.jpeg|.png)$"
    ControlToValidate="filUpload2" runat="server" ForeColor="Red" ErrorMessage="Please select a valid PDF File file."
    Display="Dynamic" />
                                    </div>
                        
                          </td>
                      </tr>
                      <tr>
                          <td>
                               <div class="col-lg-12" style="text-align:center">
                         
                                 </div>
                          </td>
                      </tr>
                      <tr>
                          <td>                     
                              
                              <div class="row">
                                  <div class="col-lg-12" style="text-align:center; padding-top:5px">
                                        <%-- <asp:Button ID="btnsubmit" runat="server" Text="Save"  CssClass="submit" OnClick="btnsubmit_Click"/>--%>
                                      <dx:ASPxButton ID="btnsubmit" runat="server" Text="Save"  CssClass="submit" OnClick="btnsubmit_Click"></dx:ASPxButton>
                                  </div>
                              </div>
                          </td>
                      </tr>
                      <tr>
                          <td>
                               <div class="row">
                                  <div class="col-lg-12" style="text-align:center; padding-top:5px">
                                      <dx:ASPxGridView ID="ASPxGridView1" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" KeyFieldName="ID">
                                          <SettingsSearchPanel Visible="True" />
                                          <Columns>

                                              <dx:GridViewCommandColumn ShowEditButton="True" VisibleIndex="0" ShowDeleteButton="True"></dx:GridViewCommandColumn>
                                              <dx:GridViewDataTextColumn FieldName="title" VisibleIndex="1"></dx:GridViewDataTextColumn>


                                              <dx:GridViewDataTextColumn FieldName="link" VisibleIndex="2">
                                              </dx:GridViewDataTextColumn>
                                              <dx:GridViewDataDateColumn FieldName="Date" VisibleIndex="3">
                                              </dx:GridViewDataDateColumn>
                                            
                                          </Columns>
                                      </dx:ASPxGridView>
                                      <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:con %>" DeleteCommand="DELETE FROM [tbl_founder] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tbl_founder] ([title], [link], [Date]) VALUES (@title, @link, @Date)" SelectCommand="SELECT * FROM [tbl_founder] ORDER BY [ID] DESC" UpdateCommand="UPDATE [tbl_founder] SET [title] = @title, [link] = @link, [Date] = @Date WHERE [ID] = @ID">
                                          <DeleteParameters>
                                              <asp:Parameter Name="ID" Type="Int32" />
                                          </DeleteParameters>
                                          <InsertParameters>
                                              <asp:Parameter Name="title" Type="String" />
                                              <asp:Parameter Name="link" Type="String" />
                                              <asp:Parameter Name="Date" Type="DateTime" />
                                          </InsertParameters>
                                          <UpdateParameters>
                                              <asp:Parameter Name="title" Type="String" />
                                              <asp:Parameter Name="link" Type="String" />
                                              <asp:Parameter Name="Date" Type="DateTime" />
                                              <asp:Parameter Name="ID" Type="Int32" />
                                          </UpdateParameters>
                                      </asp:SqlDataSource>
                                  </div>
                              </div>
                          </td>
                      </tr>
                  </table>
              </div>
             
             </div>
          </div>  
        
      </div>
        <div class="clearfix"></div>
  <div class="row">
      <div class="col-lg-12" style="text-align:left">
     
      </div>
  </div>
           </div>
        </div>
</asp:Content>