public List <Role> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Roles.ToList()); } }
public bool Create(User model) { if (model != null) { using (AuthenticationDB db = new AuthenticationDB()) { //db.Users.Add(model); //return (db.SaveChanges() > 0) ? true : false; var rows = db.Database.ExecuteSqlCommand(ResourceSQL.SP_InsertUserAddRoleDefault, new SqlParameter("@USR_IDE_AREA", model.USR_IDE_AREA), new SqlParameter("@USR_DES_POSITION", model.USR_DES_POSITION), new SqlParameter("@USR_DES_NAME", model.USR_DES_NAME), new SqlParameter("@USR_DES_FIRST_NAME", model.USR_DES_FIRST_NAME), new SqlParameter("@USR_DES_LAST_NAME", model.USR_DES_LAST_NAME), new SqlParameter("@USR_DES_PASSWORD", model.USR_DES_PASSWORD), new SqlParameter("@USR_DES_PHONE", model.USR_DES_PHONE), new SqlParameter("@USR_DES_EMAIL", model.USR_DES_EMAIL), new SqlParameter("@USR_FH_CREATED", model.USR_FH_CREATED) ); return((rows > 0) ? true : false); } } return(false); }
public List <AccountingAccount> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.AccountingAccounts.ToList()); } }
public ActionResult Orders() { using (var db = new AuthenticationDB()) { string pharmacy = db.Pharms.FirstOrDefault(u => u.RefUser.UserId == ((OrdPrincipal)HttpContext.User).UserID).Pharmacy; var VM = db.Docs.Where(d => d.RefUser.UserId == db.Pharms .FirstOrDefault(p => p.RefUser.UserId == ((OrdPrincipal)User).UserID).Doc.UserId) .Select(d => new DocPrice { Id = d.DocID, FirstName = d.RefUser.FirstName, LastName = d.RefUser.LastName, Price = d.Patients .SelectMany(p => p.Medicines) .Where(m => m.PharmacyName == pharmacy) .Sum(x => x.Price) == null ? 0 : d.Patients .SelectMany(p => p.Medicines) .Where(m => m.PharmacyName == pharmacy) .Sum(x => x.Price) }).ToList(); return(View(VM)); } }
public List <Budget> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Budgets.ToList()); } }
public List <StatusAprov> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.StatusAprovs.ToList()); } }
void SeedUsers(AuthenticationDB context) { if (!isInitDb) { return; } var pwd = new PasswordHasher(); string hashed = pwd.HashPassword("admin@123"); User admin = new User() { UserName = "******", Email = "*****@*****.**", EmailConfirmed = true, PhoneNumber = "+84936124031", PhoneNumberConfirmed = true, SecurityStamp = Guid.NewGuid().ToString("D"), PasswordHash = hashed }; if (!context.Users.Any(u => u.UserName == admin.UserName)) { var userStore = new UserStore <User>(context); var result = userStore.CreateAsync(admin); foreach (string role in roles) { userStore.AddToRoleAsync(admin, role); } } context.SaveChanges(); }
public override bool ChangePassword(string username, string oldPassword, string newPassword) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(oldPassword) || string.IsNullOrEmpty(newPassword)) { return(false); } using (AuthenticationDB dbContext = new AuthenticationDB()) { var user = (from us in dbContext.Users where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 && string.Compare(oldPassword, us.Password, StringComparison.OrdinalIgnoreCase) == 0 && us.IsActive == true select us).FirstOrDefault(); if (user == null) { return(false); } user.Password = newPassword; dbContext.SaveChanges(); return(true); } }
public List <User> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Users.ToList()); } }
public List <Request> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Requests.ToList()); } }
public List <Invoice> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Invoices.ToList()); } }
public ActionResult RegisterUserEdit(User user, int id) { var model = AuthenticationDB.GetUserByEmail(user.Email); if (model != null) { if (model.UserId != user.UserId) { ModelState.AddModelError("Warning Email", "Sorry: Email already Exists"); return(View(user)); } } else { model = AuthenticationDB.GetUserById(user.UserId); } model.FullName = user.FullName; model.Email = user.Email; model.IsActive = user.IsActive; model.Phone = user.Phone; model.CommunicationAddress = user.CommunicationAddress; AuthenticationDB.Save(model); return(RedirectToAction("RegisterUser")); }
public ActionResult RegisterUserEdit(int id) { var model = AuthenticationDB.GetUserById(id); // View Model Conversation here.... return(View(model)); }
public List <Area> GetAll() { using (AuthenticationDB db = new AuthenticationDB()) { return(db.Areas.ToList()); } }
public void EditCoWorker(int id, string pas) { using (var db = new AuthenticationDB()) { db.Usrs.FirstOrDefault(x => x.UserId == id).UserPassword = pas; db.SaveChanges(); } }
public ActionResult UserProfile() { var name = User.Identity.Name; var model = AuthenticationDB.GetUserByEmail(name); // View Model Conversation here.... return(View(model)); }
public ActionResult ChangeStatus(int id) { var model = AuthenticationDB.GetUserById(id); model.IsActive = !model.IsActive; AuthenticationDB.Save(model); return(RedirectToAction("RegisterUser")); }
public User GetOne(string id) { using (AuthenticationDB db = new AuthenticationDB()) { User User = db.Users.Find(id); return(User); } }
public void Create(User model) { using (AuthenticationDB db = new AuthenticationDB()) { db.Users.Add(model); db.SaveChanges(); } }
public ActionResult Medicines() { using (var db = new AuthenticationDB()) { var pharmacy = db.Pharms.FirstOrDefault(u => u.RefUser.UserId == ((OrdPrincipal)HttpContext.User).UserID).Pharmacy; return(View(db.Medicines.Where(m => m.PharmacyName == pharmacy).ToList())); } }
public PartialViewResult GetPatientData(int id) { using (var db = new AuthenticationDB()) { Patient patient = db.Patients .FirstOrDefault(x => x.PatientID == id && x.Doctor.RefUser.UserId == ((OrdPrincipal)HttpContext.User).UserID); return(PartialView(patient)); } }
public PartialViewResult RenderMedicines(string currentPharmacy, int currentPatient) { using (var db = new AuthenticationDB()) { var VM = new DocMedicinesVM(); VM.Medicines = db.Medicines.Where(m => m.PharmacyName == currentPharmacy).ToList(); VM.CurrentPatientId = currentPatient; return(PartialView(VM)); } }
public void DeleteCoWorker(int id) { using (var db = new AuthenticationDB()) { db.InWs.RemoveRange(db.InWs.Where(u => u.RefUser.UserId == id)); db.Pharms.RemoveRange(db.Pharms.Where(u => u.RefUser.UserId == id)); db.Usrs.RemoveRange(db.Usrs.Where(u => u.UserId == id)); db.SaveChanges(); } }
public ActionResult DeleteMedicine(int id) { using (var db = new AuthenticationDB()) { db.Medicines.Remove(db.Medicines.FirstOrDefault(m => m.MedicineID == id)); db.SaveChanges(); } return(RedirectToAction("Medicines")); }
public PartialViewResult RenderMedicines(int id) { using (var db = new AuthenticationDB()) { var VM = db.Patients.FirstOrDefault(p => p.PatientID == id).Medicines.ToList(); ViewBag.Price = VM.Sum(x => x.Price); ViewBag.Id = id; return(PartialView(VM)); } }
public void DocInit() { doc = new DoctorM(); doc.Id = ((OrdPrincipal)HttpContext.User).UserID; doc.FirstName = ((OrdPrincipal)HttpContext.User).FirstName; doc.LastName = ((OrdPrincipal)HttpContext.User).LastName; using (AuthenticationDB context = new AuthenticationDB()) { doc.Specialization = context.Docs.FirstOrDefault(d => d.RefUser.UserId == doc.Id)?.Specialization; } }
public void DeletePatient(int patient) { using (var db = new AuthenticationDB()) { // ReSharper disable once AssignNullToNotNullAttribute db.Patients.Remove(db.Patients.FirstOrDefault(p => (p.PatientID == patient) && (p.Doctor.RefUser.UserId == ((OrdPrincipal)HttpContext.User).UserID))); db.SaveChanges(); } }
public override string GetUserNameByEmail(string email) { var user = AuthenticationDB.GetUserByEmail(email); if (user == null) { return(null); } return(user != null ? user.Email : string.Empty); }
public override string GetPassword(string username, string answer) { using (AuthenticationDB dbContext = new AuthenticationDB()) { var strPass = (from us in dbContext.Users where string.Compare(username, us.Username, StringComparison.OrdinalIgnoreCase) == 0 select us).FirstOrDefault(); return(strPass.Password); } }
/// <summary> /// /// </summary> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public override bool ValidateUser(string username, string password) { if (string.IsNullOrEmpty(username) || string.IsNullOrEmpty(password)) { return(false); } var user = AuthenticationDB.GetUserValidate(username, password); return((user != null) ? user.IsActive ? true : false : false); }