private void PasteButton_Click(object sender, EventArgs e)
{
if (PriceCopy == null)
{
return;
}
var brgID = BrgGrid.CurrentRow.Cells["BrgKodeCol"].Value.ToString();
PriceGrid.Rows.Clear();
var listBrg = new List <BrgPriceModel>();
foreach (var item in PriceCopy)
{
var qty = item.Qty;
var brgPrice = new BrgPriceModel
{
BrgID = brgID,
Qty = qty,
Harga = (double)item.Harga,
Diskon = (double)item.Diskon
};
listBrg.Add(brgPrice);
}
var result = _brgPriceBL.Save(brgID, listBrg);
BrgGrid.Refresh();
RefreshPrice(BrgGrid.CurrentRow.Index);
}
private void SaveButton_Click(object sender, EventArgs e)
{
var brgID = BrgGrid.CurrentRow.Cells["BrgKodeCol"].Value.ToString();
if (PriceGrid.Rows.Count == 0)
{
return;
}
var listBrg = new List <BrgPriceModel>();
foreach (DataGridViewRow item in PriceGrid.Rows)
{
var qty = Convert.ToInt16(item.Cells["PriceQtyCol"].Value);
if (qty == 0)
{
continue;
}
var brgPrice = new BrgPriceModel
{
BrgID = brgID,
Qty = qty,
Harga = Convert.ToDouble(item.Cells["PriceHargaCol"].Value),
Diskon = Convert.ToDouble(item.Cells["PriceDiskonCol"].Value)
};
listBrg.Add(brgPrice);
}
var result = _brgPriceBL.Save(brgID, listBrg);
BrgGrid.Refresh();
RefreshPrice(BrgGrid.CurrentRow.Index);
}
public void Insert(string brgID, BrgPriceModel brgPrice)
{
var sSql = @"
INSERT INTO
BrgPrice (
BrgID, Qty, Harga, Diskon)
VALUES (
@BrgID, @Qty, @Harga, @Diskon) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BrgID", brgID);
cmd.AddParam("@Qty", brgPrice.Qty);
cmd.AddParam("@Harga", brgPrice.Harga);
cmd.AddParam("@Diskon", brgPrice.Diskon);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public IEnumerable <BrgPriceModel> ListData(string brgID)
{
List <BrgPriceModel> result = null;
var sSql = @"
SELECT
aa.BrgID, aa.Qty, aa.Harga, aa.Diskon
FROM
BrgPrice aa
WHERE
BrgID = @BrgID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@BrgID", brgID);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (dr.HasRows)
{
result = new List <BrgPriceModel>();
while (dr.Read())
{
var item = new BrgPriceModel
{
BrgID = dr["BrgID"].ToString(),
Qty = Convert.ToInt16(dr["Qty"]),
Harga = Convert.ToDouble(dr["Harga"]),
Diskon = Convert.ToDouble(dr["Diskon"])
};
result.Add(item);
}
}
}
}
return(result);
}
