<%@ page language="C#" masterpagefile="~/MasterFile/TimeCheck.master" autoeventwireup="true" inherits="Transactions_TA_UI_Transactions_Attendance_OracleExport, App_Web_k4soorg1" title="Attendance_OracleExport" %>

<asp:Content ID="Content1" ContentPlaceHolderID="BodyContentPH" runat="Server">
    <table width="650px" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                <table border="0" cellspacing="0" cellpadding="0">
                    <tr>
                        <td valign="top" style="width: 16px">
                            <img src="../Images/corner1<%=Session["Direction"] %>.gif" width="15" height="15" /></td>
                        <td valign="top" background="../Images/sideline.gif" bgcolor="#EAEAEA">
                            <img src="../Images/spacer.gif" width="1" height="1" /></td>
                        <td valign="top" style="width: 16px">
                            <img src="../Images/corner2<%=Session["Direction"] %>.gif" width="15" height="15" /></td>
                    </tr>
                    <tr>
                        <td background="../Images/line<%=Session["Direction"] %>.gif" style="width: 16px">
                            &nbsp;</td>
                        <td valign="top" bgcolor="#EAEAEA">
                            <table border="0" align="center" cellpadding="2" cellspacing="1" width="650">
                                <tr>
                                    <td valign="top" colspan="2" class="ModuleTitle" align="left" style="height: 23px">
                                        <asp:Label ID="lblLateEntry" runat="server" Text="Attendance-Oracle Export"></asp:Label></td>
                                </tr>
                                <tr>
                                    <td colspan="5">
                                        <%--<input id="Hidden1" type="hidden" value='<% Response.Write(Convert.ToString(Session["IDateFormat"])); %>'/>--%>
                                        <asp:HiddenField ID="Hidden1" runat="server" />
                                        <div id="divEmployeeDetails" runat="server">
                                        </div>
                                    </td>
                                </tr>
                                <tr>
                                    <td class="td">
                                        <asp:Label ID="lblDate" Text="Attendance Date" runat="server"></asp:Label></td>
                                    <td class="td" align="left">
                                    <asp:TextBox onpaste="return true"     ID="txtFromDate" runat="server" CssClass="textbox_4" OnCut="return false" OnDrop="return false"
                                    EnableViewState="false" MaxLength="25" ></asp:TextBox>
                                        <%--<asp:TextBox onpaste="return true"     ID="txtFromDate" runat="server" CssClass="textbox_4" onCut="return false"
                                            onDrop="return false"  MaxLength="25" EnableViewState="false"></asp:TextBox>--%>
                                        <input type="image" src="../../Images/dateicon.gif" id="butFromDate" runat="server" />

                                        <script type="text/javascript">
                                Calendar.setup({
                                    inputField     :    "ctl00_BodyContentPH_txtFromDate",      // id of the input field
                                    ifFormat       :    document.getElementById('ctl00_BodyContentPH_Hidden1').value,       // format of the input field
                                    showsTime      :    false,            // will display a time selector
                                    button         :    "ctl00_BodyContentPH_butFromDate",   // trigger for the calendar (button ID)
                                    singleClick    :    true,           // double-click mode
                                    step           :    1                // show all years in drop-down boxes (instead of every other year as default)
                                });
                                        </script>

                                    </td>
                                </tr>
                                <tr>
                                    <td align="center" valign="middle" style="height: 32px" colspan="2">
                                        <asp:Button ID="btn_View" CssClass="but" runat="server" Text="VIEW" OnClientClick="return DateEntryValidation()" OnClick="btn_View_Click" /></td>
                                </tr>
                                <tr>
                                    <td class="ModuleHeadtd" colspan="2" align="center">
                                        <asp:GridView ID="grv_Attendence_OracleExport" runat="server" AutoGenerateColumns="False"
                                            AllowPaging="True" CssClass="td" Width="100%" AllowSorting="True" DataKeyNames="Employee Code"
                                            PageSize="10" BorderColor="white" BorderWidth="1px" OnPageIndexChanging="grv_Attendence_OracleExport_PageIndexChanging"
                                            OnSorting="grv_Attendence_OracleExport_Sorting">
                                            <RowStyle Height="30px" />
                                            <Columns>
                                                <asp:TemplateField HeaderText="Employee Code" SortExpression="Employee Code" HeaderStyle-BorderStyle="Solid"
                                                    HeaderStyle-BorderWidth="1px" HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid"
                                                    ItemStyle-BorderColor="#FFFFFF" ItemStyle-BorderWidth="1px" ItemStyle-Width="15%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblEmpId" Text='<%# Eval("Employee Code") %>' runat="server"></asp:Label>
                                                        <asp:HiddenField ID="lblProcess_Rec_ID" Value='<%# Eval("Employee Code") %>' runat="server" />
                                                        <%--<edititemtemplate>
                                                    <asp:Label ID="Label2" Text='<%# Bind("Employee Code") %>' runat="server" Visible="false" ></asp:Label>
                                                    </edititemtemplate>--%>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Employee Name" SortExpression="Employee Name" HeaderStyle-BorderStyle="Solid"
                                                    HeaderStyle-BorderWidth="1px" HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid"
                                                    ItemStyle-BorderColor="#FFFFFF" ItemStyle-BorderWidth="1px" ItemStyle-Width="20%">
                                                    <%--<EditItemTemplate>
                                                <asp:HiddenField ID="htnPresentday" runat="server" Value='<%# Bind("Employee Name") %>' />
                                                <asp:TextBox onpaste="return true"     ID="txtPresentDays" runat="server" Text='<%# Bind("Employee Name") %>'
                                                    CssClass="textbox_4" MaxLength="5" Width="40px"></asp:TextBox>
                                            </EditItemTemplate>--%>
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblPresentDays" Text='<%# Eval("Employee Name") %>' runat="server">
                                                        </asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="In Time" HeaderStyle-BorderStyle="Solid" HeaderStyle-BorderWidth="1px"
                                                    HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid" ItemStyle-BorderColor="#FFFFFF"
                                                    ItemStyle-BorderWidth="1px" ItemStyle-Width="12%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblOD" Text='<%# Eval("In Time") %>' runat="server"></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="Out Time" HeaderStyle-BorderStyle="Solid" HeaderStyle-BorderWidth="1px"
                                                    HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid" ItemStyle-BorderColor="#FFFFFF"
                                                    ItemStyle-BorderWidth="1px" ItemStyle-Width="15%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblEL" Text='<%# Eval("Out Time") %>' runat="server"></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="No of Hours" HeaderStyle-BorderStyle="Solid" HeaderStyle-BorderWidth="1px"
                                                    HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid" ItemStyle-BorderColor="#FFFFFF"
                                                    ItemStyle-BorderWidth="1px" ItemStyle-Width="12%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblCL" Text='<%# Eval("No of Hours") %>' runat="server"></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <asp:TemplateField HeaderText="No of OT Hours" HeaderStyle-BorderStyle="Solid" HeaderStyle-BorderWidth="1px"
                                                    HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid" ItemStyle-BorderColor="#FFFFFF"
                                                    ItemStyle-BorderWidth="1px" ItemStyle-Width="15%">
                                                    <ItemTemplate>
                                                        <asp:Label ID="lblSL" Text='<%# Eval("No of OT Hours") %>' runat="server"></asp:Label>
                                                    </ItemTemplate>
                                                </asp:TemplateField>
                                                <%--<asp:TemplateField HeaderText="Total" HeaderStyle-BorderStyle="Solid" HeaderStyle-BorderWidth="1px"
                                            HeaderStyle-BorderColor="#FFFFFF" ItemStyle-BorderStyle="Solid" ItemStyle-BorderColor="#FFFFFF"
                                            ItemStyle-BorderWidth="1px">
                                            <ItemTemplate>
                                                <asp:Label ID="lblTotal" Text='<%# Eval("Total") %>' runat="server"></asp:Label>
                                            </ItemTemplate>
                                        </asp:TemplateField>--%>
                                            </Columns>
                                            <RowStyle Height="30px" />
                                            <PagerStyle BorderColor="#FFFFFF" BorderStyle="solid" BorderWidth="1px" VerticalAlign="Bottom"
                                                HorizontalAlign="Right" Font-Overline="False" Font-Size="Smaller" />
                                            <PagerSettings Mode="NumericFirstLast" FirstPageText="First" LastPageText="Last"
                                                NextPageText="Next" PreviousPageText="&lt;" />
                                        </asp:GridView>
                                    </td>
                                </tr>
                                <tr>
                                
                                <td align="center" valign="middle" style="height: 32px" colspan="2">
                                        <asp:Button ID="btnExportToOracle" CssClass="but" runat="server" Text="EXPORT TO ORACLE" Visible="false" Width="160px"  />
                                </td>
                                </tr>
                            </table>
                        </td>
                        <td background="../Images/line1<%=Session["Direction"] %>.gif" style="width: 16px">
                            &nbsp;</td>
                    </tr>
                    <tr>
                        <td valign="bottom" style="width: 16px; height: 16px">
                            <img src="../Images/corner3<%=Session["Direction"] %>.gif" width="15" height="16" /></td>
                        <td valign="bottom" background="../Images/sideline1.gif" bgcolor="#EAEAEA" style="height: 16px">
                            <img src="../Images/spacer.gif" width="1" height="1" /></td>
                        <td valign="bottom" style="width: 16px; height: 16px">
                            <img src="../Images/corner4<%=Session["Direction"] %>.gif" width="15" height="16" /></td>
                    </tr>
                </table>
            </td>
        </tr>
    </table>


</asp:Content>
