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