public void LoadData() { string username = Request.Cookies["usernameLoginSystem"].Value; var acc = AccountController.GetByUsername(username); if (acc != null) { if (acc.RoleID == 0 || acc.Username == "nhom_zalo502") { ltrAddPost.Text = "<a href='/tao-bai-viet' class='h45-btn btn primary-btn'>Thêm mới</a>"; } } string TextSearch = ""; string CreatedDate = ""; string CreatedBy = ""; int CategoryID = 0; string Status = ""; string WebPublish = ""; if (Request.QueryString["textsearch"] != null) { TextSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["status"] != null) { Status = Request.QueryString["status"]; } if (Request.QueryString["categoryid"] != null) { CategoryID = Request.QueryString["categoryid"].ToInt(); } if (Request.QueryString["createddate"] != null) { CreatedDate = Request.QueryString["createddate"]; } if (Request.QueryString["webpublish"] != null) { WebPublish = Request.QueryString["webpublish"]; } if (Request.QueryString["createdby"] != null) { CreatedBy = Request.QueryString["createdby"]; } txtSearchPost.Text = TextSearch; ddlCategory.SelectedValue = CategoryID.ToString(); ddlCreatedDate.SelectedValue = CreatedDate.ToString(); ddlStatus.SelectedValue = Status.ToString(); ddlWebPublish.SelectedValue = WebPublish.ToString(); ddlCreatedBy.SelectedValue = CreatedBy; List <PostSQL> a = new List <PostSQL>(); a = PostController.GetAllSql(CategoryID, TextSearch, Status, WebPublish, CreatedDate, CreatedBy); pagingall(a); ltrNumberOfPost.Text = a.Count().ToString(); }
public void LoadData() { string TextSearch = ""; string CreatedDate = ""; int CategoryID = 0; if (Request.QueryString["textsearch"] != null) { TextSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["categoryid"] != null) { CategoryID = Request.QueryString["categoryid"].ToInt(); } if (Request.QueryString["createddate"] != null) { CreatedDate = Request.QueryString["createddate"]; } txtSearchPost.Text = TextSearch; ddlCategory.SelectedValue = CategoryID.ToString(); ddlCreatedDate.SelectedValue = CreatedDate.ToString(); List <PostSQL> a = new List <PostSQL>(); a = PostController.GetAllSql(CategoryID, TextSearch, "1", "false", CreatedDate, ""); pagingall(a); }
public void LoadData() { string TextSearch = ""; string CreatedDate = ""; int CategoryID = 0; if (Request.QueryString["textsearch"] != null) { TextSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["categoryid"] != null) { CategoryID = Request.QueryString["categoryid"].ToInt(); } if (Request.QueryString["createddate"] != null) { CreatedDate = Request.QueryString["createddate"]; } txtSearchPost.Text = TextSearch; ddlCategory.SelectedValue = CategoryID.ToString(); ddlCreatedDate.SelectedValue = CreatedDate.ToString(); List <PostSQL> a = new List <PostSQL>(); a = PostController.GetAllSql(CategoryID, TextSearch); a = a.Where(p => p.Status == 1).ToList(); if (CreatedDate != "") { DateTime fromdate = DateTime.Today; DateTime todate = DateTime.Now; switch (CreatedDate) { case "today": fromdate = DateTime.Today; todate = DateTime.Now; break; case "yesterday": fromdate = fromdate.AddDays(-1); todate = DateTime.Today; break; case "beforeyesterday": fromdate = DateTime.Today.AddDays(-2); todate = DateTime.Today.AddDays(-1); break; case "week": int days = DateTime.Today.DayOfWeek == DayOfWeek.Sunday ? 7 : (int)DateTime.Today.DayOfWeek; fromdate = fromdate.AddDays(-days + 1); todate = DateTime.Now; break; case "month": fromdate = new DateTime(fromdate.Year, fromdate.Month, 1); todate = DateTime.Now; break; case "7days": fromdate = DateTime.Today.AddDays(-6); todate = DateTime.Now; break; case "30days": fromdate = DateTime.Today.AddDays(-29); todate = DateTime.Now; break; } a = a.Where(p => p.CreatedDate >= fromdate && p.CreatedDate <= todate).ToList(); } pagingall(a); }
public void LoadData() { string username = Request.Cookies["userLoginSystem"].Value; var acc = AccountController.GetByUsername(username); if (acc != null) { if (acc.RoleID == 0) { ltrAddPost.Text = "<a href=\"/tao-bai-viet\" class=\"h45-btn btn primary-btn\">Thêm mới</a>"; } } string TextSearch = ""; string CreatedDate = ""; int CategoryID = 0; string Status = ""; if (Request.QueryString["textsearch"] != null) { TextSearch = Request.QueryString["textsearch"].Trim(); } if (Request.QueryString["status"] != null) { Status = Request.QueryString["status"]; } if (Request.QueryString["categoryid"] != null) { CategoryID = Request.QueryString["categoryid"].ToInt(); } if (Request.QueryString["createddate"] != null) { CreatedDate = Request.QueryString["createddate"]; } txtSearchPost.Text = TextSearch; ddlCategory.SelectedValue = CategoryID.ToString(); ddlCreatedDate.SelectedValue = CreatedDate.ToString(); ddlStatus.SelectedValue = Status.ToString(); List <PostSQL> a = new List <PostSQL>(); a = PostController.GetAllSql(CategoryID, TextSearch); if (Status != "") { a = a.Where(p => p.Status == Status.ToInt()).ToList(); } else { a = a.Where(p => p.Status == 1).ToList(); } if (CreatedDate != "") { DateTime fromdate = DateTime.Today; DateTime todate = DateTime.Now; switch (CreatedDate) { case "today": fromdate = DateTime.Today; todate = DateTime.Now; break; case "yesterday": fromdate = fromdate.AddDays(-1); todate = DateTime.Today; break; case "beforeyesterday": fromdate = DateTime.Today.AddDays(-2); todate = DateTime.Today.AddDays(-1); break; case "week": int days = DateTime.Today.DayOfWeek == DayOfWeek.Sunday ? 7 : (int)DateTime.Today.DayOfWeek; fromdate = fromdate.AddDays(-days + 1); todate = DateTime.Now; break; case "month": fromdate = new DateTime(fromdate.Year, fromdate.Month, 1); todate = DateTime.Now; break; case "7days": fromdate = DateTime.Today.AddDays(-6); todate = DateTime.Now; break; case "30days": fromdate = DateTime.Today.AddDays(-29); todate = DateTime.Now; break; } a = a.Where(p => p.CreatedDate >= fromdate && p.CreatedDate <= todate).ToList(); } pagingall(a); ltrNumberOfPost.Text = a.Count().ToString(); }