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