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