public void INSERT(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN 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("@KODE", MySqlDbType.VarChar, obj.KODE));
db.Commands[0].Parameters.Add(new Parameter("@NAMA", MySqlDbType.VarChar, obj.NAMA));
db.Commands[0].Parameters.Add(new Parameter("@FILE", MySqlDbType.LongBlob, obj.FILE));
db.Commands[0].Parameters.Add(new Parameter("@SIZE", MySqlDbType.Int32, obj.SIZE));
db.Commands[0].Parameters.Add(new Parameter("@IMAGE", MySqlDbType.VarChar, obj.IMAGE));
db.Commands[0].Parameters.Add(new Parameter("@NPWP", MySqlDbType.VarChar, obj.NPWP));
db.Commands[0].Parameters.Add(new Parameter("@ALAMAT", MySqlDbType.VarChar, obj.ALAMAT));
db.Commands[0].Parameters.Add(new Parameter("@TELP", MySqlDbType.VarChar, obj.TELP));
db.Commands[0].Parameters.Add(new Parameter("@FAX", MySqlDbType.VarChar, obj.FAX));
db.Commands[0].Parameters.Add(new Parameter("@CABANGBANK1", MySqlDbType.VarChar, obj.CABANGBANK1));
db.Commands[0].Parameters.Add(new Parameter("@CABANGBANK2", MySqlDbType.VarChar, obj.CABANGBANK2));
db.Commands[0].Parameters.Add(new Parameter("@NOREK1", MySqlDbType.VarChar, obj.NOREK1));
db.Commands[0].Parameters.Add(new Parameter("@NOREK2", MySqlDbType.VarChar, obj.NOREK2));
db.Commands[0].Parameters.Add(new Parameter("@ATASNAMA1", MySqlDbType.VarChar, obj.ATASNAMA1));
db.Commands[0].Parameters.Add(new Parameter("@ATASNAMA2", MySqlDbType.VarChar, obj.ATASNAMA2));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DELETE(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN 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 SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
//db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAME));
//db.Commands[0].Parameters.Add(new Parameter("@NAMASATUAN", MySqlDbType.VarChar, obj.NAMA));
// dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYKODE(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
return(p.CARI_BYKODE(obj));
}
public void DELETE(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
p.UPDATE(obj);
}
public void INSERT(RMS.COMMON.MASTER.RMS_TENTANGPERUSAHAAN obj)
{
p.INSERT(obj);
}
