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