public bool UpdateProduct(ref MawarDBO mawarBDO, ref string message) { message = "Room updated successfully"; bool ret = true; using (var MMEEntities = new HotelMawarMelatiEntities()) { var kamar_ID = mawarBDO.Kamar_ID; Kamar kamarInDB = (from p in MMEEntities.Kamar where p.kamarID == kamar_ID select p).FirstOrDefault(); if (kamarInDB == null) { throw new Exception("No room(s) found with ID " + mawarBDO.Kamar_ID); } MMEEntities.Kamar.Remove(kamarInDB); kamarInDB.Harga = mawarBDO.Harga; kamarInDB.Jenis = mawarBDO.Jenis; kamarInDB.Jumlah = mawarBDO.Jumlah; MMEEntities.Entry(kamarInDB).State = System.Data.Entity.EntityState.Modified; MMEEntities.SaveChanges(); } return(ret); }
public void DeleteProduct(int id) { using (var MMEEntities = new HotelMawarMelatiEntities()) { var c = (from p in MMEEntities.Kamar where p.kamarID == id select p).First(); MMEEntities.Kamar.Remove(c); MMEEntities.SaveChanges(); } }
public void InsertProduct(MawarDBO mawar) { Kamar penerbangan = new Kamar() { kamarID = mawar.Kamar_ID, Jumlah = (int)mawar.Jumlah, Harga = (int)mawar.Harga, Jenis = mawar.Jenis }; /*Console.WriteLine(mawar.Penerbangan_ID);*/ using (var MMEEntities = new HotelMawarMelatiEntities()) { MMEEntities.Kamar.Add(penerbangan); MMEEntities.SaveChanges(); } }
public IEnumerable <MawarDBO> GetAllProduct() { List <Kamar> li = new List <Kamar>(); List <MawarDBO> temp = new List <MawarDBO>(); using (var MMEEntities = new HotelMawarMelatiEntities()) { li = (from p in MMEEntities.Kamar select p).ToList(); } foreach (var c in li) { MawarDBO data = new MawarDBO() { Kamar_ID = c.kamarID, Jumlah = (int)c.Jumlah, Harga = (int)c.Harga, Jenis = c.Jenis }; temp.Add(data); } return(temp); }
public MawarDBO GetProduct(int id) { MawarDBO mawarBDO = null; using (var MMEEntities = new HotelMawarMelatiEntities()) { Kamar kamar = (from p in MMEEntities.Kamar where p.kamarID == id select p).FirstOrDefault(); if (kamar != null) { mawarBDO = new MawarDBO() { Kamar_ID = kamar.kamarID, Jumlah = (int)kamar.Jumlah, Harga = (int)kamar.Harga, Jenis = kamar.Jenis, }; } } return(mawarBDO); }