public void AddOutbond(Outbond user) { using (DBOutbondEntities1 db = new DBOutbondEntities1()) { outbond OU = new outbond(); OU.keterangan = user.keterangan; OU.harga = user.harga; db.outbonds.Add(OU); db.SaveChanges(); } }
public void Addoutbond(addoutbondView m) { using (DemoEntities1 db = new DemoEntities1()) { outbond mn = new outbond(); mn.harga = m.harga; mn.keterangan = m.keterangan; db.outbonds.Add(mn); db.SaveChanges(); } }
public void AddOutbond(OutbondView OV) { using (DemoEntities db = new DemoEntities()) { outbond ob = new outbond(); ob.keterangan = OV.keterangan; ob.harga = OV.harga; db.outbonds.Add(ob); db.SaveChanges(); } }
public List <OrderProfileView> GetAllOrders() { List <OrderProfileView> orders = new List <OrderProfileView>(); using (DemoEntities1 db = new DemoEntities1()) { OrderProfileView OV; //var orderData = db.laporans.ToList(); ??? foreach (laporan l in db.laporans) { OV = new OrderProfileView(); OV.id_laporan = l.id_laporan; pelanggan pelanggan = db.pelanggans.Where(o => o.id_pelanggan.Equals(l.id_pelanggan)).FirstOrDefault(); OV.namapelanggan = pelanggan.nama; outbond outbond = db.outbonds.Where(o => o.id_outbond.Equals(l.id_outbond)).FirstOrDefault(); OV.namaoutbond = outbond.keterangan; OV.keterangan = l.keterangan; OV.tgl_akhir = (DateTime)l.tgl_akhir; OV.tgl_mulai = (DateTime)l.tgl_mulai; OV.tgl_pesan = (DateTime)l.tgl_pesan; OV.harga = l.harga; OV.quantity = l.quantity; OV.jumlah = l.jumlah; orders.Add(OV); } } orders.Reverse(); return(orders); }
public void AddOrder(addOrderView m) { using (DemoEntities1 db = new DemoEntities1()) { outbond mn = db.outbonds.Find(m.id_outbond); mn.harga = mn.harga; mn.id_outbond = mn.id_outbond; mn.keterangan = mn.keterangan; laporan lp = new laporan(); lp.id_outbond = m.id_outbond; lp.id_pelanggan = m.id_pelanggan; lp.keterangan = m.keterangan; lp.tgl_akhir = m.tgl_akhir; lp.tgl_mulai = m.tgl_mulai; lp.tgl_pesan = m.tgl_pesan; lp.quantity = m.quantity; lp.harga = m.harga; lp.jumlah = m.jumlah; db.laporans.Add(lp); db.SaveChanges(); } }
//[AuthorizeRoles("Admin")] public ActionResult UpdateoutbondData(int id_outbond, string keterangan, int harga) { outbondProfileView MPV = new outbondProfileView(); MPV.id_outbond = id_outbond; MPV.keterangan = keterangan; MPV.harga = harga; using (DemoEntities1 db = new DemoEntities1()) { using (var dbContext = db.Database.BeginTransaction()) { try { outbond m = db.outbonds.Find(MPV.id_outbond); m.keterangan = MPV.keterangan; m.harga = MPV.harga; db.SaveChanges(); dbContext.Commit(); } catch (Exception ex) { dbContext.Rollback(); } } } return(Json(new { success = true, id_outbond = MPV.id_outbond, keterangan = MPV.keterangan, harga = MPV.harga })); }