public List <TreatmentFundus> GetList()
{
FundusMaster f = new FundusMaster();
List <FundusMaster> fmst = f.GetAllFundus();
List <TreatmentFundus> fundus = new List <TreatmentFundus>();
for (int i = 0; i <= fmst.Count - 1; i++)
{
TreatmentFundus tf = new TreatmentFundus();
tf.fundusid = fmst[i].fundusid;
tf.fundusname = fmst[i].fundusname;
fundus.Add(tf);
}
return(fundus);
}
private Treatment Fill(DataSet ds)
{
Treatment treatobj = new Treatment();
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
treatobj.patientid = Convert.ToInt32(ds.Tables[0].Rows[0]["patientid"].ToString());
treatobj.hid = Convert.ToInt32(ds.Tables[0].Rows[0]["hid"].ToString());
treatobj.treatmentid = Convert.ToInt32(ds.Tables[0].Rows[0]["treatmentid"].ToString());
treatobj.followup_dt = ds.Tables[0].Rows[0]["followup_dt"].ToString();
treatobj.checkfollowup = ds.Tables[0].Rows[0]["isFollowup"].ToString();
treatobj.xray_dt = ds.Tables[0].Rows[0]["xray_dt"].ToString();
treatobj.xray = ds.Tables[0].Rows[0]["isXRay"].ToString();
treatobj.bloodtest_dt = ds.Tables[0].Rows[0]["bloodtest_dt"].ToString();
treatobj.bloodtest = ds.Tables[0].Rows[0]["isBloodTest"].ToString();
treatobj.occupation = ds.Tables[0].Rows[0]["occupation"].ToString();
treatobj.dfname = ds.Tables[0].Rows[0]["dfname"].ToString();
treatobj.dlname = ds.Tables[0].Rows[0]["dlname"].ToString();
}
if (ds.Tables[1].Rows.Count > 0)
{
List <TreatmentMedicine> TM = new List <TreatmentMedicine>();
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
TreatmentMedicine t = new TreatmentMedicine();
t.m = ds.Tables[1].Rows[i]["m"].ToString();
t.a = ds.Tables[1].Rows[i]["a"].ToString();
t.e = ds.Tables[1].Rows[i]["e"].ToString();
t.n = ds.Tables[1].Rows[i]["n"].ToString();
t.mischecked = ds.Tables[1].Rows[i]["m"].ToString() == "" ? false : true;
t.aischecked = ds.Tables[1].Rows[i]["a"].ToString() == "" ? false : true;
t.eischecked = ds.Tables[1].Rows[i]["e"].ToString() == "" ? false : true;
t.nischecked = ds.Tables[1].Rows[i]["n"].ToString() == "" ? false : true;
t.medicineid = Convert.ToInt32(ds.Tables[1].Rows[i]["medicineid"].ToString());
t.particular = ds.Tables[1].Rows[i]["particular"].ToString();
t.qty = Convert.ToInt32(ds.Tables[1].Rows[i]["quantity"].ToString() == "" ? "0" : ds.Tables[1].Rows[i]["quantity"].ToString());
TM.Add(t);
}
treatobj.TreatMedicineList = TM;
HttpContext.Current.Session["TreatmentMedicine"] = TM;
}
if (ds.Tables[2].Rows.Count > 0)
{
int i = 0;
TreatmentVision tv = new TreatmentVision();
tv.right_vn = ds.Tables[2].Rows[i]["right_vn"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_vn"].ToString();
tv.right_dist_sph = ds.Tables[2].Rows[i]["right_dist_sph"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_dist_sph"].ToString();
tv.right_dist_cyl = ds.Tables[2].Rows[i]["right_dist_cyl"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_dist_cyl"].ToString();
tv.right_dist_axis = ds.Tables[2].Rows[i]["right_dist_axis"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_dist_axis"].ToString();
tv.right_near_sph = ds.Tables[2].Rows[i]["right_near_sph"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_near_sph"].ToString();
tv.right_near_cyl = ds.Tables[2].Rows[i]["right_near_cyl"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_near_cyl"].ToString();
tv.right_near_axis = ds.Tables[2].Rows[i]["right_near_axis"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["right_near_axis"].ToString();
tv.left_vn = ds.Tables[2].Rows[i]["left_vn"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_vn"].ToString();
tv.left_dist_sph = ds.Tables[2].Rows[i]["left_dist_sph"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_dist_sph"].ToString();
tv.left_dist_cyl = ds.Tables[2].Rows[i]["left_dist_cyl"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_dist_cyl"].ToString();
tv.left_dist_axis = ds.Tables[2].Rows[i]["left_dist_axis"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_dist_axis"].ToString();
tv.left_near_sph = ds.Tables[2].Rows[i]["left_near_sph"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_near_sph"].ToString();
tv.left_near_cyl = ds.Tables[2].Rows[i]["left_near_cyl"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_near_cyl"].ToString();
tv.left_near_axis = ds.Tables[2].Rows[i]["left_near_axis"].ToString() == "" ? "0" : ds.Tables[2].Rows[i]["left_near_axis"].ToString();
treatobj.TreatVision = tv;
}
if (ds.Tables[3].Rows.Count > 0)
{
TreatmentInvestigation t = new TreatmentInvestigation();
List <TreatmentInvestigation> ti = new List <TreatmentInvestigation>();
ti = t.GetList();
for (int i = 0; i < ds.Tables[3].Rows.Count; i++)
{
ti.Where(w => w.invName == ds.Tables[3].Rows[i]["diseasename"].ToString()).ToList().ForEach(s => s.isChecked = true);
}
HttpContext.Current.Session["TreatInvestigationList"] = treatobj.TreatInvestigationList = ti;
}
else
{
TreatmentInvestigation t = new TreatmentInvestigation();
List <TreatmentInvestigation> ti = new List <TreatmentInvestigation>();
ti = t.GetList();
treatobj.TreatInvestigationList = ti;
}
if (ds.Tables[4].Rows.Count > 0)
{
List <TreatmentFundus> TF = new List <TreatmentFundus>();
for (int i = 0; i < ds.Tables[4].Rows.Count; i++)
{
TreatmentFundus tfun = new TreatmentFundus();
tfun.fundusid = Convert.ToInt32(ds.Tables[4].Rows[i]["fundusid"]);
tfun.fundusname = ds.Tables[4].Rows[i]["fundusname"].ToString();
TF.Add(tfun);
}
treatobj.TreatFundusList = TF;
HttpContext.Current.Session["TreatmentFundus"] = TF;
}
if (ds.Tables[5].Rows.Count > 0)
{
List <TreatmentComplents> TC = new List <TreatmentComplents>();
for (int i = 0; i < ds.Tables[5].Rows.Count; i++)
{
TreatmentComplents t = new TreatmentComplents();
t.complentid = Convert.ToInt32(ds.Tables[5].Rows[i]["complentsid"].ToString());
t.complentname = ds.Tables[5].Rows[i]["complentsname"].ToString();
TC.Add(t);
}
treatobj.TreatComplentsList = TC;
HttpContext.Current.Session["TreatmentComplents"] = TC;
}
if (ds.Tables[6].Rows.Count > 0)
{
List <TreatmentDiagnosis> TD = new List <TreatmentDiagnosis>();
for (int i = 0; i < ds.Tables[6].Rows.Count; i++)
{
TreatmentDiagnosis t = new TreatmentDiagnosis();
t.diagnosisid = Convert.ToInt32(ds.Tables[6].Rows[i]["diagnosisid"]);
t.diagnosisname = ds.Tables[6].Rows[i]["disgnosisname"].ToString();
TD.Add(t);
}
treatobj.TreatDiagnosisList = TD;
HttpContext.Current.Session["TreatmentDiagnosis"] = TD;
}
if (ds.Tables[7].Rows.Count > 0)
{
List <TreatmentCheckups> TCH = new List <TreatmentCheckups>();
for (int i = 0; i < ds.Tables[7].Rows.Count; i++)
{
TreatmentCheckups t = new TreatmentCheckups();
t.checkupid = Convert.ToInt32(ds.Tables[7].Rows[i]["checkupid"]);
t.checkupname = ds.Tables[7].Rows[i]["checkupname"].ToString();
TCH.Add(t);
}
treatobj.TreatCheckupList = TCH;
HttpContext.Current.Session["TreatmentCheckups"] = TCH;
}
if (ds.Tables[8].Rows.Count > 0)
{
List <TreatmentHistory> TH = new List <TreatmentHistory>();
for (int i = 0; i < ds.Tables[8].Rows.Count; i++)
{
TreatmentHistory t = new TreatmentHistory();
t.historyid = Convert.ToInt32(ds.Tables[8].Rows[i]["historyid"]);
t.historyname = ds.Tables[8].Rows[i]["historyname"].ToString();
t.from_dt = ds.Tables[8].Rows[i]["from_dt"].ToString();
t.to_dt = ds.Tables[8].Rows[i]["to_dt"].ToString();
TH.Add(t);
}
treatobj.TreatHistoryList = TH;
HttpContext.Current.Session["TreatmentHistory"] = TH;
}
if (ds.Tables[9].Rows.Count > 0)
{
List <TreatmentAdvice> TA = new List <TreatmentAdvice>();
for (int i = 0; i < ds.Tables[9].Rows.Count; i++)
{
TreatmentAdvice t = new TreatmentAdvice();
t.adviceid = Convert.ToInt32(ds.Tables[9].Rows[i]["adviceid"]);
t.advicename = ds.Tables[9].Rows[i]["advicename"].ToString();
TA.Add(t);
}
treatobj.TreatAdviceList = TA;
HttpContext.Current.Session["TreatmentAdvice"] = TA;
}
if (ds.Tables[10].Rows.Count > 0)
{
TreatmentTnVn tn = new TreatmentTnVn();
tn.tn_re_clg = ds.Tables[10].Rows[0]["tn_re_clg"].ToString();
tn.tn_le_clg = ds.Tables[10].Rows[0]["tn_le_clg"].ToString();
tn.vn_re_clg = ds.Tables[10].Rows[0]["vn_re_clg"].ToString();
tn.vn_le_clg = ds.Tables[10].Rows[0]["vn_le_clg"].ToString();
tn.tn_re_clg_t = ds.Tables[10].Rows[0]["tn_re_clg_t"].ToString();
tn.tn_le_clg_t = ds.Tables[10].Rows[0]["tn_le_clg_t"].ToString();
tn.vn_re_clg_v = ds.Tables[10].Rows[0]["vn_re_clg_v"].ToString();
tn.vn_le_clg_v = ds.Tables[10].Rows[0]["vn_le_clg_v"].ToString();
tn.tn_re_cph = ds.Tables[10].Rows[0]["tn_re_cph"].ToString();
tn.tn_le_cph = ds.Tables[10].Rows[0]["tn_le_cph"].ToString();
tn.vn_re_cph = ds.Tables[10].Rows[0]["vn_re_cph"].ToString();
tn.vn_le_cph = ds.Tables[10].Rows[0]["vn_le_cph"].ToString();
treatobj.TreatTnVn = tn;
}
}
return(treatobj);
}
