public Rooms FindById(int id)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
Rooms room = (from u in dbContext.Rooms where u.Id == id select u).FirstOrDefault();
return(room);
}
}
public int Save(Rooms room)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
dbContext.Entry(room).State = room.Id == 0 ? EntityState.Added : EntityState.Modified;
return(dbContext.SaveChanges());
}
}
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);
}
}
public List <Rooms> FindAll()
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
List <Rooms> rooms = dbContext.Rooms.ToList();
return(rooms);
}
}
public List <Reserversions> FindAll()
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
List <Reserversions> reserversions = getWithDependences(dbContext).ToList();
return(reserversions);
}
}
public int Save(Customers customer)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
dbContext.Entry(customer).State = customer.Id == 0 ? EntityState.Added : EntityState.Modified;
return(dbContext.SaveChanges());
}
}
public Customers FindById(int id)
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
Customers user = (from u in dbContext.Customers where u.Id == id select u).FirstOrDefault();
return(user);
}
}
public List <Customers> FindAll()
{
using (var dbContext = new RezerwacjeDatabaseEntities())
{
List <Customers> users = dbContext.Customers.ToList();
return(users);
}
}
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(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());
}
}
private IQueryable <Reserversions> getWithDependences(RezerwacjeDatabaseEntities dbContext)
{
return(dbContext.Reserversions.Include(r => r.Customers).Include(r => r.Rooms).Include(r => r.Users));
}
