protected void lnk_Add_Command(object sender, CommandEventArgs e) { try { radFinPeriod.Enabled = radQuarters.Enabled = true; radQuarters.ClearSelection(); btn_Save.Visible = false; Rg_Quarters.Visible = false; clearControls(); BindFinancialPeriod(); SMHR_PENSION_QUARTERS _obj_Smhr_PensionQrtrs = new SMHR_PENSION_QUARTERS(); _obj_Smhr_PensionQrtrs.OPERATION = operation.Select; _obj_Smhr_PensionQrtrs.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_PensionQuarters(_obj_Smhr_PensionQrtrs); if (DT.Rows.Count > 0) { foreach (DataRow dr in DT.Rows) { radFinPeriod.Items.Remove(radFinPeriod.FindItemIndexByValue(dr["QRTR_PERIODID"].ToString())); } } //ControlsEnableorDisable(true); btn_Save.Visible = true; Rm_CY_page.SelectedIndex = 1; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AddQuarters", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public void LoadGrid() { try { SMHR_PENSION_QUARTERS _obj_Smhr_PensionQrtrs = new SMHR_PENSION_QUARTERS(); _obj_Smhr_PensionQrtrs.OPERATION = operation.Select; _obj_Smhr_PensionQrtrs.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_PensionQuarters(_obj_Smhr_PensionQrtrs); Rg_InteretsQuarters.DataSource = DT; clearControls(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AddQuarters", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { _obj_Smhr_PensionQrtrs = new SMHR_PENSION_QUARTERS(); _obj_Smhr_PensionQrtrs.QRTR_PERIODID = Convert.ToInt32(radFinPeriod.SelectedItem.Value); _obj_Smhr_PensionQrtrs.QRTR_NOOFQRTRS = Convert.ToInt32(radQuarters.SelectedItem.Value); RadDatePicker rd1, rd2; foreach (GridDataItem g in Rg_Quarters.Items) { rd1 = rd2 = new RadDatePicker(); rd1 = g.FindControl("rdpStartDate") as RadDatePicker; rd2 = g.FindControl("rdpEndDate") as RadDatePicker; switch (g.Cells[2].Text) { case "1": _obj_Smhr_PensionQrtrs.QRTR_QRTR1SDATE = (DateTime)rd1.SelectedDate; _obj_Smhr_PensionQrtrs.QRTR_QRTR1EDATE = (DateTime)rd2.SelectedDate; if (_obj_Smhr_PensionQrtrs.QRTR_QRTR1EDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR1SDATE) { BLL.ShowMessage(this, "Quarter1 End Date Should be Greater than Quarter1 Start Date"); return; } break; case "2": _obj_Smhr_PensionQrtrs.QRTR_QRTR2SDATE = (DateTime)rd1.SelectedDate; _obj_Smhr_PensionQrtrs.QRTR_QRTR2EDATE = (DateTime)rd2.SelectedDate; if (_obj_Smhr_PensionQrtrs.QRTR_QRTR2EDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR2SDATE) { BLL.ShowMessage(this, "Quarter2 End Date Should be Greater than Quarter2 Start Date"); return; } if (_obj_Smhr_PensionQrtrs.QRTR_QRTR2SDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR1EDATE) { BLL.ShowMessage(this, "Quarter2 Start Date Should be Greater than Quarter1 end Date"); return; } break; case "3": _obj_Smhr_PensionQrtrs.QRTR_QRTR3SDATE = (DateTime)rd1.SelectedDate; _obj_Smhr_PensionQrtrs.QRTR_QRTR3EDATE = (DateTime)rd2.SelectedDate; if (_obj_Smhr_PensionQrtrs.QRTR_QRTR3EDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR3SDATE) { BLL.ShowMessage(this, "Quarter3 End Date Should be Greater than Quarter3 Start Date"); return; } if (_obj_Smhr_PensionQrtrs.QRTR_QRTR3SDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR2EDATE) { BLL.ShowMessage(this, "Quarter3 Start Date Should be Greater than Quarter2 end Date"); return; } break; case "4": _obj_Smhr_PensionQrtrs.QRTR_QRTR4SDATE = (DateTime)rd1.SelectedDate; _obj_Smhr_PensionQrtrs.QRTR_QRTR4EDATE = (DateTime)rd2.SelectedDate; if (_obj_Smhr_PensionQrtrs.QRTR_QRTR4EDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR4SDATE) { BLL.ShowMessage(this, "Quarter4 End Date Should be Greater than Quarter4 Start Date"); return; } if (_obj_Smhr_PensionQrtrs.QRTR_QRTR4SDATE < _obj_Smhr_PensionQrtrs.QRTR_QRTR3EDATE) { BLL.ShowMessage(this, "Quarter4 Start Date Should be Greater than Quarter3 end Date"); return; } break; } } switch (radQuarters.SelectedItem.Value) { case "1": if (Convert.ToDateTime(hdnEndDate.Value) != _obj_Smhr_PensionQrtrs.QRTR_QRTR1EDATE) { BLL.ShowMessage(this, "Quarter1 End Date Should be equal to Financial period end Date"); return; } break; case "2": if (Convert.ToDateTime(hdnEndDate.Value) != _obj_Smhr_PensionQrtrs.QRTR_QRTR2EDATE) { BLL.ShowMessage(this, "Quarter2 End Date Should be equal to Financial period end Date"); return; } break; case "3": if (Convert.ToDateTime(hdnEndDate.Value) != _obj_Smhr_PensionQrtrs.QRTR_QRTR3EDATE) { BLL.ShowMessage(this, "Quarter3 End Date Should be equal to Financial period end Date"); return; } break; case "4": if (Convert.ToDateTime(hdnEndDate.Value) != _obj_Smhr_PensionQrtrs.QRTR_QRTR4EDATE) { BLL.ShowMessage(this, "Quarter4 End Date Should be equal to Financial period end Date"); return; } break; } _obj_Smhr_PensionQrtrs.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); _obj_Smhr_PensionQrtrs.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); _obj_Smhr_PensionQrtrs.CREATEDDATE = DateTime.Now; _obj_Smhr_PensionQrtrs.LASTMDFDATE = DateTime.Now; _obj_Smhr_PensionQrtrs.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Smhr_PensionQrtrs.QRTR_ID = Convert.ToInt32(lblID.Text); _obj_Smhr_PensionQrtrs.OPERATION = operation.Update; if (BLL.set_PensionQuarters(_obj_Smhr_PensionQrtrs)) { BLL.ShowMessage(this, "Information Updated Successfully"); } else { BLL.ShowMessage(this, "Information Not Updated"); } break; case "BTN_SAVE": _obj_Smhr_PensionQrtrs.OPERATION = operation.Insert; if (BLL.set_PensionQuarters(_obj_Smhr_PensionQrtrs)) { BLL.ShowMessage(this, "Information Saved Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; default: break; } Rm_CY_page.SelectedIndex = 0; LoadGrid(); Rg_InteretsQuarters.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AddQuarters", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { clearControls(); _obj_Smhr_PensionQrtrs = new SMHR_PENSION_QUARTERS(); _obj_Smhr_PensionQrtrs.OPERATION = operation.Get; _obj_Smhr_PensionQrtrs.QRTR_ID = Convert.ToInt32(e.CommandArgument); lblID.Text = _obj_Smhr_PensionQrtrs.QRTR_ID.ToString(); _obj_Smhr_PensionQrtrs.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_PensionQuarters(_obj_Smhr_PensionQrtrs); BindFinancialPeriod(); radFinPeriod.SelectedIndex = radFinPeriod.FindItemIndexByValue(dt.Rows[0]["QRTR_PERIODID"].ToString()); radQuarters.SelectedIndex = radQuarters.FindItemIndexByValue(dt.Rows[0]["QRTR_NOOFQRTRS"].ToString()); radFinPeriod.Enabled = radQuarters.Enabled = false; DataTable dtGridData = GetDataTable(); for (int i = 1; i <= Convert.ToInt32(dt.Rows[0]["QRTR_NOOFQRTRS"]); i++) { switch (i.ToString()) { case "1": dtGridData.Rows.Add(i, "Quarter " + i.ToString(), Convert.ToDateTime(dt.Rows[0]["PERIOD_STARTDATE"]), Convert.ToDateTime(dt.Rows[0]["PERIOD_ENDDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR1SDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR1EDATE"])); break; case "2": dtGridData.Rows.Add(i, "Quarter " + i.ToString(), Convert.ToDateTime(dt.Rows[0]["PERIOD_STARTDATE"]), Convert.ToDateTime(dt.Rows[0]["PERIOD_ENDDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR2SDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR2EDATE"])); break; case "3": dtGridData.Rows.Add(i, "Quarter " + i.ToString(), Convert.ToDateTime(dt.Rows[0]["PERIOD_STARTDATE"]), Convert.ToDateTime(dt.Rows[0]["PERIOD_ENDDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR3SDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR3EDATE"])); break; case "4": dtGridData.Rows.Add(i, "Quarter " + i.ToString(), Convert.ToDateTime(dt.Rows[0]["PERIOD_STARTDATE"]), Convert.ToDateTime(dt.Rows[0]["PERIOD_ENDDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR4SDATE"]), Convert.ToDateTime(dt.Rows[0]["QRTR_QRTR4EDATE"])); break; } } Rg_Quarters.DataSource = dtGridData; Rg_Quarters.DataBind(); Rg_Quarters.Visible = true; SMHR_PERIOD osmhr_period = new SMHR_PERIOD(); osmhr_period.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); osmhr_period.PERIOD_ID = Convert.ToInt32(radFinPeriod.SelectedValue); DataTable dtCurrentFinPeriod = BLL.IscurrentFinPeriod(osmhr_period); if (string.Compare(dtCurrentFinPeriod.Rows[0]["ISEXISTS"].ToString(), "0", true) == 0) { Rg_Quarters.Enabled = false; btn_Update.Visible = false; } else { Rg_Quarters.Enabled = Convert.ToBoolean(dt.Rows[0]["ISEnable"]); btn_Update.Visible = Convert.ToBoolean(dt.Rows[0]["ISEnable"]); } Rm_CY_page.SelectedIndex = 1; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_AddQuarters", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void rcmb_FinancialYear_SelectedIndexChanged(object o, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e) { try { if (rcmb_FinancialYear.SelectedIndex > 0) { btn_Save.Visible = true; } else { btn_Save.Visible = false; } //clear controls trQrtr1.Visible = false; trQrtr2.Visible = false; trQrtr3.Visible = false; trQrtr4.Visible = false; trYearlyIntrst.Visible = false; SMHR_PENSION_QUARTERS _obj_Smhr_PensionQrtrs = new SMHR_PENSION_QUARTERS(); _obj_Smhr_PensionQrtrs.OPERATION = operation.Select_New; _obj_Smhr_PensionQrtrs.QRTR_PERIODID = Convert.ToInt32(rcmb_FinancialYear.SelectedValue); _obj_Smhr_PensionQrtrs.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_PensionQuarters(_obj_Smhr_PensionQrtrs); if (dt.Rows.Count > 0) { btn_Save.Visible = true; int noOfQrtrs = Convert.ToInt32(dt.Rows[0]["QRTR_NOOFQRTRS"]); if (noOfQrtrs > 0) { trYearlyIntrst.Visible = true; for (int i = 1; i <= noOfQrtrs; i++) { if (i == 1) { trQrtr1.Visible = true; } else if (i == 2) { trQrtr2.Visible = true; } else if (i == 3) { trQrtr3.Visible = true; } else if (i == 4) { trQrtr4.Visible = true; } } } } else { btn_Save.Visible = false; } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_IntrstOnNormlContribution", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }