public ActionResult PostInfo(long ID) { VD_POST _post = new VD_POST(); _post = _postModel.getDetailsPost(ID); return(PartialView(_post)); }
public ResultResponse insertUpdatePost(VD_POST _post) { string _Msg = string.Empty; long _Result = 0; _rr = new ResultResponse(); _DBAccess = new DBController(); _DBAccess.InsertPost("WEB_VD_INSERT_POST", _post, ref _Msg, ref _Result); _rr.Msg = _Msg; _rr.Result = _Result; return(_rr); }
public VD_POST getPostIndexByCategory(string CateID) { VD_POST info = new VD_POST(); _DBAccess = new DBController(); DataSet ds = new DataSet(); ds = _DBAccess.GetEntityDetails("WEB_VD_GET_POST_INDEX_BY_CATEGORY", CateID); if (ds != null && ds.Tables.Count > 0) { if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0) { info.ID = Convert.ToInt64(ds.Tables[0].Rows[0]["ID"]); info.CategoryID = Convert.ToString(ds.Tables[0].Rows[0]["CategoryID"]); info.CategoryName = Convert.ToString(ds.Tables[0].Rows[0]["CategoryName"]); info.MetaTitleCategory = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitleCategory"]); info.MainMenuID = Convert.ToString(ds.Tables[0].Rows[0]["MainMenuID"]); info.MainMenuName = Convert.ToString(ds.Tables[0].Rows[0]["MainMenuName"]); info.MetaTitleMainMenu = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitleMainMenu"]); info.SubMenuID = Convert.ToString(ds.Tables[0].Rows[0]["SubMenuID"]); info.SubMenuName = Convert.ToString(ds.Tables[0].Rows[0]["SubMenuName"]); info.MetaTitleSubMenu = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitleSubMenu"]); info.TitlePost = Convert.ToString(ds.Tables[0].Rows[0]["TitlePost"]); info.ContentPost = Convert.ToString(ds.Tables[0].Rows[0]["ContentPost"]); info.CreatedBy = Convert.ToString(ds.Tables[0].Rows[0]["CreatedBy"]); info.CreatedDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["CreatedDate"]); info.ChangeBy = Convert.ToString(ds.Tables[0].Rows[0]["ChangeBy"]); info.ChangeDate = Convert.ToDateTime(ds.Tables[0].Rows[0]["ChangeDate"]); info.IsPublish = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsPublish"]); info.IsSlide = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsSlide"]); info.IsHome = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsHome"]); info.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[0]["IsActive"]); info.Comment = Convert.ToString(ds.Tables[0].Rows[0]["Comment"]); info.ImagesDisplay = Convert.ToString(ds.Tables[0].Rows[0]["ImagesDisplay"]); info.ShortDescription = Convert.ToString(ds.Tables[0].Rows[0]["ShortDescription"]); info.MetaDescription = Convert.ToString(ds.Tables[0].Rows[0]["MetaDescription"]); info.MetaKeywords = Convert.ToString(ds.Tables[0].Rows[0]["MetaKeywords"]); info.MetaTitle = Convert.ToString(ds.Tables[0].Rows[0]["MetaTitle"]); info.AdminComment = Convert.ToString(ds.Tables[0].Rows[0]["AdminComment"]); } } return(info); }
//POST public void InsertPost(string DataTitle, VD_POST _post, ref string outputMsg, ref long outputResult) { SqlCommand command = this.DataManager.CreateCommand(DataTitle, CommandType.StoredProcedure); DataManager.AddParameterWithValue(command, "@ID", _post.ID); DataManager.AddParameterWithValue(command, "@CategoryID", _post.CategoryID); DataManager.AddParameterWithValue(command, "@MainMenuID", _post.MainMenuID); DataManager.AddParameterWithValue(command, "@SubMenuID", _post.SubMenuID); DataManager.AddParameterWithValue(command, "@TitlePost", _post.TitlePost); DataManager.AddParameterWithValue(command, "@ContentPost", _post.ContentPost); DataManager.AddParameterWithValue(command, "@CreatedBy", _post.CreatedBy); DataManager.AddParameterWithValue(command, "@ChangeBy", _post.ChangeBy); DataManager.AddParameterWithValue(command, "@IsPublish", _post.IsPublish); DataManager.AddParameterWithValue(command, "@IsSlide", _post.IsSlide); DataManager.AddParameterWithValue(command, "@IsHome", _post.IsHome); DataManager.AddParameterWithValue(command, "@IsActive", _post.IsActive); DataManager.AddParameterWithValue(command, "@Comment", _post.Comment); DataManager.AddParameterWithValue(command, "@ImagesDisplay", _post.ImagesDisplay); SqlParameter paramOutputMsg = new SqlParameter("@outputMsg", SqlDbType.NVarChar, 1000); paramOutputMsg.Direction = ParameterDirection.Output; DataManager.AddParameter(command, paramOutputMsg); SqlParameter paramOutputResult = new SqlParameter("@outputResult", SqlDbType.BigInt); paramOutputResult.Direction = ParameterDirection.Output; DataManager.AddParameter(command, paramOutputResult); DataManager.ExecuteNonQuery(command); if (paramOutputResult.Value != null) { outputResult = (long)paramOutputResult.Value; outputMsg = paramOutputMsg.Value.ToString(); } else { outputResult = -1; outputMsg = string.Empty; } }
public void InsertPost(string DataTitle, VD_POST _post, ref string outputMsg, ref long outputResult) { _DB.InsertPost(DataTitle, _post, ref outputMsg, ref outputResult); }
public ActionResult InsertUpdatePosts(VD_POST posts) { _rr = new ResultResponse(); return(Json(_rr)); }