public Account GetByLogin(string login)
{
using (PersianRugContext entityContext = new PersianRugContext())
{
return((from a in entityContext.AccountSet
where a.LoginEmail == login
select a).FirstOrDefault());
}
}
protected override Appointment GetEntity(PersianRugContext entityContext, int id)
{
var query = (from e in entityContext.AppointmentSet
where e.AppointmentId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
protected override Reservation GetEntity(PersianRugContext entityContext, int id)
{
var query = (from e in entityContext.ReservationSet
where e.ReservationId == id
select e);
var results = query.FirstOrDefault();
return(results);
}
public Appointment GetCurrentAppointmentByTimeSlot(int timeSlotId)
{
using (PersianRugContext entityContext = new PersianRugContext())
{
var query = from e in entityContext.AppointmentSet
where e.TimeSlotId == timeSlotId
select e;
return(query.FirstOrDefault());
}
}
public IEnumerable <Reservation> GetReservationsByAppointmentDate(DateTime appointmentDate)
{
using (PersianRugContext entityContext = new PersianRugContext())
{
var query = from r in entityContext.ReservationSet
where r.BookDate < appointmentDate
select r;
return(query.ToFullyLoaded());
}
}
public IEnumerable <Appointment> GetCurrentlyAppointments()
{
using (PersianRugContext entityContext = new PersianRugContext())
{
var query = from e in entityContext.AppointmentSet
where e.AppointmentDate > DateTime.Now && e.AppointmentDate < DateTime.Now.AddDays(7)
select e;
return(query.ToFullyLoaded());
}
}
public IEnumerable <Appointment> GetAppointmentHistoryByAccount(int accountId)
{
using (PersianRugContext entityContext = new PersianRugContext())
{
var query = from e in entityContext.AppointmentSet
where e.AccountId == accountId
select e;
return(query.ToFullyLoaded());
}
}
public IEnumerable <CustomerReservationInfo> GetCurrentCustomerReservationInfo()
{
using (PersianRugContext entityContext = new PersianRugContext())
{
var query = from r in entityContext.ReservationSet
join a in entityContext.AccountSet on r.AccountId equals a.AccountId
join c in entityContext.TimeSlotSet on r.TimeSlotId equals c.TimeSlotId
select new CustomerReservationInfo()
{
Customer = a,
TimeSlot = c,
Reservation = r
};
return(query.ToFullyLoaded());
}
}
protected override TimeSlot AddEntity(PersianRugContext entityContext, TimeSlot entity)
{
return(entityContext.TimeSlotSet.Add(entity));
}
protected override IEnumerable <TimeSlot> GetEntities(PersianRugContext entityContext)
{
return(from e in entityContext.TimeSlotSet
select e);
}
protected override IEnumerable <Reservation> GetEntities(PersianRugContext entityContext)
{
return(from e in entityContext.ReservationSet
select e);
}
protected override Reservation UpdateEntity(PersianRugContext entityContext, Reservation entity)
{
return((from e in entityContext.ReservationSet
where e.ReservationId == entity.ReservationId
select e).FirstOrDefault());
}
protected override Reservation AddEntity(PersianRugContext entityContext, Reservation entity)
{
return(entityContext.ReservationSet.Add(entity));
}
protected override TimeSlot UpdateEntity(PersianRugContext entityContext, TimeSlot entity)
{
return((from e in entityContext.TimeSlotSet
where e.TimeSlotId == entity.TimeSlotId
select e).FirstOrDefault());
}
protected override Account AddEntity(PersianRugContext entityContext, Account entity)
{
return(entityContext.AccountSet.Add(entity));
}
protected override IEnumerable <Appointment> GetEntities(PersianRugContext entityContext)
{
return(from e in entityContext.AppointmentSet
select e);
}
protected override Appointment UpdateEntity(PersianRugContext entityContext, Appointment entity)
{
return((from e in entityContext.AppointmentSet
where e.AppointmentId == entity.AppointmentId
select e).FirstOrDefault());
}
protected override Appointment AddEntity(PersianRugContext entityContext, Appointment entity)
{
return(entityContext.AppointmentSet.Add(entity));
}