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)); }