<%@ Page Title="" Language="C#" MasterPageFile="~/admin/admin.master" AutoEventWireup="true" CodeFile="latest_news.aspx.cs" Inherits="admin_latest_news" %>

<%@ 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" %>

<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>Deleted!</strong> Deleted successfully!
</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="txtheading" runat="server" CssClass="form-control" Placeholder="Heading"></asp:TextBox>
                                   <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="You Can't Leave Empty" ForeColor="red" ControlToValidate="txtheading" Display="Dynamic"></asp:RequiredFieldValidator>
                                 </div>
                          </td>
                      </tr>
                      <tr>
                          <td>
                               <div class="col-lg-12" style="text-align:center">
                            <asp:Label ID="lblmessage" runat="server" Text="Page Content"></asp:Label>
                                 </div>
                          </td>
                      </tr>
                      <tr>
                          <td>                     
                               <div class="row">
                                 <div class="col-lg-12">
                                     <CKEditor:CKEditorControl ID="CKEditorControl1" runat="server" BasePate="../ckeditor/"  CssClass="table-responsive"></CKEditor:CKEditorControl>
                                 
                                           </div>
                             </div> 
                              <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>
                      <tr>
                          <td>
                               <div class="row">
                                  <div class="col-lg-12" style="text-align:center; padding-top:5px">
                                  
                                  </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">
          <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>
              <Columns>
                  <dx:GridViewCommandColumn VisibleIndex="0" ShowDeleteButton="false" ShowEditButton="false"></dx:GridViewCommandColumn>
              
                  <dx:GridViewDataTextColumn FieldName="heading" Caption="Heading" VisibleIndex="2"></dx:GridViewDataTextColumn>
               
                  <dx:GridViewDataTextColumn FieldName="Datetime" VisibleIndex="3"></dx:GridViewDataTextColumn>
                 <dx:GridViewDataColumn  Caption="Delete"  Width="70px" VisibleIndex="37" Visible="true">
    <DataItemTemplate>
        <asp:Button ID="btndelete" runat="server" Text="Delete" CssClass="reset" OnCommand="btndelete_Command" CausesValidation="false"  CommandArgument='<%#Eval("ID")%>'/>
    </DataItemTemplate>
</dx:GridViewDataColumn>
              </Columns>
          </dx:ASPxGridView>
          <asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:con %>' DeleteCommand="DELETE FROM [Latest_news] WHERE [ID] = @ID" InsertCommand="INSERT INTO [Latest_news] ([heading], [ckeditor], [Datetime], [date]) VALUES (@heading, @ckeditor, @Datetime, @date)" SelectCommand="SELECT * FROM [Latest_news] ORDER BY [ID] DESC" UpdateCommand="UPDATE [Latest_news] SET [heading] = @heading, [ckeditor] = @ckeditor, [Datetime] = @Datetime, [date] = @date WHERE [ID] = @ID">
              <DeleteParameters>
                  <asp:Parameter Name="ID" Type="Int32"></asp:Parameter>
              </DeleteParameters>
              <InsertParameters>
                  <asp:Parameter Name="heading" Type="String"></asp:Parameter>
                  <asp:Parameter Name="ckeditor" 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="heading" Type="String"></asp:Parameter>
                  <asp:Parameter Name="ckeditor" 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>