public static int LeaveAccontBalance_Adjust(Entity.LeaveManagement.LeaveAccountBalance leaveAccountBalance)
{
int retValue = 0;
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["constr"].ToString()))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "usp_HR_LeaveAccontBalance_Adjust";
cmd.Parameters.AddWithValue("@EmployeeId", leaveAccountBalance.EmployeeId);
cmd.Parameters.AddWithValue("@LeaveTypeId", leaveAccountBalance.LeaveTypeId);
cmd.Parameters.AddWithValue("@Amount", leaveAccountBalance.Amount);
cmd.Parameters.AddWithValue("@Reason", leaveAccountBalance.Reason);
if (con.State == ConnectionState.Closed)
{
con.Open();
}
retValue = cmd.ExecuteNonQuery();
con.Close();
}
}
return(retValue);
}
private int LeaveAccontBalance_Adjust(int leaveApplicationId)
{
Entity.LeaveManagement.LeaveAccountBalance leaveAccountBalance = new Entity.LeaveManagement.LeaveAccountBalance();
Business.LeaveManagement.LeaveAccountBalance objLeaveAccountBalance = new Business.LeaveManagement.LeaveAccountBalance();
leaveAccountBalance.EmployeeId = EmployeeMasterId;
leaveAccountBalance.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue);
leaveAccountBalance.Amount = (ddlOperation.SelectedValue == "1") ? Convert.ToDecimal(txtLeaveAmount.Text.Trim()) : -Convert.ToDecimal(txtLeaveAmount.Text.Trim());
leaveAccountBalance.Reason = "MANUAL ADJUSTMENT: " + txtComments.Text.Trim();
int response = objLeaveAccountBalance.LeaveAccontBalance_Adjust(leaveAccountBalance);
return(response);
}
private int LeaveAccontBalance_Deduct(int leaveApplicationId)
{
Entity.LeaveManagement.LeaveAccountBalance leaveAccountBalance = new Entity.LeaveManagement.LeaveAccountBalance();
Business.LeaveManagement.LeaveAccountBalance objLeaveAccountBalance = new Business.LeaveManagement.LeaveAccountBalance();
DataTable dtLeaveApplicationMaster = new Business.LeaveManagement.LeaveApplication()
.LeaveApplicationMaster_GetAll(
new Entity.LeaveManagement.LeaveApplicationMaster()
{
LeaveApplicationId = leaveApplicationId
});
if (dtLeaveApplicationMaster != null && dtLeaveApplicationMaster.AsEnumerable().Any())
{
leaveAccountBalance.EmployeeId = Convert.ToInt32(dtLeaveApplicationMaster.Rows[0]["RequestorId"].ToString());
leaveAccountBalance.LeaveTypeId = Convert.ToInt32(dtLeaveApplicationMaster.Rows[0]["LeaveTypeId"].ToString());
leaveAccountBalance.Amount = -(Convert.ToDecimal(dtLeaveApplicationMaster.Rows[0]["TotalLeaveDays"].ToString()));
leaveAccountBalance.Reason = "LEAVE APPROVED";
}
int response = objLeaveAccountBalance.LeaveAccontBalance_Adjust(leaveAccountBalance);
return(response);
}
public int LeaveAccontBalance_Adjust(Entity.LeaveManagement.LeaveAccountBalance leaveAccountBalance)
{
return(DataAccess.LeaveManagement.LeaveAccountBalance.LeaveAccontBalance_Adjust(leaveAccountBalance));
}
