bool execute(string email, string password) { using (var context = new RmaEntities()) { var isCorrectData = context.User.FirstOrDefault(u => u.Email == email && u.Password == password); return(isCorrectData != null); } }
public void SaveToDb() { using (var context = new RmaEntities()) { context.Email.Add(_emailMessage); context.SaveChanges(); } }
public override void CreateRole(string roleName) { using (var context = new RmaEntities()) { context.Role.Add(new Role { Name = roleName }); } }
int CreateBankAccount(BankAccount bankAccount) { using (var context = new RmaEntities()) { var addedBankAccount = context.BankAccount.Add(bankAccount); context.SaveChanges(); return(addedBankAccount.Id); } }
int CreateAddress(Adress address) { using (var context = new RmaEntities()) { var addedAddress = context.Adress.Add(address); context.SaveChanges(); return(addedAddress.Id); } }
public ActionResult MessageHistory(int applicationId, string clientEMail) { var context = new RmaEntities(); var emails = context.Email.Where(e => e.Application_Id == applicationId).ToList(); var model = new EmailsViewModel(emails, clientEMail, applicationId); return(View(model)); }
void CreateCode(Application application) { int newId; using (var context = new RmaEntities()) { newId = context.Application.Max(u => u.Id); } application.Name = $"{newId + 1}/{DateTime.Today.Month}/{DateTime.Today.Year}"; }
public void filtr_app_by_status() { var context = new RmaEntities(); var application = context.Application.Include(a => a.AppType).Include(a => a.User).Include(a => a.User1).Include(a => a.Product).Include(a => a.Realization).Include(a => a.Result).Include(a => a.Statue); var result = excecute(application); Assert.True(result > 0); }
void SetStatus(Application application) { using (var context = new RmaEntities()) { var statusName = Statue.StatusDictionary[EStatue.NotConfirmed]; var statue = context.Statue.FirstOrDefault(s => s.Name == statusName); if (statue != null) { application.Statue_Id = statue.Id; } } }
int AddNewBank(RegisterUserViewModel model) { using (var context = new RmaEntities()) { var newBank = new BankAccount { Name = model.BankName, AccountNumber = model.AccountNumber }; context.BankAccount.Add(newBank); context.SaveChanges(); return(newBank.Id); } }
int AddNewAddress(RegisterUserViewModel model) { using (var context = new RmaEntities()) { var newAddress = new Adress { City = model.City, Street = model.Street, ZipCode = model.ZipCode }; context.Adress.Add(newAddress); context.SaveChanges(); return(newAddress.Id); } }
public ActionResult ConfirmEmail(string token, string email) { using (var context = new RmaEntities()) { var userId = int.Parse(HashHelper.Decrypt(token, email)); var user = context.User.FirstOrDefault(u => u.Id == userId && u.Email == email); if (user == null) { return(null); } user.EmailConfirmed = true; context.Entry(user).Property(p => p.EmailConfirmed).IsModified = true; context.SaveChanges(); return(RedirectToAction("Index")); } }
public ActionResult EditDate(int?userId) { if (userId == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var context = new RmaEntities(); var user = context.User.Find(userId); if (user == null) { return(HttpNotFound()); } return(View(user)); }
bool ChangeValues(User user, Adress address, BankAccount bankAccount) { using (var context = new RmaEntities()) { var oldUser = context.User.Find(user.Id); if (oldUser != null) { if (context.User.Any(m => m.Email == user.Email && m.Id != user.Id)) { ModelState.AddModelError("", "Podany e-mail już istnieje!"); return(false); } ChangeValues(user, address, bankAccount, oldUser); } context.SaveChanges(); return(true); } }
void AddNewUser(RegisterUserViewModel model, int addressId, int bankId) { using (var context = new RmaEntities()) { var newUser = new User { FirstName = model.FirstName, LastName = model.LastName, Email = model.Email, Password = model.Password, Phone = model.Phone, Adress_Id = addressId, BankAccount_Id = bankId, Role_Id = context.Role.First(r => r.Name == "Klient").Id }; context.User.Add(newUser); context.SaveChanges(); model.Id = newUser.Id; } }
void SetupFormsAuthTicket(string email, bool persistanceFlag) { User user; using (var context = new RmaEntities()) { user = context.User.FirstOrDefault(u => u.Email == email); } var userId = user.Id; var userData = userId.ToString(CultureInfo.InvariantCulture); var authTicket = new FormsAuthenticationTicket(1, user.Email, DateTime.Now, DateTime.Now.AddMinutes(30), persistanceFlag, userData); var encTicket = FormsAuthentication.Encrypt(authTicket); Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket)); }
public override string[] GetAllRoles() { using (var context = new RmaEntities()) { return(context.Role.Select(r => r.Name).ToArray()); } }
User GetUser(string email) { var context = new RmaEntities(); return(context.User.FirstOrDefault(u => u.Email == email)); }
static bool IsEmailNotUnique(string newEmail) { using (var context = new RmaEntities()) { return(context.User.Any(u => u.Email == newEmail)); } }