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