private DocotorScreening LoadData(int TokenNumber, string ArogyaID)
{
ArogyaParivarEntities context = new ArogyaParivarEntities();
var query1 = (from screening in context.T_Screenings
from pc in context.M_PComplaints
.Where(x => x.ID == screening.ComplaintID).DefaultIfEmpty()
//on screening.ComplaintID equals pc.ID
from user in context.M_User
.Where(x => x.User_ID == screening.UserID).DefaultIfEmpty()
//on screening.UserID equals user.User_ID
where screening.Token_Number == TokenNumber &&
EntityFunctions.TruncateTime(screening.CreateDate).Value == DateTime.Today &&
screening.ArogyaID == ArogyaID
select new DocotorScreening
{
ChiefComplaintName = pc.M_PresentingComplainting,
ChiefComplaintID = screening.ComplaintID.Value,
HistoryPresentingComplaint = screening.PresentingComplaint,
PastMedicalHistory = screening.PastMedicalHistory,
PastSurgicalHistory = screening.PastSurgicalHistory,
FamilyHistory = screening.FamilyHistory,
CurrentMedication = screening.CurrentMedication,
ECGOutcomeID = screening.ECGOutcomeID.Value,
ScreenOutcomeID = screening.ScreenOutcomeID.Value
//CreateDate = screening.CreateDate
}).ToList();
doctormodel = query1[0];
var query = context.T_Vitals.Where(o => o.ArogyaID == ArogyaID && o.Token_Number == TokenNumber && EntityFunctions.TruncateTime(o.CreateDate) == DateTime.Today).ToList();
if (query.Count > 0)
{
doctormodel.Weight = query[0].Weight;
doctormodel.Height = query[0].Height;
doctormodel.BMI = query[0].BMI;
doctormodel.DiaBP = query[0].DiaBP;
doctormodel.SysBP = query[0].SysBP;
doctormodel.Temparature = query[0].Temparature;
doctormodel.Pulse = query[0].Pulse;
doctormodel.Respiratory = query[0].Respiratory;
var query2 = from allergy in context.T_Allergies
from at in context.M_AllergyType
.Where(x => x.ID == allergy.AllergenID).DefaultIfEmpty()
//on allergy.AllergenID equals at.ID
from ar in context.M_Reaction
.Where(x => x.ID == allergy.ReactionID).DefaultIfEmpty()
//on allergy.ReactionID equals ar.ID
from asev in context.M_Severity
.Where(x => x.ID == allergy.SeverityID).DefaultIfEmpty()
//on allergy.SeverityID equals asev.ID
from ast in context.M_Status
.Where(x => x.ID == allergy.StatusID).DefaultIfEmpty()
//on allergy.StatusID equals ast.ID
where allergy.Token_Number == TokenNumber &&
EntityFunctions.TruncateTime(allergy.CreateDate).Value == DateTime.Today &&
allergy.ArogyaID == ArogyaID
select new AllergyModel
{
AllergyTypeName = at.AllergyType,
AllergenName = "",
ReactionName = ar.Reaction,
SeverityName = asev.Severity,
StatusName = ast.M_StatusName,
CreateDate = allergy.CreateDate,
//CreateDateString=allergy.CreateDate.Value.ToString("dd/MM/yyyy")
};
doctormodel.Allergies = query2.ToList();
}
return(doctormodel);
}
private DocotorScreening LoadData(int TokenNumber, string ArogyaID)
{
ArogyaParivarEntities context = new ArogyaParivarEntities();
var query1 = (from screening in context.T_Screenings
from pc in context.M_PComplaints
.Where(x => x.ID == screening.ComplaintID).DefaultIfEmpty()
//on screening.ComplaintID equals pc.ID
from user in context.M_User
.Where(x => x.User_ID == screening.UserID).DefaultIfEmpty()
//on screening.UserID equals user.User_ID
where screening.Token_Number == TokenNumber
&& EntityFunctions.TruncateTime(screening.CreateDate).Value == DateTime.Today
&& screening.ArogyaID == ArogyaID
select new DocotorScreening
{
ChiefComplaintName = pc.M_PresentingComplainting,
ChiefComplaintID = screening.ComplaintID.Value,
HistoryPresentingComplaint = screening.PresentingComplaint,
PastMedicalHistory = screening.PastMedicalHistory,
PastSurgicalHistory = screening.PastSurgicalHistory,
FamilyHistory = screening.FamilyHistory,
CurrentMedication = screening.CurrentMedication,
ECGOutcomeID = screening.ECGOutcomeID.Value,
ScreenOutcomeID = screening.ScreenOutcomeID.Value
//CreateDate = screening.CreateDate
}).ToList();
doctormodel = query1[0];
var query = context.T_Vitals.Where(o => o.ArogyaID == ArogyaID && o.Token_Number == TokenNumber && EntityFunctions.TruncateTime(o.CreateDate) == DateTime.Today).ToList();
if (query.Count > 0)
{
doctormodel.Weight = query[0].Weight;
doctormodel.Height = query[0].Height;
doctormodel.BMI = query[0].BMI;
doctormodel.DiaBP = query[0].DiaBP;
doctormodel.SysBP = query[0].SysBP;
doctormodel.Temparature = query[0].Temparature;
doctormodel.Pulse = query[0].Pulse;
doctormodel.Respiratory = query[0].Respiratory;
var query2 = from allergy in context.T_Allergies
from at in context.M_AllergyType
.Where(x => x.ID == allergy.AllergenID).DefaultIfEmpty()
//on allergy.AllergenID equals at.ID
from ar in context.M_Reaction
.Where(x => x.ID == allergy.ReactionID).DefaultIfEmpty()
//on allergy.ReactionID equals ar.ID
from asev in context.M_Severity
.Where(x => x.ID == allergy.SeverityID).DefaultIfEmpty()
//on allergy.SeverityID equals asev.ID
from ast in context.M_Status
.Where(x => x.ID == allergy.StatusID).DefaultIfEmpty()
//on allergy.StatusID equals ast.ID
where allergy.Token_Number == TokenNumber
&& EntityFunctions.TruncateTime(allergy.CreateDate).Value == DateTime.Today
&& allergy.ArogyaID == ArogyaID
select new AllergyModel
{
AllergyTypeName = at.AllergyType,
AllergenName = "",
ReactionName = ar.Reaction,
SeverityName = asev.Severity,
StatusName = ast.M_StatusName,
CreateDate = allergy.CreateDate,
//CreateDateString=allergy.CreateDate.Value.ToString("dd/MM/yyyy")
};
doctormodel.Allergies = query2.ToList();
}
return doctormodel;
}