public IList <Message> GetAll()
{
using (db = new HairstudioDBContext())
{
return(db.Messages.ToList());
}
}
public IList <TimeRange> GetAll()
{
using (db = new HairstudioDBContext())
{
return(db.TimeRanges.ToList());
}
}
public ServiceOffered Get(int id)
{
using (db = new HairstudioDBContext())
{
return(db.ServicesOffered.FirstOrDefault(x => x.ID == id));
}
}
public IList <ServiceOffered> GetAll()
{
using (db = new HairstudioDBContext())
{
return(db.ServicesOffered.ToList());
}
}
public Appointment Update(Appointment t)
{//TODO
using (db = new HairstudioDBContext())
{
var ea = db.Appointments //ea = existing appointment
.Include(a => a.Hairdresser)
.Include(a => a.Customer)
.Include(a => a.TimeRange)
.FirstOrDefault(x => x.ID == t.ID);
var hairdresser = db.Hairdressers.FirstOrDefault(x => x.ID == t.Hairdresser.ID);
var customer = db.Customers.FirstOrDefault(x => x.ID == t.Customer.ID);
if (ea != null)
{
ea.Hairdresser = hairdresser;
ea.Customer = customer;
ea.TimeRange.TheDate = t.TimeRange.TheDate;
ea.TimeRange.EndTime = t.TimeRange.EndTime;
ea.TimeRange.StartTime = t.TimeRange.StartTime;
}
//var objectStateManager = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager;
//objectStateManager.ChangeObjectState(ea, EntityState.Modified);
db.SaveChanges();
return(t);
}
}
public TimeRange Get(int id)
{
using (db = new HairstudioDBContext())
{
return(db.TimeRanges.FirstOrDefault(x => x.ID == id));
}
}
public ServiceOffered Update(ServiceOffered t)
{//TODO
using (db = new HairstudioDBContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(t);
}
}
public bool Remove(Customer t)
{
using (db = new HairstudioDBContext())
{
db.Entry(db.Customers.FirstOrDefault(x => x.ID == t.ID)).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(db.Customers.FirstOrDefault(x => x.ID == t.ID) == null);
}
}
public TimeRange Update(TimeRange t)
{//TODO
using (db = new HairstudioDBContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(t);
}
}
public TimeRange Create(TimeRange t)
{
using (db = new HairstudioDBContext())
{
db.TimeRanges.Add(t);
db.SaveChanges();
return(t);
}
}
public Customer Create(Customer t)
{
using (db = new HairstudioDBContext())
{
db.Customers.Add(t);
db.SaveChanges();
return(t);
}
}
public Customer Update(Customer t)
{
using (db = new HairstudioDBContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(t);
}
}
public ServiceOffered Create(ServiceOffered t)
{
using (db = new HairstudioDBContext())
{
db.ServicesOffered.Add(t);
db.SaveChanges();
return(t);
}
}
public Message Create(Message t)
{
using (db = new HairstudioDBContext())
{
db.Messages.Add(t);
db.SaveChanges();
return(t);
}
}
public bool Remove(ServiceOffered t)
{
using (db = new HairstudioDBContext())
{
db.Entry(t).State = System.Data.Entity.EntityState.Deleted;
db.SaveChanges();
return(true);
}
}
public Hairdresser Create(Hairdresser t)
{
using (db = new HairstudioDBContext())
{
db.Hairdressers.Add(t);
db.SaveChanges();
return(t);
}
}
public Appointment Get(int id)
{
using (db = new HairstudioDBContext())
{
return(db.Appointments
.Include(t => t.TimeRange)
.Include(t => t.Hairdresser)
.Include(t => t.Customer)
.FirstOrDefault(x => x.ID == id));
}
}
public IList <Hairdresser> GetAll()
{
using (db = new HairstudioDBContext())
{
return(db.Hairdressers
.Include(h => h.Appointments.Select(c => c.TimeRange))
.Include(h => h.Appointments.Select(c => c.Customer))
.Include(h => h.WorkingDays)
.ToList());
}
}
public Customer Get(int id)
{
using (db = new HairstudioDBContext())
{
return(db.Customers
.Include(h => h.Appointments.Select(c => c.TimeRange))
.Include(h => h.Appointments.Select(c => c.Hairdresser))
.Include(h => h.Appointments)
.FirstOrDefault(x => x.ID == id));
}
}
public IList <Appointment> GetAll()
{
using (db = new HairstudioDBContext())
{
return(db.Appointments
.Include(t => t.TimeRange)
.Include(t => t.Hairdresser)
.Include(t => t.Customer)
.ToList());
}
}
public Hairdresser Get(int id)
{
using (db = new HairstudioDBContext())
{
var hairdresser = db.Hairdressers
.Include(h => h.Appointments.Select(c => c.TimeRange))
.Include(h => h.Appointments.Select(c => c.Customer))
.Include(h => h.WorkingDays)
.FirstOrDefault(x => x.ID == id);
return(hairdresser);
}
}
public Appointment Create(Appointment t)
{
using (db = new HairstudioDBContext())
{
var hairdresser = db.Hairdressers.FirstOrDefault(x => x.ID == t.Hairdresser.ID);
var customer = db.Customers.FirstOrDefault(x => x.ID == t.Customer.ID);
t.Hairdresser = hairdresser;
t.Customer = customer;
db.Appointments.Add(t);
db.SaveChanges();
return(t);
}
}
public Message Update(Message t)
{//TODO
using (db = new HairstudioDBContext())
{
var em = db.Messages.FirstOrDefault(x => x.ID == t.ID);
if (em != null)
{
em.Description = t.Description;
db.SaveChanges();
}
return(em);
}
}
public Hairdresser Update(Hairdresser t)
{//TODO
using (db = new HairstudioDBContext())
{
var eh = db.Hairdressers
.Include(h => h.Appointments)
.Include(h => h.WorkingDays)
.FirstOrDefault(x => x.ID == t.ID);
if (eh != null)
{
//eh = Existing hairdresser
eh.Name = t.Name;
eh.Email = t.Email;
eh.Appointments = new List <Appointment>();
if (t.Appointments != null)
{
foreach (var a in t.Appointments)
{
eh.Appointments.Add(a);
}
}
eh.WorkingDays = new List <TimeRange>();
if (t.WorkingDays != null)
{
foreach (var w in t.WorkingDays)
{
eh.WorkingDays.Add(w);
}
}
//Password, usertype and ID are not to be changed here.
eh.PhoneNumber = t.PhoneNumber;
eh.Email = t.Email;
eh.Username = t.Username;
eh.Name = t.Name;
if (t.Appointments != null)
{
foreach (var a in t.Appointments)
{
eh.Appointments.Add(db.Appointments.FirstOrDefault(x => x.ID == a.ID));
}
}
}
db.SaveChanges();
return(eh);
}
}
/// <summary>
/// Constructor where a new DBContext is created
/// </summary>
public CustomerRepository()
{
db = new HairstudioDBContext();
}
/// <summary>
/// Constructor where a new DBContext is created
/// </summary>
public MessageRepository()
{
db = new HairstudioDBContext();
}
/// <summary>
/// Constructor where a new DBContext is created
/// </summary>
public ServiceOfferedRepository()
{
db = new HairstudioDBContext();
}
/// <summary>
/// Method where the HairstudioDBContext used by this repository is set.
/// </summary>
/// <param name="ctx"></param>
public void SetContext(HairstudioDBContext ctx)
{
db = ctx;
}
/// <summary>
/// Constructor where a new DBContext is created
/// </summary>
public TimeRangeRepository()
{
db = new HairstudioDBContext();
}
/// <summary>
/// Constructor where a new DBContext is created
/// </summary>
public AppointmentRepository()
{
db = new HairstudioDBContext();
}
