private void btnadd_Click(object sender, EventArgs e)
{
new_ID();
int insertrec = 0;
try
{
leave.LEAVEID = txtleaveid.Text;
leave.EMPID = cmbemp.SelectedValue.ToString();
leave.APPDATE = DateTime.Parse(dateTimePicker1.Value.ToLongTimeString());
leave.RESDATE = DateTime.Parse(dateTimePicker2.Value.ToLongTimeString());
leave.TYPE = cmbtype.Text;
insertrec = leavebal.Insert(leave);
gridBind();
if (insertrec > 0)
{
MessageBox.Show("Record Insert Successfull", "Insert", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show("Record Already Insert!!!");
}
}
catch (Exception ee)
{
MessageBox.Show(ee.ToString(), "Insert Error");
}
finally
{
}
}
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;
}
}
}
