public static IQueryable <TO_DO> FilterForAdmin(DateFilterModel d) { ToDoEntities br = new ToDoEntities(); var result = br.TO_DO.AsQueryable(); if (d != null) { if (d.Deadline != 3) { if (d.Deadline == 1) { result = result.Where(x => x.Deadline > DateTime.Now); } else if (d.Deadline == 0) { result = result.Where(x => x.Deadline < DateTime.Now); } } if (!string.IsNullOrEmpty(d.UserId)) { var userid = Guid.Parse(d.UserId); result = result.Where(x => x.UserID.Equals(userid)); } if (!string.IsNullOrEmpty(d.Name)) { result = result.Where(x => x.Name.Equals(d.Name)); } if (!string.IsNullOrEmpty(d.Status)) { byte n = Convert.ToByte(d.Status); result = result.Where(x => x.Status.Equals(n)); } } return(result); }
public List <line_chart_data_view_model> GetSMSSR_For_Line_Last_Month([FromBody] DateFilterModel model) { List <line_chart_data_view_model> result = new List <line_chart_data_view_model>(); DateTime startDateTime = model.fromDate; model.fromDate = model.fromDate.AddMonths(-1); model.toDate = startDateTime; List <Gauge_Result_ViewModel> data = _dataProviderService.getSMSSR(model.operators, model.technologies, model.fromDate, model.toDate); var groups = data.GroupBy(s => s.accurance_date); foreach (var group in groups) { line_chart_data_view_model temp = new line_chart_data_view_model(); temp.accurance_date = group.Key; temp.data = group.Sum(r => r.data * r.weight) / group.Sum(r => r.weight); result.Add(temp); } return(result); }
public static IQueryable <TO_DO> Filter(DateFilterModel d) { ToDoEntities br = new ToDoEntities(); var usrid = Guid.Parse(Membership.GetUser().ProviderUserKey.ToString()); var result = br.TO_DO.Where(x => x.UserID == usrid).AsQueryable(); if (d != null) { if (d.Deadline != 3) { if (d.Deadline == 1) { result = result.Where(x => x.Deadline > DateTime.Now); } else if (d.Deadline == 0) { result = result.Where(x => x.Deadline < DateTime.Now); } } if (!string.IsNullOrEmpty(d.Name)) { result = result.Where(x => x.Name.Equals(d.Name)); } if (!string.IsNullOrEmpty(d.Status)) { byte n = Convert.ToByte(d.Status); result = result.Where(x => x.Status.Equals(n)); } } return(result); }
public async Task <AdminGetStatisticsModel> GetAsync(DateFilterModel model) { var query = _context.Statistics.Where(x => x.Date <model.From && x.Date> model.To); return(new AdminGetStatisticsModel { Total = await query.CountAsync(), Items = await query.OrderByDescending(x => x.Date).PaginateAsync(model) }); }
public ActionResult ToDoList(DateFilterModel d) { if (d.Status == "null") { d.Status = null; } var model = FilterFunction.Filter(d); return(View(model)); }
public ActionResult ToDoList(DateFilterModel d) { if (d.Status == "null") { d.Status = null; } ViewData["User"] = td.aspnet_Users.ToList(); var model = FilterFunction.FilterForAdmin(d); return(View(model)); }
public List <line_chart_data_view_model> GetCSSR_For_Line_Current_Month([FromBody] DateFilterModel model) { List <CSSR_Result_ViewModel> data = _dataProviderService.getCSSR(model.operators, model.technologies, model.fromDate, model.toDate); List <line_chart_data_view_model> result = data.GroupBy(s => s.accurance_date) .Select(s => new line_chart_data_view_model() { accurance_date = s.Key, data = s.Average(g => g.RANAP_RABAssignment_Response / g.MM_CMServiceRequest) }).ToList(); return(result); }
private DateFilterModel ParseDatesToFilterModel(List <DateTime> dates, int?year, int?month) { DateFilterModel model = new DateFilterModel { Years = dates.Select(k => k.Year).Distinct().ToList() }; if (year.HasValue) { model.Months = dates.Where(k => k.Year == year.Value).Select(k => k.Month).Distinct().ToList(); if (month.HasValue) { model.Days = dates.Where(k => k.Year == year && k.Month == month.Value).Select(k => k.Day).Distinct().ToList(); } } return(model); }
public DateFilterModel GetProjectWithActivities(int projectId, int?year, int?month) { DateFilterModel model = new DateFilterModel(); DataSets.Project project = db.Projects.AsNoTracking() .Include(k => k.Tasks) .ThenInclude(k => k.TimeSheetTasks) .ThenInclude(k => k.Activities) .Where(k => k.ID == projectId) .FirstOrDefault(); if (project == null) { return(model); } List <DateTime> dates = new List <DateTime>(); foreach (DataSets.ProjectTask item in project.Tasks) { foreach (DataSets.TimeSheetTask timeSheetProject in item.TimeSheetTasks) { foreach (DataSets.TimeSheetActivity timeSheetActivity in timeSheetProject.Activities) { if (timeSheetActivity.ToDate.HasValue) { dates.Add(timeSheetActivity.FromDate); } } } } model = ParseDatesToFilterModel(dates, year, month); return(model); }
public async Task <IActionResult> Statistics([FromQuery] DateFilterModel model) { AdminGetStatisticsModel result = await _statisticsService.GetAsync(model); return(Ok(result)); }
public List <TCH_ASR_Result_ViewModel> GetTCH_ASR_Current_Month([FromBody] DateFilterModel model) { return(_dataProviderService.getTCH_ASR(model.operators, model.technologies, model.fromDate, model.toDate)); }
public List <Gauge_Result_ViewModel> GetSMSSR([FromBody] DateFilterModel model) { return(_dataProviderService.getSMSSR(model.operators, model.technologies, model.fromDate, model.toDate)); }
public List <line_chart_data_view_model> GetTotal_successful_Call_For_Line_Current_Month([FromBody] DateFilterModel model) { List <line_chart_data_view_model> result = new List <line_chart_data_view_model>(); List <Gauge_Result_ViewModel> data = _dataProviderService.getTotal_successful_Call(model.operators, model.technologies, model.fromDate, model.toDate); var groups = data.GroupBy(s => s.accurance_date); foreach (var group in groups) { line_chart_data_view_model temp = new line_chart_data_view_model(); temp.accurance_date = group.Key; temp.data = group.Sum(r => r.data * r.weight) / group.Sum(r => r.weight); result.Add(temp); } return(result); }
public List <Gauge_Result_ViewModel> GetTotal_successful_Call_Current_Month([FromBody] DateFilterModel model) { return(_dataProviderService.getTotal_successful_Call(model.operators, model.technologies, model.fromDate, model.toDate)); }
public List <Gauge_Result_ViewModel> GetSuccess_Attach_Request_Current_Month([FromBody] DateFilterModel model) { return(_dataProviderService.getSuccess_Attach_Request(model.operators, model.technologies, model.fromDate, model.toDate)); }