/// <summary>
/// Setting init when load page
/// </summary>
private void LoadData()
{
string TextSearch = "";
string COD = "";
string Prepay = "";
string CreatedBy = "";
string CreatedDate = "";
if (Request.QueryString["textsearch"] != null)
{
TextSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["cod"] != null)
{
COD = Request.QueryString["cod"];
}
if (Request.QueryString["prepay"] != null)
{
Prepay = Request.QueryString["prepay"];
}
if (Request.QueryString["createdby"] != null)
{
CreatedBy = Request.QueryString["createdby"];
}
if (Request.QueryString["createddate"] != null)
{
CreatedDate = Request.QueryString["createddate"];
}
txtTextSearch.Text = TextSearch;
ddlCOD.SelectedValue = COD.ToString();
ddlPrepay.SelectedValue = Prepay.ToString();
ddlCreatedBy.SelectedValue = CreatedBy.ToString();
ddlCreatedDate.SelectedValue = CreatedDate.ToString();
var rs = TransportCompanyController.Filter(TextSearch);
if (COD != "")
{
rs = rs.Where(x => x.COD == COD.ToBool()).ToList();
}
if (Prepay != "")
{
rs = rs.Where(x => x.Prepay == Prepay.ToBool()).ToList();
}
if (CreatedBy != "")
{
rs = rs.Where(x => x.CreatedBy == CreatedBy).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;
}
rs = rs.Where(x => x.CreatedDate >= fromdate && x.CreatedDate <= todate).ToList();
}
pagingall(rs);
ltrNumberOfTransport.Text = rs.Count().ToString();
}
/// <summary>
/// Setting init when load page
/// </summary>
private void LoadData()
{
string username = Request.Cookies["usernameLoginSystem"].Value;
var acc = AccountController.GetByUsername(username);
string TextSearch = "";
string COD = "";
string Prepay = "";
string CreatedDate = "";
string Status = "";
if (Request.QueryString["textsearch"] != null)
{
TextSearch = Request.QueryString["textsearch"].Trim();
}
if (Request.QueryString["cod"] != null)
{
COD = Request.QueryString["cod"];
}
if (Request.QueryString["prepay"] != null)
{
Prepay = Request.QueryString["prepay"];
}
if (Request.QueryString["createddate"] != null)
{
CreatedDate = Request.QueryString["createddate"];
}
if (Request.QueryString["status"] != null)
{
Status = Request.QueryString["status"];
}
txtTextSearch.Text = TextSearch;
ddlCOD.SelectedValue = COD.ToString();
ddlPrepay.SelectedValue = Prepay.ToString();
ddlCreatedDate.SelectedValue = CreatedDate.ToString();
ddlStatus.SelectedValue = Status.ToString();
var rs = TransportCompanyController.Filter(TextSearch);
if (acc.RoleID == 2)
{
rs = rs.Where(x => x.Status == 1).ToList();
}
if (acc.RoleID == 0)
{
if (Status != "")
{
rs = rs.Where(x => x.Status == Status.ToInt()).ToList();
}
}
if (COD != "")
{
rs = rs.Where(x => x.COD == COD.ToBool()).ToList();
}
if (Prepay != "")
{
rs = rs.Where(x => x.Prepay == Prepay.ToBool()).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 "thismonth":
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;
}
rs = rs.Where(x => x.CreatedDate >= fromdate && x.CreatedDate <= todate).ToList();
}
pagingall(rs.Distinct().ToList());
ltrNumberOfTransport.Text = rs.Count().ToString();
}
