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