public async Task <CarriageWithEquipment> GetByIdWithEquipment(int id)
{
using (var conn = new SqlConnection(AppSettings.ConnectionString))
{
var carriage = await GetById(id);
var mr = new ModelRepository(_logger);
var equipment = await mr.GetEquipmentByModel(carriage.Model);
var sqlr = new EquipmentRepository(_logger);
var sqlLabelsR = new LabelRepository();
var listeq = new List <LocationEquipmentAlgo>();
foreach (var loc in equipment)
{
string nameFromParent = null;
if (loc.ParentId != 0)
{
nameFromParent = sqlr.GetByParentId(loc.ParentId).Name;
}
//названия типов чеклистов, прицепленных к данному оборудованию
var checkListEquipment = await sqlr.GetCheckListByEquipmentModelId(loc.Id);
var algosNameList = (from algo in checkListEquipment.Algorithms
where algo.NameTask != null
select TranslateChecklistType(algo.CheckListType)).ToList();
listeq.Add(new LocationEquipmentAlgo
{
Location = nameFromParent,
Equipment = loc.Equipment.Name,
Algorithm = String.Join(", ", algosNameList.Distinct()),
Labels = (await sqlLabelsR.GetByCarriageId(carriage.Id, loc.Id)).ToArray().Select(e => e.Rfid)
.ToArray()
});
}
var ce = new CarriageWithEquipment
{
Carriage = carriage,
Equipment = listeq.ToArray()
};
return(ce);
}
}
//public async Task<EquipmentCategoryPaging> GetAll(int skip, int limit)
//{
// var sql = Sql.SqlQueryCach["CategoryEquipment.All"];
// var result = await _db.Connection.QueryAsync<EquipmentCategory>(sql, new { skip = skip, limit = limit });
// var sqlc = Sql.SqlQueryCach["CategoryEquipment.CountAll"];
// var count = _db.Connection.ExecuteScalar<int>(sqlc);
// var output = new EquipmentCategoryPaging
// {
// Data = result.ToArray(),
// Total = count
// };
// return output;
//}
/// <summary>
/// Получить категории оборудовани
/// </summary>
public async Task <EquipmentCategoryPaging> GetAll(int skip, int limit, FilterBody[] filters = null)
{
var crunchFilter = "equipmentname";
var crunch = new List <FilterBody>();
_sql = Sql.SqlQueryCach["CategoryEquipment.All"];
_sqlc = Sql.SqlQueryCach["CategoryEquipment.CountAll"];
#region Filter
if (filters != null)
{
crunch = filters.Where(e => e.Filter.ToLower().Equals(crunchFilter)).ToList();
//Категории можно фильтровать только по имени
var filter = filters.Where(e => e.Filter.ToLower().Equals("name")).ToArray();
if (filter.Any())
{
CreateFilter(filter, out _sqlfilter, out _sql);
_sqlc = $"{CategoryEquipmentCommon.sqlCountCommon} {_sqlfilter}";
}
}
#endregion
List <EquipmentCategory> sqlResult;
int count = 0;
if (crunch.Any())
{
sqlResult = (await _db.Connection.QueryAsync <EquipmentCategory>(_sql, new { skip = 0, limit = MaxValue })).ToList();
}
else
{
//using (var conn = new SqlConnection(AppSettings.ConnectionString))
//{
sqlResult = (await _db.Connection.QueryAsync <EquipmentCategory>(_sql, new { skip = skip, limit = limit })).ToList();
}
count = _db.Connection.ExecuteScalar <int>(_sqlc);
//}
var result = new EquipmentCategoryPaging
{
Data = sqlResult.ToList(),
Total = count
};
//Теперь мегокастыль. Проверяем есть ли фильтр на оборудование. Если есть то фильтруем по нему
if (crunch.Any())
{
result.Data = new List <EquipmentCategory>();
var eR = new EquipmentRepository(_logger);
foreach (var equipmentCategory in sqlResult)
{
var equipments = await eR.GetByCategory(equipmentCategory);
if (equipments.Data.Any(e => e.Name.ToLower().Contains(crunch.FirstOrDefault()?.Value.ToLower())))
{
result.Data.Add(equipmentCategory);
}
}
result.Total = result.Data.Count;
result.Data = result.Data.TakeWhile((e, i) => i >= skip && i <= skip + limit).ToList();
}
return(result);
}