private bool LeaveApprovalValidation()
{
try
{
if (string.IsNullOrEmpty(txtRemarks.Text.Trim()))
{
Message.IsSuccess = false;
Message.Text = "Please enter remarks.";
Message.Show = true;
return(false);
}
Business.LeaveManagement.LeaveApplication objLeaveApplication = new Business.LeaveManagement.LeaveApplication();
Entity.LeaveManagement.LeaveApplicationMaster leaveApplicationMaster = new Entity.LeaveManagement.LeaveApplicationMaster();
leaveApplicationMaster.LeaveApplicationId = Business.Common.Context.LeaveApplicationId;
DataTable dtLeaveApplication = objLeaveApplication.LeaveApplicationMaster_GetAll(leaveApplicationMaster);
DataTable dtLeaveAccountBalance = new Business.LeaveManagement.LeaveAccountBalance().LeaveAccountBalance_ByEmployeeId(Convert.ToInt32(dtLeaveApplication.Rows[0]["RequestorId"].ToString()), Convert.ToInt32(dtLeaveApplication.Rows[0]["LeaveTypeId"].ToString())).Tables[0];
DataSet dsLeaveDetails = objLeaveApplication.GetLeaveApplicationDetails_ByLeaveApplicationId(Business.Common.Context.LeaveApplicationId);
decimal totalLeaveCount = 0;
totalLeaveCount = Convert.ToDecimal(dsLeaveDetails.Tables[2].Compute("Sum(AppliedForDay)", string.Empty));
if (dtLeaveAccountBalance != null && dtLeaveAccountBalance.AsEnumerable().Any())
{
if (totalLeaveCount > Convert.ToDecimal(dtLeaveAccountBalance.Rows[0]["Amount"].ToString()))
{
Message.Text = "Applicant's Leave Balance is low.";
Message.IsSuccess = false;
Message.Show = true;
return(false);
}
if (Convert.ToBoolean(dtLeaveAccountBalance.Rows[0]["LeaveBlocked"].ToString()))
{
Message.Text = "Applicant's leaves are blocked. Please contact to HR.";
Message.IsSuccess = false;
Message.Show = true;
return(false);
}
}
else
{
Message.Text = "Applicant do not have any Leave Balance.";
Message.IsSuccess = false;
Message.Show = true;
return(false);
}
return(true);
}
catch (Exception ex)
{
ex.WriteException();
Message.Text = ex.Message;
Message.IsSuccess = false;
Message.Show = true;
return(false);
}
}
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;
}
}