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