protected void btnSave_Click(object sender, EventArgs e)
{
try
{
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
Entity.LeaveManagement.LeaveApprovalConfiguration leaveApprovalConfiguration = new Entity.LeaveManagement.LeaveApprovalConfiguration();
leaveApprovalConfiguration.LeaveApprovalConfigurationId = LeaveApprovalConfigurationId;
leaveApprovalConfiguration.ApproverDesignationId = Convert.ToInt32(ddlApproverDesignation.SelectedValue);
leaveApprovalConfiguration.LeaveDesignationConfigurationId = Convert.ToInt32(ddlRequestorDesignation.SelectedValue);
leaveApprovalConfiguration.ApprovalLevel = Convert.ToInt32(ddlApprovalLevel.SelectedValue);
int response = objLeaveApprovalConfiguration.LeaveApprovalConfig_Save(leaveApprovalConfiguration);
if (response > 0)
{
Clear();
LeaveApprovalConfig_GetAll();
Message.IsSuccess = true;
Message.Text = "Saved Successfully";
}
else
{
Message.IsSuccess = false;
Message.Text = "Exists";
}
Message.Show = true;
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
protected void LeaveApprovalConfig_GetAll()
{
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
DataTable dt = objLeaveApprovalConfiguration.LeaveApprovalConfig_GetAll(new Entity.LeaveManagement.LeaveApprovalConfiguration()
{
});
gvLeaveApprovalConfiguration.DataSource = dt;
gvLeaveApprovalConfiguration.DataBind();
}
protected void LeaveApprovalConfig_GetById()
{
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
DataTable dt = objLeaveApprovalConfiguration.LeaveApprovalConfig_GetAll(new Entity.LeaveManagement.LeaveApprovalConfiguration()
{
LeaveApprovalConfigurationId = LeaveApprovalConfigurationId
});
if (dt.Rows.Count > 0)
{
ddlRequestorDesignation.SelectedValue = dt.Rows[0]["LeaveDesignationConfigId"].ToString();
ddlApproverDesignation.SelectedValue = dt.Rows[0]["ApproverDesignationId"].ToString();
ddlApprovalLevel.SelectedValue = dt.Rows[0]["ApproverLevel"].ToString();
}
}
private int LeaveApprovalDetails_Save(int leaveApplicationId)
{
int response = 0;
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
DataTable dtLeaveEmployeeWiseApprovalConfiguration = objLeaveApprovalConfiguration.LeaveEmployeeWiseApprovalConfiguration_GetAll(
new Entity.LeaveManagement.LeaveApprovalConfiguration()
{
EmployeeId = Convert.ToInt32(HttpContext.Current.User.Identity.Name)
});
Business.LeaveManagement.LeaveApprovalDetails objLeaveApprovalDetails = new Business.LeaveManagement.LeaveApprovalDetails();
Entity.LeaveManagement.LeaveApprovalDetails leaveApprovalDetails = new Entity.LeaveManagement.LeaveApprovalDetails();
//If LeaveEmployeeWiseApprovalConfiguration is configured
if (dtLeaveEmployeeWiseApprovalConfiguration != null &&
dtLeaveEmployeeWiseApprovalConfiguration.AsEnumerable().Any() &&
dtLeaveEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = 1").Any())
{
leaveApprovalDetails.ApproverId = Convert.ToInt32(dtLeaveEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = 1").FirstOrDefault()["ApproverId"].ToString());
}
else //If not confiured then send approval to Reporting employee
{
DataTable dtEmployee = new Business.HR.EmployeeMaster().EmployeeMaster_ById(new Entity.HR.EmployeeMaster()
{
EmployeeMasterId = Convert.ToInt32(HttpContext.Current.User.Identity.Name)
});
if (dtEmployee != null && dtEmployee.AsEnumerable().Any())
{
leaveApprovalDetails.ApproverId = Convert.ToInt32(dtEmployee.Rows[0]["ReportingEmployeeId"].ToString());
}
}
leaveApprovalDetails.LeaveApprovalDetailId = 0;
leaveApprovalDetails.LeaveApplicationId = leaveApplicationId;
leaveApprovalDetails.Status = (int)LeaveStatusEnum.Pending;
leaveApprovalDetails.Remarks = "APPROVAL PENDING";
response = objLeaveApprovalDetails.LeaveApprovalDetails_Save(leaveApprovalDetails);
return(response);
}
protected void gvLeaveApprovalConfiguration_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
if (e.CommandName == "E")
{
LeaveApprovalConfigurationId = Convert.ToInt32(e.CommandArgument.ToString());
LeaveApprovalConfig_GetById();
}
else
{
if (e.CommandName == "D")
{
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
LeaveApprovalConfigurationId = Convert.ToInt32(e.CommandArgument.ToString());
int RowsAffected = objLeaveApprovalConfiguration.LeaveApprovalConfig_Delete(LeaveApprovalConfigurationId);
if (RowsAffected > 0)
{
Clear();
LeaveApprovalConfig_GetAll();
Message.Show = true;
Message.Text = "Deleted Successfully";
}
else
{
Message.Show = false;
Message.Text = "Data Dependency Exists";
}
Message.Show = true;
}
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}
protected void btnApprove_Click(object sender, EventArgs e)
{
try
{
if (LeaveApprovalValidation())
{
Entity.LeaveManagement.LeaveApprovalDetails leaveApprovalDetails = new Entity.LeaveManagement.LeaveApprovalDetails();
leaveApprovalDetails.ApproverId = Convert.ToInt32(HttpContext.Current.User.Identity.Name);
leaveApprovalDetails.LeaveApplicationId = Business.Common.Context.LeaveApplicationId;
leaveApprovalDetails.Status = (int)LeaveStatusEnum.Approved;
leaveApprovalDetails.Remarks = txtRemarks.Text.Trim();
int response = new Business.LeaveManagement.LeaveApprovalDetails().LeaveApprove(leaveApprovalDetails);
if (response > 0)
{
//Fetching Requestor Id
Entity.LeaveManagement.LeaveApplicationMaster leaveApplicationMaster = new Entity.LeaveManagement.LeaveApplicationMaster();
Business.LeaveManagement.LeaveApplication objLeaveApplication = new Business.LeaveManagement.LeaveApplication();
leaveApplicationMaster.LeaveApplicationId = Business.Common.Context.LeaveApplicationId;
DataTable dtLeaveApplication = objLeaveApplication.LeaveApplicationMaster_GetAll(leaveApplicationMaster);
Business.LeaveManagement.LeaveApprovalConfiguration objLeaveApprovalConfiguration = new Business.LeaveManagement.LeaveApprovalConfiguration();
DataTable dtLeaveEmployeeWiseApprovalConfiguration = objLeaveApprovalConfiguration.LeaveEmployeeWiseApprovalConfiguration_GetAll(
new Entity.LeaveManagement.LeaveApprovalConfiguration()
{
EmployeeId = (dtLeaveApplication != null && dtLeaveApplication.AsEnumerable().Any()) ? Convert.ToInt32(dtLeaveApplication.Rows[0]["RequestorId"].ToString()) : 0
});
int currentLeaveApproverLevel = 0;
if (dtLeaveEmployeeWiseApprovalConfiguration != null &&
dtLeaveEmployeeWiseApprovalConfiguration.AsEnumerable().Any() &&
dtLeaveEmployeeWiseApprovalConfiguration.Select("ApproverId = " + HttpContext.Current.User.Identity.Name).Any())
{
//Fetching the current approver approval level
currentLeaveApproverLevel = Convert.ToInt32(dtLeaveEmployeeWiseApprovalConfiguration
.Select("ApproverId = " + HttpContext.Current.User.Identity.Name).FirstOrDefault()["ApprovalLevel"].ToString());
currentLeaveApproverLevel = currentLeaveApproverLevel + 1;
}
if (dtLeaveEmployeeWiseApprovalConfiguration != null &&
dtLeaveEmployeeWiseApprovalConfiguration.AsEnumerable().Any() &&
dtLeaveEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = " + currentLeaveApproverLevel).Any())
{
Business.LeaveManagement.LeaveApprovalDetails objLeaveApprovalDetails = new Business.LeaveManagement.LeaveApprovalDetails();
leaveApprovalDetails.LeaveApprovalDetailId = 0;
leaveApprovalDetails.LeaveApplicationId = Business.Common.Context.LeaveApplicationId;
leaveApprovalDetails.Status = (int)LeaveStatusEnum.Pending;
leaveApprovalDetails.ApproverId = Convert.ToInt32(dtLeaveEmployeeWiseApprovalConfiguration.Select("ApprovalLevel = " + currentLeaveApproverLevel).FirstOrDefault()["ApproverId"].ToString());
//Assigning Leave Request to next approver
int approvalResponse = objLeaveApprovalDetails.LeaveApprovalDetails_Save(leaveApprovalDetails);
if (approvalResponse > 0)
{
GetLeaveApplications_ByApproverId(ckShowAll.Checked ? (int)LeaveStatusEnum.None : (int)LeaveStatusEnum.Pending);
MessageSuccess.IsSuccess = true;
MessageSuccess.Text = "Approval moved to next level.";
MessageSuccess.Show = true;
ModalPopupExtender1.Hide();
}
}
else
{
//If final Appoval approved then update status in Master table
new Business.LeaveManagement.LeaveApplication().LeaveApplicationMaster_Save(
new Entity.LeaveManagement.LeaveApplicationMaster()
{
LeaveApplicationId = Business.Common.Context.LeaveApplicationId,
LeaveStatusId = (int)LeaveStatusEnum.Approved
});
int adjustResponse = LeaveAccontBalance_Deduct(Business.Common.Context.LeaveApplicationId);
if (adjustResponse > 0)
{
GetLeaveApplications_ByApproverId(ckShowAll.Checked ? (int)LeaveStatusEnum.None : (int)LeaveStatusEnum.Pending);
MessageSuccess.IsSuccess = true;
MessageSuccess.Text = "Leave approved.";
MessageSuccess.Show = true;
ModalPopupExtender1.Hide();
}
else
{
Message.IsSuccess = false;
Message.Text = "Something went wrong! Please contact system administrator";
Message.Show = true;
TabContainer1.ActiveTab = Approval;
ModalPopupExtender1.Show();
}
}
}
else
{
Message.IsSuccess = false;
Message.Text = "Response not given.";
Message.Show = true;
TabContainer1.ActiveTab = Approval;
ModalPopupExtender1.Show();
}
}
else
{
TabContainer1.ActiveTab = Approval;
ModalPopupExtender1.Show();
}
}
catch (Exception ex)
{
ex.WriteException();
Message.IsSuccess = false;
Message.Text = ex.Message;
Message.Show = true;
}
}