private void GenerateYearly() { Business.LeaveManagement.LeaveGenerateLog objLeaveGenerateLog = new Business.LeaveManagement.LeaveGenerateLog(); Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog = new Entity.LeaveManagement.LeaveGenerateLog(); leaveGenerateLog.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue); leaveGenerateLog.Year = Convert.ToInt32(ddlYears.SelectedValue); DataTable dtLeaveGenerate = objLeaveGenerateLog.LeaveGenerateLog_GetAll(leaveGenerateLog); if (dtLeaveGenerate != null && dtLeaveGenerate.AsEnumerable().Any()) { Message.IsSuccess = false; Message.Text = "Leave Type " + ddlLeaveType.SelectedItem + " is already generated for " + ddlYears.SelectedItem; return; } //Generate Leave long leaveGenerateLogId = LeaveGenerateLog_Save(); int totalCount = Generate(); LeaveGenerateLog_Update(leaveGenerateLogId, totalCount); LeaveGenerateLog_GetAll(); Message.IsSuccess = true; Message.Text = "Processing completed."; }
private void LeaveGenerateLog_GetAll() { Business.LeaveManagement.LeaveGenerateLog objLeaveGenerateLog = new Business.LeaveManagement.LeaveGenerateLog(); Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog = new Entity.LeaveManagement.LeaveGenerateLog(); DataTable dtLeaveGenerateLog = objLeaveGenerateLog.LeaveGenerateLog_GetAll(leaveGenerateLog); dgvGeneratedLeaveList.DataSource = dtLeaveGenerateLog; dgvGeneratedLeaveList.DataBind(); }
private long LeaveGenerateLog_Update(long leaveGenerateLogId, int totalCount) { Business.LeaveManagement.LeaveGenerateLog objLeaveGenerateLog = new Business.LeaveManagement.LeaveGenerateLog(); Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog = new Entity.LeaveManagement.LeaveGenerateLog(); leaveGenerateLog.LeaveGenerateLogId = leaveGenerateLogId; leaveGenerateLog.TotalDistribution = totalCount; return(objLeaveGenerateLog.LeaveGenerateLog_Save(leaveGenerateLog)); }
private long LeaveGenerateLog_Save() { Business.LeaveManagement.LeaveGenerateLog objLeaveGenerateLog = new Business.LeaveManagement.LeaveGenerateLog(); Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog = new Entity.LeaveManagement.LeaveGenerateLog(); leaveGenerateLog.LeaveGenerateLogId = 0; leaveGenerateLog.LeaveTypeId = Convert.ToInt32(ddlLeaveType.SelectedValue); leaveGenerateLog.Month = ddlMonths.SelectedValue; leaveGenerateLog.Quarter = ddlQuarters.SelectedValue; leaveGenerateLog.Half = ddlHalf.SelectedValue; leaveGenerateLog.Year = Convert.ToInt32(ddlYears.SelectedValue); leaveGenerateLog.ScheduleDateTime = DateTime.Now; long leaveGenerateLogId = objLeaveGenerateLog.LeaveGenerateLog_Save(leaveGenerateLog); return(leaveGenerateLogId); }
public long LeaveGenerateLog_Save(Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog) { return(DataAccess.LeaveManagement.LeaveGenerateLog.LeaveGenerateLog_Save(leaveGenerateLog)); }
public DataTable LeaveGenerateLog_GetAll(Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog) { return(DataAccess.LeaveManagement.LeaveGenerateLog.LeaveGenerateLog_GetAll(leaveGenerateLog)); }
public static DataTable LeaveGenerateLog_GetAll(Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog) { 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_LeaveGenerateLog_GetAll"; if (leaveGenerateLog.LeaveTypeId == 0) { cmd.Parameters.AddWithValue("@LeaveTypeId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@LeaveTypeId", leaveGenerateLog.LeaveTypeId); } if (string.IsNullOrEmpty(leaveGenerateLog.Month)) { cmd.Parameters.AddWithValue("@Month", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Month", leaveGenerateLog.Month); } if (string.IsNullOrEmpty(leaveGenerateLog.Quarter)) { cmd.Parameters.AddWithValue("@Quarter", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Quarter", leaveGenerateLog.Quarter); } if (string.IsNullOrEmpty(leaveGenerateLog.Half)) { cmd.Parameters.AddWithValue("@Half", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Half", leaveGenerateLog.Half); } if (leaveGenerateLog.Year == 0) { cmd.Parameters.AddWithValue("@Year", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Year", leaveGenerateLog.Year); } if (leaveGenerateLog.ScheduleDateTime == DateTime.MinValue) { cmd.Parameters.AddWithValue("@ScheduleDateTime", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ScheduleDateTime", leaveGenerateLog.ScheduleDateTime); } using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { da.Fill(dt); } con.Close(); } } return(dt); } }
public static long LeaveGenerateLog_Save(Entity.LeaveManagement.LeaveGenerateLog leaveGenerateLog) { long 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_LeaveGenerateLog_Save"; cmd.Parameters.AddWithValue("@LeaveGenerateLogId", leaveGenerateLog.LeaveGenerateLogId).Direction = ParameterDirection.InputOutput; if (leaveGenerateLog.LeaveTypeId == 0) { cmd.Parameters.AddWithValue("@LeaveTypeId", DBNull.Value); } else { cmd.Parameters.AddWithValue("@LeaveTypeId", leaveGenerateLog.LeaveTypeId); } if (string.IsNullOrEmpty(leaveGenerateLog.Month)) { cmd.Parameters.AddWithValue("@Month", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Month", leaveGenerateLog.Month); } if (string.IsNullOrEmpty(leaveGenerateLog.Quarter)) { cmd.Parameters.AddWithValue("@Quarter", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Quarter", leaveGenerateLog.Quarter); } if (string.IsNullOrEmpty(leaveGenerateLog.Half)) { cmd.Parameters.AddWithValue("@Half", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Half", leaveGenerateLog.Half); } if (leaveGenerateLog.Year == 0) { cmd.Parameters.AddWithValue("@Year", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Year", leaveGenerateLog.Year); } if (leaveGenerateLog.TotalDistribution == 0) { cmd.Parameters.AddWithValue("@TotalDistribution", DBNull.Value); } else { cmd.Parameters.AddWithValue("@TotalDistribution", leaveGenerateLog.TotalDistribution); } if (leaveGenerateLog.ScheduleDateTime == DateTime.MinValue) { cmd.Parameters.AddWithValue("@ScheduleDateTime", DBNull.Value); } else { cmd.Parameters.AddWithValue("@ScheduleDateTime", leaveGenerateLog.ScheduleDateTime); } if (con.State == ConnectionState.Closed) { con.Open(); } cmd.ExecuteNonQuery(); retValue = Convert.ToInt64(cmd.Parameters["@LeaveGenerateLogId"].Value); con.Close(); } } return(retValue); }