public ActionResult CoWorkers(CoWorkersVM VM) // add co-worker
{
if (!ModelState.IsValid)
{
return(RedirectToAction("CoWorkers"));
}
string type;
using (var db = new AuthenticationDB())
{
if (db.Usrs.Any(x => x.UserName == VM.NewCoWorker.UserName))
{
return(RedirectToAction("CoWorkers"));
}
type = VM.NewCoWorker.Type;
db.Usrs.Add(new User
{
UserName = VM.NewCoWorker.UserName,
FirstName = VM.NewCoWorker.FirstName,
LastName = VM.NewCoWorker.LastName,
Roles = db.Rls.Where(r => r.RoleName == type).ToList(),
UserPassword = VM.NewCoWorker.Password,
});
db.SaveChanges();
}
using (var db = new AuthenticationDB())
{
if (type == "Insurance worker")
{
db.InWs.Add(new InW
{
Doc = db.Usrs.FirstOrDefault(u => u.UserId == ((OrdPrincipal)User).UserID),
InsuranceName = VM.NewCoWorker.Employer,
RefUser = db.Usrs.FirstOrDefault(u => u.UserName == VM.NewCoWorker.UserName),
});
}
else if (type == "Pharmacist")
{
db.Pharms.Add(new Pharm
{
Doc = db.Usrs.FirstOrDefault(u => u.UserId == ((OrdPrincipal)User).UserID),
Pharmacy = VM.NewCoWorker.Employer,
RefUser = db.Usrs.FirstOrDefault(u => u.UserName == VM.NewCoWorker.UserName),
});
}
db.SaveChanges();
}
return(RedirectToAction("CoWorkers"));
}
public ActionResult CoWorkers()
{
using (var db = new AuthenticationDB())
{
var VM = new CoWorkersVM();
VM.Pharmacists = db.Pharms.Where(p => p.Doc.UserId == ((OrdPrincipal)User).UserID).Select(ph =>
new CoWorkerPharmacist
{
Id = ph.RefUser.UserId,
FirstName = ph.RefUser.FirstName,
LastName = ph.RefUser.LastName,
Pharmacy = ph.Pharmacy,
}).ToList();
VM.InsuranceWorkers = db.InWs.Where(p => p.Doc.UserId == ((OrdPrincipal)User).UserID).Select(ph =>
new CoWorkerInsuranceWorker()
{
Id = ph.RefUser.UserId,
FirstName = ph.RefUser.FirstName,
LastName = ph.RefUser.LastName,
InsuranceName = ph.InsuranceName,
}).ToList();
return(View(VM));
}
}
