public List <BatchPriceComponentItemModel> LoadPriceComponentsReport()
{
var result = new List <BatchPriceComponentItemModel>(10000);
m_database.Sql().Call("GetBatchPricesReport")
.WithParam("@projectId", m_session.Project.Id)
.WithParam("@culture", m_session.Culture)
.ReadRows <string, string, string, decimal, string, int, decimal>((material, batch, text, price, month, unitId, unitPrice) =>
{
var item = new BatchPriceComponentItemModel
{
Text = text,
Price = price
};
result.Add(item);
item.BatchIdentifier = batch;
item.MaterialName = material;
item.Month = month;
AssignUnitAndUnitPrice(item, unitId, unitPrice);
});
return(result);
}
private void AssignUnitAndUnitPrice(BatchPriceComponentItemModel model, int unitId, decimal unitPrice)
{
var unit = m_unitRepository.GetUnit(unitId);
model.UnitText = $"1 {unit.Symbol}";
model.UnitPrice = unitPrice;
}
