public async Task <ActionResult <IEnumerable <UnitTreeOut> > > GetUnitTrees(UnitLobCoverageDivisionTreeQueryCommand command)
{
var result = await mediator.Send(command);
if (!result.IsValid)
{
return(BadRequest(result.Errors));
}
return(Ok(result.Data));
}
public async Task <ActionResult <IEnumerable <UnitTreeOut> > > GetUnitTrees(UnitLobCoverageDivisionTreeQueryCommand command)
{
var result = await mediator.Send(command);
return(Ok(result));
}
public async Task <IEnumerable <UnitTreeOut> > Handle(UnitLobCoverageDivisionTreeQueryCommand request, CancellationToken cancellationToken)
{
List <UnitTreeOut> result = new List <UnitTreeOut>();
var data = (await preminumFinanceRepository.GetLobUnitsCoverageDivision()).ToList();
if (data.Any())
{
// group by product_id
var product_ids = from product in data
group product by product.id_product into g
select g;
if (product_ids.Any())
{
foreach (var productId in product_ids)
{
var product = data.FirstOrDefault(a => a.id_product == productId.Key);
UnitTreeOut producttree = new UnitTreeOut()
{
id = product.id_division_product,
Data = new Data()
{
id_division_product = product.id_division_product,
id_product = product.id_product,
},
Text = product.product_name
};
data.Remove(product);
var lob_data = data.Where(a => a.id_product == productId.Key).ToList();
var lob_ids = from lobitem in lob_data
group lobitem by lobitem.id_lob into g
select g;
if (lob_ids.Any())
{
List <UnitTreeOut> lobs = new List <UnitTreeOut>();
foreach (var lob_id in lob_ids)
{
var lob = lob_data.FirstOrDefault(a => a.id_lob == lob_id.Key);
lob_data.Remove(lob);
UnitTreeOut lobtree = new UnitTreeOut()
{
id = lob.id_division_product,
Data = new Data()
{
id_product = producttree.Data.id_product,
id_lob = lob.id_lob,
id_division_product = producttree.Data.id_division_product
},
Text = lob.lob_name
};
var division_data = lob_data.Where(a => a.id_lob == lob_id.Key).ToList();
var division_ids = from divisionitem in division_data
group divisionitem by divisionitem.id_division into g
select g;
if (division_ids.Any())
{
List <UnitTreeOut> divisions = new List <UnitTreeOut>();
foreach (var division_id in division_ids)
{
var division = division_data.FirstOrDefault(a => a.id_division == division_id.Key);
division_data.Remove(division);
UnitTreeOut divisiontree = new UnitTreeOut()
{
id = division.id_division_product,
Data = new Data()
{
id_product = lobtree.Data.id_product,
id_division = division.id_division,
id_division_product = lobtree.Data.id_division_product,
id_lob = lobtree.Data.id_lob,
},
Text = division.division_name
};
var coverage_data = division_data.Where(a => a.id_division == division_id.Key);
List <UnitTreeOut> coverages = new List <UnitTreeOut>();
foreach (var coverageitem in coverage_data)
{
UnitTreeOut treecoverage = new UnitTreeOut()
{
id = coverageitem.id_division_product,
Data = new Data()
{
id_division = divisiontree.Data.id_division,
id_coverage = coverageitem.id_coverage,
id_division_product = divisiontree.Data.id_division_product,
id_lob = divisiontree.Data.id_lob,
id_product = divisiontree.Data.id_product
},
Text = coverageitem.coverage_name
};
coverages.Add(treecoverage);
}
divisiontree.Children = coverages;
coverages = new List <UnitTreeOut>();
divisions.Add(divisiontree);
}
lobtree.Children = divisions;
divisions = new List <UnitTreeOut>();
}
lobs.Add(lobtree);
}
producttree.Children = lobs;
lobs = new List <UnitTreeOut>();
}
result.Add(producttree);
}
}
}
return(result);
}
