public static GetPost Detail(int id)
{
string sql = @"SELECT * FROM [dbo].[Articles] WHERE Id = @p1";
DataSet ds = DB.Query(sql, id);
return(DB.GetPostDS(ds));
}
public static GetPost Detail(int id)
{
string sql = @"SELECT Articles.ID, Title, Content, Category, Articles.ByUser, Name, Articles.OnDate, Firstname, Lastname, Photo
FROM [dbo].[Articles]
INNER JOIN Users ON Users.Id = Articles.ByUser
INNER JOIN Categories ON Categories.Id = Articles.Category
WHERE Articles.Id = @p1";
DataSet ds = DB.Query(sql, id);
return(DB.GetPostDS(ds));
}
