public FormKENDARAAN(MASTER.FormKENDARAAN _frm, int _Type, RMS.COMMON.MASTER.RMS_KENDARAAN obj) { InitializeComponent(); this.frm = _frm; Type = _Type; loadCOMBO(); if (Type == 1) { LOAD_DATA(obj); } }
public void GET_DATA_KENDARAAN(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { //c.ID = obj.ID; c.IDKENDARAAN = obj.ID; c.IDDRIVER = obj.IDDRIVER; c.IDCODRIVER = obj.IDHELPER; txtNOPOL.Text = obj.NOPOL; txtJENISKENDARAAN.Text = obj.JENISKENDARAAN; txtMAXMUATAN.Text = obj.MAXMUATAN.ToString(); txtMAXVOLUME.Text = obj.MAXVOLUME.ToString(); txtSTATUS.Text = obj.STATUSKENDARAAN.ToString(); txtKODEDRIVER.Text = obj.KODEDRIVER; txtKODEHELPER.Text = obj.KODEHELPER; txtNAMADRIVER.Text = obj.NAMADRIVER; txtNAMAHELPER.Text = obj.NAMAHELPER; }
public void DELETE(RMS.COMMON.MASTER.RMS_KENDARAAN 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("@KODE", MySqlDbType.VarChar, obj.NOPOL)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_KENDARAAN 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("@NAMACUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void INSERT(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { try { using (Database db = new Database()) { DataTable dt = new DataTable(); db.Commands.Add(db.CreateCommand(QUERY_INSERT)); db.Commands[0].Parameters.Add(new Parameter("@NOPOL", MySqlDbType.VarChar, obj.NOPOL)); db.Commands[0].Parameters.Add(new Parameter("@IDJENISKENDARAAN", MySqlDbType.VarChar, obj.IDJENISKENDARAAN)); db.Commands[0].Parameters.Add(new Parameter("@MAXMUATAN", MySqlDbType.VarChar, obj.MAXMUATAN)); db.Commands[0].Parameters.Add(new Parameter("@MAXVOLUME", MySqlDbType.VarChar, obj.MAXVOLUME)); db.Commands[0].Parameters.Add(new Parameter("@STATUS", MySqlDbType.Int32, obj.STATUS)); // mungkin ini bisi jadi exception if (obj.IDDRIVER == 0) { db.Commands[0].Parameters.Add(new Parameter("@IDDRIVER", MySqlDbType.VarChar, null)); } else { db.Commands[0].Parameters.Add(new Parameter("@IDDRIVER", MySqlDbType.Int32, obj.IDDRIVER)); } if (obj.IDHELPER == 0) { db.Commands[0].Parameters.Add(new Parameter("@IDHELPER", MySqlDbType.VarChar, null)); } else { db.Commands[0].Parameters.Add(new Parameter("@IDHELPER", MySqlDbType.Int32, obj.IDHELPER)); } dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYKODE)); db.Commands[0].Parameters.Add(new Parameter("@ID", MySqlDbType.Int32, obj.ID)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
void LOAD_DATA(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { c.ID = obj.ID; txtNOPOL.Enabled = false; DataTable dt = b.SEARCH_BYKODE(obj); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { string test = dt.Rows[i]["JENISKENDARAAN"].ToString(); cboJENISKENDARAAN.Text = dt.Rows[i]["JENISKENDARAAN"].ToString(); txtNOPOL.Text = dt.Rows[i]["NOPOL"].ToString(); txtMAXMUATAN.Text = dt.Rows[i]["MAXMUATAN"].ToString(); txtMAXVOLUME.Text = dt.Rows[i]["MAXVOLUME"].ToString(); if (!string.IsNullOrEmpty(dt.Rows[i]["IDDRIVER"].ToString())) { c.IDDRIVER = Convert.ToInt32(dt.Rows[i]["IDDRIVER"].ToString()); } if (!string.IsNullOrEmpty(dt.Rows[i]["IDHELPER"].ToString())) { c.IDHELPER = Convert.ToInt32(dt.Rows[i]["IDHELPER"].ToString()); } txtKODEDRIVER.Text = dt.Rows[i]["KODEDRIVER"].ToString(); txtKODEHELPER.Text = dt.Rows[i]["KODEHELPER"].ToString(); txtNAMADRIVER.Text = dt.Rows[i]["NAMADRIVER"].ToString(); txtNAMAHELPER.Text = dt.Rows[i]["NAMAHELPER"].ToString(); if (Convert.ToBoolean(dt.Rows[0]["STATUS"].ToString()) == true) { chkTERSEDIA.Checked = true; } else { chkTIDAKTERSEDIA.Checked = true; } } } }
public DataTable SEARCHLIKE(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { db.Commands.Add(db.CreateCommand(QUERY_SEARCHLIKE)); db.Commands[0].Parameters.Add(new Parameter("@NOPOL", MySqlDbType.VarChar, obj.NOPOL)); db.Commands[0].Parameters.Add(new Parameter("@NAMADRIVER", MySqlDbType.VarChar, obj.NAMADRIVER)); db.Commands[0].Parameters.Add(new Parameter("@NAMAHELPER", MySqlDbType.VarChar, obj.NAMAHELPER)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { return(p.SEARCH_BYNAMA(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { return(p.CARI_BYNAMA(obj)); }
public void DELETE(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { p.DELETE(obj); }
public void UPDATE(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { p.UPDATE(obj); }
public void INSERT(RMS.COMMON.MASTER.RMS_KENDARAAN obj) { p.INSERT(obj); }