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