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