public void INSERTPEMBINV(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_INSERTPMBINV));
db.Commands[0].Parameters.Add(new Parameter("@NOTRANSAKSI", MySqlDbType.VarChar, obj.NOTRANSAKSI));
db.Commands[0].Parameters.Add(new Parameter("@NOTRANSFER", MySqlDbType.VarChar, obj.NOTRANSFER));
db.Commands[0].Parameters.Add(new Parameter("@TGLBAYAR", MySqlDbType.VarChar, obj.TGLBAYAR));
db.Commands[0].Parameters.Add(new Parameter("@IDINVOICE", MySqlDbType.Int32, obj.IDINVOICE));
db.Commands[0].Parameters.Add(new Parameter("@IDMETODEBAYAR", MySqlDbType.Int32, obj.IDMETODEBAYAR));
db.Commands[0].Parameters.Add(new Parameter("@IDJENISBAYAR", MySqlDbType.Int32, obj.IDJENISBAYAR));
db.Commands[0].Parameters.Add(new Parameter("@TOTALBAYAR", MySqlDbType.Float, obj.TOTALBAYAR));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_DELETE));
db.Commands[0].Parameters.Add(new Parameter("@IDPEMBAYARAN", MySqlDbType.Int32, obj.IDPEMBAYARAN));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAME));
//db.Commands[0].Parameters.Add(new Parameter("@NAMASALES", MySqlDbType.VarChar, obj.NAMA));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SELECTHISTORY_BYID(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTHISTORY_BYID));
db.Commands[0].Parameters.Add(new Parameter("@IDPEMBAYARAN", MySqlDbType.VarChar, obj.IDPEMBAYARAN));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
void LOAD_HISTORYBAYAR(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
dgvHISTORY.DataSource = null;
dgvHISTORY.Rows.Clear();
DataTable dt = bPMB.SEARCH_HISTORY(obj);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
// txtKODE.Text = dt.Rows[0]["KODEAGENT"].ToString();
string IDPEMB = dt.Rows[i]["IDPEMBAYARAN"].ToString();
string IDSTT = dt.Rows[i]["ID"].ToString();
string NOTRANSAKSI = dt.Rows[i]["NOTRANSAKSI"].ToString();
string NOTRANSFER = dt.Rows[i]["NOTRANSFER"].ToString();
string TGLBAYAR = DateTime.Parse(dt.Rows[i]["TGLBAYAR"].ToString()).ToString("dd-MM-yyyy");
string METODEBAYAR = dt.Rows[i]["METODEBAYAR"].ToString();
string BAYAR = dt.Rows[i]["TOTALBAYAR"].ToString();
dgvHISTORY.Rows.Add(IDPEMB, IDSTT, NOTRANSAKSI, NOTRANSFER, TGLBAYAR, METODEBAYAR, BAYAR);
}
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable SEARCHPEMBTAGIHAN_BYID(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
return(p.SEARCHPEMBTAGIHAN_BYID(obj));
}
public DataTable SELECTHISTORY_BYID(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
return(p.SELECTHISTORY_BYID(obj));
}
public DataTable SEARCH_HISTORYINV(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
return(p.SELECTHISTORYINv(obj));
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
p.DELETE(obj);
}
public void UPDATETAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
p.UPDATETAGIHAN(obj);
}
public void INSERTPMBINV(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
p.INSERTPEMBINV(obj);
}
public void INSERTTAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_PEMBAYARAN obj)
{
p.INSERTTAGIHAN(obj);
}
