public IGridPageDto <IInvoiceDto> GetAllByGridPage(ServiceArgs args = null)
{
// Load Status.
var status = 3;
if ((args?.ContainsKey("StatusFilter") ?? false) && Enum.TryParse(args["StatusFilter"]?.ToString(), out RepairStatuses statusFilter))
{
if (statusFilter == RepairStatuses.Completed || statusFilter == RepairStatuses.Invoiced)
{
status = (int)statusFilter;
}
}
// Load Grid Items.
var query = Conn.Query <InvoiceDto>("Billing.usp_GetBillingInvoiceGrid",
new
{
UserGuid = User.UserGuid,
Search = args?["SearchPhrase"]?.ToString(),
Status = status
}, null, true, null, CommandType.StoredProcedure).ToList();
// Set Default Sort.
args?.SetDefaultSort("InvoicedDt DESC, RepairLastUpdatedDt ASC");
// Load Grid Page.
var result = query.ToList <IInvoiceDto>().GetGridPageFromCollection(args);
// Return.
return(result);
}
public IGridPageDto <IUploadDto> GetAllByGridPage(ServiceArgs args = null)
{
// Load Uploads.
var uploads = GetAll(args).ToList();
// Set Default Sort.
args?.SetDefaultSort("UploadId DESC");
// Load Grid Page.
var result = uploads.GetGridPageFromCollection(args);
// Return.
return(result);
}
public async Task <IGridPageDto <IDecisionDto> > GetAllByGridPageAsync(ServiceArgs args = null)
{
// Load Grid Items.
var query = await Conn.QueryAsync <DecisionDto>("Scan.usp_GetDecisionsByGridPage",
new
{
UserGuid = User.UserGuid,
Search = args?["SearchPhrase"]?.ToString(),
}, null, null, CommandType.StoredProcedure);
// Set Default Sort.
args?.SetDefaultSort("DecisionId ASC");
// Load Grid Page.
var result = query.ToList <IDecisionDto>().GetGridPageFromCollection(args);
// Return.
return(result);
}
public async Task <IGridPageDto <ITroubleCodeRecommendationDto> > GetAllByGridPageAsync(ServiceArgs args = null)
{
// Load Grid Items.
var query = await Conn.QueryAsync <TroubleCodeRecommendationDto>("Scan.usp_GetTroubleCodeRecommendations",
new
{
UserGuid = User.UserGuid,
Search = args?["SearchPhrase"]?.ToString(),
}, null, null, CommandType.StoredProcedure);
// Select Distinct.
var distinct = query.GroupBy(q => q.TroubleCodeRecommendationId).Select(q => q.First()).ToList <ITroubleCodeRecommendationDto>();
// Set Default Sort.
args?.SetDefaultSort("TroubleCodeRecommendationId ASC");
// Load Grid Page.
var result = distinct.GetGridPageFromCollection(args);
// Return.
return(result);
}
public IGridPageDto <IAirProToolDto> GetAllByGridPage(ServiceArgs args = null)
{
// Search Tools.
var search = args?["SearchPhrase"]?.ToString().ToLower();
bool toolTypeParseResult = Enum.TryParse <ToolType>(Enum.GetNames(typeof(ToolType)).FirstOrDefault(x => x.ToLower() == search) ?? "", out var type);
var filtered = string.IsNullOrEmpty(search)
? Db.AirProTools
: Db.AirProTools.Where(t => t.ToolId.ToString().Contains(search) || t.ToolKey.ToString().Contains(search) ||
t.AutoEnginuityNum.ToLower().Contains(search) || t.AutoEnginuityVersion.ToLower().Contains(search) ||
t.CarDaqNum.ToLower().Contains(search) || t.DGNum.ToLower().Contains(search) ||
t.TeamViewerId.ToLower().Contains(search) || t.WindowsVersion.ToLower().Contains(search) ||
t.TabletModel.ToLower().Contains(search) || t.HubModel.ToLower().Contains(search) ||
t.Shops.Any(s => s.Shop.Name.Contains(search)) || t.Accounts.Any(a => a.Account.Name.Contains(search)) ||
t.ToolName.ToLower().Contains(search) || t.Type == type);
// Execute.
var result = filtered
.Include(t => t.CreatedBy)
.Include(t => t.UpdatedBy)
.Include(t => t.Subscriptions)
.Include(d => d.Deposits)
.Include(d => d.Shops)
.Include(d => d.Accounts)
.ToList()
.Select(Mapper.Map <AirProToolDto>).ToList <IAirProToolDto>();
// Set Default Sort.
args?.SetDefaultSort("ToolId ASC");
// Get Page.
var page = result.GetGridPageFromCollection(args);
// Return.
return(page);
}