protected void lnk_Delete_Command(object sender, CommandEventArgs e) { try { _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); lbl_HID = Convert.ToString(e.CommandArgument); DataTable dt = new DataTable(); _obj_Smhr_Holiday.OPERATION = operation.Delete; if (BLL.set_HolidayMaster(_obj_Smhr_Holiday)) { BLL.ShowMessage(this, "Row deleted Successfully"); } else { BLL.ShowMessage(this, "Row Could Not be Deleted"); } LoadMainGrid(); Rg_HolidayCalendar.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { LoadCombos(); btn_Save.Visible = false; _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(Convert.ToString(e.CommandArgument)); lbl_HID = Convert.ToString(e.CommandArgument); DataTable dt = new DataTable(); dt = BLL.get_HolidayMaster(_obj_Smhr_Holiday); rcmb_BusinessUnit.SelectedIndex = rcmb_BusinessUnit.Items.FindItemIndexByValue(Convert.ToString(dt.Rows[0]["HOLMST_BUSINESSUNITID"])); // rcmb_BusinessUnit.SelectedIndex = Convert.ToInt32(dt.Rows[0]["HOLMST_BUSINESSUNITID"]); rtxt_HCCode.Text = Convert.ToString(dt.Rows[0]["HOLMST_CODE"]); rtxt_HCDesc.Text = Convert.ToString(dt.Rows[0]["HOLMST_DESCRIPTION"]); rdtp_HCDATE.SelectedDate = Convert.ToDateTime(dt.Rows[0]["HOLMST_DATE"]); rtxt_HCCode.Enabled = false; Rm_HolidayCalendar_page.SelectedIndex = 1; //code for security if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Edit.Visible = false; } else { btn_Edit.Visible = true; } //if (Convert.ToString(Request.QueryString["ID"]) == null) //{ // rcmb_BusinessUnit.Enabled = true; //} //else //{ rcmb_BusinessUnit.Enabled = false; //} } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public void LoadMainGrid() { try { if (Convert.ToString(Request.QueryString["ID"]) == null) { _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); Rg_HolidayCalendar.DataSource = BLL.get_HolidayMaster(_obj_Smhr_Holiday); for (int h = 0; h <= Rg_HolidayCalendar.Items.Count - 1; h++) { LinkButton lnk_Delete = new LinkButton(); lnk_Delete = Rg_HolidayCalendar.Items[h].FindControl("lnk_Delete") as LinkButton; lnk_Delete.Visible = false; } Rm_HolidayCalendar_page.SelectedIndex = 0; } else { _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.OPERATION = operation.Empty; _obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(Convert.ToString(Request.QueryString["ID"])); _obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); Rg_HolidayCalendar.DataSource = BLL.get_HolidayMaster(_obj_Smhr_Holiday); for (int h = 0; h <= Rg_HolidayCalendar.Items.Count - 1; h++) { LinkButton lnk_Delete = new LinkButton(); lnk_Delete = Rg_HolidayCalendar.Items[h].FindControl("lnk_Delete") as LinkButton; lnk_Delete.Visible = false; } Rm_HolidayCalendar_page.SelectedIndex = 0; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
/*protected void rntb_Hours_TextChanged(object sender, EventArgs e) * { * try * { * decimal hrs = 0, mins = 0, val = 0, final = 0; * string weekDay = string.Empty; * * if (rdtp_OTDt.SelectedDate != null) * { * weekDay = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString(); * * if (weekDay == "Saturday" || weekDay == "Sunday") * val = 2; * else * val = Convert.ToDecimal(1.5); * * if (rtbOTHrs.Text != string.Empty || rntb_Mins.Text != string.Empty) * { * if (rtbOTHrs.Text != string.Empty) * hrs = Convert.ToDecimal(rtbOTHrs.Text) * 60; //to convert hours into minutes * if (rntb_Mins.Text != string.Empty) * mins = Convert.ToDecimal(rntb_Mins.Text); * * final = (hrs + mins) * val; * * if (final > 0) * { * rtbOTHrs.Text = Convert.ToString(final / 60).Substring(0, 2); * rtbOTMins.Text = Convert.ToString(final % 60); * } * } * else * { * if (rtbOTHrs.Text != string.Empty && rntb_Mins.Text != string.Empty) * rtbOTHrs.Text = rntb_Mins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; * } * } * else * { * BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours"); * rtbOTHrs.Text = rntb_Mins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; * rdtp_OTDt.Focus(); * return; * } * } * catch (Exception ex) * { * throw ex; * } * }*/ protected void rtbActHrs_TextChanged(object sender, EventArgs e) { try { decimal hrs = 0, mins = 0, val = 0, final = 0, hldyval = 0, hldyfinal = 0; string weekDay = string.Empty; string holiday = string.Empty; int maxHrs = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["maxHrs"]); int maxMins = Convert.ToInt32(System.Configuration.ConfigurationSettings.AppSettings["maxMins"]); SMHR_HOLIDAY _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.OPERATION = operation.chkholiday; _obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(rcmb_BusinessUnit.SelectedValue); _obj_Smhr_Holiday.HOLMST_DATE = Convert.ToDateTime(rdtp_OTDt.SelectedDate); if (rdtp_OTDt.SelectedDate == null) { BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours"); rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; rdtp_OTDt.Focus(); return; } DataTable dthld = new DataTable(); dthld = BLL.get_HolidayMaster(_obj_Smhr_Holiday); if (Convert.ToInt32(dthld.Rows[0]["HOLMST_DATE"]) > 0) { if (rdtp_OTDt.SelectedDate != null) { holiday = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString(); if (holiday == "Saturday" || holiday == "Sunday") { hldyval = 2; } else { hldyval = Convert.ToInt32(2); } if (rtbActHrs.Text != string.Empty || rtbActMins.Text != string.Empty) { if (rtbActHrs.Text != string.Empty) { if (Convert.ToInt32(rtbActHrs.Text) > 12) { rtbActHrs.Text = maxHrs.ToString(); } } if (rtbActMins.Text != string.Empty) { if (Convert.ToInt32(rtbActMins.Text) > 59) { rtbActMins.Text = maxMins.ToString(); } } if (rtbActHrs.Text != string.Empty) { hrs = Convert.ToDecimal(rtbActHrs.Text) * 60; //to convert hours into minutes } if (rtbActMins.Text != string.Empty) { mins = Convert.ToDecimal(rtbActMins.Text); } hldyfinal = (hrs + mins) * hldyval; if (hldyval > 0) { if (Convert.ToString(hldyfinal / 60).Contains('.')) { rtbOTHrs.Text = Convert.ToString(hldyfinal / 60).Substring(0, Convert.ToString(hldyfinal / 60).IndexOf('.')); } else { rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(hldyfinal / 60)); } rtbOTMins.Text = Convert.ToString(Convert.ToInt32((hldyfinal % 60) + Convert.ToDecimal(0.1))); } } else { if (rtbActHrs.Text == string.Empty && rtbActMins.Text == string.Empty) { rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; } } } } else if (rdtp_OTDt.SelectedDate != null) { weekDay = Convert.ToDateTime(rdtp_OTDt.SelectedDate).DayOfWeek.ToString(); if (weekDay == "Saturday" || weekDay == "Sunday") { val = 2; } else { val = Convert.ToDecimal(1.5); } if (rtbActHrs.Text != string.Empty || rtbActMins.Text != string.Empty) { if (rtbActHrs.Text != string.Empty) { if (Convert.ToInt32(rtbActHrs.Text) > 12) { rtbActHrs.Text = maxHrs.ToString(); } } if (rtbActMins.Text != string.Empty) { if (Convert.ToInt32(rtbActMins.Text) > 59) { rtbActMins.Text = maxMins.ToString(); } } if (rtbActHrs.Text != string.Empty) { hrs = Convert.ToDecimal(rtbActHrs.Text) * 60; //to convert hours into minutes } if (rtbActMins.Text != string.Empty) { mins = Convert.ToDecimal(rtbActMins.Text); } final = (hrs + mins) * val; //hldyfinal = (hrs + mins) * hldyval; //if (hldyval>0) //{ // if (Convert.ToString(hldyfinal / 60).Contains('.')) // rtbOTHrs.Text = Convert.ToString(hldyfinal / 60).Substring(0, Convert.ToString(hldyfinal / 60).IndexOf('.')); // else // rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(hldyfinal / 60)); // rtbOTMins.Text = Convert.ToString(Convert.ToInt32((hldyfinal % 60) + Convert.ToDecimal(0.1))); //} if (final > 0) { if (Convert.ToString(final / 60).Contains('.')) { rtbOTHrs.Text = Convert.ToString(final / 60).Substring(0, Convert.ToString(final / 60).IndexOf('.')); } else { rtbOTHrs.Text = Convert.ToString(Convert.ToInt32(final / 60)); } rtbOTMins.Text = Convert.ToString(Convert.ToInt32((final % 60) + Convert.ToDecimal(0.1))); } } else { if (rtbActHrs.Text == string.Empty && rtbActMins.Text == string.Empty) { rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; } } } else { BLL.ShowMessage(this, "Please select Date of Over Time before entering Actual hours"); rtbActHrs.Text = rtbActMins.Text = rtbOTHrs.Text = rtbOTMins.Text = string.Empty; rdtp_OTDt.Focus(); return; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmOverTimeCalcRM", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { _obj_Smhr_Holiday = new SMHR_HOLIDAY(); _obj_Smhr_Holiday.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString()); _obj_Smhr_Holiday.HOLMST_BUSINESSUNITID = Convert.ToInt32(rcmb_BusinessUnit.SelectedItem.Value); _obj_Smhr_Holiday.HOLMST_CODE = Convert.ToString(rtxt_HCCode.Text); if (_obj_Smhr_Holiday.HOLMST_CODE.Contains("'")) { _obj_Smhr_Holiday.HOLMST_CODE = _obj_Smhr_Holiday.HOLMST_CODE.Replace("'", "''"); } _obj_Smhr_Holiday.HOLMST_DESCRIPTION = Convert.ToString(rtxt_HCDesc.Text); if (_obj_Smhr_Holiday.HOLMST_DESCRIPTION.Contains("'")) { _obj_Smhr_Holiday.HOLMST_DESCRIPTION = _obj_Smhr_Holiday.HOLMST_DESCRIPTION.Replace("'", "''"); } _obj_Smhr_Holiday.HOLMST_DATE = Convert.ToDateTime(rdtp_HCDATE.SelectedDate); _obj_Smhr_Holiday.HOLMST_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_Smhr_Holiday.HOLMST_CREATEDDATE = DateTime.Now; _obj_Smhr_Holiday.HOLMST_LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); _obj_Smhr_Holiday.HOLMST_LASTMDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_SAVE": _obj_Smhr_Holiday.OPERATION = operation.Check; if (Convert.ToString(BLL.get_HolidayMaster(_obj_Smhr_Holiday).Rows[0][0]) != "0") { BLL.ShowMessage(this, "This Holiday Name Is Already Exists"); rtxt_HCCode.Text = String.Empty; return; } _obj_Smhr_Holiday.OPERATION = operation.Insert; if (BLL.set_HolidayMaster(_obj_Smhr_Holiday)) { BLL.ShowMessage(this, "Information Saved Successfully"); Rm_HolidayCalendar_page.SelectedIndex = 0; LoadMainGrid(); Rg_HolidayCalendar.DataBind(); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; case "BTN_EDIT": _obj_Smhr_Holiday.HOLMST_ID = Convert.ToInt32(lbl_HID); _obj_Smhr_Holiday.OPERATION = operation.Check; if (Convert.ToString(BLL.get_HolidayMaster(_obj_Smhr_Holiday).Rows[0][0]) != "1") { BLL.ShowMessage(this, "This Holiday Name Is Already Exists"); rtxt_HCCode.Text = String.Empty; return; } _obj_Smhr_Holiday.OPERATION = operation.Update; if (BLL.set_HolidayMaster(_obj_Smhr_Holiday)) { BLL.ShowMessage(this, "Information Updated Successfully"); Rm_HolidayCalendar_page.SelectedIndex = 0; LoadMainGrid(); Rg_HolidayCalendar.DataBind(); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_HolidayCalendar", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }