public ActionResult OPDCharges() { List <OPDCharge> CategoryList = new List <OPDCharge>(); Property p = new Property(); DataSet ds = new DataSet(); p.OnTable = "FetchOPDCharge"; p.Condition1 = "1"; ds = dl.FetchOPDCharge_sp(p); List <SelectListItem> ChargeTypeinventory = new List <SelectListItem>(); ChargeTypeinventory.Add(new SelectListItem { Text = "Select", Value = "" }); foreach (DataRow dr in ds.Tables[1].Rows) { ChargeTypeinventory.Add(new SelectListItem { Text = dr["Type"].ToString(), Value = dr["ChargeTypeId"].ToString() }); } ViewBag.ChargeTypeinventory = new SelectList(ChargeTypeinventory, "Value", "Text"); try { foreach (DataRow item in ds.Tables[0].Rows) { OPDCharge m = new OPDCharge(); m.OPDChargeId = item["OPDChargeId"].ToString(); m.OPDId = item["OPDId"].ToString(); m.PatientId = item["PatientId"].ToString(); m.Date = item["Date"].ToString(); m.Type = item["Type"].ToString(); m.Name = item["Name"].ToString(); m.StandardCharge = item["StandardCharge"].ToString(); m.AppliedCharge = item["AppliedCharge"].ToString(); CategoryList.Add(m); } ViewBag.CategoryList = CategoryList; } catch (Exception ex) { } OPDCharge info = new RXGOADMIN.Models.OPDCharge(); try { info = new RXGOADMIN.Models.OPDCharge() { AppliedCharge = ds.Tables[4].Rows[0]["AppliedCharge"].ToString(), }; } catch (Exception ex) { } OPDPayment info1 = new RXGOADMIN.Models.OPDPayment(); try { info1 = new RXGOADMIN.Models.OPDPayment() { Amount = ds.Tables[5].Rows[0]["Amount"].ToString(), }; ViewBag.PaymentInfo = info1; } catch (Exception ex) { } List <OPDPayment> PaymentList = new List <OPDPayment>(); p.OnTable = "FetchOPDPayment"; ds = dl.FetchOPDPayment_sp(p); try { foreach (DataRow item in ds.Tables[0].Rows) { OPDPayment m = new OPDPayment(); m.PaymentId = item["PaymentId"].ToString(); m.OPDId = item["OPDId"].ToString(); m.PatientId = item["PatientId"].ToString(); m.Date = item["Date"].ToString(); m.Note = item["Note"].ToString(); m.PaymentMode = item["PaymentMode"].ToString(); m.Amount = item["Amount"].ToString(); m.Attachment = item["Attachment"].ToString(); PaymentList.Add(m); } ViewBag.PaymentList = PaymentList; } catch (Exception ex) { } List <OPDDiagnosis> DiagnosisList = new List <OPDDiagnosis>(); p.OnTable = "FetchOPDDiagnosis"; ds = dl.FetchOPDDiagnosis_sp(p); try { foreach (DataRow item in ds.Tables[0].Rows) { OPDDiagnosis m = new OPDDiagnosis(); m.DiagnosisId = item["DiagnosisId"].ToString(); m.OPDId = item["OPDId"].ToString(); m.PatientId = item["PatientId"].ToString(); m.ReportType = item["ReportType"].ToString(); m.ReportDate = item["ReportDate"].ToString(); m.Description = item["Description"].ToString(); m.Attachment = item["Attachment"].ToString(); DiagnosisList.Add(m); } ViewBag.DiagnosisList = DiagnosisList; } catch (Exception ex) { } return(View(info)); }