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