public void CreateEmployee(Employees objEmployee)
    {
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        List<SqlParameter> lstMasterEmployeeDetail = new List<SqlParameter>();
        lstMasterEmployeeDetail.Add(new SqlParameter("@facultyId", objEmployee.Id));
        lstMasterEmployeeDetail.Add(new SqlParameter("@name", objEmployee.Name));
        lstMasterEmployeeDetail.Add(new SqlParameter("@joiningDate", objEmployee.JoiningDate));
        lstMasterEmployeeDetail.Add(new SqlParameter("@gender", objEmployee.Gender));
        lstMasterEmployeeDetail.Add(new SqlParameter("@createdOn", objEmployee.CreatedOn));
        lstMasterEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
        DataTable dt = new DataTable();
        DataSet ds;
        int EmployeeId;
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            ds = objDDBDataHelper.GetDataSet("spCreateEmployee", SQLTextType.Stored_Proc, lstMasterEmployeeDetail);
            EmployeeId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
        }
        List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
        lstEmployeeDetail.Add(new SqlParameter("@employeeId", EmployeeId));
        lstEmployeeDetail.Add(new SqlParameter("@roleId", objEmployee.RoleId));
        lstEmployeeDetail.Add(new SqlParameter("@departmentId", objEmployee.DepartmentId));
        lstEmployeeDetail.Add(new SqlParameter("@contactNumber", objEmployee.ContactNumber));
        lstEmployeeDetail.Add(new SqlParameter("@weeklyOffDay", objEmployee.WeeklyOffDay));
        lstEmployeeDetail.Add(new SqlParameter("@shiftId", objEmployee.ShiftId));
        lstEmployeeDetail.Add(new SqlParameter("@createdAt", objEmployee.CreatedOn));
        lstEmployeeDetail.Add(new SqlParameter("@updatedAt", objEmployee.UpdatedOn));
        lstEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            objDDBDataHelper.ExecSQL("spCreateEmployeeTransc", SQLTextType.Stored_Proc, lstEmployeeDetail);
        }

    }

    public List<TypeOfLeave> LeaveFromGivenMasterLeaveType(int masterLeaveType)
    {
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DBDataHelper helper = new DBDataHelper();
        List<SqlParameter> lstLeaveDetail = new List<SqlParameter>();
        string query = "select Id,Name from tblTypeOfLeave where [email protected]";
        lstLeaveDetail.Add(new SqlParameter("@masterleavetype", masterLeaveType));
        DataTable dt = new DataTable();
        DataSet ds;
        int i = 0;
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstLeaveDetail);
            List<TypeOfLeave> lstLeaveType = new List<TypeOfLeave>();
            foreach (DataRow rows in ds.Tables[0].Rows)
            {
                TypeOfLeave objLeaveType = new TypeOfLeave();
                objLeaveType.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
                objLeaveType.Name = (ds.Tables[0].Rows[i][1]).ToString();
                lstLeaveType.Add(objLeaveType);
                i++;
            }
            return lstLeaveType;
        }

    }

    public bool UpdateEmployee(Employees objEmployee)
    {
        List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
        lstEmployeeDetail.Add(new SqlParameter("@employeeId", objEmployee.Id));
        lstEmployeeDetail.Add(new SqlParameter("@gender", objEmployee.Gender));
        lstEmployeeDetail.Add(new SqlParameter("@joiningDate", objEmployee.JoiningDate));
        lstEmployeeDetail.Add(new SqlParameter("@isDeleted", false));
        lstEmployeeDetail.Add(new SqlParameter("@updatedOn", DateTime.Now));
        lstEmployeeDetail.Add(new SqlParameter("@password", objEmployee.Password));
        lstEmployeeDetail.Add(new SqlParameter("@roleId", objEmployee.RoleId));
        lstEmployeeDetail.Add(new SqlParameter("@departmentId", objEmployee.DepartmentId));
        lstEmployeeDetail.Add(new SqlParameter("@contactNumber", objEmployee.ContactNumber));
        lstEmployeeDetail.Add(new SqlParameter("@weeklyOffDay", objEmployee.WeeklyOffDay));
        lstEmployeeDetail.Add(new SqlParameter("@shiftId", objEmployee.ShiftId));
        DataTable dt = new DataTable();
        try
        {
            using (DBDataHelper objDDBDataHelper = new DBDataHelper())
            {
                objDDBDataHelper.ExecSQL("spUpdateEmployeeByEmployeeId", SQLTextType.Stored_Proc, lstEmployeeDetail);

            }
            return true;
        }
        catch(Exception ex)
        {
            return false;
        }
    }

    protected void Calendar1_SelectionChanged(object sender, EventArgs e)
    {
        BindData();
        lblDate.Text = Calendar1.SelectedDate.Date.ToString("d");
        txtHoliday.Text = "";
        btnAddHoliday.Text = "Add Holiday";
        btnAddHoliday.Enabled = true;

        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DBDataHelper helper = new DBDataHelper();
        string query = @"SELECT [NameOfHoliday]
                         FROM [tblHolidays]
                         WHERE Date = @date";
        List<SqlParameter> lst_params = new List<SqlParameter>();
        lst_params.Add(new SqlParameter("@date", Calendar1.SelectedDate));
        DataTable dt = new DataTable();
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            dt = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lst_params);
            if (dt != null && dt.Rows.Count > 0)
            {
                btnAddHoliday.Enabled = false;
                btnAddHoliday.Text = "Holiday Exists";
                txtHoliday.Text = dt.Rows[0][0] == DBNull.Value ? "" : dt.Rows[0][0].ToString();
            }
        }
    }

 public List<Employees> GetEmployeesPresentDateWise(DateTime dateTime)
 {
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     List<Employees> lstEmployees = new List<Employees>();
     List<SqlParameter> lstAttendanceDetail = new List<SqlParameter>();
     lstAttendanceDetail.Add(new SqlParameter("@date", dateTime));
     int i = 0;
     DataSet ds = new DataSet();
     try
     {
         using (DBDataHelper objDDBDataHelper = new DBDataHelper())
         {
             ds = objDDBDataHelper.GetDataSet("spGetEmployeesPresentDateWise", SQLTextType.Stored_Proc, lstAttendanceDetail);
         }
     }
     catch (Exception ex)
     {
         return lstEmployees;
     }
     foreach (DataRow rows in ds.Tables[0].Rows)
     {
         Employees objEmployees = new Employees();
         objEmployees.Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
         objEmployees.FirstName = ds.Tables[0].Rows[i][1].ToString();
         objEmployees.MiddleName = ds.Tables[0].Rows[i][2].ToString();
         objEmployees.LastName = ds.Tables[0].Rows[i][3].ToString();
         lstEmployees.Add(objEmployees);
         i++;
     }
     return lstEmployees;
 }

 public List<AssignLeaveViewModel> BindGridData()
 {
     MasterEntries objMasterEntries = new MasterEntries();
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     DataTable dt = new DataTable();
     List<SqlParameter> lstData = new List<SqlParameter>();
     lstData.Add(new SqlParameter("@employeeId", Convert.ToInt32(Session["employeeId"])));
     lstData.Add(new SqlParameter("@dateMonth", Calendar1.SelectedDate.Month));
     lstData.Add(new SqlParameter("@dateYear", Calendar1.SelectedDate.Year));
     lstData.Add(new SqlParameter("@IsDeleted", Convert.ToInt32(0)));
     DataSet ds;
     int i = 0;
     string query = "SELECT Id , LeaveTypeId , [Date] FROM tblLeave WHERE MONTH([Date]) = @dateMonth AND YEAR([Date]) = @dateYear And EmployeeId = @employeeId And IsDeleted = @IsDeleted";
     using (DBDataHelper objDDBDataHelper = new DBDataHelper())
     {
         ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstData);
         List<AssignLeaveViewModel> lstLeaves = new List<AssignLeaveViewModel>();
         foreach (DataRow row in ds.Tables[0].Rows)
         {
             AssignLeaveViewModel objLeaves = new AssignLeaveViewModel();
             int Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
             int leaveId = Convert.ToInt32(ds.Tables[0].Rows[i][1]);
             Leaves objLeaves1 = new Leaves();
             objMasterEntries.GetLeavesById(leaveId, out objLeaves1);
             objLeaves.leaveId = Id;
             objLeaves.Id = objLeaves1.Id;
             objLeaves.LeaveName = objLeaves1.LeaveName;
             objLeaves.EmployeeId = Convert.ToInt32(Session["employeeId"]);
             objLeaves.Date = (Convert.ToDateTime(ds.Tables[0].Rows[i][2])).Date;
             lstLeaves.Add(objLeaves);
             i++;
         }
         return lstLeaves;
     }
 }

    public LeavesOldStockViewModel getDataForOldLeavesByEmployeeId(DateTime sessionStartDate, DateTime sessionEndDate, int employeeId)
    {
        List<LeavesOldStockViewModel> lstLeavesOldStockViewModel = new List<LeavesOldStockViewModel>();
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DBDataHelper helper = new DBDataHelper();
        List<SqlParameter> lst_params = new List<SqlParameter>();
        lst_params.Add(new SqlParameter("@employeeId", employeeId));
        DataTable dt = new DataTable();
        string query = "SELECT tblEmployeesMaster.Id, Name ,[SLCount],[ELCount],[SessionStartDate],[SesssionEndDate] FROM[tblLeavesOldStock] right outer join tblEmployeesMaster On tblEmployeesMaster.Id = tblLeavesOldStock.EmployeeId Where tblLeavesOldStock.EmployeeId = @employeeId";
        LeavesOldStockViewModel objLeavesOldStockViewModel = new LeavesOldStockViewModel();
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            dt = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lst_params);
            foreach (DataRow row in dt.Rows)
            {
                objLeavesOldStockViewModel.employeeId = row[0] == DBNull.Value ? 0 : Int32.Parse(row[0].ToString());
                objLeavesOldStockViewModel.employeeName = row[1] == DBNull.Value ? "" : row[1].ToString();
                objLeavesOldStockViewModel.slCount = row[2] == DBNull.Value ? 0 : Int32.Parse(row[2].ToString());
                objLeavesOldStockViewModel.elCount = row[3] == DBNull.Value ? 0 : Int32.Parse(row[3].ToString());
                objLeavesOldStockViewModel.sessionStartDate = row[4] == DBNull.Value ? DateTime.Now : DateTime.Parse(row[4].ToString());
                objLeavesOldStockViewModel.sessionEndDate = row[5] == DBNull.Value ? DateTime.Now : DateTime.Parse(row[5].ToString());
                
            }
        }

        return objLeavesOldStockViewModel;
    }

    public List<AssignLeaveViewModel> GetDataForGridview()
    {
        MasterEntries objMasterEntries = new MasterEntries();
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DateTime sessionStartDate = new DateTime();
        DateTime sessionEndDate = new DateTime();
        if (DateTime.Now.Month <= 7)
        {
            sessionStartDate = new DateTime(DateTime.Now.Year - 1, 8, 1);
            sessionEndDate = new DateTime(DateTime.Now.Year, 7, 31);
        }
        else
        {
            sessionStartDate = new DateTime(DateTime.Now.Year, 8, 1);
            sessionEndDate = new DateTime(DateTime.Now.Year + 1, 7, 31);
        }

        List<SqlParameter> lstData = new List<SqlParameter>();
        lstData.Add(new SqlParameter("@employeeId", Convert.ToInt32(Session["employeeId"])));
        lstData.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
        lstData.Add(new SqlParameter("@sessionEndDate", sessionEndDate));
        lstData.Add(new SqlParameter("@IsDeleted", Convert.ToInt32(0)));

        DataSet ds;
        int i = 0;
        string query = @"SELECT Id , LeaveTypeId , [Date] 
                         FROM tblLeave 
                         WHERE [Date]  >= @sessionStartDate
                         AND [Date] <= @sessionEndDate 
                         AND EmployeeId = @employeeId 
                         AND IsDeleted = @IsDeleted";

        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstData);
            List<AssignLeaveViewModel> lstLeaves = new List<AssignLeaveViewModel>();
            foreach (DataRow row in ds.Tables[0].Rows)
            {
                AssignLeaveViewModel objLeaves = new AssignLeaveViewModel();
                int Id = Convert.ToInt32(ds.Tables[0].Rows[i][0]);
                int leaveId = Convert.ToInt32(ds.Tables[0].Rows[i][1]);
                Leaves objLeaves1 = new Leaves();
                objMasterEntries.GetLeavesById(leaveId, out objLeaves1);
                objLeaves.leaveId = Id;
                objLeaves.Id = objLeaves1.Id;
                objLeaves.LeaveName = objLeaves1.LeaveName;
                objLeaves.EmployeeId = Convert.ToInt32(Session["employeeId"]);
                objLeaves.Date = (Convert.ToDateTime(ds.Tables[0].Rows[i][2])).Date;
                lstLeaves.Add(objLeaves);
                i++;
            }
            return lstLeaves;
        }
    }

    protected void BindData()
    {
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DBDataHelper helper = new DBDataHelper();
        string query = @"SELECT [Id],[SessionStartDate],[SessionEndDate]
                         FROM [tblSession] ORDER BY [SessionStartDate] DESC";

        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            grdSession.DataSource = objDDBDataHelper.GetDataTable(query, SQLTextType.Query);
            grdSession.DataBind();
        }
    }

 /// <summary>
 /// 
 /// </summary>
 /// <param name="departmentId"></param>
 /// <returns></returns>
 public string GetDepartmentById(int departmentId)
 {
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     List<SqlParameter> lstDepartment = new List<SqlParameter>();
     lstDepartment.Add(new SqlParameter("@departmentId", departmentId));
     DataTable dt = new DataTable();
     DataSet ds;
     string department;
     using (DBDataHelper objDDBDataHelper = new DBDataHelper())
     {
         ds = objDDBDataHelper.GetDataSet("spGetDepartmentById", SQLTextType.Stored_Proc, lstDepartment);
         department = ds.Tables[0].Rows[0][0].ToString();
     }
     return department;
 }

 /// <summary>
 /// This method gets all the tasks that are assigned to the faculty based on the id of the faculty.
 /// </summary>
 /// <param name="facultyID">An integer parameter containing the ID of the faculty.</param>
 /// <returns>It returns a dictionary of tasks assigned to the faculty along with the status of each task.</returns>
 public Dictionary<Task, TaskStatusType> GetAllTasksAssignedToAFaculty(int facultyID)
 {
     SqlParameter FacultyID = new SqlParameter("facultyID", facultyID);
     List<SqlParameter> parameterCollection = new List<SqlParameter>(){FacultyID};
     DataTable taskTable = new DataTable();
     using(DBDataHelper helper = new DBDataHelper())
     {
         taskTable = helper.GetDataTable("dbo.GetAllTasksAssignedToAFaculty", SQLTextType.Stored_Proc, parameterCollection);
     }
     //List<Task> tasks = new List<Task>();
     Dictionary<Task, TaskStatusType> tasks = new Dictionary<Task, TaskStatusType>();
     foreach (DataRow row in taskTable.Rows)
     {
         Task task = new Task()
         {
             ID = int.Parse(row["TaskID"].ToString()),
             Name = row["Name"].ToString(),
             Priority = (PriorityType)(Enum.Parse(typeof(PriorityType), row["PriorityID"].ToString())),
             StartDate = DateTime.Parse(row["StartDate"].ToString()),
             EndDate = DateTime.Parse(row["EndDate"].ToString()),
             Description = row["Description"].ToString(),
             Type = (TaskType)(Enum.Parse(typeof(TaskType), row["TaskTypeID"].ToString()))
         };
         TaskStatusType taskStatus = (TaskStatusType)(Enum.Parse(typeof(TaskStatusType),row["TaskStatusID"].ToString()));
         DataTable table = new DataTable();
         SqlParameter HODID = new SqlParameter("ID",row["HODID"]);
         List<SqlParameter> collection = new List<SqlParameter>(){HODID};
         using(DBDataHelper helper = new DBDataHelper())
         {
             table = helper.GetDataTable("dbo.GetFacultyByID", SQLTextType.Stored_Proc, collection);
         }
         HOD hod = new HOD()
         {
             ID = int.Parse(table.Rows[0]["FacultyID"].ToString()),
             Name = table.Rows[0]["Name"].ToString(),
             EmailID = table.Rows[0]["EmailID"].ToString(),
             Designation = DesignationType.HOD,
             Department = (DepartmentType)(Enum.Parse(typeof(DepartmentType),table.Rows[0]["DepartmentID"].ToString())),
             ImageURL = table.Rows[0]["ImageURL"].ToString(),
             ContactNo = table.Rows[0]["ContactNo"].ToString()
         };
         task.AssignedBy = hod;
         task.AssignedTo = GetAllFacultiesHavingTheTask(task.ID);
         tasks.Add(task,taskStatus);
     }
     return tasks;
 }

    protected void btnUpdate_Click(object sender, EventArgs e)
    {
        List<LeaveAssignedRecord> lstLeaveAssignedRecord = new List<LeaveAssignedRecord>();
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DataSet ds;
        int leaveId;
        LeaveAssignedPerSession objLeaveAssignedPerSession = new LeaveAssignedPerSession();
        ManageReports objManageReports = new ManageReports();
        foreach (RepeaterItem i in EditgvLeaves.Items)
        {
            TextBox txtLeaveCount = (TextBox)i.FindControl("txtLeaveCount");
            Label txtLeaveName = (Label)i.FindControl("txtLeave");
            string leaveName = txtLeaveName.Text;
            List<SqlParameter> lstParams = new List<SqlParameter>();
            lstParams.Add(new SqlParameter("@name", leaveName));
            string query = "Select Id from tblTypeOfLeave where Name = @name";
            using (DBDataHelper objDDBDataHelper = new DBDataHelper())
            {
                ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstParams);
                leaveId = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            }

            DateTime SessionStartDate, SessionEndDate;
            if (DateTime.Now.Month >= 8)
            {
                SessionStartDate = new DateTime(DateTime.Now.Year, 08, 01);
                SessionEndDate = new DateTime(DateTime.Now.Year+1, 07, 31);
            }
            else
            {
                SessionStartDate = new DateTime(DateTime.Now.Year-1, 08, 01);
                SessionEndDate = new DateTime(DateTime.Now.Year, 07, 31);
            }
            objLeaveAssignedPerSession.EmployeeId = Convert.ToInt32(Session["empId"]);
            objLeaveAssignedPerSession.leaveCount = Convert.ToInt32(txtLeaveCount.Text);
            objLeaveAssignedPerSession.leaveType = leaveId;
            objManageReports.UpdateLeavesAssignedPerSessionEmployeeWise(objLeaveAssignedPerSession, SessionStartDate,SessionEndDate);
        }

        popupEditLeaveAssigned.Hide();

        int departmentId = Convert.ToInt32(ddlShowDepartment.SelectedValue);
        ManageReports objManageReports1 = new ManageReports();
        lstLeaveAssignedRecord = objManageReports1.GetLeavesAssignedPerSession(departmentId, DateTime.Now);
        //grid1.DataSource = lstLeaveAssignedRecord;
        //grid1.DataBind();
    }

    protected void BindData()
    {
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        DBDataHelper helper = new DBDataHelper();
        string query = @"SELECT [Id],[NameOfHoliday],[Status],[Date]
                             FROM [tblHolidays]
                             WHERE year([Date]) = year(@date)";

        List<SqlParameter> lst_params = new List<SqlParameter>();
        lst_params.Add(new SqlParameter("@date", Calendar1.SelectedDate));

        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            grdHoliday.DataSource = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lst_params);
            grdHoliday.DataBind();
        }
    }

    protected void btnAddSession_Click(object sender, EventArgs e)
    {
        #region Add_Session
        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;

        DateTime sessionStartDate = new DateTime(Int32.Parse(DateTime.Now.Year.ToString()), 8, 1);
        DateTime sessionEndDate = new DateTime(sessionStartDate.Year + 1, 7, 31);

        string query = "Select Count(*) from tblSession Where [email protected]";
        List<SqlParameter> lstParams = new List<SqlParameter>();
        lstParams.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
        DataTable ds = new DataTable();
        using (DBDataHelper objDDBDataHelper = new DBDataHelper())
        {
            ds = objDDBDataHelper.GetDataTable(query, SQLTextType.Query, lstParams);
        }

        if (ds.Rows.Count != 0)
            if (Int32.Parse(ds.Rows[0][0].ToString()) == 0)
            {

                string addSession = @"INSERT INTO [dbo].[tblSession]
                                      ([SessionStartDate]
                                       ,[SessionEndDate])
                                       VALUES (@sessionStartDate,@sessionEndDate)";

                List<SqlParameter> lstParams2 = new List<SqlParameter>();
                lstParams2.Add(new SqlParameter("@sessionStartDate", sessionStartDate));
                lstParams2.Add(new SqlParameter("@sessionEndDate", sessionEndDate));

                using (DBDataHelper objDDBDataHelper = new DBDataHelper())
                {
                    objDDBDataHelper.ExecSQL(addSession, SQLTextType.Query, lstParams2);
                }
                ManageReports objManageReprts = new ManageReports();
                objManageReprts.AssignSessionWiseLeave(sessionStartDate);
                objManageReprts.UpdateLeaveBalanceTable(sessionStartDate);
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Added')", true);
            }
            else
            {
                ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Session Exists')", true);
            }
        #endregion
    }

 public bool DeleteEmployee(long employeeId)
 {
     List<SqlParameter> lstEmployeeDetail = new List<SqlParameter>();
     lstEmployeeDetail.Add(new SqlParameter("@employeeId", employeeId));
     DataTable dt = new DataTable();
     try
     {
         using (DBDataHelper objDDBDataHelper = new DBDataHelper())
         {
             objDDBDataHelper.ExecSQL("spDeleteEmployee", SQLTextType.Stored_Proc, lstEmployeeDetail);
         }
         return true;
     }
     catch (Exception ex)
     {
         return false;
     }
 }

 protected void btnAddSession_Click(object sender, EventArgs e)
 {
     int shiftId = Convert.ToInt32(ddlShift.SelectedValue);
     DateTime date = DateTime.Parse(txtDate.Text);
     int employeeId = Convert.ToInt32(txtEmployeeId.Text);
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     List<SqlParameter> lstparameter = new List<SqlParameter>();
     lstparameter.Add(new SqlParameter("@shiftId", shiftId));
     lstparameter.Add(new SqlParameter("@date", date));
     lstparameter.Add(new SqlParameter("@employeeId", employeeId));
     string query = "Insert into tblDateWiseShift values(@shiftId,@employeeId,@date)";
     DataTable dt = new DataTable();
     DataSet ds;
     using (DBDataHelper objDDBDataHelper = new DBDataHelper())
     {
         ds = objDDBDataHelper.GetDataSet(query, SQLTextType.Query, lstparameter);
     }
 }

 protected void btnAddHoliday_Click(object sender, EventArgs e)
 {
     string query = "INSERT INTO [tblHolidays] VALUES (@date,@status,@nameOfHoliday)";
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     DataTable dt = new DataTable();
     List<SqlParameter> lstData = new List<SqlParameter>();
     lstData.Add(new SqlParameter("@date", Calendar1.SelectedDate.Date.ToString("d")));
     lstData.Add(new SqlParameter("@nameOfHoliday", txtHoliday.Text == "" ? ((Convert.ToInt32(ddlStatus.SelectedValue)) == (int)DayStatus.Holiday ? DayStatus.Holiday.ToString() : "Weekly Off") : (txtHoliday.Text)));
     lstData.Add(new SqlParameter("@status", ddlStatus.SelectedValue));
     using (DBDataHelper objDDBDataHelper = new DBDataHelper())
     {
         objDDBDataHelper.ExecSQL(query, SQLTextType.Query, lstData);
     }
     ScriptManager.RegisterStartupScript(this, this.GetType(), "script", "alert('Holiday Added Successfully...');", true);
     btnAddHoliday.Enabled = false;
     btnAddHoliday.Text = "Holiday Exists";
     txtHoliday.Text = dt.Rows[0][0] == DBNull.Value ? "" : dt.Rows[0][0].ToString();
     BindData();
 }

    public void Add(Day day)
    {

        DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
        List<SqlParameter> list_params = new List<SqlParameter>() { new SqlParameter("@date", day.Date), new SqlParameter("@status", day.Status) };
        try
        {
            using (DBDataHelper helper = new DBDataHelper())
            {
                helper.ExecSQL("Insert into [tblSpecialDays] values (@date,@status)", SQLTextType.Query, list_params);

            }

        }
        catch(Exception)
        {

        }
    }

 public bool GetEmployeesOnLeaveByDate(DateTime date, out List<Reports> objEmployees)
 {
     DataTable dt, dt1, dt2, dt3, dt4;
     List<Reports> objEmployees1 = new List<Reports>();
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     List<SqlParameter> list_params = new List<SqlParameter>() { new SqlParameter("@date", date) };
     try
     {
         using (DBDataHelper helper = new DBDataHelper())
         {
             dt = helper.GetDataTable("spGetEmployeesOnLeaveByDate", SQLTextType.Stored_Proc, list_params);
             for (int i = 0; i < dt.Rows.Count; i++)
             {
                 int EmployeeId = Convert.ToInt32(dt.Rows[i]["EmployeeId"]);
                 List<SqlParameter> list_params2 = new List<SqlParameter>() { new SqlParameter("@employeeId", EmployeeId) };
                 dt1 = helper.GetDataTable("select FirstName,MiddleName,LastName from tblEmployeesMaster where [email protected]", SQLTextType.Query, list_params2);
                 Reports objReports = new Reports();
                 objReports.FirstName = Convert.ToString(dt1.Rows[0]["FirstName"]);
                 objReports.MiddleName = Convert.ToString(dt1.Rows[0]["MiddleName"]);
                 objReports.LastName = Convert.ToString(dt1.Rows[0]["LastName"]);
                 List<SqlParameter> list_params3 = new List<SqlParameter>() { new SqlParameter("@employeeId", EmployeeId) };
                 dt2 = helper.GetDataTable("Select RoleId,DepartmentId from tblEmployees where [email protected]", SQLTextType.Query, list_params3);
                 objReports.RoleId = Convert.ToInt32(dt2.Rows[0]["RoleId"]);
                 objReports.DepartmentId = Convert.ToInt32(dt2.Rows[0]["DepartmentId"]);
                 List<SqlParameter> list_params4 = new List<SqlParameter>() { new SqlParameter("@roleId", objReports.RoleId) };
                 dt3 = helper.GetDataTable("spGetRoleById", SQLTextType.Stored_Proc, list_params4);
                 objReports.RoleName = dt3.Rows[0][0].ToString();
                 List<SqlParameter> list_params5 = new List<SqlParameter>() { new SqlParameter("@departmentId", objReports.DepartmentId) };
                 dt4 = helper.GetDataTable("spGetDepartmentById", SQLTextType.Stored_Proc, list_params5);
                 objReports.DepartmentName = dt4.Rows[0][0].ToString();
                 objEmployees1.Add(objReports);
             }
         }
         objEmployees = objEmployees1;
         return true;
     }
     catch (Exception)
     {
         objEmployees = null;
         return false;
     }
 }

 /// <summary>
 /// Adds a new Department
 /// </summary>
 /// <param name="Department">String value for Department Name</param>
 /// <returns>True if Department is added successfully</returns>
 public bool AddDepartment(string Department)
 {
     DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
     List<SqlParameter> lstDepartment = new List<SqlParameter>();
     lstDepartment.Add(new SqlParameter("@name", Department));
     lstDepartment.Add(new SqlParameter("@createdOn", DateTime.Now));
     lstDepartment.Add(new SqlParameter("@updatedOn", DateTime.Now));
     DataTable dt = new DataTable();
     try
     {
         using (DBDataHelper objDDBDataHelper = new DBDataHelper())
         {
             objDDBDataHelper.ExecSQL("spCreateDepartment", SQLTextType.Stored_Proc, lstDepartment);
         }
         return true;
     }
     catch (Exception ex)
     {
         return false;
     }
 }