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