private void DeleteRes(object obj) { lock (synclock) { CashDeskEntities db = new CashDeskEntities(); var reservations = db.Reservations.Include(r => r.Client).Include(r => r.Status_res).Include(r => r.Ticket); foreach (var item in reservations.ToList()) { if (DateTime.Now >= (item.date_reservation).AddDays(1)) { var tick = db.Tickets.Where(c => c.id_ticket == item.ticket_id).FirstOrDefault(); tick.status_ticket_id = 1; db.Reservations.Remove(item); db.SaveChanges(); } } } }
public ActionResult Register(Client model) { if (ModelState.IsValid) { Client client = null; using (CashDeskEntities db = new CashDeskEntities()) { client = db.Clients.FirstOrDefault(u => u.login == model.login); } if (client == null) { using (CashDeskEntities db = new CashDeskEntities()) { db.Clients.Add(new Client { surname = model.surname, name = model.name, patronymic = model.patronymic, pass = model.pass, login = model.login, password = model.password, role_id = 3 }); db.SaveChanges(); client = db.Clients.Where(u => u.login == model.login && u.password == model.password).FirstOrDefault(); } if (client != null) { FormsAuthentication.SetAuthCookie(model.login, true); return(RedirectToAction("Index", "Reys")); } } else { ModelState.AddModelError("", "Пользователь с таким логином уже существует!"); } } return(View(model)); }
public ActionResult Login(Client model) { if (ModelState.IsValid) { Client client = null; using (CashDeskEntities db = new CashDeskEntities()) { client = db.Clients.FirstOrDefault(u => u.login == model.login && u.password == model.password); } if (client != null) { FormsAuthentication.SetAuthCookie(model.login, true); return(RedirectToAction("Index", "Reys")); } else { ModelState.AddModelError("", "Неверное имя пользователя или пароль!"); } } return(View(model)); }