public bool SqlUpdateQuery(string connectionString, Dictionary <string, string> updateList, string sqlUpdateQuery)
 {
     this.dbHandler = new DBHandler();
     return(dbHandler.SqlUpdateQuery(connectionString, sqlUpdateQuery, updateList));
 }
 public bool SqlInsertQuery(string connectionString, Dictionary <string, string> insertList, string sqlInsertQuery)
 {
     this.dbHandler = new DBHandler();
     return(dbHandler.SqlInsertQuery(connectionString, insertList, sqlInsertQuery));
 }
 public DataTable SqlFilterByIdQuery(string connectionString, string filterQuery, int id)
 {
     this.dbHandler = new DBHandler();
     return(dbHandler.SqlFilterByIdQuery(connectionString, filterQuery, id));
 }
 public DataTable SqlSelectFilterQuery(string connectionString, Dictionary <string, string> filterCondition, string sqlSelectFilterQuery)
 {
     this.dbHandler = new DBHandler();
     return(dbHandler.SqlSelectFilterQuery(connectionString, filterCondition, sqlSelectFilterQuery));
 }
 public DataTable SqlSelectQuery(string connectionString, string selectQuery)
 {
     this.dbHandler = new DBHandler();
     return(dbHandler.SqlSelectQuery(connectionString, selectQuery));
 }