public List <VD_POST> getListPostByMenu(string MainID, string SubID) { List <VD_POST> lst = new List <VD_POST>(); _DBAccess = new DBController(); DataSet ds = new DataSet(); ds = _DBAccess.getListPostByMenu("WEB_VD_GETLIST_POST_BY_MENU", MainID, SubID); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { foreach (DataRow row in ds.Tables[0].Rows) { lst.Add(new VD_POST { ID = Convert.ToInt64(row["ID"]), CategoryID = Convert.ToString(row["CategoryID"]), CategoryName = Convert.ToString(row["CategoryName"]), MetaTitleCategory = Convert.ToString(row["MetaTitleCategory"]), MainMenuID = Convert.ToString(row["MainMenuID"]), MainMenuName = Convert.ToString(row["MainMenuName"]), MetaTitleMainMenu = Convert.ToString(row["MetaTitleMainMenu"]), SubMenuID = Convert.ToString(row["SubMenuID"]), SubMenuName = Convert.ToString(row["SubMenuName"]), MetaTitleSubMenu = Convert.ToString(row["MetaTitleSubMenu"]), TitlePost = Convert.ToString(row["TitlePost"]), ContentPost = Convert.ToString(row["ContentPost"]), CreatedBy = Convert.ToString(row["CreatedBy"]), CreatedDate = Convert.ToDateTime(row["CreatedDate"]), ChangeBy = Convert.ToString(row["ChangeBy"]), ChangeDate = Convert.ToDateTime(row["ChangeDate"]), IsPublish = Convert.ToBoolean(row["IsPublish"]), IsSlide = Convert.ToBoolean(row["IsSlide"]), IsHome = Convert.ToBoolean(row["IsHome"]), IsActive = Convert.ToBoolean(row["IsActive"]), Comment = Convert.ToString(row["Comment"]), ImagesDisplay = Convert.ToString(row["ImagesDisplay"]), ShortDescription = Convert.ToString(row["ShortDescription"]), MetaDescription = Convert.ToString(row["MetaDescription"]), MetaKeywords = Convert.ToString(row["MetaKeywords"]), MetaTitle = Convert.ToString(row["MetaTitle"]), AdminComment = Convert.ToString(row["AdminComment"]) }); } } } return(lst); }