public Precription ViewPricripion(int QueueId, string CPno)
{
try
{
SqlParameter[] sqlparam;
sqlparam = new SqlParameter[3];
sqlparam[0] = new SqlParameter("@flag", "7");
sqlparam[1] = new SqlParameter("@QueueId", QueueId);
sqlparam[2] = new SqlParameter("@CPno", CPno);
DataSet ds = CommonFunction.GetDataSet("USP_Get_Precription", sqlparam, "");
Precription p = new Precription();
if (ds != null && ds.Tables[7].Rows.Count > 0)
{
DataTable dt = ds.Tables[7];
foreach (DataRow dr in dt.Rows)
{
CommonFunction.ReflectSingleData(p, dr);
}
}
List <Observation> olst = new List <Observation>();
if (ds != null && ds.Tables[3].Rows.Count > 0)
{
DataTable dt = ds.Tables[3];
foreach (DataRow dr in dt.Rows)
{
Observation Model = new Observation();
CommonFunction.ReflectSingleData(Model, dr);
olst.Add(Model);
}
}
List <Medication> mlst = new List <Medication>();
if (ds != null && ds.Tables[4].Rows.Count > 0)
{
DataTable dt = ds.Tables[4];
foreach (DataRow dr in dt.Rows)
{
Medication Model = new Medication();
CommonFunction.ReflectSingleData(Model, dr);
mlst.Add(Model);
}
}
List <Common> clst = new List <Common>();
if (ds != null && ds.Tables[5].Rows.Count > 0)
{
DataTable dt = ds.Tables[5];
foreach (DataRow dr in dt.Rows)
{
Common Model = new Common();
CommonFunction.ReflectSingleData(Model, dr);
clst.Add(Model);
}
}
List <Common> NextList = new List <Common>();
if (ds != null && ds.Tables[6].Rows.Count > 0)
{
DataTable dt = ds.Tables[6];
foreach (DataRow dr in dt.Rows)
{
Common Model1 = new Common();
CommonFunction.ReflectSingleData(Model1, dr);
NextList.Add(Model1);
}
}
List <NestVisitlst> NextListlst = new List <NestVisitlst>();
if (ds != null && ds.Tables[6].Rows.Count > 0)
{
DataTable dt = ds.Tables[6];
foreach (DataRow dr in dt.Rows)
{
NestVisitlst Model1 = new NestVisitlst();
CommonFunction.ReflectSingleData(Model1, dr);
NextListlst.Add(Model1);
}
}
//List<VitalInformation> vlst = new List<VitalInformation>();
//if (ds != null && ds.Tables[3].Rows.Count > 0)
//{
// DataTable dt = ds.Tables[3];
// foreach (DataRow dr in dt.Rows)
// {
// VitalInformation Model = new VitalInformation();
// CommonFunction.ReflectSingleData(Model, dr);
// vlst.Add(Model);
// }
//}
List <VitalInformation> VList = new List <VitalInformation>();
if (ds != null && ds.Tables[2].Rows.Count > 0)
{
DataTable dt = ds.Tables[2];
foreach (DataRow dr in dt.Rows)
{
VitalInformation Model1 = new VitalInformation();
CommonFunction.ReflectSingleData(Model1, dr);
VList.Add(Model1);
}
}
p.vlist = VList;
p.olist = olst;
p.mlist = mlst;
p.clist = clst;
p.NextList = NextList;
p.NextListlst = NextListlst;
return(p);
}
catch (Exception Ex)
{
throw Ex;
}
}
public ActionResult ManageVitalInformation(VitalInformation VI)
{
AdminDetails admObj = (AdminDetails)Session["UserDetails"];
PatientAllDetails patientDETAILS = (PatientAllDetails)Session["patientDetails"];
ModelState.Clear();
VI.HospitalId = patientDETAILS.HospitalId.ToString();
VI.CreatedBy = admObj.UserId;
VI.PatientId = patientDETAILS.Id;
VI.CasePaperNo = patientDETAILS.CasePapaerNo;
//Ob.CasePaperNo =
int Flag = BM.ManageVitalInformation(VI);
//if (Flag > 0)
//{
// List<VitalInformation> vi = new List<VitalInformation>();
// VitalInformation v = new VitalInformation();
// vi = BM.GetVitalInformation(patientDETAILS.CasePapaerNo);
// var viralInfo = vi.FirstOrDefault(x => x.CasePaperNo == patientDETAILS.CasePapaerNo);
// if (viralInfo != null)
// {
// v.BloodPressure = viralInfo.BloodPressure;
// v.Temperature = viralInfo.Temperature;
// v.BloodGlucosePostPrandial = viralInfo.BloodGlucosePostPrandial;
// v.Weight = viralInfo.Weight;
// v.Height = viralInfo.Height;
// v.BloodGlucoseFasting = viralInfo.BloodGlucoseFasting;
// v.BloodlucoseRandom = viralInfo.BloodlucoseRandom;
// v.BloodUrea = viralInfo.BloodUrea;
// v.Creatinine = viralInfo.Creatinine;
// v.UricAcidM = viralInfo.UricAcidM;
// v.HB = viralInfo.HB;
// v.PCV = viralInfo.PCV;
// v.WBCCount = viralInfo.WBCCount;
// v.PlateletCount = viralInfo.PlateletCount;
// v.ESR = viralInfo.ESR;
// v.RBCCount = viralInfo.RBCCount;
// v.MCH = viralInfo.MCH;
// v.MCHC = viralInfo.MCHC;
// v.Lymphocyte = viralInfo.Lymphocyte;
// v.Eosinophil = viralInfo.Eosinophil;
// v.SerumBilirubin = viralInfo.SerumBilirubin;
// v.SGPTALT = viralInfo.SGPTALT;
// v.GGPT = viralInfo.GGPT;
// v.TotalProtein = viralInfo.TotalProtein;
// v.SerumAlbumin = viralInfo.SerumAlbumin;
// v.Globulin = viralInfo.Globulin;
// v.AlkalinePhosphatase = viralInfo.AlkalinePhosphatase;
// v.SGOT = viralInfo.SGOT;
// v.TotalCholesterol = viralInfo.TotalCholesterol;
// v.HDLCholestero = viralInfo.HDLCholestero;
// v.LDLCholesterol = viralInfo.LDLCholesterol;
// v.Triglycerides = viralInfo.Triglycerides;
// v.NonHDL = viralInfo.NonHDL;
// v.HbA1c = viralInfo.HbA1c;
// v.TSH = viralInfo.TSH;
// v.SPO2 = viralInfo.SPO2;
// v.RR = viralInfo.RR;
// v.HeadCircumference = viralInfo.HeadCircumference;
// // return View("VitalInformation",v);
// //return RedirectToAction("OpdPrescription", "MyOPD");
// }
// return View("VitalInformation", viralInfo);
//}
//return View("VitalInformation");
return(RedirectToAction("PatientVitalInformation", "MyOPD"));
}
public int ManageVitalInformation(VitalInformation VI)
{
return DM.ManageVitalInformation(VI);
}
