public Deal GetDeal(int id) { using (var db = new TwinkleDbContext()) { return(db.Deals.Find(id)); } }
private SessionContext(string login, string password) { try { using (var db = new TwinkleDbContext()) { CurrentUser = db.Users.Include(x => x.ChachedEmailBoxes.Select(s => s.IncomingEmailServerParam)) .Include(x => x.ChachedEmailBoxes.Select(s => s.OutgoingEmailServerParam)) .Include(x => x.ChachedEmailBoxes.Select(s => s.EmailServer)) .Include(x => x.ChachedEmailBoxes.Select(s => s.User)) .Single(t => t.Login == login && t.PasswordHash == password); //CurrentUser = db.Users.Include(x => x.ChachedEmailBoxes.Select( s => s.IncomingEmailServerParam)) // .Single(t => t.Login == login && t.PasswordHash == password); //db.Entry(CurrentUser).Collection(nameof(CurrentUser.ChachedEmailBoxes)).Load(); } } catch (ArgumentNullException ex) { throw new InvalidCredentialException("Authorize failed!", ex); } catch (InvalidOperationException ex) { throw new InvalidCredentialException("Authorize failed: user is not found!", ex); } catch (Exception ex) { throw ex; } }
public Customer GetCustomer(int id) { using (var db = new TwinkleDbContext()) { return(db.Customers.Find(id)); } }
public Performer GetPerformer(int id) { using (var db = new TwinkleDbContext()) { return(db.Performers.Find(id)); } }
public IEnumerable <Vehicle> GetAllVehicles() { using (var db = new TwinkleDbContext()) { db.Vehicles.Load(); return(db.Vehicles.ToList()); } }
public IEnumerable <DictionaryTripType> GetAllTripTypes() { using (var db = new TwinkleDbContext()) { db.TripTypes.Load(); return(db.TripTypes.ToList()); } }
public void UpdateMail(TheMail mail) { using (var db = new TwinkleDbContext()) { db.Entry(mail).State = EntityState.Modified; db.SaveChanges(); } }
public IEnumerable <Deal> GetFreeAppointments() { using (var db = new TwinkleDbContext()) { db.Deals.Load(); return(db.Deals.Where(x => x.VehicleId == null).ToList()); } }
public IEnumerable <ViewAssignedDeal> GetAssignedAppointments() { using (var db = new TwinkleDbContext()) { db.ViewAssignedDeals.Load(); return(db.ViewAssignedDeals.ToList()); } }
public IEnumerable <Performer> GetAllPerformers() { using (var db = new TwinkleDbContext()) { db.Performers.Load(); return(db.Performers.ToList()); } }
public void DeleteCustomer(int id) { using (var db = new TwinkleDbContext()) { var customer = db.Customers.Find(id); db.Customers.Remove(customer); db.SaveChanges(); } }
public void DeletePerformer(int id) { using (var db = new TwinkleDbContext()) { var performer = db.Performers.Find(id); db.Performers.Remove(performer); db.SaveChanges(); } }
public void DeleteDeal(int id) { using (var db = new TwinkleDbContext()) { var deal = db.Deals.Find(id); db.Deals.Remove(deal); db.SaveChanges(); } }
public void CancelAppointment(int appointmentId) { using (var db = new TwinkleDbContext()) { var appt = db.Deals.Find(appointmentId); appt.VehicleId = null; db.SaveChanges(); } }
public void RemoveMail(string id) { using (var db = new TwinkleDbContext()) { var mail = db.Mails.Find(id); db.Mails.Remove(mail); db.SaveChanges(); } }
public void DeleteAppointment(int appointmentId) { using (var db = new TwinkleDbContext()) { var appt = db.Mails.Find(appointmentId); db.Mails.Remove(appt); db.SaveChanges(); } }
public void AssignAppointment(int appointmentId, int resourceId) { using (var db = new TwinkleDbContext()) { var appt = db.Deals.Find(appointmentId); appt.VehicleId = resourceId; db.SaveChanges(); } }
public void InsertCustomer(Customer customer) { using (var db = new TwinkleDbContext()) { customer.CreatedBy = -1; customer.CreationDate = DateTime.Now; db.Customers.Add(customer); db.SaveChanges(); } }
public void InsertPerformer(Performer performer) { using (var db = new TwinkleDbContext()) { performer.CreatedBy = -1; performer.CreationDate = DateTime.Now; db.Performers.Add(performer); db.SaveChanges(); } }
public void InsertDeal(Deal deal) { using (var db = new TwinkleDbContext()) { deal.CreatedBy = -1; deal.CreationDate = DateTime.Now; db.Deals.Add(deal); db.SaveChanges(); } }
public void InsertMail(TheMail mail) { using (var db = new TwinkleDbContext()) { if (!db.Mails.Select(x => x.Id).Contains(mail.Id)) { db.Mails.Add(mail); db.SaveChanges(); } } }
public List <TheMail> GetUserMails() { var allMails = new List <TheMail>(); using (var db = new TwinkleDbContext()) { db.Mails.Load(); var userEmailBoxIds = SessionContext.Instance.CurrentUser.ChachedEmailBoxes.Select(box => box.Id.Value).ToList(); allMails = db.Mails.Where(mail => userEmailBoxIds.Contains(mail.ChachedEmailBoxId.Value)).ToList(); } return(allMails); }