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; } }