public DataTable SEARCH_BYNAMA(RMS.COMMON.MASTER.RMS_KOTATERUSAN obj) { DataTable dt = new DataTable(); try { using (Database db = new Database()) { if (string.IsNullOrEmpty(obj.NAMAKOTA)) { db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAME)); } else { db.Commands.Add(db.CreateCommand(QUERY_SEARCH_BYNAMELIKE)); } db.Commands[0].Parameters.Add(new Parameter("@KODEKOTA", MySqlDbType.VarChar, obj.KODEAREA)); db.Commands[0].Parameters.Add(new Parameter("@NAMATERUSAN", MySqlDbType.VarChar, obj.NAMAKOTA)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void DELETE(RMS.COMMON.MASTER.RMS_KOTATERUSAN 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("@KODESALES", MySqlDbType.VarChar, obj.KODE)); dt = db.Commands[0].ExecuteDataTable(); } } catch (Exception ex) { throw new Exception(ex.Message); } }
public DataTable SEARCH_BYKODE(RMS.COMMON.MASTER.RMS_KOTATERUSAN 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("@KODEAREA", MySqlDbType.VarChar, obj.KODEAREA)); dt = db.Commands[0].ExecuteDataTable(); } return(dt); } catch (Exception ex) { throw new Exception(ex.Message); } }
public void UPDATE(RMS.COMMON.MASTER.RMS_KOTATERUSAN 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("@KODESALES", MySqlDbType.VarChar, obj.KODE)); * db.Commands[0].Parameters.Add(new Parameter("@NAMASALES", 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_KOTATERUSAN obj) { return(p.SEARCH_BYNAMA(obj)); }
public DataTable CARI_BYNAMA(RMS.COMMON.MASTER.RMS_KOTATERUSAN obj) { return(p.CARI_BYNAMA(obj)); }
public void DELETE(RMS.COMMON.MASTER.RMS_KOTATERUSAN obj) { p.DELETE(obj); }
public void UPDATE(RMS.COMMON.MASTER.RMS_KOTATERUSAN obj) { p.UPDATE(obj); }
public void INSERT(RMS.COMMON.MASTER.RMS_KOTATERUSAN obj) { p.INSERT(obj); }