public dynamic GetAll() { using (var cnn = SimpleDbConnection()) { cnn.Open(); return(cnn.Query(TicketsScripts.getAll())); } }
public dynamic GetByCondition(string Query) { using (var cnn = SimpleDbConnection()) { cnn.Open(); var Parameters = new DynamicParameters(); Parameters.Add("@Query", Query, DbType.String, ParameterDirection.Input); return(cnn.Query(TicketsScripts.getByCondition(Query))); } }