public ActionResult EditProfile() { using (var db = new MainDbContext()) { string firstname = User.Identity.Name; var FdrModel = db.FDR.FirstOrDefault(u => u.FirstName.Equals(firstname)); var searchKeyAdd = db.FDR.Select(u => u.Key_Address); var materializeAddKey = searchKeyAdd.ToList(); var KeyAdd = materializeAddKey[0]; var AddModel = db.Address.FirstOrDefault(u => u.Id.Equals(KeyAdd)); var searchKeyCon = db.FDR.Select(u => u.Key_Contact); var materializeConKey = searchKeyCon.ToList(); var KeyCon = materializeConKey[0]; var ConModel = db.Contact.FirstOrDefault(u => u.Id.Equals(KeyCon)); var searchUserKey = db.FDR.Select(u => u.Key_Users); var materializeUserKey = searchUserKey.ToList(); var KeyUser = materializeUserKey[0]; var UsersModel = db.Users.FirstOrDefault(u => u.Id.Equals(KeyUser)); var password = CustomDecrypt.Decrypt(UsersModel.Password); UsersModel.Password = password; var viewmodel = new FDRModel { Contact = ConModel, Address = AddModel, FDR = FdrModel, Users = UsersModel }; return(View(viewmodel)); } }
public ActionResult EditProfile(FDRModel model) { if (ModelState.IsValid) { using (var db = new MainDbContext()) { string firstname = User.Identity.Name; //Get Doctor var FdrModel = db.FDR.FirstOrDefault(u => u.FirstName.Equals(firstname)); FdrModel.HospName = model.FDR.HospName; FdrModel.EmployeeId = model.FDR.EmployeeId; FdrModel.LicenseNo = model.FDR.LicenseNo; FdrModel.Specialization = model.FDR.Specialization; FdrModel.FirstName = model.FDR.FirstName; FdrModel.MiddleName = model.FDR.MiddleName; FdrModel.LastName = model.FDR.LastName; FdrModel.Email = model.FDR.Email; FdrModel.DateBirth = model.FDR.DateBirth; FdrModel.Sex = model.FDR.Sex; FdrModel.SecQuestion = model.FDR.SecQuestion; FdrModel.SecAnswer = model.FDR.SecAnswer; db.Entry(FdrModel).State = EntityState.Modified; // Get the Address var searchKeyAdd = db.FDR.Select(u => u.Key_Address); var materializeAddKey = searchKeyAdd.ToList(); var KeyAdd = materializeAddKey[0]; var AddModel = db.Address.FirstOrDefault(u => u.Id.Equals(KeyAdd)); AddModel.City = model.Address.City; AddModel.Province = model.Address.Province; AddModel.Zipcode = model.Address.Zipcode; AddModel.AddressType = model.Address.AddressType; db.Entry(AddModel).State = EntityState.Modified; // Get the Contact var searchKeyCon = db.FDR.Select(u => u.Key_Contact); var materializeConKey = searchKeyCon.ToList(); var KeyCon = materializeConKey[0]; var ConModel = db.Contact.FirstOrDefault(u => u.Id.Equals(KeyCon)); ConModel.MobileNo = model.Contact.MobileNo; ConModel.PhoneNo = model.Contact.PhoneNo; db.Entry(ConModel).State = EntityState.Modified; // Get the Users var searchUserKey = db.FDR.Select(u => u.Key_Users); var materializeUserKey = searchUserKey.ToList(); var KeyUser = materializeUserKey[0]; var UsersModel = db.Users.FirstOrDefault(u => u.Id.Equals(KeyUser)); var encryptedPassword = CustomEnrypt.Encrypt(model.Users.Password); UsersModel.Username = model.Users.Username; UsersModel.Password = encryptedPassword; db.Entry(UsersModel).State = EntityState.Modified; db.SaveChanges(); var identity = new ClaimsIdentity(new[] { new Claim(ClaimTypes.Name, FdrModel.FirstName), new Claim(ClaimTypes.Role, "FDR") }, "ApplicationCookie"); var ctx = Request.GetOwinContext(); var authManager = ctx.Authentication; authManager.SignIn(identity); return RedirectToAction("Index", "FDR"); } } return View(model); }
public ActionResult EditProfile() { using (var db = new MainDbContext()) { string firstname = User.Identity.Name; var FdrModel = db.FDR.FirstOrDefault(u => u.FirstName.Equals(firstname)); var searchKeyAdd = db.FDR.Select(u => u.Key_Address); var materializeAddKey = searchKeyAdd.ToList(); var KeyAdd = materializeAddKey[0]; var AddModel = db.Address.FirstOrDefault(u => u.Id.Equals(KeyAdd)); var searchKeyCon = db.FDR.Select(u => u.Key_Contact); var materializeConKey = searchKeyCon.ToList(); var KeyCon = materializeConKey[0]; var ConModel = db.Contact.FirstOrDefault(u => u.Id.Equals(KeyCon)); var searchUserKey = db.FDR.Select(u => u.Key_Users); var materializeUserKey = searchUserKey.ToList(); var KeyUser = materializeUserKey[0]; var UsersModel = db.Users.FirstOrDefault(u => u.Id.Equals(KeyUser)); var password = CustomDecrypt.Decrypt(UsersModel.Password); UsersModel.Password = password; var viewmodel = new FDRModel { Contact = ConModel, Address = AddModel, FDR = FdrModel, Users = UsersModel }; return View(viewmodel); } }
public ActionResult CreateFDR(FDRModel model) { if (ModelState.IsValid) { using (var db = new MainDbContext()) { var queryUser = db.Users.FirstOrDefault(u => u.Username == model.Users.Username); if (queryUser == null) { var encryptedPassword = CustomEnrypt.Encrypt(model.Users.Password); var fdr = db.FDR.Create(); var address = db.Address.Create(); var contact = db.Contact.Create(); var user = db.Users.Create(); var role = db.Role.Create(); fdr.FirstName = model.FDR.FirstName; fdr.MiddleName = model.FDR.MiddleName; fdr.LastName = model.FDR.LastName; fdr.Email = model.FDR.Email; fdr.EmployeeId = model.FDR.EmployeeId; fdr.LicenseNo = model.FDR.LicenseNo; fdr.HospName = model.FDR.HospName; fdr.Specialization = model.FDR.Specialization; fdr.DateBirth = model.FDR.DateBirth; fdr.Sex = model.FDR.Sex; address.AddressType = model.Address.AddressType; address.City = model.Address.City; address.Province = model.Address.Province; address.Zipcode = model.Address.Zipcode; user.Username = model.Users.Username; user.Password = encryptedPassword; user.Password = encryptedPassword; role.RoleType = "FDR"; fdr.SecQuestion = model.FDR.SecQuestion; fdr.SecAnswer = model.FDR.SecAnswer; contact.MobileNo = model.Contact.MobileNo; contact.PhoneNo = model.Contact.PhoneNo; db.Address.Add(address); db.Contact.Add(contact); db.Role.Add(role); db.SaveChanges(); user.Key_Role = role.Id; db.Users.Add(user); db.SaveChanges(); fdr.Key_Users = user.Id; fdr.Key_Address = address.Id; fdr.Key_Contact = contact.Id; db.FDR.Add(fdr); db.SaveChanges(); return(RedirectToAction("CreateFDR", "Admin")); } else { return(RedirectToAction("CreateFDR", "Admin")); } } } else { ModelState.AddModelError("", "One or more fields have been"); } return(View()); }
public ActionResult EditProfile(FDRModel model) { if (ModelState.IsValid) { using (var db = new MainDbContext()) { string firstname = User.Identity.Name; //Get Doctor var FdrModel = db.FDR.FirstOrDefault(u => u.FirstName.Equals(firstname)); FdrModel.HospName = model.FDR.HospName; FdrModel.EmployeeId = model.FDR.EmployeeId; FdrModel.LicenseNo = model.FDR.LicenseNo; FdrModel.Specialization = model.FDR.Specialization; FdrModel.FirstName = model.FDR.FirstName; FdrModel.MiddleName = model.FDR.MiddleName; FdrModel.LastName = model.FDR.LastName; FdrModel.Email = model.FDR.Email; FdrModel.DateBirth = model.FDR.DateBirth; FdrModel.Sex = model.FDR.Sex; FdrModel.SecQuestion = model.FDR.SecQuestion; FdrModel.SecAnswer = model.FDR.SecAnswer; db.Entry(FdrModel).State = EntityState.Modified; // Get the Address var searchKeyAdd = db.FDR.Select(u => u.Key_Address); var materializeAddKey = searchKeyAdd.ToList(); var KeyAdd = materializeAddKey[0]; var AddModel = db.Address.FirstOrDefault(u => u.Id.Equals(KeyAdd)); AddModel.City = model.Address.City; AddModel.Province = model.Address.Province; AddModel.Zipcode = model.Address.Zipcode; AddModel.AddressType = model.Address.AddressType; db.Entry(AddModel).State = EntityState.Modified; // Get the Contact var searchKeyCon = db.FDR.Select(u => u.Key_Contact); var materializeConKey = searchKeyCon.ToList(); var KeyCon = materializeConKey[0]; var ConModel = db.Contact.FirstOrDefault(u => u.Id.Equals(KeyCon)); ConModel.MobileNo = model.Contact.MobileNo; ConModel.PhoneNo = model.Contact.PhoneNo; db.Entry(ConModel).State = EntityState.Modified; // Get the Users var searchUserKey = db.FDR.Select(u => u.Key_Users); var materializeUserKey = searchUserKey.ToList(); var KeyUser = materializeUserKey[0]; var UsersModel = db.Users.FirstOrDefault(u => u.Id.Equals(KeyUser)); var encryptedPassword = CustomEnrypt.Encrypt(model.Users.Password); UsersModel.Username = model.Users.Username; UsersModel.Password = encryptedPassword; db.Entry(UsersModel).State = EntityState.Modified; db.SaveChanges(); var identity = new ClaimsIdentity(new[] { new Claim(ClaimTypes.Name, FdrModel.FirstName), new Claim(ClaimTypes.Role, "FDR") }, "ApplicationCookie"); var ctx = Request.GetOwinContext(); var authManager = ctx.Authentication; authManager.SignIn(identity); return(RedirectToAction("Index", "FDR")); } } return(View(model)); }
public ActionResult CreateFDR(FDRModel model) { if (ModelState.IsValid) { using (var db = new MainDbContext()) { var queryUser = db.Users.FirstOrDefault(u => u.Username == model.Users.Username); if (queryUser == null) { var encryptedPassword = CustomEnrypt.Encrypt(model.Users.Password); var fdr = db.FDR.Create(); var address = db.Address.Create(); var contact = db.Contact.Create(); var user = db.Users.Create(); var role = db.Role.Create(); fdr.FirstName = model.FDR.FirstName; fdr.MiddleName = model.FDR.MiddleName; fdr.LastName = model.FDR.LastName; fdr.Email = model.FDR.Email; fdr.EmployeeId = model.FDR.EmployeeId; fdr.LicenseNo = model.FDR.LicenseNo; fdr.HospName = model.FDR.HospName; fdr.Specialization = model.FDR.Specialization; fdr.DateBirth = model.FDR.DateBirth; fdr.Sex = model.FDR.Sex; address.AddressType = model.Address.AddressType; address.City = model.Address.City; address.Province = model.Address.Province; address.Zipcode = model.Address.Zipcode; user.Username = model.Users.Username; user.Password = encryptedPassword; user.Password = encryptedPassword; role.RoleType = "FDR"; fdr.SecQuestion = model.FDR.SecQuestion; fdr.SecAnswer = model.FDR.SecAnswer; contact.MobileNo = model.Contact.MobileNo; contact.PhoneNo = model.Contact.PhoneNo; db.Address.Add(address); db.Contact.Add(contact); db.Role.Add(role); db.SaveChanges(); user.Key_Role = role.Id; db.Users.Add(user); db.SaveChanges(); fdr.Key_Users = user.Id; fdr.Key_Address = address.Id; fdr.Key_Contact = contact.Id; db.FDR.Add(fdr); db.SaveChanges(); return RedirectToAction("CreateFDR", "Admin"); } else { return RedirectToAction("CreateFDR", "Admin"); } } } else { ModelState.AddModelError("", "One or more fields have been"); } return View(); }