public void UPDATE(RMS.COMMON.MASTER.RMS_TARIF 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("@ID", MySqlDbType.VarChar, obj.ID));
db.Commands[0].Parameters.Add(new Parameter("@IDKOTAASAL", MySqlDbType.Int32, obj.IDKOTAASAL));
db.Commands[0].Parameters.Add(new Parameter("@IDKOTATUJUAN", MySqlDbType.Int32, obj.IDKOTATUJUAN));
db.Commands[0].Parameters.Add(new Parameter("@TARIF", MySqlDbType.Float, obj.TARIF));
db.Commands[0].Parameters.Add(new Parameter("@TARIFBERIKUT", MySqlDbType.Float, obj.TARIFBERIKUT));
db.Commands[0].Parameters.Add(new Parameter("@ETD", MySqlDbType.VarChar, obj.ETD));
db.Commands[0].Parameters.Add(new Parameter("@IDJENISKIRIMAN", MySqlDbType.Int32, obj.IDJENISKIRIMAN));
db.Commands[0].Parameters.Add(new Parameter("@IDPRODUK", MySqlDbType.Int32, obj.IDPRODUK));
db.Commands[0].Parameters.Add(new Parameter("@KETERANGAN", MySqlDbType.VarChar, obj.KETERANGAN));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public void DELETE(RMS.COMMON.MASTER.RMS_TARIF 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("@ID", MySqlDbType.Int32, obj.ID));
dt = db.Commands[0].ExecuteDataTable();
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable CARI_BYID(RMS.COMMON.MASTER.RMS_TARIF obj)
{
DataTable dt = new DataTable();
try
{
using (Database db = new Database())
{
db.Commands.Add(db.CreateCommand(QUERY_CARI_BYID));
db.Commands[0].Parameters.Add(new Parameter("@ID", MySqlDbType.VarChar, obj.ID));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_TARIF 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("@KOTAASAL", MySqlDbType.VarChar, obj.KOTAASAL));
db.Commands[0].Parameters.Add(new Parameter("@KOTATUJUAN", MySqlDbType.VarChar, obj.KOTATUJUAN));
dt = db.Commands[0].ExecuteDataTable();
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_TARIF 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("@KODECUSTOMER", MySqlDbType.VarChar, obj.KODE));
* dt = db.Commands[0].ExecuteDataTable();
*/
}
return(dt);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_TARIF obj)
{
return(p.SEARCH_BYNAMA(obj));
}
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_TARIF obj)
{
return(p.CARI_BYNAMA(obj));
}
public DataTable SEARCHLIKE(RMS.COMMON.MASTER.RMS_TARIF obj)
{
return(p.SEARCHLIKE(obj));
}
public void DELETE(RMS.COMMON.MASTER.RMS_TARIF obj)
{
p.DELETE(obj);
}
public void UPDATE(RMS.COMMON.MASTER.RMS_TARIF obj)
{
p.UPDATE(obj);
}
public void INSERT(RMS.COMMON.MASTER.RMS_TARIF obj)
{
p.INSERT(obj);
}