public static int LeaveDesignationConfig_Save(Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration) { 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_LeaveDesignationConfig_Save"; cmd.Parameters.AddWithValue("@LeaveDesignationConfigId", leaveDesignationWiseConfiguration.LeaveDesignationConfigId); cmd.Parameters.AddWithValue("@LeaveTypeId", leaveDesignationWiseConfiguration.LeaveTypeId); cmd.Parameters.AddWithValue("@DesignationId", leaveDesignationWiseConfiguration.DesignationId); cmd.Parameters.AddWithValue("@LeaveCount", leaveDesignationWiseConfiguration.LeaveCount); cmd.Parameters.AddWithValue("@CarryForwardCount", leaveDesignationWiseConfiguration.CarryForwardCount); cmd.Parameters.AddWithValue("@MinApplyDays", leaveDesignationWiseConfiguration.MinApplyDays); cmd.Parameters.AddWithValue("@MaxApplyDays", leaveDesignationWiseConfiguration.MaxApplyDays); if (con.State == ConnectionState.Closed) { con.Open(); } retValue = cmd.ExecuteNonQuery(); con.Close(); } } return(retValue); }
private void LeaveDesignationWiseConfiguration_GetAll() { Business.LeaveManagement.LeaveDesignationWiseConfiguration objLeaveDesignationWiseConfiguration = new Business.LeaveManagement.LeaveDesignationWiseConfiguration(); Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration = new Entity.LeaveManagement.LeaveDesignationWiseConfiguration(); DataTable dt = objLeaveDesignationWiseConfiguration.LeaveDesignationConfig_GetAll(leaveDesignationWiseConfiguration); gvLeaveDesignationConfiguration.DataSource = dt; gvLeaveDesignationConfiguration.DataBind(); }
protected void btnSave_Click(object sender, EventArgs e) { try { if (LeaveDesignationConfigValidate()) { Business.LeaveManagement.LeaveDesignationWiseConfiguration objLeaveDesignationWiseConfiguration = new Business.LeaveManagement.LeaveDesignationWiseConfiguration(); Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration = new Entity.LeaveManagement.LeaveDesignationWiseConfiguration(); leaveDesignationWiseConfiguration.LeaveDesignationConfigId = LeaveDesignationWiseConfigurationId; leaveDesignationWiseConfiguration.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue); leaveDesignationWiseConfiguration.DesignationId = Convert.ToInt32(ddlDesignation.SelectedValue); leaveDesignationWiseConfiguration.LeaveCount = Convert.ToDecimal(txtLeaveCount.Text.Trim()); leaveDesignationWiseConfiguration.CarryForwardCount = Convert.ToDecimal(txtCarryForwardCount.Text.Trim()); leaveDesignationWiseConfiguration.MinApplyDays = Convert.ToDecimal(txtMinApplyDays.Text.Trim()); leaveDesignationWiseConfiguration.MaxApplyDays = Convert.ToDecimal(txtMaxApplyDays.Text.Trim()); int response = objLeaveDesignationWiseConfiguration.LeaveDesignationConfig_Save(leaveDesignationWiseConfiguration); if (response > 0) { Clear(); LeaveDesignationWiseConfiguration_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; } }
public static DataTable LeaveDesignationConfig_GetAll(Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration) { using (DataTable dt = new DataTable()) { 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_LeaveDesignationConfig_GetAll"; if (leaveDesignationWiseConfiguration.LeaveTypeId == 0) { cmd.Parameters.AddWithValue("@LeaveTypeId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@LeaveTypeId", leaveDesignationWiseConfiguration.LeaveTypeId); } if (leaveDesignationWiseConfiguration.DesignationId == 0) { cmd.Parameters.AddWithValue("@DesignationId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@DesignationId", leaveDesignationWiseConfiguration.DesignationId); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
private bool LeaveApplyValidation() { if (!LeaveApplicationControlValidation()) { return(false); } DataTable dtLeaveConfigurations = GlobalCache.ExecuteCache <DataTable>(typeof(Business.LeaveManagement.LeaveConfiguration), "LeaveConfigurations_GetAll", new Entity.LeaveManagement.LeaveConfiguration() { }); Entity.LeaveManagement.LeaveApplicationMaster leaveApplicationMaster = new Entity.LeaveManagement.LeaveApplicationMaster(); leaveApplicationMaster.RequestorId = Convert.ToInt32(HttpContext.Current.User.Identity.Name); DataTable dtLeaveApplicationMaster = new Business.LeaveManagement.LeaveApplication().LeaveApplicationMaster_GetAll(leaveApplicationMaster); if (dtLeaveConfigurations != null && dtLeaveConfigurations.AsEnumerable().Any()) { DataRow drLeaveConfiguration = dtLeaveConfigurations.Select("LeaveTypeId = " + ddlLeaveType.SelectedValue).FirstOrDefault(); if (drLeaveConfiguration == null) { Message.Text = "Leave Configuration not found"; Message.IsSuccess = false; Message.Show = true; return(false); } if (!(DateTime.Now.Date >= Convert.ToDateTime(drLeaveConfiguration["LeaveAccrueDate"].ToString()))) { Message.Text = "Leave Not Yet Applicable"; Message.IsSuccess = false; Message.Show = true; return(false); } if (dtLeaveApplicationMaster != null && dtLeaveApplicationMaster.AsEnumerable().Any()) { if (dtLeaveApplicationMaster.Select("LeaveStatusId = " + ((int)LeaveStatusEnum.Pending).ToString()).Any()) { Message.Text = "You already have leave approval pending."; Message.IsSuccess = false; Message.Show = true; return(false); } } } else { Message.Text = "Leave Configuration not found"; Message.IsSuccess = false; Message.Show = true; return(false); } 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()) { if (dtEmployee.Rows[0]["ReportingEmployeeId"] == DBNull.Value) { Message.Text = "Please update reporting person."; Message.IsSuccess = false; Message.Show = true; return(false); } Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration = new Entity.LeaveManagement.LeaveDesignationWiseConfiguration(); leaveDesignationWiseConfiguration.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue); leaveDesignationWiseConfiguration.DesignationId = Convert.ToInt32(dtEmployee.Rows[0]["DesignationMasterId_FK"].ToString()); DataTable dtLeaveDesignationConfiguration = new Business.LeaveManagement.LeaveDesignationWiseConfiguration().LeaveDesignationConfig_GetAll(leaveDesignationWiseConfiguration); if (dtLeaveDesignationConfiguration != null && dtLeaveDesignationConfiguration.AsEnumerable().Any()) { decimal totalDays = Convert.ToDecimal(lbTotalCount.Text.Trim()); if (totalDays < Convert.ToDecimal(dtLeaveDesignationConfiguration.Rows[0]["MinApplyDays"].ToString())) { Message.Text = "Min leave should be more than " + dtLeaveDesignationConfiguration.Rows[0]["MinApplyDays"].ToString() + " days"; Message.IsSuccess = false; Message.Show = true; return(false); } else if (totalDays > Convert.ToDecimal(dtLeaveDesignationConfiguration.Rows[0]["MaxApplyDays"].ToString())) { Message.Text = "Max leave should be less than " + dtLeaveDesignationConfiguration.Rows[0]["MaxApplyDays"].ToString() + " days"; Message.IsSuccess = false; Message.Show = true; return(false); } //if (Convert.ToDecimal(lbTotalCount.Text.Trim()) > Convert.ToDecimal(dtLeaveDesignationConfiguration.Rows[0]["LeaveCount"].ToString())) //{ // Message.Text = "Maximum Leave you can apply is " + dtLeaveDesignationConfiguration.Rows[0]["LeaveCount"].ToString() + " days in a year"; // Message.IsSuccess = false; // Message.Show = true; // return false; //} } else { Message.Text = "Leave designation configuration not found"; Message.IsSuccess = false; Message.Show = true; return(false); } DataTable dtLeaveAccountBalance = new Business.LeaveManagement.LeaveAccountBalance().LeaveAccountBalance_ByEmployeeId(Convert.ToInt32(HttpContext.Current.User.Identity.Name), Convert.ToInt32(ddlLeaveType.SelectedValue)).Tables[0]; if (dtLeaveAccountBalance != null && dtLeaveAccountBalance.AsEnumerable().Any()) { if (Convert.ToInt32(lbTotalCount.Text.Trim()) > Convert.ToDecimal(dtLeaveAccountBalance.Rows[0]["Amount"].ToString())) { Message.Text = "Your Leave Balance is low."; Message.IsSuccess = false; Message.Show = true; return(false); } if (Convert.ToBoolean(dtLeaveAccountBalance.Rows[0]["LeaveBlocked"].ToString())) { Message.Text = "Your leaves are blocked. Please contact to HR."; Message.IsSuccess = false; Message.Show = true; return(false); } } else { Message.Text = "You do not have any Leave Balance."; Message.IsSuccess = false; Message.Show = true; return(false); } //Checking leave date overlapping DataTable dtLeaveApplicationDetails = new Business.LeaveManagement.LeaveApplication().LeaveApplicationDetails_GetByDate(new Entity.LeaveManagement.LeaveApplicationMaster() { RequestorId = Convert.ToInt32(HttpContext.Current.User.Identity.Name), FromLeaveDate = Convert.ToDateTime(lbFromDate.Text.Trim()), ToLeaveDate = Convert.ToDateTime(lbToDate.Text.Trim()), LeaveStatuses = Convert.ToString((int)LeaveStatusEnum.Approved) + "," + Convert.ToString((int)LeaveStatusEnum.Pending) }); if (dtLeaveApplicationDetails != null && dtLeaveApplicationDetails.AsEnumerable().Any()) { Message.Text = "Your leave dates are overlapping. Please check your Approved/Pending list."; Message.IsSuccess = false; Message.Show = true; return(false); } if (!string.IsNullOrEmpty(hdnHalfDayList.Value.Replace(',', ' ').Trim())) { if (!(ddlLeaveType.SelectedValue == ((int)LeaveTypeEnum.CL).ToString()) && !(ddlLeaveType.SelectedValue == ((int)LeaveTypeEnum.LWP).ToString())) { Message.Text = "You cannot apply half day with leave type " + ddlLeaveType.SelectedItem.Text; Message.IsSuccess = false; Message.Show = true; return(false); } } } else { Message.Text = "Employee Details not found."; Message.IsSuccess = false; Message.Show = true; return(false); } return(true); }
public DataTable LeaveDesignationConfig_GetAll(Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration) { return(DataAccess.LeaveManagement.LeaveDesignationWiseConfiguration.LeaveDesignationConfig_GetAll(leaveDesignationWiseConfiguration)); }
public int LeaveDesignationConfig_Save(Entity.LeaveManagement.LeaveDesignationWiseConfiguration objLeaveDesignation) { return(DataAccess.LeaveManagement.LeaveDesignationWiseConfiguration.LeaveDesignationConfig_Save(objLeaveDesignation)); }
private bool LeaveDesignationConfigValidate() { bool retValue = true; try { if (ddlLeaveType.SelectedIndex == 0) { Message.IsSuccess = false; Message.Text = "Please select Leave Type."; Message.Show = true; return(false); } if (ddlDesignation.SelectedIndex == 0) { Message.IsSuccess = false; Message.Text = "Please select Designation."; Message.Show = true; return(false); } if (string.IsNullOrEmpty(txtLeaveCount.Text.Trim())) { Message.IsSuccess = false; Message.Text = "Please enter Leave Total."; Message.Show = true; return(false); } if (string.IsNullOrEmpty(txtCarryForwardCount.Text.Trim())) { Message.IsSuccess = false; Message.Text = "Please enter Carry Forward Amount."; Message.Show = true; return(false); } if (string.IsNullOrEmpty(txtMinApplyDays.Text.Trim())) { Message.IsSuccess = false; Message.Text = "Please enter Min Apply Days."; Message.Show = true; return(false); } if (string.IsNullOrEmpty(txtMaxApplyDays.Text.Trim())) { Message.IsSuccess = false; Message.Text = "Please enter Max Apply Days."; Message.Show = true; return(false); } Business.LeaveManagement.LeaveDesignationWiseConfiguration objLeaveDesignationWiseConfiguration = new Business.LeaveManagement.LeaveDesignationWiseConfiguration(); Entity.LeaveManagement.LeaveDesignationWiseConfiguration leaveDesignationWiseConfiguration = new Entity.LeaveManagement.LeaveDesignationWiseConfiguration(); leaveDesignationWiseConfiguration.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue); leaveDesignationWiseConfiguration.DesignationId = Convert.ToInt32(ddlDesignation.SelectedValue); DataTable dt = objLeaveDesignationWiseConfiguration.LeaveDesignationConfig_GetAll(leaveDesignationWiseConfiguration); if (LeaveDesignationWiseConfigurationId == 0) { if (dt != null && dt.AsEnumerable().Any()) { Message.IsSuccess = false; Message.Text = "Designation configuration already exists."; Message.Show = true; return(false); } } else { if (dt == null || !dt.AsEnumerable().Any()) { Message.IsSuccess = false; Message.Text = "Designation configuration does not exists."; Message.Show = true; return(false); } } } catch (Exception ex) { ex.WriteException(); Message.IsSuccess = false; Message.Text = ex.Message; Message.Show = true; } return(retValue); }