public void UPDATETAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
try
{
using (Database db = new Database())
{
DataTable dt = new DataTable();
db.Commands.Add(db.CreateCommand(QUERY_UPDATETAGIHAN));
db.Commands[0].Parameters.Add(new Parameter("@ID", MySqlDbType.Int32, obj.ID));
db.Commands[0].Parameters.Add(new Parameter("@IDAGENT", MySqlDbType.Int32, obj.IDAGENT));
db.Commands[0].Parameters.Add(new Parameter("@TGLDATANGINV", MySqlDbType.VarChar, obj.TGLDATANGINV));
db.Commands[0].Parameters.Add(new Parameter("@TGLINV", MySqlDbType.VarChar, obj.TGLINV));
db.Commands[0].Parameters.Add(new Parameter("@NOINV", MySqlDbType.VarChar, obj.NOINV));
db.Commands[0].Parameters.Add(new Parameter("@JUMLAHTAGIHAN", MySqlDbType.Float, obj.JUMLAHTAGIHAN));
db.Commands[0].Parameters.Add(new Parameter("@KETERANGAN", MySqlDbType.VarChar, obj.KETERANGAN));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void INSERTPEMBINV(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN 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 FormTAGIHAN(FINANCE.FormDAFTARPEMBAYARANHUTANG _frm, int _Type, RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = _Type;
//txtKODE.Text = GETKODE();
//txtKODE.ReadOnly = true;
if (Type == 1)
{
LOAD_DATA(obj);
}
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN 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 CARI_BYKODE(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_CARI_BYKODE));
db.Commands[0].Parameters.Add(new Parameter("@NOINVOICE", MySqlDbType.VarChar, obj.NOINV));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN 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 SELECTHISTORYTAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECTHISTORYTAGIHAN));
db.Commands[0].Parameters.Add(new Parameter("@IDTAGIHAN", MySqlDbType.VarChar, obj.ID));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
void LOAD_DATA(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
DataTable dt = b.SELECTTAGIHAN(obj);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
txtAGENT.Text = dt.Rows[0]["NAMAAGENT"].ToString();
txtHANDLING.Text = dt.Rows[0]["HANDLING"].ToString();
txtTAGIHAN.Text = dt.Rows[0]["JUMLAHTAGIHAN"].ToString();
txtTGLDATANGINVOICE.Text = DateTime.Parse(dt.Rows[0]["TGLDATANGINV"].ToString()).ToString("dd-MM-yyyy");
txtTGLINVOICE.Text = DateTime.Parse(dt.Rows[0]["TGLINV"].ToString()).ToString("dd-MM-yyyy");
txtINVOICE.Text = dt.Rows[0]["NOINV"].ToString();
txtTOTALTAGIHAN.Text = dt.Rows[0]["JUMLAHTAGIHAN"].ToString();
txtTOTALPEMBAYARAN.Text = dt.Rows[0]["TOTALBAYAR"].ToString();
txtSISA.Text = dt.Rows[0]["SISA"].ToString();
lblSTATUSTAGIHAN.Text = dt.Rows[0]["STATUS"].ToString();
}
}
}
void LOAD_DATA(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
txtKODE.Enabled = false;
txtNAMA.Enabled = false;
DataTable dt = b.SELECTTAGIHAN(obj);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
c.ID = obj.ID;
c.IDAGENT = int.Parse(dt.Rows[i]["IDAGENT"].ToString());
txtKODE.Text = dt.Rows[i]["KODEAGENT"].ToString();
txtNAMA.Text = dt.Rows[i]["NAMAAGENT"].ToString();
string tgldatanginv = dt.Rows[i]["TGLDATANGINV"].ToString();
string tglinv = dt.Rows[i]["TGLINV"].ToString();
dtTGLDATANGINVOICE.Value = DateTime.Parse(tgldatanginv);
dtTGLINVOICE.Value = DateTime.Parse(tglinv);
txtNOINVOICE.Text = dt.Rows[i]["NOINV"].ToString();
txtJMLTAGIHAN.Text = dt.Rows[i]["JUMLAHTAGIHAN"].ToString();
txtKETERANGAN.Text = dt.Rows[i]["KETERANGAN"].ToString();
}
}
}
void LOAD_HISTORYBAYAR(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
dgvHISTORY.DataSource = null;
dgvHISTORY.Rows.Clear();
DataTable dt = bPMB.SEARCH_HISTORYTAGIHAN(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 IDTAGIHAN = dt.Rows[i]["IDTAGIHAN"].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, IDTAGIHAN, NOTRANSAKSI, NOTRANSFER, TGLBAYAR, METODEBAYAR, BAYAR);
}
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYKODE(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.CARI_BYKODE(obj));
}
public DataTable SELECTHISTORY_BYID(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.SELECTHISTORY_BYID(obj));
}
public DataTable SEARCHPEMBINV_BYID(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.SEARCHPEMBINV_BYID(obj));
}
public DataTable SEARCH_HISTORYINV(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.SELECTHISTORYINv(obj));
}
public void DELETE(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
p.DELETE(obj);
}
public void UPDATETAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
p.UPDATETAGIHAN(obj);
}
public void INSERTPMBINV(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
p.INSERTPEMBINV(obj);
}
public DataTable SELECTTAGIHAN(RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
return(p.SELECTTAGIHAN(obj));
}
public FormPEMBAYARANTAGIHAN(FINANCE.FormDAFTARPEMBAYARANHUTANG _frm, int Type, RMS.COMMON.DELIVERYORDER.RMS_TAGIHAN obj)
{
InitializeComponent();
this.type = Type;
type = 0;
c.ID = obj.ID;
cPMB.IDTAGIHAN = obj.ID;
//cDETAIL.KODEIVOICE = obj.KODEINVOICE;
cboMETODEBAYAR.Text = "CASH";
cboJENISBAYAR.Text = "PELUNASAN";
pnlNOTRANSFER.Visible = false;
if (type == 0)
{
LOAD_DATA(obj);
LOAD_HISTORYBAYAR(c);
}
}
