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