//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 static bool Update(DetailReturPenjualanViewModel model) { bool result = true; try { using (var db = new PosContext()) { if (model.Id == 0) { DetailPenjualan detailPenjualan = new DetailPenjualan(); detailPenjualan.Id = model.Id; detailPenjualan.IdHeaderPenjualan = model.IdHeaderPenjualan; detailPenjualan.IdBarang = model.IdBarang; detailPenjualan.HargaPenjualan = model.HargaPenjualan; detailPenjualan.JumlahBarang = model.JumlahBarang; detailPenjualan.Total = model.Total; detailPenjualan.JumlahPengembalian = model.JumlahPengembalian; detailPenjualan.TanggalPengembalian = model.TanggalPengembalian; detailPenjualan.AlasanPengembalian = model.AlasanPengembalian; detailPenjualan.CreatedBy = "Arief"; detailPenjualan.CreatedDate = DateTime.Now; db.Trans_DetailPenjualans.Add(detailPenjualan); db.SaveChanges(); } else { DetailPenjualan detailPenjualan = db.Trans_DetailPenjualans.Where(d => d.Id == model.Id).FirstOrDefault(); if (detailPenjualan != null) { detailPenjualan.IdHeaderPenjualan = model.IdHeaderPenjualan; detailPenjualan.IdBarang = model.IdBarang; detailPenjualan.HargaPenjualan = model.HargaPenjualan; detailPenjualan.JumlahBarang = model.JumlahBarang; detailPenjualan.Total = model.Total; detailPenjualan.JumlahPengembalian = model.JumlahPengembalian; detailPenjualan.TanggalPengembalian = model.TanggalPengembalian; detailPenjualan.AlasanPengembalian = model.AlasanPengembalian; detailPenjualan.ModifiedBy = "Arief"; detailPenjualan.ModifiedDate = DateTime.Now; db.SaveChanges(); } } } } catch (Exception ex) { result = false; Message = ex.Message; } return(result); }
public static ReturnValueViewModel SaveSelling(HeaderDetailPenjualanViewModel model) { ReturnValueViewModel result = new ReturnValueViewModel(); result.Success = true; result.Referensi = GetNewReference(); try { using (var db = new PosContext()) { HeaderPenjualan sh = new HeaderPenjualan(); sh.Id = 1; sh.IdPembeli = model.IdPembeli; sh.Referensi = result.Referensi; sh.TanggalPenjualan = DateTime.Now; sh.CreatedDate = DateTime.Now; sh.CreatedBy = "Arief"; db.Trans_HeaderPenjualans.Add(sh); foreach (var item in model.Details) { DetailPenjualan sd = new DetailPenjualan(); sd.IdHeaderPenjualan = sh.Id; sd.IdBarang = item.IdBarang; sd.HargaPenjualan = item.HargaPenjualan; sd.JumlahBarang = item.JumlahBarang; sd.Total = item.HargaPenjualan * item.JumlahBarang; //item.Amount; sd.CreatedBy = "Arief"; sd.CreatedDate = DateTime.Now; db.Trans_DetailPenjualans.Add(sd); } db.SaveChanges(); } } catch (Exception ex) { result.Success = false; result.Message = ex.InnerException.ToString(); } return(result); }
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); }