public async Task <IActionResult> Edit(int id, [Bind("PostId,PostsName,BlogTitle,BlogDescription,BlogsRating,AuthorsName,PostedTime,ImageName")] BlogPostsModel blogPostsModel)
{
if (id != blogPostsModel.PostId)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(blogPostsModel);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!BlogPostsModelExists(blogPostsModel.PostId))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(blogPostsModel));
}
/// <summary>
/// Initializes a new instance of the class.
/// </summary>
/// <param name="model">Model</param>
/// <returns>A <see cref="Task"/> Returns Result </returns>
public async Task <int> InsertAsync(BlogPostsModel model)
{
if (model == null)
{
throw new ArgumentNullException("Curation");
}
return(await this.blogRepository.InsertAsync(model));
}
/// /////////////////////{ end : blog_post }////////////////////////
public ActionResult BlogMainPageSectionofPost()
{
Blog_ModelFiller BMF = new Blog_ModelFiller();
var model = new BlogPostsModel()
{
Posts = BMF.UserPostModels("همه", 1, 7, "")
};
return(View(model));
}
public ActionResult AfraMaterPostsTypes()
{
Blog_ModelFiller BMF = new Blog_ModelFiller();
BlogPostsModel bpm = new BlogPostsModel()
{
GroupsList = BMF.Groups_Filler()
};
return(View(bpm));
}
public ActionResult Index()
{
Blog_ModelFiller BMF = new Blog_ModelFiller(3);
var model = new BlogPostsModel()
{
Posts = BMF.UserPostModels("همه", 1, 0, "")
};
return(View(model));
}
public BlogPostsRepository()
{
var json = File.ReadAllText(@"D:\InterviewTasks\Bytology\systems-developer-assessment-master\src\Blog.Data\Blog-Posts.json", System.Text.Encoding.UTF8);
blogPosts = JsonConvert.DeserializeObject <BlogPostsModel>(json);
foreach (BlogModel b in blogPosts.blogPosts)
{
blogs.Add(b);
}
}
public async Task <IActionResult> Create([Bind("PostId,PostsName,BlogTitle,BlogDescription,BlogsRating,AuthorsName,PostedTime,ImageName")] BlogPostsModel blogPostsModel)
{
if (ModelState.IsValid)
{
_context.Add(blogPostsModel);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(blogPostsModel));
}
public async Task <IActionResult> Search()
{
ViewBag.Term = HttpContext.Request.Form["term"];
var model = new BlogPostsModel();
model.Pager = new Pager(1);
model.Posts = await _search.Find(model.Pager, ViewBag.Term);
model.CustomFields = _custom.GetProfileCustomFields(null).Result;
return(View(_theme + "Search.cshtml", model));
}
public async Task <IActionResult> PagedSearch(string term, int page = 1)
{
ViewBag.Term = term;
var model = new BlogPostsModel();
model.Pager = new Pager(page);
model.Posts = await _search.Find(model.Pager, ViewBag.Term);
model.CustomFields = _custom.GetProfileCustomFields(null).Result;
if (page < 1 || page > model.Pager.LastPage)
{
return(View(_theme + "Error.cshtml", 404));
}
return(View(_theme + "Search.cshtml", model));
}
/// /////////////////////{ 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));
}
