C#

admin/Hr_Permission.aspx <%@ Page Title="" Language="C#" MasterPageFile="~/Admin/AdminMaster.master" AutoEventWireup="true" CodeFile="Hr_Permission.aspx.cs" Inherits="Admin_Default" %> <asp:Content ID="Content1" ContentPlaceHolderID="head" runat="Server"> </asp:Content> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">    <%-- <table width="100%" border="1" cellpadding="0" cellspacing="0">         <asp:Label ID="lblmsg" runat="server" ForeColor="Green"></asp:Label>         <tr>              <td valign="middle" class="Tab2" bgcolor="#CCCCCC">Coming Time             </td>             <td valign="middle" class="Tab2" bgcolor="#CCCCC

admin/hrInstantLeaveApproval.aspx.cs using System; using System.Collections.Generic; using System.Linq; 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 Admin_hrInstantLeaveApproval : System.Web.UI.Page {     MainClass dut = new MainClass();     DataAccessLayer dal = new DataAccessLayer();     protected void Page_Load(object sender, EventArgs e)     {         if(!IsPostBack)         {             bindEmployee();         }     }     public void bindEmployee()     {         string[] col4 = { "@Actiontype" };         object[] val4 = { "allemployeelist" };         DataSet ds4 = dal.getDataSet("ManageLeave", col4, val4);         if (ds4.Tables[0].Rows.Count > 0)         {             ddlEmployee.DataSource = ds4.Tables[0];             ddlEmployee.DataTextField = "name";             d

DataBase Changes  alter  proc [dbo].[ManageAttendance] @Id int, @User_Id int=null,   @Coming_Time datetime=null, @Going_Time datetime=null, @ByDate datetime=null, @StartDate datetime=null, @EndDate  datetime=null, @Status nvarchar(50)=null, @Coming_Message nvarchar(max)=null, @Going_Message nvarchar(max)=null, @isMeetingGoodMorning int=0, @Hr_Permission int=0, @Actiontype char(10) as begin  if(@Actiontype='Coming')  begin      insert into tbl_Attendance(User_Id,Coming_Time,Going_Time,Coming_Message,Status,isMeetingGoodMorning)    values (@User_Id,@Coming_Time,@Going_Time,@Coming_Message,@Status,@isMeetingGoodMorning)  end    else if(@Actiontype='select1')  begin      select a.*,datediff(month,b.date,getDate()) as numberOfMonth from tbl_Attendance a inner join tbl_Login b on a.User_Id=b.srno   where a.User_Id=@User_Id  end  else if(@Actiontype='Going')     begin      update tbl_Attendance set   Going_Time=@Going_Time,   Status=