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();
}
