public static DetailPenjualanViewModel GetDetailById(int id)
{
DetailPenjualanViewModel result = new DetailPenjualanViewModel();
using (var db = new PosContext())
{
result = (from b in db.Mst_Barangs
//join b in db.Mst_Barangs
//on d.IdBarang equals b.Id
//join d in db.Trans_DetailPenjualans
//on i.Id equals d.IdBarang
//join h in db.Trans_HeaderPenjualans
//on d.IdHeaderPenjualan equals h.Id
where b.Id == id
select new DetailPenjualanViewModel
{
IdBarang = b.Id,
//IdSupplier = d.IdSupplier,
CodeBarang = b.Code,
Deskripsi = b.Deskripsi,
//Stok = b.Stok,
HargaPenjualan = b.HargaPenjualan
}).FirstOrDefault();
}
return(result);
}
//Get By Id
public static DetailPenjualanViewModel ById(int id)
{
DetailPenjualanViewModel result = new DetailPenjualanViewModel();
using (var db = new Context())
{
result = (from c in db.DetailPenjualans
//join d in db.Barangs on c.kode_barang equals d.kode_barang
//join e in db.Penjualans on c.no_nota equals e.no_nota
where c.id == id
select new DetailPenjualanViewModel
{
id = c.id,
no_nota = c.no_nota,
kode_barang = c.kode_barang,
quantity = c.quantity,
subtotal = c.subtotal,
//nama_barang = d.nama_barang,
//harga = d.harga,
//satuan = d.satuan,
//nama_konsumen = e.nama_konsumen,
//date = e.date,
created_at = c.created_at,
created_by = c.created_by,
modified_at = c.modified_at,
modified_by = c.modified_by,
is_delete = c.is_delete,
deleted_at = c.deleted_at,
deleted_by = c.deleted_by
}).FirstOrDefault();
}
return(result != null ? result : new DetailPenjualanViewModel());
}
//Delete
public static ResponseResult Delete(DetailPenjualanViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new Context())
{
DetailPenjualan detailPenjualan = db.DetailPenjualans
.Where(o => o.id == entity.id)
.FirstOrDefault();
if (detailPenjualan != null)
{
db.DetailPenjualans.Remove(detailPenjualan);
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data not found!";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public ActionResult HapusBarang(DetailPenjualanViewModel model)
{
if (PenjualanRepo.HapusBarang(model))
{
return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { success = false, message = PenjualanRepo.Message }, JsonRequestBehavior.AllowGet));
}
}
public static bool HapusBarang(DetailPenjualanViewModel model)
{
bool result = true;
try
{
using (var db = new PosContext())
{
DetailPenjualan es = db.Trans_DetailPenjualans.Where(o => o.IdHeaderPenjualan == model.IdHeaderPenjualan && o.IdBarang == model.IdBarang).FirstOrDefault();
if (es != null)
{
db.Trans_DetailPenjualans.Remove(es);
db.SaveChanges();
}
}
}
catch (Exception ex)
{
Message = ex.Message;
result = false;
}
return(result);
}
//Create New & Edit
public static ResponseResult Update(DetailPenjualanViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new Context())
{
#region Create New / Insert
if (entity.id == 0)
{
DetailPenjualan detailPenjualan = new DetailPenjualan();
detailPenjualan.id = entity.id;
detailPenjualan.no_nota = entity.no_nota;
detailPenjualan.kode_barang = entity.kode_barang;
detailPenjualan.quantity = entity.quantity;
detailPenjualan.subtotal = entity.subtotal;
detailPenjualan.created_at = DateTime.Now;
detailPenjualan.created_by = 123;
db.DetailPenjualans.Add(detailPenjualan);
db.SaveChanges();
result.Entity = entity;
}
#endregion
//Edit
//Create New / Insert
#region Edit
else
{
DetailPenjualan detailPenjualan = db.DetailPenjualans
.Where(o => o.id == entity.id).FirstOrDefault();
if (detailPenjualan != null)
{
detailPenjualan.id = entity.id;
detailPenjualan.no_nota = entity.no_nota;
detailPenjualan.kode_barang = entity.kode_barang;
detailPenjualan.quantity = entity.quantity;
detailPenjualan.subtotal = entity.subtotal;
detailPenjualan.modified_at = DateTime.Now;
detailPenjualan.modified_by = 123;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data not found!";
}
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
