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