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