public List <PatientDetails> AddPatientTestResult(PatientTestSummary patientModel)
{
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
PatientTestResult testresult = new PatientTestResult()
{
PatientId = patientModel.PatientId,
SugarBeforeFasting = patientModel.SugarLevelBeforeFasting,
SugarAfterFasting = patientModel.SugarLevelAfterFasting,
TestDate = patientModel.TestDate
};
context.PatientTestResults.Add(testresult);
context.SaveChanges();
PatientMembershipDetail membership = (from m in context.PatientMembershipDetails
where m.PatientId == patientModel.PatientId
select m).FirstOrDefault();
membership.TestRemaining = membership.TestRemaining - 1;
context.Entry(membership).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception err)
{
throw;
}
return(GetAllPatientDetails(string.Empty, string.Empty));
}
public PatientSummary RenewPatientPlan(int patientid)
{
PatientSummary patientData = new PatientSummary();
List <PatientTestSummary> testsummary = new List <PatientTestSummary>();
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
PatientMembershipDetail memberDetail = (from member in context.PatientMembershipDetails
where member.PatientId == patientid
select member).FirstOrDefault();
int remainingtest = memberDetail.TestRemaining;
memberDetail.TestRemaining = (remainingtest + (Constants.MembershipMonths * 2));
memberDetail.BookedDate = System.DateTime.Now.Date;
memberDetail.ExpirationDate = DateTime.Now.AddMonths(3);
context.Entry(memberDetail).State = EntityState.Modified;
context.SaveChanges();
patientData = GetAPatientDataByPatientId(patientid);
}
}
catch (Exception err)
{
throw;
}
return(patientData);
}
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);
}
public void RenewPatientPlan(int patientid)
{
try
{
using (DiabeticSystemEntities context = new DiabeticSystemEntities())
{
PatientMembershipDetail memberDetail = (from member in context.PatientMembershipDetails
where member.PatientId == patientid
select member).FirstOrDefault();
int remainingtest = memberDetail.TestRemaining;
memberDetail.TestRemaining = (remainingtest + 6);
memberDetail.BookedDate = System.DateTime.Now.Date;
memberDetail.ExpirationDate = DateTime.Now.Date.AddMonths(3);
context.Entry(memberDetail).State = EntityState.Modified;
context.SaveChanges();
}
}
catch (Exception err)
{
throw;
}
}
