public static List <ItemModel> GetBookByType(string token, string type, string value) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT * FROM library_item " + "WHERE Category = 'book' " + $"AND {type} "); if (type.Equals("Id")) { sql.Append($" = {value} "); } else { sql.Append($" LIKE '%{value}%' "); } switch (UserProcessor.GetUserType(token)) { case -1: return(null); case 2: sql.Append("AND Access = 'public' "); break; } return(SqlDataAccess.LoadData <ItemModel>(sql.ToString())); }
public static IEnumerable <ItemModel> GetAllBooks(string token) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT * FROM library_item " + "WHERE Category = 'book' "); switch (UserProcessor.GetUserType(token)) { case -1: return(null); case 2: sql.Append("AND Access = 'public' "); break; } return(SqlDataAccess.LoadData <ItemModel>(sql.ToString())); }
public static List <ItemModel> GetBookById(string token, int id) { StringBuilder sql = new StringBuilder(); sql.Append("SELECT * FROM library_item " + "WHERE Category = 'book' " + $"AND Id = {id} "); switch (UserProcessor.GetUserType(token)) { case -1: return(null); case 2: sql.Append("AND Access = 'public' "); break; } return(SqlDataAccess.LoadData <ItemModel>(sql.ToString())); }