C#

DataBase ManageAttendance sp ko open kar ke colour part ko add karke alter kar lena ya pura copy kar ke execute kar lena es SP ko alter proc [dbo].[ManageAttendance] @Id int, @User_Id int=null,   @Coming_Time datetime=null, @Going_Time datetime=null, @ByDate datetime=null, @Status nvarchar(50)=null, @Coming_Message nvarchar(max)=null, @Going_Message nvarchar(max)=null, @Actiontype char(10) as  begin  if(@Actiontype='Coming') begin      insert into tbl_Attendance(User_Id,Coming_Time,Going_Time,Status,Coming_Message) values (@User_Id,@Coming_Time,@Going_Time,@Status,@Coming_Message) end    else if(@Actiontype='select1') begin      select * from tbl_Attendance where User_Id=@User_Id end else if(@Actiontype='midtime') begin      select * from tbl_Attendance where User_Id=@User_Id and cast(Coming_Time as Date) between cast(@Coming_Time as Date) and cast(@Going_Time as Date) ...

Admin->edit_attendance.aspx.cs // bindDoneReminders   function ko find karke pura replace kar lena private void bindDoneReminders(int User_Id, DateTime StartDate)     {         try         {             DoneReminders = "";             if (Session["admin_srno"] != null)             {                 string[] col1 = { "@srno", "@Actiontype" };                 object[] val1 = { User_Id, "select9" };                 DataSet ds = dal.getDataSet("ManageLogin", col1, val1);                 var list = new List<SqlParameter>();                 list.Add(new SqlParameter("@Id", "0"));             ...