private void FillGridViewLeave()
{
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
DataTable dtLeaveStatus = new DataTable();
UserBAL balUser = new UserBAL();
UserENT entUser = new UserENT();
entUser = balUser.SelectUserCount();
lblTotalEmployee.Text = entUser.Usercount.ToString();
dtLeaveStatus = balLeaveStatus.SelectAll();
Session["PendingLeaveRequest"] = dtLeaveStatus.Rows.Count;
if (dtLeaveStatus != null && dtLeaveStatus.Rows.Count > 0)
{
lblPendingLeave.Text = dtLeaveStatus.Rows.Count.ToString();
gvLeaveStatus.DataSource = dtLeaveStatus;
gvLeaveStatus.DataBind();
}
else if (dtLeaveStatus.Rows.Count < 1)
{
lblPendingLeave.Text = 0.ToString();
gvLeaveStatus.DataSource = null;
gvLeaveStatus.DataBind();
PanelGV.Visible = false;
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeaveStatus.Message;
}
}
protected void btnDeleteProfile_Click(object sender, EventArgs e)
{
UserBAL balUser = new UserBAL();
LeaveBAL balLeave = new LeaveBAL();
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
if (!balLeaveStatus.DeleteAll(Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
if (balLeave.DeleteAll(Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
if (!balLeaveType.DeleteAllByUserID(Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (!balUser.Delete(Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balUser.Message;
}
Session["UserID"] = null;
Response.Redirect("~/Content/Login.aspx");
}
protected void gvLeaveStatus_RowCommand(object sender, GridViewCommandEventArgs e)
{
LeaveBAL balLeave = new LeaveBAL();
LeaveENT entLeave = new LeaveENT();
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
UserENT entUser = new UserENT();
UserBAL balUser = new UserBAL();
entUser = balUser.SelectUserName(Convert.ToInt32(Session["UserID"].ToString().Trim()));
if (e.CommandName == "Approved")
{
if (e.CommandArgument != null)
{
#region Collect Data
entLeave.LeaveStatus = e.CommandName.ToString().Trim();
entLeave.LeaveResponseBy = entUser.UserName;
#endregion Collect Data
if (!balLeave.UpdateLeaveStatusInLeave(entLeave, Convert.ToInt32(e.CommandArgument)))
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeave.Message;
}
}
}
else if (e.CommandName == "Rejected")
{
if (e.CommandArgument != null)
{
#region Collect Data
entLeave.LeaveStatus = e.CommandName.ToString().Trim();
entLeave.LeaveResponseBy = entUser.UserName;
#endregion Collect Data
if (!balLeave.UpdateLeaveStatusInLeave(entLeave, Convert.ToInt32(e.CommandArgument)))
{
PanelErrorMesseage.Visible = true;
lblErrorMesseage.Text = balLeave.Message;
}
}
}
balLeaveStatus.Delete(Convert.ToInt32(e.CommandArgument));
FillGridViewLeave();
}
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());
}
}
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Collect Data
LeaveENT entLeave = new LeaveENT();
LeaveBAL balLeave = new LeaveBAL();
LeaveStatusENT entLeaveStatus = new LeaveStatusENT();
LeaveStatusBAL balLeaveStatus = new LeaveStatusBAL();
LeaveTypeENT entLeaveType = new LeaveTypeENT();
LeaveTypeBAL balLeaveType = new LeaveTypeBAL();
if (ddlLeaveType.SelectedIndex > 0)
{
entLeave.LeaveTypeID = Convert.ToInt32(ddlLeaveType.SelectedValue);
entLeaveStatus.LeaveTypeID = Convert.ToInt32(ddlLeaveType.SelectedValue);
entLeaveType.LeaveTypeID = Convert.ToInt32(ddlLeaveType.SelectedValue);
}
entLeaveType = balLeaveType.SelectByPK(entLeaveType.LeaveTypeID);
if (entLeave.LeaveID > 0)
{
entLeaveStatus.LeaveID = entLeave.LeaveID;
}
if (txtLeaveReason.Text.Trim() != "")
{
entLeave.LeaveReason = txtLeaveReason.Text.Trim();
}
if (rbHalfLeave.Checked != false)
{
entLeave.LeaveDuration = rbHalfLeave.Text.Trim();
}
if (rbFullLeave.Checked != false)
{
entLeave.LeaveDuration = rbFullLeave.Text.Trim();
}
if (txtLeaveStartDate.Text.Trim() != "")
{
DateTime today = DateTime.Today;
string strDate = txtLeaveStartDate.Text.Trim();
string[] dateString = strDate.Split('-');
DateTime startdate = Convert.ToDateTime(dateString[0] + "-" + dateString[1] + "-" + dateString[2]);
if (startdate < today)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "Leavedate must not be in past";
txtLeaveStartDate.Focus();
return;
}
else
{
PanelErrorMesseage.Visible = false;
entLeave.LeaveStartDate = txtLeaveStartDate.Text.Trim();
}
}
if (txtLeaveEndDate.Text.Trim() != "")
{
entLeave.LeaveEndDate = txtLeaveEndDate.Text.Trim();
}
#endregion Collect Data
if (Request.QueryString["LeaveID"] == null)
{
string strStartDate = txtLeaveStartDate.Text.Trim();
string[] StartDateString = strStartDate.Split('-');
DateTime startdate = Convert.ToDateTime(StartDateString[0] + "-" + StartDateString[1] + "-" + StartDateString[2]);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Casual Leave Because You Had Already Use It";
return;
}
else
{
if (balLeave.Insert(entLeave, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
if (entLeave.LeaveID > 0)
{
entLeaveStatus.LeaveID = entLeave.LeaveID;
}
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (!balLeaveStatus.Insert(entLeaveStatus, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
}
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Medical Leave Because You Had Already Use It";
return;
}
else
{
if (balLeave.Insert(entLeave, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
if (entLeave.LeaveID > 0)
{
entLeaveStatus.LeaveID = entLeave.LeaveID;
}
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (!balLeaveStatus.Insert(entLeaveStatus, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
}
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More LOP Because You Had Already Use It";
return;
}
else
{
if (balLeave.Insert(entLeave, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
if (entLeave.LeaveID > 0)
{
entLeaveStatus.LeaveID = entLeave.LeaveID;
}
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (!balLeaveStatus.Insert(entLeaveStatus, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
}
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Other Leave Because You Had Already Use It";
return;
}
else
{
if (balLeave.Insert(entLeave, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
if (entLeave.LeaveID > 0)
{
entLeaveStatus.LeaveID = entLeave.LeaveID;
}
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
clearSelection();
PanelSuccess.Visible = true;
lblSuccess.Text = "Data Inserted Successfully";
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (!balLeaveStatus.Insert(entLeaveStatus, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
}
}
}
else
{
entLeave.LeaveID = Convert.ToInt32(Request.QueryString["LeaveID"].ToString().Trim());
entLeaveStatus.LeaveID = Convert.ToInt32(Request.QueryString["LeaveID"].ToString().Trim());
string strStartDate = txtLeaveStartDate.Text.Trim();
string[] StartDateString = strStartDate.Split('-');
DateTime startdate = Convert.ToDateTime(StartDateString[0] + "-" + StartDateString[1] + "-" + StartDateString[2]);
if (entLeaveType.LeaveType == "Casual Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Casual Leave Because You Had Already Use It";
return;
}
}
else if (entLeaveType.LeaveType == "Medical Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Medical Leave Because You Had Already Use It";
return;
}
}
else if (entLeaveType.LeaveType == "LOP")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More LOP Leave Because You Had Already Use It";
return;
}
}
else if (entLeaveType.LeaveType == "Other Leave")
{
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (rbHalfLeave.Checked == true)
{
entLeaveType.TotalDays = entLeaveType.TotalDays - 1;
}
else if (rbFullLeave.Checked == true)
{
string strEndDate = txtLeaveEndDate.Text.Trim();
string[] EndDateString = strEndDate.Split('-');
DateTime enddate = Convert.ToDateTime(EndDateString[0] + "-" + EndDateString[1] + "-" + EndDateString[2]);
entLeaveType.TotalDays = entLeaveType.TotalDays - Convert.ToInt32((enddate - startdate).TotalDays) - 1;
}
if (entLeaveType.TotalDays < 0)
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = "You Can't Add More Other Leave Because You Had Already Use It";
return;
}
}
entLeaveType.UserID = Convert.ToInt32(Session["UserID"].ToString().Trim());
if (!balLeaveType.UpdateTotalDaysByLeaveType(entLeaveType))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveType.Message;
}
if (!balLeave.Update(entLeave, Convert.ToInt32(Session["UserID"].ToString().Trim())))
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeave.Message;
}
if (balLeaveStatus.UpdateLeaveStatus(entLeaveStatus))
{
Response.Redirect("~/Content/Leave/LeaveList.aspx");
}
else
{
PanelErrorMesseage.Visible = true;
lblErrorMessage.Text = balLeaveStatus.Message;
}
}
}
