public bool UpdateProduct(ref ItikBDO pinguinBDO, ref string message) { message = "Flight updated successfully"; bool ret = true; using (var PAEntities = new ItikAirEntities()) { var penerbanganID = pinguinBDO.Penerbangan_ID; Penerbangan penerbanganInDB = (from p in PAEntities.Penerbangan where p.PenerbanganID == penerbanganID select p).FirstOrDefault(); if (penerbanganInDB == null) { throw new Exception("No flight(s) found with ID " + pinguinBDO.Penerbangan_ID); } PAEntities.Penerbangan.Remove(penerbanganInDB); penerbanganInDB.Pesawat = pinguinBDO.Pesawat; penerbanganInDB.Harga = pinguinBDO.Harga; penerbanganInDB.Asal = pinguinBDO.Asal; penerbanganInDB.Tujuan = pinguinBDO.Tujuan; penerbanganInDB.JlhKursi = pinguinBDO.Jlh_Kursi; PAEntities.Entry(penerbanganInDB).State = System.Data.Entity.EntityState.Modified; PAEntities.SaveChanges(); } return(ret); }
public void DeleteProduct(int id) { using (var PAEntities = new ItikAirEntities()) { var c = (from p in PAEntities.Penerbangan where p.PenerbanganID == id select p).First(); PAEntities.Penerbangan.Remove(c); PAEntities.SaveChanges(); } }
public void InsertProduct(ItikBDO pinguin) { Penerbangan penerbangan = new Penerbangan() { PenerbanganID = pinguin.Penerbangan_ID, Pesawat = pinguin.Pesawat, JlhKursi = (int)pinguin.Jlh_Kursi, Harga = (int)pinguin.Harga, Asal = pinguin.Asal, Tujuan = pinguin.Tujuan, Terbang = (DateTime)pinguin.Terbang }; /*Console.WriteLine(pinguin.Penerbangan_ID);*/ using (var PAEntities = new ItikAirEntities()) { PAEntities.Penerbangan.Add(penerbangan); PAEntities.SaveChanges(); } }