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 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; } }