public Reserversions FindById(int id)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
Reserversions reserversions = (from u in getWithDependences(dbContext) where u.Id == id select u).FirstOrDefault();
return(reserversions);
}
}
private Reserversions getEntityToSave(RezerwacjeDatabaseEntities dbContext, Reserversions reserversion)
{
if (reserversion.Id == 0)
{
return(reserversion);
}
return(dbContext.Reserversions.Single(r => r.Id == reserversion.Id));
}
public bool isRoomVacant(string sessionId, ReserversionWraper reserversions)
{
if (!UserAuthFactory.Instance.isAuth(sessionId))
{
return(false);
}
Reserversions reserversionEntity = reconvert(reserversions);
return(RoomsFactory.Instance.IsRoomVacant(reserversionEntity));
}
public ReserversionWraper FindById(string sessionId, int id)
{
if (!UserAuthFactory.Instance.isAuth(sessionId))
{
return(null);
}
Reserversions reserversionEntity = ReserversionsFactory.Instance.FindById(id);
return(convert(reserversionEntity));
}
public int Save(string sessionId, ReserversionWraper reserversions)
{
if (!UserAuthFactory.Instance.isAuth(sessionId))
{
return(0);
}
Reserversions reserversionEntity = reconvert(reserversions);
reserversionEntity.Users = UserAuthFactory.Instance.getUser(sessionId);
return(ReserversionsFactory.Instance.Save(reserversionEntity));
}
public bool IsRoomVacant(Reserversions reserversion)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
bool vacant = !(from reserv in dbContext.Reserversions
where reserv.Id != reserversion.Id &&
reserv.Rooms.Id == reserversion.Rooms.Id &&
(reserv.From <reserversion.To && reserv.To> reserversion.From)
select reserv.Id).Any();
return(vacant);
}
}
public int Save(Reserversions reserversion)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
Reserversions toSave = getEntityToSave(dbContext, reserversion);
toSave.From = reserversion.From;
toSave.To = reserversion.To;
toSave.Rooms = dbContext.Rooms.Single(r => r.Id == reserversion.Rooms.Id);
toSave.Customers = dbContext.Customers.Single(c => c.Id == reserversion.Customers.Id);
toSave.Users = dbContext.Users.Single(u => u.Id == reserversion.Users.Id);
dbContext.Entry(toSave).State = toSave.Id == 0 ? EntityState.Added : EntityState.Modified;
return(dbContext.SaveChanges());
}
}