public async Task <ActionResult> AddCase() { var caseQuery = new CaseFilter(Session); var dbCase = await caseQuery.FilterCase(); return(View("AddCase", dbCase)); }
/// <summary> /// Дела с непълен състав /// </summary> /// <returns></returns> public IActionResult CaseForSelection() { CaseFilter filter = new CaseFilter(); SetViewbagIndex(); SetHelpFile(HelpFileValues.IncompleteConstitutionInfo); return(View(filter)); }
/// <summary> /// Страница за дела по критерии от филтър /// </summary> /// <returns></returns> public IActionResult Index() { if (!CheckAccess(service, SourceTypeSelectVM.Case, null, AuditConstants.Operations.View)) { return(RedirectToAction(nameof(HomeController.AccessDenied), HomeController.ControlerName)); } CaseFilter filter = new CaseFilter() { CaseYear = DateTime.Now.Year }; SetViewbagIndex(); SetHelpFile(HelpFileValues.CaseIndex); return(View(filter)); }
public ActionResult GetCaseEventData(CaseFilter filter, int page = 1, int rows = 100) { int total = 0; List <object> dataList = new List <object>(); TimeZoneConvert timeZoneConvert = new TimeZoneConvert(); EnumData.TimeZone TimeZone = MyHelp.GetTimeZone((int)Session["TimeZone"]); var CaseFilter = db.CaseEvent.AsNoTracking().AsQueryable(); if (!string.IsNullOrEmpty(filter.OrderID)) { CaseFilter = CaseFilter.Where(c => c.OrderID.ToString().Equals(filter.OrderID)); } if (!string.IsNullOrEmpty(filter.LabelID)) { CaseFilter = CaseFilter.Where(c => c.LabelID.ToString().Equals(filter.LabelID)); } if (filter.CreateDate.HasValue) { DateTime dateFrom = timeZoneConvert.InitDateTime(filter.CreateDate.Value, TimeZone).Utc; DateTime dateTO = timeZoneConvert.Utc.AddDays(1); CaseFilter = CaseFilter.Where(c => c.Create_at.CompareTo(dateFrom) >= 0 && c.Create_at.CompareTo(dateTO) < 0); } if (filter.RequestDate.HasValue) { DateTime dateFrom = timeZoneConvert.InitDateTime(filter.RequestDate.Value, TimeZone).Utc; DateTime dateTO = timeZoneConvert.Utc.AddDays(1); CaseFilter = CaseFilter.Where(c => c.Request_at.HasValue && c.Request_at.Value.CompareTo(dateFrom) >= 0 && c.Request_at.Value.CompareTo(dateTO) < 0); } if (filter.ResponseDate.HasValue) { DateTime dateFrom = timeZoneConvert.InitDateTime(filter.ResponseDate.Value, TimeZone).Utc; DateTime dateTO = timeZoneConvert.Utc.AddDays(1); CaseFilter = CaseFilter.Where(c => c.Response_at.HasValue && c.Response_at.Value.CompareTo(dateFrom) >= 0 && c.Response_at.Value.CompareTo(dateTO) < 0); } if (filter.CaseType.HasValue) { CaseFilter = CaseFilter.Where(c => c.Type.Equals(filter.CaseType.Value)); } if (filter.CaseRequest.HasValue) { CaseFilter = CaseFilter.Where(c => c.Request.Equals(filter.CaseRequest.Value)); } if (filter.CaseStatus.HasValue) { CaseFilter = CaseFilter.Where(c => c.Status.Equals(filter.CaseStatus.Value)); } List <CaseEvent> results = CaseFilter.ToList(); if (results.Any()) { int length = rows; int start = (page - 1) * length; total = results.Count(); if (!string.IsNullOrEmpty(filter.Sort) && filter.Sort.Equals("RequestDate")) { results = filter.Order.Equals("asc") ? results.OrderBy(c => c.Request_at).ToList() : results.OrderByDescending(c => c.Request_at).ToList(); } Dictionary <int, string> DirectLine = db.DirectLine.Where(d => d.IsEnable).ToDictionary(d => d.ID, d => d.Abbreviation); Dictionary <int, string> AdminName = db.AdminUsers.AsNoTracking().Where(u => u.IsEnable).ToDictionary(u => u.Id, u => u.Name); dataList.AddRange(results.Skip(start).Take(length).Select(c => new { CaseID = c.ID, c.OrderID, LabelID = DirectLine[c.Packages.Method.DirectLine].Equals("Sendle") ? string.Format("{0}-{1}-{2}", c.Packages.Items.First(i => i.IsEnable.Value).ProductID, c.OrderID, c.Packages.TrackingNumber) : c.LabelID, CreateDate = timeZoneConvert.InitDateTime(c.Create_at, EnumData.TimeZone.UTC).ConvertDateTime(TimeZone).ToString("MM/dd/yyyy tt hh:mm"), RequestDate = c.Request_at.HasValue ? timeZoneConvert.InitDateTime(c.Request_at.Value, EnumData.TimeZone.UTC).ConvertDateTime(TimeZone).ToString("MM/dd/yyyy tt hh:mm") : "", ResponseDate = c.Response_at.HasValue ? timeZoneConvert.InitDateTime(c.Response_at.Value, EnumData.TimeZone.UTC).ConvertDateTime(TimeZone).ToString("MM/dd/yyyy tt hh:mm") : "", CaseType = EnumData.CaseEventTypeList()[(EnumData.CaseEventType)c.Type], CaseRequest = Enum.GetName(typeof(EnumData.CaseEventRequest), c.Request), CaseStatus = c.Status, UpdateBy = AdminName.ContainsKey(c.Update_by) ? string.Format("{0}﹙{1}﹚", AdminName[c.Update_by], DirectLine[c.Packages.Method.DirectLine]) : DirectLine[c.Packages.Method.DirectLine] })); } return(Json(new { total, rows = dataList }, JsonRequestBehavior.AllowGet)); }
public IActionResult ListData(IDataTablesRequest request, CaseFilter model) { var data = service.Case_Select(userContext.CourtId, model); return(request.GetResponse(data)); }