public ActionResult Add_Blog_Tags()
{
string SSSession = ""; if (HttpContext.Request.Cookies["TSHPANDAControll" + StaticLicense.LicName] != null)
{
HttpCookie cookie = HttpContext.Request.Cookies.Get("TSHPANDAControll" + StaticLicense.LicName); if (cookie != null)
{
SSSession = cookie.Value;
}
else
{
SSSession = "N.A";
}
}
else
{
SSSession = "N.A";
} CheckAccess check = new CheckAccess(SSSession);
if (check.HasAccess)
{
Blog_ModelFiller BMF = new Blog_ModelFiller();
return(View(BMF.BCategory_Filler()));
}
else
{
return(RedirectToAction("NotAccess", "MS"));
}
}
public ActionResult NewBlogPost()
{
string SSSession = ""; if (HttpContext.Request.Cookies["TSHPANDAControll" + StaticLicense.LicName] != null)
{
HttpCookie cookie = HttpContext.Request.Cookies.Get("TSHPANDAControll" + StaticLicense.LicName); if (cookie != null)
{
SSSession = cookie.Value;
}
else
{
SSSession = "N.A";
}
}
else
{
SSSession = "N.A";
} CheckAccess check = new CheckAccess(SSSession);
if (check.HasAccess)
{
//ControllerContext.ParentActionViewContext.ViewBag.PageTitle = "";
Blog_ModelFiller BMF = new Blog_ModelFiller();
var Model = new Blog_Post_insert_Model()
{
Category = BMF.BCategory_Filler(),
Groups = BMF.Groups_Filler(),
Type = BMF.B_Types_Filler(),
PostData = new PostModel()
{
Id = 0,
AdminPic = "",
Category = "",
ImagePath = "",
InGroup = "",
title = "",
text_min = "",
text = "",
tags = "", date = "", by = "", Tags = new List <string>(), Comments__ = 0, IsDeleted = 0, IsDisabled = 0, IsImportant = 0, SearchGravity = 0
}
};
return(View(Model));
}
else
{
return(RedirectToAction("NotAccess", "MS"));
}
}
public ActionResult EditPost(int Post_id)
{
string SSSession = ""; if (HttpContext.Request.Cookies["TSHPANDAControll" + StaticLicense.LicName] != null)
{
HttpCookie cookie = HttpContext.Request.Cookies.Get("TSHPANDAControll" + StaticLicense.LicName); if (cookie != null)
{
SSSession = cookie.Value;
}
else
{
SSSession = "N.A";
}
}
else
{
SSSession = "N.A";
}
CheckAccess check = new CheckAccess(SSSession);
if (check.HasAccess)
{
//ControllerContext.ParentActionViewContext.ViewBag.PageTitle = "";
Blog_ModelFiller BMF = new Blog_ModelFiller();
var Model = new Blog_Post_insert_Model()
{
Category = BMF.BCategory_Filler(),
Groups = BMF.Groups_Filler(),
Type = BMF.B_Types_Filler(),
PostData = BMF.EditModelFiller(Post_id)
};
Model.Tags = BMF.B_Tags_Filler(Convert.ToInt32(Model.PostData.Category));
return(View(Model));
}
else
{
return(RedirectToAction("NotAccess", "MS"));
}
}
/// /////////////////////{ end : login }////////////////////////
////////////////////////{ start : blog }////////////////////////5
///مثال
////url = MS/blog?NamePage=post&page=1
////url = MS/blog?NamePage=Categories&Valuepage=اخبار پاندایی&page=1
public ActionResult Blog(string Cat = "همه", int Page = 1, int Id = 0, string search = "")
{
PDBC db = new PDBC("PandaMarketCMS", true);
string SearchNAmeHeader = "تمامی مطالب";
int num = 1;
db.Connect();
if (Cat == "همه")
{
num = Convert.ToInt32(db.Select("SELECT Count(*) FROM [tbl_BLOG_Post] where Is_Deleted=0 AND Is_Disabled=0").Rows[0][0]);
db.DC();
}
else if (Cat == "دسته بندی")
{
num = Convert.ToInt32(db.Select("SELECT Count(*) FROM [tbl_BLOG_Post] where Is_Deleted=0 AND Is_Disabled=0 AND Cat_Id=" + Id).Rows[0][0]);
using (DataTable dt2 = db.Select("SELECT [name] FROM [tbl_BLOG_Categories] WHERE [Id] =" + Id))
{
SearchNAmeHeader = dt2.Rows[0][0].ToString();
}
db.DC();
}
else if (Cat == "گروه بندی")
{
num = Convert.ToInt32(db.Select("SELECT Count(*) FROM [tbl_BLOG_Post] where Is_Deleted=0 AND Is_Disabled=0 AND [GroupId] = " + Id).Rows[0][0]);
using (DataTable dt2 = db.Select("SELECT [name] FROM [tbl_BLOG_Groups] WHERE [G_Id] =" + Id))
{
SearchNAmeHeader = dt2.Rows[0][0].ToString();
}
db.DC();
}
else if (Cat == "برچسب")
{
num = Convert.ToInt32(db.Select("SELECT COUNT(*) FROM [tbl_BLOG_TagConnector] as A inner join [tbl_BLOG_Post] as B on A.Post_Id=B.Id where Is_Deleted=0 AND Is_Disabled=0 AND Tag_Id=" + Id).Rows[0][0]);
using (DataTable dt2 = db.Select("SELECT [name] FROM [tbl_BLOG_Tags] WHERE [Id] =" + Id))
{
SearchNAmeHeader = dt2.Rows[0][0].ToString();
}
db.DC();
}
else if (Cat == "جست و جو")
{
num = Convert.ToInt32(db.Select("SELECT Count(*) FROM [tbl_BLOG_Post] where (Is_Deleted=0 AND Is_Disabled=0) AND (Title Like N'%" + search + "%' OR Text_min Like N'%" + search + "%' OR [Text] Like N'%" + search + "%') ").Rows[0][0]);
db.DC();
}
if (num % 15 == 0)
{
num = (num / 15);
}
else
{
num = (num / 15) + 1;
}
Blog_ModelFiller BMF = new Blog_ModelFiller();
var model = new BlogPostsModel()
{
Categories = BMF.BCategory_Filler(),
Tags = BMF.B_AllTags_Filler(),
Posts = BMF.UserPostModels(Cat, Page, Id, search),
GroupsList = BMF.C_AllTags_Filler(),
Pages = num,
Page = Page,
Cat = Cat,
Id = Id,
SearchNAmeHeaderH1 = SearchNAmeHeader
};
return(View(model));
}