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