Posts

some changes for DeveloperLeave 2

Developer/DeveloperLeave.aspx.cs using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; public partial class Developer_DeveloperLeave : System.Web.UI.Page {     MainClass dut = new MainClass();     DataAccessLayer dal = new DataAccessLayer();     protected void Page_Load(object sender, EventArgs e)     {         if (Request.Cookies["developer_srno"] != null)         {             var value = Request.Cookies["developer_srno"].Value;             if (value == "")             {                 Response.Redirect("~/Pr-Admin-Log");             }             Session["developer_srno"] = value; ...
Post a Comment
Read more

some changes

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...
Post a Comment
Read more

Developr leave

DataBase create table tblLeave (  id int identity(1,1),  dateFrom datetime,  dateTo datetime,  srno int,  lastworkingday nvarchar(max),  reportingday nvarchar(max),  address nvarchar(max),  mobilenumber varchar(20),  JobsTODoBeforeLeave nvarchar(max),  ReasonforLeave nvarchar(max),  approvedBy int,  approvedStatus int default 0,  submitedDate datetime default getDate()  ) 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 srn...
Post a Comment
Read more

lave page for developer

<%@ Page Title="" Language="C#" MasterPageFile="~/Developer/DeveloperMaster.master" AutoEventWireup="true" CodeFile="DeveloperLeave.aspx.cs" Inherits="Developer_DeveloperLeave" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">     <h5>Leave Application Form (Please fill this form atleast 7 days before.)</h5>     <table width="100%" border="1" cellpadding="0" cellspacing="0">         <tr>             <td>Date From:  </td><td><input type="date" placeholder="dd/mm/yyyyy" /></td><td>Date To:  </td><td><input type="date" placeholder="dd/mm/yyyyy" /></td>  ...
Post a Comment
Read more

1) Latest Excel Sheet

Admin/Attendance.aspx.cs download_XL_Click  please find and replace this function protected void download_XL_Click(object sender, EventArgs e)     {         if (ddlusers.SelectedValue == "0" && txt_from.Text != "" && txt_to.Text != "")         {             try             {                 string[] col1 = { "@dateFrom", "@dateTo" };                 object[] val1 = { txt_from.Text, txt_to.Text };                 DataSet ds = dal.getDataSet("USPAttendanceReport", col1, val1);                 ClosedXML.Excel.XLWorkbook wb = new ClosedXML.Excel.XLWorkbook();                 var ws = wb.Worksheets.Add("Attendance");         ...
Post a Comment
Read more