private void BindMedicalGrid() { try { int count = 0; RadGrid1.Visible = true; smhr_MedicalBenfit = new SMHR_MEDICALBENFIT(); smhr_MedicalBenfit.OPERATION = operation.Get; smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]); //smhr_MedicalBenfit.ExpendID = Convert.ToInt32(rad_ExpenditureName.SelectedValue); smhr_MedicalBenfit.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue); DataTable dt = BLL.get_MedicalBenfit(smhr_MedicalBenfit); 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) { RadGrid1.Enabled = false; RadGrid1.MasterTableView.Columns[3].Visible = false; } else { RadGrid1.Enabled = true; RadGrid1.MasterTableView.Columns[3].Visible = true; } RadGrid1.DataSource = dt; RadGrid1.DataBind(); for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(dt.Rows[i]["medical_added"]) == false) { RadGrid1.MasterTableView.Columns[3].Visible = false; return; } } } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public void LoadGrid() { try { smhr_MedicalBenfit = new SMHR_MEDICALBENFIT(); smhr_MedicalBenfit.OPERATION = operation.Select; smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_MedicalBenfit(smhr_MedicalBenfit); Rg_MedicalBenifit.DataSource = DT; clearControls(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { if (radFinPeriod.SelectedIndex <= 0) { BLL.ShowMessage(this, "Please Select Financial Period"); return; } smhr_MedicalBenfit = new SMHR_MEDICALBENFIT(); smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]); DataTable dtGadeWiseAMount = GetGadeWiseAMount(); smhr_MedicalBenfit.GradeWiseAmount = dtGadeWiseAMount; smhr_MedicalBenfit.FinancialPeriodID = Convert.ToInt32(radFinPeriod.SelectedValue); smhr_MedicalBenfit.MEDICALBENFIT_CREATEDBY = Convert.ToInt32(Session["USER_ID"]); smhr_MedicalBenfit.MEDICALBENFIT_CREATEDDATE = DateTime.Now; smhr_MedicalBenfit.MEDICALBENFIT_MDFBY = Convert.ToInt32(Session["USER_ID"]); smhr_MedicalBenfit.MEDICALBENFIT_MDFDATE = DateTime.Now; switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": //smhr_MedicalBenfit.ExpendID = Convert.ToInt32(lbl_ExpenditureID.Text); smhr_MedicalBenfit.OPERATION = operation.Insert; if (BLL.set_MedicalBenfit(smhr_MedicalBenfit)) { BLL.ShowMessage(this, "Information Updated Successfully"); } else { BLL.ShowMessage(this, "Information Not Updated"); } break; case "BTN_SAVE": //smhr_MedicalBenfit.ExpendID = Convert.ToInt32(rad_ExpenditureName.SelectedValue); smhr_MedicalBenfit.OPERATION = operation.Insert; if (BLL.set_MedicalBenfit(smhr_MedicalBenfit)) { BLL.ShowMessage(this, "Information Saved Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; default: break; } Rm_CY_page.SelectedIndex = 0; LoadGrid(); Rg_MedicalBenifit.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { int finPrdID = Convert.ToInt32(e.CommandArgument); lbl_ExpenditureID.Text = finPrdID.ToString(); int count = 0; clearControls(); BindFinancialPeriod(); BindExpenditureNames(); rad_ExpenditureName.Enabled = false; RadGrid1.Visible = true; smhr_MedicalBenfit = new SMHR_MEDICALBENFIT(); smhr_MedicalBenfit.OPERATION = operation.Get; smhr_MedicalBenfit.OrgID = Convert.ToInt32(Session["ORG_ID"]); //smhr_MedicalBenfit.ExpendID = lbl_ExpenditureID.Text; smhr_MedicalBenfit.FinancialPeriodID = finPrdID; DataTable dt = BLL.get_MedicalBenfit(smhr_MedicalBenfit); RadGrid1.DataSource = dt; RadGrid1.DataBind(); if (dt.Rows.Count > 0) { SMHR_EXPENDITURE _obj_Smhr_Expenditure = new SMHR_EXPENDITURE(); _obj_Smhr_Expenditure.OPERATION = operation.Select; _obj_Smhr_Expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); /*rad_ExpenditureName.DataSource = BLL.get_Expenditure(_obj_Smhr_Expenditure); * rad_ExpenditureName.DataValueField = "EXPENDITURE_ID"; * rad_ExpenditureName.DataTextField = "EXPENDITURE_NAME"; * rad_ExpenditureName.DataBind(); * rad_ExpenditureName.Items.Insert(0, new Telerik.Web.UI.RadComboBoxItem("Select", "-1")); * rad_ExpenditureName.SelectedIndex = rad_ExpenditureName.FindItemIndexByValue(smhr_MedicalBenfit.ExpendID.ToString());*/ radFinPeriod.SelectedIndex = radFinPeriod.FindItemIndexByValue(dt.Rows[0]["MEDICALBENFIT_FIN_PERIOD_ID"].ToString()); } 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) { RadGrid1.Enabled = false; } else { RadGrid1.Enabled = true; } // trExpend.Visible = false; // rad_ExpenditureName.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_NAME"]); // rad_ExpenditureName.Enabled = false; // rtxt_ExpenditureDesc.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_DESC"]); if (Convert.ToInt32(Session["WRITEFACILITY"]) == 2) { btn_Update.Visible = false; } else { btn_Update.Visible = true; } Rm_CY_page.SelectedIndex = 1; for (int i = 0; i < dt.Rows.Count; i++) { if (Convert.ToBoolean(dt.Rows[i]["MEDICAL_ADDED"]) == false) { count++; } } if (count > 0) { RadGrid1.MasterTableView.Columns[3].Visible = false; } else { RadGrid1.MasterTableView.Columns[3].Visible = true; } radFinPeriod.Enabled = false; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "MedicalBenifits", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }