public static void UpdatePembayaran(SqlConnection conn, int idx)
{
var Id = Utilities.GetNoFaktur(f.FakturBeliNoFakturTextBox.Text); // Parse Code here
SqlCommand com = new SqlCommand(QueryString.UpdateFakturBeli, conn);
//com.Parameters.Add("@jatuhTempo", Date).Value = jatuhTempo;
com.Parameters.Add("@id", Int).Value = Id;
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
int rowsAffected = com.ExecuteNonQuery();
if (rowsAffected != 1)
{
Console.WriteLine("Update FakturBeli failed");
// throw Exception ?
return;
}
List <FakturBeli> list = f.FakturBeliOLV.Objects.Cast <FakturBeli>().ToList();
FakturBeli fb = list[idx];
fb.Id = fb.Id = "R" + Id;
f.FakturBeliOLV.RefreshObject(fb);
}
catch (Exception e)
{
Console.WriteLine("Error :" + e.Message);
}
}
public static void UpdateFakturBeli(SqlConnection conn, int idx)
{
var Id = Utilities.GetNoFaktur(f.FakturBeliNoFakturTextBox.Text); // Parse Code here
var jatuhTempo = Utilities.GetDateNow();
var ppn = f.FakturBeliPPNCheckBox.Checked ? 1 : 0;
var cashCredit = f.FakturBeliCashKreditComboBox.SelectedIndex;
var beliReturn = f.FakturBeliBeliReturnComboBox.SelectedIndex;
var sid = Utilities.GetSupplierCode(f.FakturBeliKodeSuppTextBox.Text);
var discount = 0; // ?
var nomorPajak = f.FakturBeliNoPajakTextBox.Text;
var datePajak = Utilities.ChangeDateFormatToyyyyMMdd(f.FakturBeliTanggalPajakDatePicker.Value.ToString());
var extra = "";
SqlCommand com = new SqlCommand(QueryString.UpdateFakturBeli, conn);
//com.Parameters.Add("@jatuhTempo", Date).Value = jatuhTempo;
com.Parameters.Add("@ppn", Bit).Value = ppn;
com.Parameters.Add("@cashCredit", Bit).Value = cashCredit;
com.Parameters.Add("@beliReturn", Bit).Value = beliReturn;
com.Parameters.Add("@sid", Int).Value = sid;
com.Parameters.Add("@discount", Int).Value = discount;
com.Parameters.Add("@nomorPajak", VarChar).Value = nomorPajak;
com.Parameters.Add("@datePajak", Date).Value = datePajak;
com.Parameters.Add("@extra", VarChar).Value = extra;
com.Parameters.Add("@id", Int).Value = Id;
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
int rowsAffected = com.ExecuteNonQuery();
if (rowsAffected != 1)
{
Console.WriteLine("Update FakturBeli failed");
// throw Exception ?
return;
}
List <FakturBeli> list = f.FakturBeliOLV.Objects.Cast <FakturBeli>().ToList();
FakturBeli fb = list[idx];
fb.Id = fb.Id = beliReturn == 1 ? "R" + Id : "B" + Id;
fb.CashCredit = cashCredit == 1;
fb.BeliReturn = beliReturn == 1;
fb.DatePajak = datePajak;
fb.Discount = discount;
fb.Extra = extra;
//fb.JatuhTempo = jatuhTempo;
fb.NomorPajak = nomorPajak;
fb.Ppn = ppn == 1;
fb.SupplierId = sid;
f.FakturBeliOLV.RefreshObject(fb);
}
catch (Exception e)
{
Console.WriteLine("Error :" + e.Message);
}
}
