<%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="youtube_links.aspx.cs" Inherits="admin_youtube_links" %>
<%@ Register Assembly="DevExpress.Web.v19.2, Version=19.2.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" Namespace="DevExpress.Web" TagPrefix="dx" %>
<%@ Register Assembly="CKEditor.NET" Namespace="CKEditor.NET" TagPrefix="CKEditor" %>

<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">
         Latest News
            </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-12" style="text-align:left">
                                   <asp:TextBox ID="CKEditorControl1" runat="server" Placeholder="Insert Youtube Link" CssClass="form-control"></asp:TextBox>
                                 
                                  <%-- <CKEditor:CKEditorControl ID="CKEditorControl1" runat="server" BasePate="../ckeditor/"  CssClass="table-responsive"></CKEditor:CKEditorControl>--%>
                                                                 </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"/>
                                  </div>
                              </div>
                          </td>
                      </tr>
                  </table>
              </div>
             
             </div>
          </div>  
        
      </div>
        <div class="clearfix"></div>
              <br />
    <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">
              <Columns>
          
               
                  <dx:GridViewCommandColumn ShowDeleteButton="True" ShowEditButton="false" VisibleIndex="0">
                  </dx:GridViewCommandColumn>
          
               
                  <dx:GridViewDataTextColumn FieldName="youlink" VisibleIndex="1" Caption="Youtube Link"></dx:GridViewDataTextColumn>
                
                  <dx:GridViewDataTextColumn FieldName="datetime" VisibleIndex="2" Caption="Date/Time">
                  </dx:GridViewDataTextColumn>
                
              </Columns>
          </dx:ASPxGridView>
          <asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:con %>' DeleteCommand="DELETE FROM [tbl_youtube] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tbl_youtube] ([youlink], [datetime], [date]) VALUES (@youlink, @datetime, @date)" SelectCommand="SELECT * FROM [tbl_youtube] ORDER BY [ID] DESC" UpdateCommand="UPDATE [tbl_youtube] SET [youlink] = @youlink, [datetime] = @datetime, [date] = @date WHERE [ID] = @ID">
              <DeleteParameters>
                  <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
              </DeleteParameters>
              <InsertParameters>
                  <asp:Parameter Name="youlink" Type="String"></asp:Parameter>
                  <asp:Parameter Name="datetime" Type="String"></asp:Parameter>
                  <asp:Parameter Name="date" Type="DateTime"></asp:Parameter>
              </InsertParameters>
              <UpdateParameters>
                  <asp:Parameter Name="youlink" Type="String"></asp:Parameter>
                  <asp:Parameter Name="datetime" Type="String"></asp:Parameter>
                  <asp:Parameter Name="date" Type="DateTime"></asp:Parameter>
                  <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
              </UpdateParameters>
          </asp:SqlDataSource>
     
      </div>
  </div>
           </div>
        
        </div>
</asp:Content>