//Get a list of referrals registered by the current user
public List <Referral> GetAll()
{
using (var db = new ReferralContext())
{
return(db.Referrals.Include("Doctor").Include("Patient").Include("Reason").Where(x => x.Doctor.UserProfileId.Equals(WebSecurity.CurrentUserId)).ToList()); //OrderByDescending(item => item.Date).ToList();
}
}
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();
}
//Find a referral by Id
public Referral FindById(int id)
{
using (var db = new ReferralContext())
{
return(db.Referrals.Include("Doctor").Include("Reason").Include("Patient").First(x => x.Id.Equals(id)));
}
}
//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();
}
}
}
//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();
}
}
private ReferralContext CreateDataContext()
{
var options = new DbContextOptionsBuilder()
.UseInMemoryDatabase(nameof(ReferralContext))
.Options;
var context = new ReferralContext("referral", options);
context.Database.EnsureDeleted();
context.Database.EnsureCreated();
return(context);
}
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();
}
protected virtual void Seed(ReferralContext context)
{
}
