public void Insert(ReceiptDetilModel model) { var sSql = @" INSERT INTO ReceiptDetil ( ReceiptID, ReceiptDetilID, NoUrut, BrgID, Qty, Harga, Diskon, TaxRupiah, SubTotal ) VALUES ( @ReceiptID, @ReceiptDetilID, @NoUrut, @BrgID, @Qty, @Harga, @Diskon, @TaxRupiah, @SubTotal ) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@ReceiptID", model.ReceiptID); cmd.AddParam("@ReceiptDetilID", model.ReceiptDetilID); cmd.AddParam("@NoUrut", model.NoUrut); cmd.AddParam("@BrgID", model.BrgID); cmd.AddParam("Qty", model.Qty); cmd.AddParam("@Harga", model.Harga); cmd.AddParam("@Diskon", model.Diskon); cmd.AddParam("@TaxRupiah", model.TaxRupiah); cmd.AddParam("@SubTotal", model.SubTotal); conn.Open(); cmd.ExecuteNonQuery(); } }
public ReceiptDetilModel ValidateBrg(ReceiptDetilModel rd) { var brg = _brgBL.GetData(rd.BrgID); if (brg == null) { return(null); } rd.BrgName = brg.BrgName; return(rd); }
public List <ReceiptDetilModel> ListDetil(string bpPurchaseID) { // list all data di bpPurchaseReceipt var listDetil = _bpPurchaseReceiptDal.ListData(bpPurchaseID); if (listDetil == null) { return(null); } // ambil purchase-nya aja, lalu copykan ke result; var listPurchase = listDetil.Where(x => x.BPReceiptID.Trim() == ""); if (listPurchase == null) { return(null); } var result = new List <ReceiptDetilModel>(); foreach (var item in listPurchase) { // ambil nama barang string brgName = ""; var brg = _brgDal.GetData(item.BrgID); if (brg != null) { brgName = brg.BrgName; } // hitung qty sisa var qty = item.QtyPurchase; qty -= listDetil.Where(x => x.BrgID == item.BrgID) .Sum(x => x.QtyReceipt); // tambahkan item / baris baru var receiptDetil = new ReceiptDetilModel { BrgID = item.BrgID, BrgName = brgName, Qty = qty, Harga = item.Harga, Diskon = item.Diskon, TaxRupiah = item.Tax, SubTotal = item.SubTotal }; result.Add(receiptDetil); } return(result); }
public IEnumerable <ReceiptDetilModel> ListData(string receiptID) { List <ReceiptDetilModel> result = null; var sSql = @" SELECT aa.ReceiptID, aa.ReceiptDetilID, aa.NoUrut, aa.BrgID, aa.Qty, aa.Harga, aa.Diskon, aa.TaxRupiah, aa.SubTotal, ISNULL(bb.BrgName, '') BrgName FROM ReceiptDetil aa LEFT JOIN Brg bb ON aa.BrgID = bb.BrgID WHERE aa.ReceiptID = @ReceiptID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@ReceiptID", receiptID); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } result = new List <ReceiptDetilModel>(); while (dr.Read()) { var item = new ReceiptDetilModel { ReceiptID = dr["ReceiptID"].ToString(), ReceiptDetilID = dr["ReceiptDetilID"].ToString(), NoUrut = Convert.ToInt16(dr["NoUrut"]), BrgID = dr["BrgID"].ToString(), BrgName = dr["BrgName"].ToString(), Qty = Convert.ToInt64(dr["Qty"]), Harga = Convert.ToDecimal(dr["Harga"]), Diskon = Convert.ToDecimal(dr["Diskon"]), SubTotal = Convert.ToDecimal(dr["SubTotal"]), TaxRupiah = Convert.ToDecimal(dr["TaxRupiah"]) }; result.Add(item); } } } return(result); }
private ReceiptDetilModel ReceiptDetilDataFactory() { var result = new ReceiptDetilModel { ReceiptID = "A1", ReceiptDetilID = "B1", BrgID = "C1", BrgName = "", Harga = 1, NoUrut = 2, Qty = 3, Diskon = 200, SubTotal = 2121, TaxRupiah = 122 }; return(result); }
public ReceiptDetilModel PilihBrg(ReceiptDetilModel pd) { var searchForm = new SearchingForm <BrgSearchResultModel>(_brgBL); var resultDialog = searchForm.ShowDialog(); if (resultDialog == DialogResult.OK) { var brgID = searchForm.SelectedDataKey; var brg = _brgBL.GetData(brgID); if (brg == null) { return(pd); } if (pd == null) { pd = new ReceiptDetilModel(); } pd.BrgID = brgID; pd.BrgName = brg.BrgName; } return(pd); }
public ReceiptDetilModel Calculate(ReceiptDetilModel rd) { rd.SubTotal = rd.Qty * (rd.Harga - rd.Diskon + rd.TaxRupiah); return(rd); }