public FormMARKETING(MASTER.FormMARKETING _frm, int Type, RMS.COMMON.MASTER.RMS_MARKETING obj)
{
InitializeComponent();
this.frm = _frm;
this.Type = Type;
txtKODE.Text = GETKODE();
if (Type == 1)
{
LOAD_DATA(obj);
}
}
void LOAD_DATA(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
txtKODE.Enabled = false;
DataTable dt = b.CARI_BYKODE(obj);
if (dt.Rows.Count > 0)
{
txtKODE.Text = dt.Rows[0]["KODE"].ToString();
txtNAMA.Text = dt.Rows[0]["NAMA"].ToString();
txtALAMAT.Text = dt.Rows[0]["ALAMAT"].ToString();
txtTLP.Text = dt.Rows[0]["TELEPON"].ToString();
txtEMAIL.Text = dt.Rows[0]["EMAIL"].ToString();
}
}
public void DELETE(RMS.COMMON.MASTER.RMS_MARKETING 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.KODE));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_MARKETING 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("@NAMA", MySqlDbType.VarChar, obj.NAMA));
dt = db.Commands[0].ExecuteDataTable();
}
return dt;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void UPDATE(RMS.COMMON.MASTER.RMS_MARKETING 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("@KODE", MySqlDbType.VarChar, obj.KODE));
db.Commands[0].Parameters.Add(new Parameter("@NAMA", MySqlDbType.VarChar, obj.NAMA));
db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT));
db.Commands[0].Parameters.Add(new Parameter("@TELEPON", MySqlDbType.VarChar, obj.TELP));
db.Commands[0].Parameters.Add(new Parameter("@EMAIL", MySqlDbType.VarChar, obj.EMAIL));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
return(p.CARI_BYNAMA(obj));
}
public void DELETE(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
p.UPDATE(obj);
}
public void INSERT(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
p.INSERT(obj);
}
public void GET_DATA_MARKETING(RMS.COMMON.MASTER.RMS_MARKETING obj)
{
txtIDMARKETING.Text = obj.ID.ToString();
txtKODEMARKETING.Text = obj.KODE;
txtNAMAMARKETING.Text = obj.NAMA;
}