private void fillControls(SqlInt32 LeaveID, SqlInt32 UserID)
{
LeaveBAL balLeave = new LeaveBAL();
LeaveENT entLeave = new LeaveENT();
entLeave = balLeave.SelectByPK(LeaveID, UserID);
if (!entLeave.LeaveTypeID.IsNull)
{
ddlLeaveType.SelectedValue = entLeave.LeaveTypeID.Value.ToString();
Session["LeaveTypeID"] = entLeave.LeaveTypeID.Value.ToString();
}
if (!entLeave.LeaveReason.IsNull)
{
txtLeaveReason.Text = entLeave.LeaveReason.Value.ToString();
}
if (!entLeave.LeaveDuration.IsNull)
{
if (entLeave.LeaveDuration == "HalfLeave")
{
rbHalfLeave.Checked = true;
lblLeaveStartDate.Text = "Leave Date";
txtLeaveEndDate.Text = "";
panelLeaveEndDate.Visible = false;
}
if (entLeave.LeaveDuration == "FullLeave")
{
rbFullLeave.Checked = true;
lblLeaveStartDate.Text = "Leave StartDate";
txtLeaveEndDate.Text = "";
panelLeaveEndDate.Visible = true;
}
}
if (!entLeave.LeaveStartDate.IsNull)
{
txtLeaveStartDate.Text = entLeave.LeaveStartDate.Value.ToString();
}
if (!entLeave.LeaveEndDate.IsNull)
{
txtLeaveEndDate.Text = entLeave.LeaveEndDate.Value.ToString();
}
}
protected void gvLeave_RowCommand(object sender, GridViewCommandEventArgs e)
{
LeaveBAL balLeave = new LeaveBAL();
LeaveENT entLeave = new LeaveENT();
LeaveENT entLeaveforRemainingLeave = new LeaveENT();
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
LeaveTypeENT entLeaveType = new LeaveTypeENT();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
entLeave = balLeave.SelectLeaveStatusByPK(Convert.ToInt32(e.CommandArgument.ToString().Trim()));
if (e.CommandName == "DeleteRecord")
{
if (e.CommandArgument != null)
{
entLeaveforRemainingLeave = balLeave.SelectByPK(Convert.ToInt32(e.CommandArgument.ToString().Trim()), Convert.ToInt32(Session["UserID"].ToString()));
if (balLeaveStatus.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim())))
{
if (!balLeave.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim()), Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
lblErrorMesseage.Text = balLeave.Message;
}
FillGridViewLeave();
displayRemainingLeave();
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeaveStatus.Message;
}
if (entLeave.LeaveResponseBy == "Pending" && entLeave.LeaveStatus == "Pending")
{
if (entLeaveforRemainingLeave.LeaveEndDate != "")
{
string strStartDate = entLeaveforRemainingLeave.LeaveStartDate.ToString();
string[] StartDateString = strStartDate.Split('-');
DateTime startdate = Convert.ToDateTime(StartDateString[0] + "-" + StartDateString[1] + "-" + StartDateString[2]);
string strEndDate = entLeaveforRemainingLeave.LeaveEndDate.ToString();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType = balLeaveType.SelectByPK(entLeave.LeaveTypeID);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
}
}
else
{
entLeaveType = balLeaveType.SelectByPK(entLeave.LeaveTypeID);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
}
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
displayRemainingLeave();
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeaveType.Message;
}
}
}
}
else if (e.CommandName == "EditRecord")
{
if (entLeave.LeaveResponseBy != "Pending" && entLeave.LeaveStatus != "Pending")
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = "You can not edit leave after Responsed";
}
else
{
if (e.CommandArgument != null)
{
Response.Redirect("~/Content/Leave/LeaveAddEdit.aspx?LeaveID=" + e.CommandArgument.ToString().Trim());
}
}
}
}
private void addLeave()
{
LeaveBAL balLeave = new LeaveBAL();
LeaveENT entLeave = new LeaveENT();
LeaveTypeENT entLeaveType = new LeaveTypeENT();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
entLeave = balLeave.SelectByPK(Convert.ToInt32(Request.QueryString["LeaveID"]), Convert.ToInt32(Session["UserID"].ToString().Trim()));
if (Request.QueryString["LeaveID"] != null)
{
if (entLeave.LeaveEndDate != "")
{
string strStartDate = entLeave.LeaveStartDate.ToString();
string[] StartDateString = strStartDate.Split('-');
DateTime startdate = Convert.ToDateTime(StartDateString[0] + "-" + StartDateString[1] + "-" + StartDateString[2]);
string strEndDate = entLeave.LeaveEndDate.ToString();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType = balLeaveType.SelectByPK(entLeave.LeaveTypeID);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
Session["Casual Leave"] = entLeaveType.TotalDays;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
Session["Medical Leave"] = entLeaveType.TotalDays;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
Session["LOP"] = entLeaveType.TotalDays;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + Convert.ToInt32((enddate - startdate).TotalDays) + 1;
Session["Other Leave"] = entLeaveType.TotalDays;
}
}
else
{
entLeaveType = balLeaveType.SelectByPK(entLeave.LeaveTypeID);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays + 1;
}
}
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
}
}
protected void btnCancel_Click(object sender, EventArgs e)
{
LeaveENT entLeave = new LeaveENT();
LeaveBAL balLeave = new LeaveBAL();
LeaveTypeENT entLeaveType = new LeaveTypeENT();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
if (Request.QueryString["LeaveID"] != null)
{
entLeave = balLeave.SelectByPK(Convert.ToInt32(Request.QueryString["LeaveID"]), Convert.ToInt32(Session["UserID"].ToString().Trim()));
entLeaveType = balLeaveType.SelectByPK(entLeave.LeaveTypeID);
if (entLeave.LeaveEndDate != "")
{
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32(Session["Casual Leave"].ToString().Trim()) - 2;
Session["Casual Leave"] = null;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32(Session["Medical Leave"].ToString().Trim()) - 2;
Session["Medical Leave"] = null;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32(Session["LOP"].ToString().Trim()) - 2;
Session["LOP"] = null;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32(Session["Other Leave"].ToString().Trim()) - 2;
Session["Other Leave"] = null;
}
}
else
{
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
}
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
}
Response.Redirect("~/Content/Leave/LeaveList.aspx");
}
