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