protected void lnk_Edit_Command(object sender, CommandEventArgs e) { try { clearControls(); rtxt_ExpenditureName.Enabled = false; _obj_Smhr_Expenditure = new SMHR_EXPENDITURE(); _obj_Smhr_Expenditure.OPERATION = operation.Get; _obj_Smhr_Expenditure.EXPENDITURE_ID = Convert.ToInt32(e.CommandArgument); DataTable dt = BLL.get_Expenditure(_obj_Smhr_Expenditure); lbl_ExpenditureID.Text = dt.Rows[0]["EXPENDITURE_ID"].ToString(); rtxt_ExpenditureName.Text = Convert.ToString(dt.Rows[0]["EXPENDITURE_NAME"]); 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; } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ExpenditureType", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
protected void btn_Save_Click(object sender, EventArgs e) { try { _obj_Smhr_Expenditure = new SMHR_EXPENDITURE(); _obj_Smhr_Expenditure.EXPENDITURE_NAME = BLL.ReplaceQuote(rtxt_ExpenditureName.Text); _obj_Smhr_Expenditure.EXPENDITURE_DESC = BLL.ReplaceQuote(rtxt_ExpenditureDesc.Text); _obj_Smhr_Expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); switch (((Button)sender).ID.ToUpper()) { case "BTN_UPDATE": _obj_Smhr_Expenditure.EXPENDITURE_ID = Convert.ToInt32(lbl_ExpenditureID.Text); _obj_Smhr_Expenditure.OPERATION = operation.Update; if (BLL.set_Expenditure(_obj_Smhr_Expenditure)) { BLL.ShowMessage(this, "Information Updated Successfully"); } else { BLL.ShowMessage(this, "Information Not Updated"); } break; case "BTN_SAVE": _obj_Smhr_Expenditure.OPERATION = operation.Check; if (Convert.ToString(BLL.get_Expenditure(_obj_Smhr_Expenditure).Rows[0][0]) != "0") { BLL.ShowMessage(this, "Expenditure Name Already Exists"); return; } _obj_Smhr_Expenditure.OPERATION = operation.Insert; if (BLL.set_Expenditure(_obj_Smhr_Expenditure)) { BLL.ShowMessage(this, "Information Saved Successfully"); } else { BLL.ShowMessage(this, "Information Not Saved"); } break; default: break; } Rm_CY_page.SelectedIndex = 0; LoadGrid(); Rg_Expenditure.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ExpenditureType", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
public void LoadGrid() { try { _obj_Smhr_Expenditure = new SMHR_EXPENDITURE(); _obj_Smhr_Expenditure.OPERATION = operation.Select; _obj_Smhr_Expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable DT = BLL.get_Expenditure(_obj_Smhr_Expenditure); Rg_Expenditure.DataSource = DT; clearControls(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ExpenditureType", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void BindExpenditure() { try { SMHR_EXPENDITURE _obj_smhr_expenditure = new SMHR_EXPENDITURE(); _obj_smhr_expenditure.OPERATION = operation.Select; _obj_smhr_expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_Expenditure(_obj_smhr_expenditure); radExpenditureName.DataSource = dt; radExpenditureName.DataTextField = "EXPENDITURE_NAME"; radExpenditureName.DataValueField = "EXPENDITURE_ID"; radExpenditureName.DataBind(); } catch (Exception ex) { SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ServiceProviders", ex.StackTrace, DateTime.Now); Response.Redirect("~/Frm_ErrorPage.aspx"); } }
private void BindExpenditureNames() { try { SMHR_EXPENDITURE _obj_Smhr_Expenditure = new SMHR_EXPENDITURE(); _obj_Smhr_Expenditure.OPERATION = operation.Select2; _obj_Smhr_Expenditure.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); DataTable dt = BLL.get_Expenditure(_obj_Smhr_Expenditure); rad_ExpenditureName.DataSource = dt; 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")); } 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"); } }
private void ValidateData(out SMHR_MedicalInvoice oSMHR_MedicalInvoice, out bool result) { try { result = true; oSMHR_MedicalInvoice = new SMHR_MedicalInvoice(); string strfilename = Guid.NewGuid().ToString() + FBrowse.FileName; strfilename2 = strfilename; if (FBrowse.HasFile) { FBrowse.PostedFile.SaveAs(Server.MapPath("~/MedicalInvoice/") + strfilename); } else { result = false; BLL.ShowMessage(this, "Please Select the File to upload"); return; } string strpath = Server.MapPath("~/MedicalInvoice/") + strfilename; string ExcelPath = System.Configuration.ConfigurationManager.AppSettings["ExcelPath"];//"Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=Excel 8.0;"; string strcon = ExcelPath + "Data Source='" + strpath + "';"; DataTable dtExcelData = GetDatafromExcel(strcon); if (dtExcelData != null && ValidateHeader(dtExcelData)) { if (dtExcelData.Rows.Count != 0) { oSMHR_MedicalInvoice.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); oSMHR_MedicalInvoice.OPERATION = operation.Check; DataTable dtBenficaryDetails = BLL.get_MedicalInvoice(oSMHR_MedicalInvoice); oSMHR_MedicalInvoice.OPERATION = operation.Validate; DataTable dtInvoiceValidate = BLL.get_MedicalInvoice(oSMHR_MedicalInvoice); DataTable dtInvoices = CreateInvoiceTable(); SMHR_EXPENDITURE oSMHR_EXPENDITURE = new SMHR_EXPENDITURE(); oSMHR_EXPENDITURE.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); oSMHR_EXPENDITURE.OPERATION = operation.Select; DataTable dtexpenditures = BLL.get_Expenditure(oSMHR_EXPENDITURE); foreach (DataRow record in dtExcelData.Rows) { if (!string.IsNullOrEmpty(record["Beneficiary Name"].ToString().Trim())) { if (dtBenficaryDetails.Select("BenficaryName='" + record["Beneficiary Name"].ToString().Trim() + "'").Length == 0) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Benficary Name not exists"); return; } } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Benficary Name should not be empty"); return; } if (string.IsNullOrEmpty(record["Invoice ID"].ToString().Trim())) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Invoice ID should not be empty"); return; } if (string.IsNullOrEmpty(record["Invoice Date"].ToString().Trim())) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Invoice Date should not be empty"); return; } if (string.IsNullOrEmpty(record["Staff Name"].ToString().Trim())) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Staff Name should not be empty"); return; } if (!string.IsNullOrEmpty(record["Exp Name"].ToString().Trim())) { if (dtexpenditures.Select("expenditure_name='" + record["Exp Name"].ToString().Trim() + "'").Length == 0) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Exp Name not exists"); return; } } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Exp Name should not be empty"); return; } if (!string.IsNullOrEmpty(record["Service Provider"].ToString().Trim()) && string.Compare(record["Service Provider"].ToString().Trim(), "Select", true) != 0) { if (string.Compare(record["Service Provider"].ToString().Trim(), RadServiceProviderName.SelectedItem.Text.Trim(), true) != 0) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Service Provider mismatch"); return; } } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Service Provider should not be empty"); return; } if (!string.IsNullOrEmpty(record["Amount"].ToString().Trim())) { double d; if (!double.TryParse(record["Amount"].ToString().Trim(), out d)) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Amount should be a number"); return; } } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Amount should not be empty"); return; } if (dtInvoiceValidate.Select("SERVICEPROVIDERNAME='" + record["Service Provider"].ToString().Trim() + "' and INVOICEID='" + record["Invoice ID"].ToString().Trim() + "'").Length > 0) { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Invoice ID already exists"); return; } DateTime drt = new DateTime(); try { drt = Convert.ToDateTime(record[1].ToString()); } catch (Exception ex) { result = false; BLL.ShowMessage(this, "Date Format should be mm/dd/yyyy"); } dtInvoices.Rows.Add(record[0].ToString(), drt.ToString("MM/dd/yyyy"), record[2].ToString(), record[3].ToString(), record[4].ToString(), record[5].ToString(), record[6].ToString()); } //if (dtInvoices.Select("Invoice ID='" + record["Exp Name"].ToString().Trim() + "'").Length == 0) //{ //} oSMHR_MedicalInvoice.ServiceProviderID = Convert.ToInt32(RadServiceProviderName.SelectedValue); oSMHR_MedicalInvoice.InvoiceDoc = "~/MedicalInvoice/" + strfilename; oSMHR_MedicalInvoice.MedicalInvoice = dtInvoices; oSMHR_MedicalInvoice.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); oSMHR_MedicalInvoice.CREATEDDATE = DateTime.Now; oSMHR_MedicalInvoice.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]); } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "There are no records to load"); return; } } else { Delete_Excel_File(); result = false; BLL.ShowMessage(this, "Header mismatch"); return; } } catch (Exception ex) { throw ex; } }