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