void LOAD_DATA(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
txtKODE.Enabled = false;
DataTable dt = b.SEARCH_BYKODE(obj);
int TypeCustomer;
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
txtKODE.Text = dt.Rows[i]["KODECUSTOMER"].ToString();
txtNAMACUSTOMER.Text = dt.Rows[i]["NAMACUSTOMER"].ToString();
txtALAMAT.Text = dt.Rows[i]["ALAMAT"].ToString();
txtTELP.Text = dt.Rows[i]["TELEPON"].ToString();
txtHP.Text = dt.Rows[i]["HP"].ToString();
txtEMAIL.Text = dt.Rows[i]["EMAIL"].ToString();
txtKODEMARKETING.Text = dt.Rows[i]["KODEMARKETING"].ToString();
txtNAMAMARKETING.Text = dt.Rows[i]["MARKETING"].ToString();
TypeCustomer = Convert.ToInt32(dt.Rows[i]["TYPE"].ToString());
if (TypeCustomer == 1)
{
cboTYPE.Text = "RETAIL";
}
else
{
cboTYPE.Text = "CORPORATE";
txtIDMARKETING.Text = dt.Rows[i]["IDMARKETING"].ToString();
}
}
}
}
public void UPDATE(RMS.COMMON.MASTER.RMS_CUSTOMER 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("@KODECUSTOMER", MySqlDbType.VarChar, obj.KODE));
db.Commands[0].Parameters.Add(new Parameter("@NAMACUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER));
db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT));
db.Commands[0].Parameters.Add(new Parameter("@TELEPON", MySqlDbType.VarChar, obj.TELEPON));
db.Commands[0].Parameters.Add(new Parameter("@HP", MySqlDbType.VarChar, obj.HP));
db.Commands[0].Parameters.Add(new Parameter("@EMAIL", MySqlDbType.VarChar, obj.EMAIL));
if (obj.IDMARKETING != 0)
{
db.Commands[0].Parameters.Add(new Parameter("@IDMARKETING", MySqlDbType.Int32, obj.IDMARKETING));
}
else
{
db.Commands[0].Parameters.Add(new Parameter("@IDMARKETING", MySqlDbType.Int32, null));
}
db.Commands[0].Parameters.Add(new Parameter("@TYPE", MySqlDbType.Int32, obj.TYPE));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void GET_DATA_CUSTOMER(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
c.IDCUSTOMER = obj.ID;
txtKODECUSTOMER.Text = obj.KODE;
txtNAMACUSTOMER.Text = obj.NAMACUSTOMER;
txtALAMATPENGIRIM.Text = obj.ALAMAT;
txtPHONEPENGIRIM.Text = obj.TELEPON;
txtHPPENGIRIM.Text = obj.HP;
}
public FormCUSTOMER(MASTER.FormCUSTOMER _frm, int _Type, RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = _Type;
txtKODE.Text = GETKODE();
txtKODE.ReadOnly = true;
cboTYPE.Text = "RETAIL";
if (Type == 1)
{
LOAD_DATA(obj);
}
}
public void DELETE(RMS.COMMON.MASTER.RMS_CUSTOMER 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("@KODECUSTOMER", MySqlDbType.VarChar, obj.KODE));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void GET_DATA_CUSTOMER(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
// STRING DATE TIDAK BOLEH KOSONG
int _nourut;
startDATE = dtINVOICEDATE.Value.ToString("yyyy-MM-dd");
endDATE = dtEND.Value.ToString("yyyy-MM-dd");
txtKODECUSTOMER.Text = obj.KODE;
txtNAMACUSTOMER.Text = obj.NAMACUSTOMER;
DataTable dt = b.SELECTNOINVOICE(startDATE, endDATE, txtKODECUSTOMER.Text.Trim());
_nourut = int.Parse(dt.Rows[0][0].ToString());
txtKODEINVOICE.Text = getNewInvoice(_nourut, txtKODECUSTOMER.Text);
lblMESSAGE.Text = txtKODEINVOICE.Text;
lblMESSAGE.BackColor = Color.Blue;
lblDETAILMSG.Text = "SILAHKAN TEKAN CARI UNTUK MENAMBAHKAN PACKING LIST PENGIRIMAN BARANG";
lblDETAILMSG.BackColor = Color.Red;
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_CUSTOMER 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 DataTable SELECT(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_SELECT));
db.Commands[0].Parameters.Add(new Parameter("@TYPE", MySqlDbType.Int32, obj.TYPE));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCHLIKE(RMS.COMMON.MASTER.RMS_CUSTOMER 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("@KODECUSTOMER", MySqlDbType.VarChar, obj.KODE));
db.Commands[0].Parameters.Add(new Parameter("@NAMACUSTOMER", MySqlDbType.VarChar, obj.NAMACUSTOMER));
db.Commands[0].Parameters.Add(new Parameter("@MARKETING", MySqlDbType.VarChar, obj.MARKETING));
db.Commands[0].Parameters.Add(new Parameter("@TYPE", MySqlDbType.Int32, obj.TYPE));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
return(p.CARI_BYNAMA(obj));
}
public DataTable SEARCHLIKE(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
return(p.SEARCHLIKE(obj));
}
public DataTable SELECT(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
return(p.SELECT(obj));
}
public void DELETE(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
p.UPDATE(obj);
}
public void INSERT(RMS.COMMON.MASTER.RMS_CUSTOMER obj)
{
p.INSERT(obj);
}
