protected void grdRoleBind()
{
MasterEntries objMasterEntries = new MasterEntries();
grdRole.DataSource = objMasterEntries.GetAllRoles();
grdRole.DataBind();
}
protected List <Role> GiveAllRole()
{
MasterEntries objMasterEntries = new MasterEntries();
List <Role> lstRole = new List <Role>();
lstRole = objMasterEntries.GetAllRoles();
return(lstRole);
}
protected void BindDropDowns()
{
MasterEntries objMasterEntries = new MasterEntries();
ddlDepartments.DataSource = objMasterEntries.GetAllDepartments();
ddlDepartments.DataTextField = "Name";
ddlDepartments.DataValueField = "Id";
ddlDepartments.DataBind();
ddlRoles.DataSource = objMasterEntries.GetAllRoles();
ddlRoles.DataTextField = "Name";
ddlRoles.DataValueField = "Id";
ddlRoles.DataBind();
}
protected void BindDropDowns()
{
MasterEntries objMasterEntries = new MasterEntries();
ddlDepartments.DataSource = objMasterEntries.GetAllDepartments();
ddlDepartments.DataTextField = "Name";
ddlDepartments.DataValueField = "Id";
ddlDepartments.DataBind();
ddlRoles.DataSource = objMasterEntries.GetAllRoles();
ddlRoles.DataTextField = "Name";
ddlRoles.DataValueField = "Id";
ddlRoles.DataBind();
ddlShifts.DataSource = objMasterEntries.GetAllShifts();
ddlShifts.DataTextField = "Name";
ddlShifts.DataValueField = "Id";
ddlShifts.DataBind();
}
public bool AssignSessionWiseLeave(DateTime sessionStartDate)
{
DBDataHelper.ConnectionString = ConfigurationManager.ConnectionStrings["CSBiometricAttendance"].ConnectionString;
MasterEntries objMasterEntries = new MasterEntries();
List<Role> lstRole = new List<Role>();
lstRole = objMasterEntries.GetAllRoles();
DateTime sessionEndDate = new DateTime(sessionStartDate.Year + 1, 7, 31);
#region Roles
foreach (Role role in lstRole)
{
ManageEmployees objManageEmployees = new ManageEmployees();
List<Employees> lstEmployees = objManageEmployees.GetEmployeesByRole(role.Id);
List<LeavesCount> lstLeaveDetails = new List<LeavesCount>();
ManageLeaves objManageLeaves = new ManageLeaves();
lstLeaveDetails = objManageLeaves.GetLeavesCountAssignedByRole(role.Id);
#region List of Employees
foreach (Employees objEmployees in lstEmployees)
{
#region List of Leaves
foreach (LeavesCount LeaveDetails in lstLeaveDetails)
{
using (DBDataHelper objDDBDataHelper = new DBDataHelper())
{
string query = @"INSERT INTO [dbo].[tblLeaveAssignedPerSession]
VALUES
(@employeeId,
@leaveTypeId,
@noOfLeaves,
@sessionStartDate,
@sessionEndDate)";
List<SqlParameter> list_params = new List<SqlParameter>()
{
new SqlParameter("@employeeId", objEmployees.Id),
new SqlParameter("@leaveTypeId", LeaveDetails.LeaveId),
new SqlParameter("@noOfLeaves", LeaveDetails.LeaveCount),
new SqlParameter("@sessionStartDate", sessionStartDate),
new SqlParameter("@sessionEndDate", sessionEndDate),
};
objDDBDataHelper.ExecSQL(query, SQLTextType.Query, list_params);
}
}
#endregion
}
#endregion
}
#endregion
return true;
}
protected List<Role> GiveAllRole()
{
MasterEntries objMasterEntries = new MasterEntries();
List<Role> lstRole = new List<Role>();
lstRole = objMasterEntries.GetAllRoles();
return lstRole;
}
protected void grdRoleBind()
{
MasterEntries objMasterEntries = new MasterEntries();
grdRole.DataSource = objMasterEntries.GetAllRoles();
grdRole.DataBind();
}
