public PatientSummary GetAPatientDetail(string username, string password)
{
PatientSummary summary = new PatientSummary();
PatientPersonal personalDetail = new PatientPersonal();
List <PatientTestSummary> testsummary = new List <PatientTestSummary>();
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
int userid = (from p in context.PatientPersonals
where p.Name.ToLower() == username.ToLower() &&
p.Password == password.ToLower()
select p.PatientId).FirstOrDefault();
if (userid > 0)
{
summary = (from p in context.PatientPersonals
join member in context.PatientMembershipDetails
on p.PatientId equals member.PatientId
where p.PatientId == userid
select new PatientSummary()
{
Id = p.PatientId,
Name = p.Name,
Age = p.Age,
Email = p.Email,
BloodGroup = p.BloodGroup,
TestRemaining = member.TestRemaining,
ExpiresOn = member.BookedDate //member.BookedDate.AddMonths(3)
}).FirstOrDefault();
summary.ExpiresOn = summary.ExpiresOn.AddMonths(3);
testsummary = (from p in context.PatientPersonals
join test in context.PatientTestResults
on p.PatientId equals test.PatientId
where p.PatientId == userid
select new PatientTestSummary()
{
PatientId = p.PatientId,
SugarLevelBeforeFasting = test.SugarBeforeFasting,
SugarLevelAfterFasting = test.SugarAfterFasting,
TestDate = test.TestDate.Value
}).ToList();
summary.PatientTestResults = testsummary;
}
else
{
summary = null;
}
}
}
catch (Exception err)
{
throw;
}
return(summary);
}
public PatientSummary GetAPatientDetail(string username, string password)
{
PatientSummary summary = new PatientSummary();
PatientPersonal personalDetail = new PatientPersonal();
List <PatientTestSummary> testsummary = new List <PatientTestSummary>();
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
int patientid = (from p in context.PatientPersonals
where p.Name.ToLower() == username.ToLower() &&
p.Password == password.ToLower()
select p.PatientId).FirstOrDefault();
if (patientid > 0)
{
summary = GetAPatientDataByPatientId(patientid);
}
else
{
summary = null;
}
}
}
catch (Exception err)
{
throw;
}
return(summary);
}
public int AddPatientDetails(PatientDetails patientModel)
{
int patientId = 0;
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
PatientPersonal personal = new PatientPersonal()
{
Name = patientModel.Name,
Age = patientModel.Age,
BloodGroup = patientModel.BloodGroup,
Email = patientModel.Email,
Password = patientModel.Password
};
context.PatientPersonals.Add(personal);
context.SaveChanges();
patientId = (from p in context.PatientPersonals
orderby p.PatientId descending
select p.PatientId).Take(1).SingleOrDefault();
PatientMembershipDetail membership = new PatientMembershipDetail()
{
PatientId = patientId,
TestRemaining = 6,
BookedDate = DateTime.Now.Date,
ExpirationDate = DateTime.Now.Date
};
membership.ExpirationDate = membership.ExpirationDate.Value.AddMonths(3);
context.PatientMembershipDetails.Add(membership);
context.SaveChanges();
}
}
catch (Exception err)
{
throw;
}
return(patientId);
}
