public void UPDATE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_UPDATE)); db.Commands[0].Parameters.Add(new Parameter("@KODEAGENT", MySqlDbType.VarChar, obj.KODE)); db.Commands[0].Parameters.Add(new Parameter("@HANDLING_ID", MySqlDbType.Int32, obj.HANDLING_ID)); db.Commands[0].Parameters.Add(new Parameter("@NAMAAGENT", MySqlDbType.VarChar, obj.NAMA)); db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT)); db.Commands[0].Parameters.Add(new Parameter("@CP", MySqlDbType.VarChar, obj.CP)); db.Commands[0].Parameters.Add(new Parameter("@TELEPON", MySqlDbType.VarChar, obj.TELEPON)); db.Commands[0].Parameters.Add(new Parameter("@NPWP", MySqlDbType.VarChar, obj.NPWP)); db.Commands[0].Parameters.Add(new Parameter("@BANK", MySqlDbType.VarChar, obj.BANK)); db.Commands[0].Parameters.Add(new Parameter("@ACCOUNTNUMBER", MySqlDbType.VarChar, obj.ACCOUNT)); db.Commands[0].Parameters.Add(new Parameter("@ATASNAMA", MySqlDbType.VarChar, obj.ATASNAMA)); db.Commands[0].Parameters.Add(new Parameter("@IS_AF", MySqlDbType.Bit, obj.IS_AF)); db.Commands[0].Parameters.Add(new Parameter("@IS_TRUCK", MySqlDbType.Bit, obj.IS_TRUCK)); db.Commands[0].Parameters.Add(new Parameter("@IS_WH", MySqlDbType.Bit, obj.IS_WH)); db.Commands[0].Parameters.Add(new Parameter("@IS_GRDH", MySqlDbType.Bit, obj.IS_GRDH)); db.Commands[0].Parameters.Add(new Parameter("@IS_SHIPPING", MySqlDbType.Bit, obj.IS_SHIPPING)); db.Commands[0].Parameters.Add(new Parameter("@IS_DELIVERY", MySqlDbType.Bit, obj.IS_DELIVERY)); db.Commands[0].Parameters.Add(new Parameter("@IS_RA", MySqlDbType.Bit, obj.IS_RA)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public FormVIEWAGENT(FINANCE.FormTAGIHAN _frm, RMS.COMMON.MASTER.RMS_SUPPLIER obj, int _type) { InitializeComponent(); type = _type; if (type == 1) { this.frm = _frm; c = obj; } LOAD_DATA(); this.txtCARI.Focus(); }
public FormSUPPLIER(MASTER.FormSUPPLIER _frm, int Type, RMS.COMMON.MASTER.RMS_SUPPLIER obj) { InitializeComponent(); this.frm = _frm; this.Type = Type; cboHANDLING.Text = "DELIVERY"; txtKODE.Text = GETKODE(); if (Type == 1) { LOAD_DATA(obj); } }
public FormVIEWAGENT(FINANCE.FormTAGIHAN _frm, RMS.COMMON.MASTER.RMS_SUPPLIER obj, int _type) { InitializeComponent(); type = _type; if (type == 1) { this.frm = _frm; c = obj; } LOAD_DATA(); this.txtCARI.Focus(); }
public void GET_DATA_SUPPLIER(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { txtKODESUPLIER.Text = obj.KODE; txtNAMASUPLIER.Text = obj.NAMA; /* * if (obj.TEMPO != 0) * { * txtTEMPO.Text = obj.TEMPO.ToString(); * txtJATUHTEMPO.Text = DateTime.Now.AddDays(obj.TEMPO).ToString("dd-MM-yyyy"); * } */ }
public void DELETE(RMS.COMMON.MASTER.RMS_SUPPLIER 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("@KODEAGENT", MySqlDbType.VarChar, obj.KODE)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SELECTUDARA(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SELECTUDARA)); db.Commands[0].Parameters.Add(new Parameter("@HANDLING", MySqlDbType.VarChar, obj.HANDLING)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_CARI_BYNAME)); db.Commands[0].Parameters.Add(new Parameter("@NAMAAGENT", MySqlDbType.VarChar, obj.NAMA)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void INSERT(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { p.INSERT(obj); }
public DataTable SEARCH_BYNAMAPRICELIST(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { return(p.SEARCH_BYNAMAPRICELIST(obj)); }
public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { return(p.SEARCH_BYKODE(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { return(p.CARI_BYNAMA(obj)); }
public DataTable CARI_BYKODE_UPDATE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { return(p.CARI_BYKODE_UPDATE(obj)); }
public DataTable SELECTUDARALIKE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { return(p.SELECTUDARALIKE(obj)); }
public void DELETE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { p.DELETE(obj); }
public void UPDATE(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { p.UPDATE(obj); }
void LOAD_DATA(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { txtKODE.Enabled = false; DataTable dt = b.CARI_BYKODE_UPDATE(obj); if (dt.Rows.Count > 0) { txtKODE.Text = dt.Rows[0]["KODEAGENT"].ToString(); if (dt.Rows[0]["HANDLING_ID"].ToString() == "1") { cboHANDLING.Text = "SHIPPING"; } else if (dt.Rows[0]["HANDLING_ID"].ToString() == "2") { cboHANDLING.Text = "DELIVERY"; } else if (dt.Rows[0]["HANDLING_ID"].ToString() == "3") { cboHANDLING.Text = "WAREHOUSE"; } else if (dt.Rows[0]["HANDLING_ID"].ToString() == "4") { cboHANDLING.Text = "REGULATED AGENT"; } else if (dt.Rows[0]["HANDLING_ID"].ToString() == "5") { cboHANDLING.Text = "SMU"; } else if (dt.Rows[0]["HANDLING_ID"].ToString() == "6") { cboHANDLING.Text = "GRDH"; } else { cboHANDLING.Text = "TRUCKING"; } txtNAMA.Text = dt.Rows[0]["NAMAAGENT"].ToString(); txtALAMAT.Text = dt.Rows[0]["ALAMAT"].ToString(); txtCP.Text = dt.Rows[0]["CP"].ToString(); txtTELP.Text = dt.Rows[0]["TELEPON"].ToString(); txtNPWP.Text = dt.Rows[0]["NPWP"].ToString(); txtBANK.Text = dt.Rows[0]["BANK"].ToString(); txtACCOUNT.Text = dt.Rows[0]["ACCOUNTNUMBER"].ToString(); txtAN.Text = dt.Rows[0]["ATASNAMA"].ToString(); string test = dt.Rows[0]["IS_AF"].ToString(); if (dt.Rows[0]["IS_AF"].ToString() == "True") { chkAF.Checked = true; } if (dt.Rows[0]["IS_TRUCK"].ToString() == "True") { chkTrucking.Checked = true; } if (dt.Rows[0]["IS_WH"].ToString() == "True") { chkWH.Checked = true; } if (dt.Rows[0]["IS_GRDH"].ToString() == "True") { chkGRDH.Checked = true; } if (dt.Rows[0]["IS_SHIPPING"].ToString() == "True") { chkSHIPPING.Checked = true; } if (dt.Rows[0]["IS_REGULATEDAGENT"].ToString() == "True") { chkRA.Checked = true; } if (dt.Rows[0]["IS_DELIVERY"].ToString() == "True") { chkDELIVERY.Checked = true; } } }
public void GET_DATA_AGENT(RMS.COMMON.MASTER.RMS_SUPPLIER obj) { c.IDAGENT = obj.IDAGENT; txtKODE.Text = obj.KODE; txtNAMA.Text = obj.NAMA; }