public async Task <string> OvertimeReportExcelExport(OvertimeReportInputModel input)
{
AppSettings.SetSiteLanguage(input.LangId);
var parentDirectory = Directory.GetParent(Environment.CurrentDirectory).FullName;
var fileName = string.Format("Overtime_Operations_{0}.xlsx", Guid.NewGuid().ToString());
FileStream fs = new FileStream(Path.Combine(parentDirectory, "Surgicalogic.Web", "static", fileName), FileMode.CreateNew);
var excelService = new ExcelDocumentService();
var items = await _overtimeReportStoreService.GetExportAsync(input);
await excelService.WriteAsync(fs, "Worksheet", items, typeof(OvertimeReportExportModel), System.Globalization.CultureInfo.CurrentCulture);
return(fileName);
}
public async Task <ResultModel <OvertimeReportOutputModel> > GetAsync <TOutputModel>(OvertimeReportInputModel input)
{
var query = _context.OperationPlans.Where(x => x.IsActive && Convert.ToInt32((x.RealizedEndDate - x.RealizedStartDate).TotalMinutes) != x.Operation.OperationTime);
var branchIds = input.BranchId?.Split(',').Select(int.Parse).ToList();
var doctorIds = input.DoctorId?.Split(',').Select(int.Parse).ToList();
if (!string.IsNullOrEmpty(input.SortBy))
{
Expression <Func <OperationPlan, object> > orderBy = null;
switch (input.SortBy)
{
case "branchName":
orderBy = x => x.Operation.OperationType.Branch.Name;
break;
case "operationName":
orderBy = x => x.Operation.Name;
break;
case "operationRoomName":
orderBy = x => x.OperatingRoom.Name;
break;
case "operationStartDate":
orderBy = x => x.OperationDate;
break;
case "operationEndDate":
orderBy = x => x.OperationDate.AddMinutes(x.Operation.OperationTime);
break;
case "realizedStartDate":
orderBy = x => x.RealizedStartDate;
break;
case "realizedEndDate":
orderBy = x => x.RealizedEndDate;
break;
case "operationTimeDifference":
orderBy = x => x.Operation.OperationTime - Convert.ToInt32((x.RealizedEndDate - x.RealizedStartDate).TotalMinutes);
break;
default:
orderBy = x => x.Id;
break;
}
if (input.Descending == true)
{
query = query.OrderByDescending(orderBy);
}
else
{
query = query.OrderBy(orderBy);
}
}
if (branchIds?.Count > 0)
{
query = query.Where(x => branchIds.Contains(x.Operation.OperationType.BranchId));
}
if (doctorIds?.Count > 0)
{
query = query.Where(x => x.Operation.OperationPersonels.Any(t => doctorIds.Contains(t.PersonnelId)));
}
if (input.RealizedStartDate != null && input.RealizedStartDate != DateTime.MinValue)
{
query = query.Where(x => x.RealizedStartDate >= input.RealizedStartDate);
}
if (input.RealizedEndDate != null && input.RealizedEndDate != DateTime.MinValue)
{
query = query.Where(x => x.RealizedEndDate <= input.RealizedEndDate.AddDays(1));
}
if (!string.IsNullOrEmpty(input.Search))
{
query = query.Where(x =>
x.Operation.Name.IndexOf(input.Search, StringComparison.CurrentCultureIgnoreCase) >= 0 ||
x.OperatingRoom.Name.IndexOf(input.Search, StringComparison.CurrentCultureIgnoreCase) >= 0 ||
x.Operation.OperationPersonels.Any(t => t.IsActive && (t.Personnel.FirstName + " " + t.Personnel.LastName).IndexOf(input.Search, StringComparison.CurrentCultureIgnoreCase) >= 0) ||
x.Operation.OperationType.Branch.Name.IndexOf(input.Search, StringComparison.CurrentCultureIgnoreCase) >= 0
);
}
int totalCount = await query.CountAsync();
if (input.PageSize > 0)
{
query = query.Skip((input.CurrentPage - 1) * input.PageSize).Take(input.PageSize);
}
var result = await query.ProjectTo <OperationPlanForReportModel>().ToListAsync();
return(new ResultModel <OvertimeReportOutputModel>
{
Result = AutoMapper.Mapper.Map <List <OvertimeReportOutputModel> >(result),
TotalCount = totalCount,
Info = new Info {
Succeeded = true
}
});
}
public async Task <List <OvertimeReportExportModel> > GetExportAsync(OvertimeReportInputModel input)
{
var query = _context.OperationPlans.AsNoTracking().Where(x => x.IsActive && Convert.ToInt32((x.RealizedEndDate - x.RealizedStartDate).TotalMinutes) != x.Operation.OperationTime);
return(await query.ProjectTo <OvertimeReportExportModel>().ToListAsync());
}
public async Task <ResultModel <OvertimeReportOutputModel> > OvertimeReportPage(OvertimeReportInputModel input)
{
return(await _overtimeReportStoreService.GetAsync <OvertimeReportOutputModel>(input));
}
