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