private void CreateDeposit() { // ambil list brg var listBrg = new List <DepositDetilModel>(); foreach (DataRow dr in DetilPenjualanTable.Rows) { if (dr["BrgID"].ToString().Trim() == "") { continue; } var depositDetil = new DepositDetilModel() { BrgID = dr["BrgID"].ToString(), Qty = Convert.ToDecimal(dr["Qty"]), Harga = Convert.ToDecimal(dr["Harga"]), Diskon = Convert.ToDecimal(dr["Diskon"]), SubTotal = Convert.ToDecimal(dr["SubTotal"]) }; listBrg.Add(depositDetil); } var jenisBayarID = ""; if (_listBayarDetil != null) { jenisBayarID = _listBayarDetil.FirstOrDefault().JenisBayarID; } var pihakKeduaID = ""; if (CustomerComboBox.SelectedValue != null) { pihakKeduaID = CustomerComboBox.SelectedValue.ToString(); } // save deposit var deposit = new DepositModel { Tgl = TanggalDateTime.Value.ToString("dd-MM-yyyy"), Jam = JamTextBox.Text, PihakKeduaID = pihakKeduaID, BuyerName = BuyerNameTextBox.Text, JenisBayarID = jenisBayarID, NilaiBiayaKirim = BiayaKirimNumText.Value, NilaiDeposit = GrandTotalNumText.Value, ListBrg = listBrg }; var form = new DepositForm(deposit) { MdiParent = this.MdiParent, StartPosition = FormStartPosition.CenterScreen, }; form.Show(); ClearForm(); }
public void Insert(DepositDetilModel model) { var sSql = @" INSERT INTO DepositDetil ( DepositID, BrgID, Qty, Harga, SubTotal) VALUES ( @DepositID, @BrgID, @Qty, @Harga, @SubTotal) "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@DepositID", model.DepositID); cmd.AddParam("@BrgID", model.BrgID); cmd.AddParam("@Qty", model.Qty); cmd.AddParam("@Harga", model.Harga); cmd.AddParam("@SubTotal", model.SubTotal); conn.Open(); cmd.ExecuteNonQuery(); } }
public IEnumerable <DepositDetilModel> ListBrg(string depositID) { List <DepositDetilModel> result = null; var sSql = @" SELECT BrgID, Qty, Harga, SubTotal FROM DepositDetil WHERE DepositID = @DepositID "; using (var conn = new SqlConnection(_connString)) using (var cmd = new SqlCommand(sSql, conn)) { cmd.AddParam("@DepositID", depositID); conn.Open(); using (var dr = cmd.ExecuteReader()) { if (!dr.HasRows) { return(null); } result = new List <DepositDetilModel>(); while (dr.Read()) { var item = new DepositDetilModel { BrgID = dr["BrgID"].ToString(), Qty = Convert.ToDecimal(dr["Qty"]), Harga = Convert.ToDecimal(dr["Harga"]), SubTotal = Convert.ToDecimal(dr["SubTotal"]) }; result.Add(item); } } } return(result); }