Posts

Showing posts from February, 2020

Developer/developerGrantLeave.aspx

Developer/developerGrantLeave.aspx <%@ Page Title="" Language="C#" MasterPageFile="~/Developer/DeveloperMaster.master" AutoEventWireup="true" CodeFile="developerGrantLeave.aspx.cs" Inherits="Developer_developerGrantLeave" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">     <h6>Grant Leave </h6>     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="true">     <Columns>      <asp:TemplateField HeaderText="Sr.No." HeaderStyle-Width="59px">             <ItemTemplate >    <%#Container.DataItemIndex +1 %>    </ItemTemplate>         </asp:TemplateField>         ...

Developer/DeveloperLeaveStatus.aspx

Developer/DeveloperLeaveStatus.aspx <%@ Page Title="" Language="C#" MasterPageFile="~/Developer/DeveloperMaster.master" AutoEventWireup="true" CodeFile="DeveloperLeaveStatus.aspx.cs" Inherits="Developer_DeveloperLeaveStatus" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">     <h6>Applied Leave Status</h6>     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false" AllowPaging="true">     <Columns>      <asp:TemplateField HeaderText="Sr.No." HeaderStyle-Width="59px">             <ItemTemplate >    <%#Container.DataItemIndex +1 %>    </ItemTemplate>         </asp:TemplateField> ...

developer/developermain.aspx

DataBase alter procedure ManageLeave (  @dateFrom datetime=null,  @dateTo datetime=null,  @srno int=0,  @lastworkingday nvarchar(max)='',  @reportingday nvarchar(max)='',  @address nvarchar(max)='',  @mobilenumber varchar(20)='',  @JobsTODoBeforeLeave nvarchar(max)='',  @ReasonforLeave nvarchar(max)='',  @approvedBy int=0,  @Actiontype varchar(50) ) as begin       if(@Actiontype='approvedby')    begin        select srno,name from tbl_Login where srno>1 and srno!=@srno and status=1 order by name    end    else if(@Actiontype='insert')    begin         insert into tblLeave(dateFrom,dateTo,srno,lastworkingday,reportingday,address,mobilenumber,JobsTODoBeforeLeave, ReasonforLeave,approvedBy)values (@dateFrom,@dateTo,@srno,@lastworkingday,@reportingday,@address,@mobilenumber,@JobsTODoBeforeLeave,@Reas...