public bool addConsume(Consume consume)
{
try
{
hotelDB.Consumes.Add(consume);
hotelDB.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public Consume getByID(int id)
{
hotelDB = new HotelDB();
try
{
Consume consume = (from c in hotelDB.Consumes
where c.id == id
select c).First();
return(consume);
}
catch (Exception)
{
throw;
}
}
public bool deleteConsume(int id)
{
try
{
Consume consume = (from c in hotelDB.Consumes
where c.id == id
select c).First();
hotelDB.Consumes.Remove(consume);
hotelDB.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
public bool editConsume(Consume consume)
{
try
{
var newRoom = hotelDB.Consumes.Single(r => r.id == consume.id);
newRoom.roomID = consume.roomID;
newRoom.roomName = consume.roomName;
newRoom.productID = consume.productID;
newRoom.productName = consume.productName;
newRoom.consume = consume.consume;
newRoom.date = consume.date;
hotelDB.SaveChanges();
return(true);
}
catch (Exception)
{
return(false);
throw;
}
}
