//Update a referral public void Update(int DoctorId, FormCollection Collection, int ReferralId) { Referral referral; using (var db = new ReferralContext()) { db.Configuration.ProxyCreationEnabled = false; referral = db.Referrals.First(x => x.Doctor.UserProfileId.Equals(WebSecurity.CurrentUserId) && x.Id.Equals(ReferralId)); db.Entry(referral).State = EntityState.Modified; referral.City = Collection["City"]; referral.State = Collection["State"]; referral.Date = DateTime.Parse(Collection["Date"]); referral.Note = Collection["Notes"]; referral.Reason = db.Reason.Find(Convert.ToInt32(Collection["Reason"])); if (referral.DoctorId != DoctorId) { referral.Doctor = db.Doctor.Where(x => x.Id.Equals(DoctorId)).First(); db.SaveChanges(); } else { // db.Referrals.Attach(referral); db.SaveChanges(); } } }
protected override void Seed(ReferralContext context) { context.PurchaseReferrals.AddRange( new List <PurchaseReferralHistoryEntity> { new PurchaseReferralHistoryEntity { Id = Guid.NewGuid(), ReferrerId = Guid.NewGuid(), ReferredId = Guid.NewGuid() }, new PurchaseReferralHistoryEntity { Id = Guid.NewGuid(), ReferrerId = Guid.Parse("57e80137-984c-44f0-ad6f-b555d46cd934"), ReferredId = Guid.NewGuid() }, new PurchaseReferralHistoryEntity { Id = Guid.NewGuid(), ReferrerId = Guid.Parse("57e80137-984c-44f0-ad6f-b555d46cd934"), ReferredId = Guid.NewGuid() } }); context.SaveChanges(); }
//Delete a referral public void DeleteReferral(int id) { Referral ReferralDelete; using (var db = new ReferralContext()) { ReferralDelete = db.Referrals.First(x => x.Doctor.UserProfileId.Equals(WebSecurity.CurrentUserId) && x.Id.Equals(id)); db.Referrals.Remove(ReferralDelete); db.SaveChanges(); } }
public void CreateReferral(int DoctorId, FormCollection Collection) { Referral newReferral; Patient Patient; string patientEmail = Collection["PatientEmail"]; List <Patient> patients; Doctor TargetDoctor; int reasonId; using (var db = new ReferralContext()) { db.Configuration.ProxyCreationEnabled = false; reasonId = Convert.ToInt32(Collection["Reason"]); Patient = new Patient(); newReferral = db.Referrals.Create(); newReferral.Date = DateTime.Parse(Collection["Date"]); newReferral.Note = Collection["Note"]; newReferral.City = Collection["City"]; newReferral.State = Collection["State"]; //Adding patient patients = db.Patient.Where(x => x.Email.Equals(patientEmail) && x.UserProfileId.Equals(WebSecurity.CurrentUserId)).ToList(); if (patients.Count < 1) { Patient = new Patient(); Patient.First_name = Collection["Name"]; Patient.Middle_initial = Collection["Middle_initial"]; Patient.Last_name = Collection["Last_name"]; Patient.Email = Collection["PatientEmail"]; Patient.UserProfileId = WebSecurity.CurrentUserId; newReferral.Patient = Patient; } else { newReferral.Patient = patients[0]; db.Entry(newReferral.Patient).State = EntityState.Unchanged; } //Adding reason newReferral.ReasonId = reasonId; TargetDoctor = db.Doctor.Include("Referrals").First(x => x.Id.Equals(DoctorId)); TargetDoctor.Referrals.Add(newReferral); db.Referrals.Add(newReferral); db.SaveChanges(); //save db changes //AddReferral(DoctorId, newReferral); } }
//Create a new referral public void Create(int DoctorId, FormCollection Collection) { Referral referral; Patient patient; Doctor doctor; List <Patient> patients; string patientEmail = Collection["PatientEmail"]; using (var db = new ReferralContext()) { db.Configuration.ProxyCreationEnabled = false; referral = db.Referrals.Create(); referral.City = Collection["City"]; referral.State = Collection["State"]; referral.Date = DateTime.Parse(Collection["Date"]); referral.Note = Collection["Notes"]; int reasonId = Convert.ToInt32(Collection["Reason"]); referral.Reason = db.Reason.FirstOrDefault(x => x.Id.Equals(reasonId)); db.Entry(referral.Reason).State = EntityState.Unchanged; //adding patient patients = db.Patient.Where(x => x.Email.Equals(patientEmail) && x.UserProfileId.Equals(WebSecurity.CurrentUserId)).ToList(); if (patients.Count < 1) { patient = new Patient(); patient.First_name = Collection["Name"]; patient.Middle_initial = Collection["Middle_initial"]; patient.Last_name = Collection["Last_name"]; patient.Email = Collection["PatientEmail"]; patient.UserProfileId = WebSecurity.CurrentUserId; referral.Patient = patient; } else { referral.Patient = patients[0]; db.Entry(referral.Patient).State = EntityState.Unchanged; } doctor = db.Doctor.Find(DoctorId); referral.Doctor = doctor; db.Referrals.Add(referral); db.SaveChanges(); // DoctorsRepository.AddReferral(DoctorId, referral); } }
protected override void Seed(ReferralContext context) { context.Referrals.AddRange(new List <ReferralEntity> { new ReferralEntity { CustomerId = Guid.NewGuid() }, new ReferralEntity { CustomerId = Guid.Parse("57e80137-984c-44f0-ad6f-b555d46cd934"), ReferralCode = "400484e213f14bc6" }, new ReferralEntity { CustomerId = Guid.NewGuid() } }); context.SaveChanges(); }
protected override void Seed(ReferralContext context) { context.PropertyPurchases.AddRange( new List <PropertyPurchaseEntity>() { new PropertyPurchaseEntity { Id = Guid.NewGuid(), ReferralLeadId = Guid.NewGuid() }, new PropertyPurchaseEntity { Id = Guid.NewGuid(), ReferralLeadId = Guid.Parse("57e80137-984c-44f0-ad6f-b555d46cd934") }, new PropertyPurchaseEntity { Id = Guid.NewGuid(), ReferralLeadId = Guid.NewGuid() } }); context.SaveChanges(); }
protected override void Seed(ReferralContext context) { context.ReferralLeads.AddRange( new List <ReferralLeadEntity> { new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.Parse("78ceb436-29a9-499c-92fc-ec77152e32d8"), State = ReferralLeadState.Pending }, new ReferralLeadEntity { Id = Guid.Parse("57e80137-984c-44f0-ad6f-b555d46cd934"), State = ReferralLeadState.Pending }, new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.Parse("78ceb436-29a9-499c-92fc-ec77152e32d8"), EmailHash = "*****@*****.**", ConfirmationToken = "3l2k3h4lk", State = ReferralLeadState.Pending }, new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.NewGuid(), State = ReferralLeadState.Confirmed, EmailHash = "*****@*****.**", PhoneCountryCodeId = 354, PhoneNumberHash = "0881212838", ConfirmationToken = "9l2l7a4lk" }, new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.NewGuid(), State = ReferralLeadState.Confirmed, EmailHash = "*****@*****.**", PhoneCountryCodeId = 359, PhoneNumberHash = "0881212838", ConfirmationToken = "9l2l7a4lk" }, new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.NewGuid(), State = ReferralLeadState.Approved, EmailHash = "*****@*****.**", PhoneCountryCodeId = 359, PhoneNumberHash = "0884543421", ConfirmationToken = "7a00a3a8p" }, new ReferralLeadEntity { Id = Guid.NewGuid(), AgentId = Guid.NewGuid(), State = ReferralLeadState.Approved, EmailHash = "*****@*****.**", PhoneCountryCodeId = 359, PhoneNumberHash = "0884543421", ConfirmationToken = "1b9yhklj3" } }); context.SaveChanges(); }