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