public async Task <IActionResult> GetFinalConsumption(string UserName, string indexConsumptionId)
{
FinalConsumption finalConsumption = new FinalConsumption();
string userId = _userRepository.GetIdByName(UserName);
finalConsumption = _consumptionContext.FinalConsumptions.Where(x => x.SmallUserId.Equals(userId)).Where(x => x.IndexConsumptionId.Equals(indexConsumptionId)).OrderBy(x => x.Id).Last();
return(Ok(finalConsumption));
}
public async Task <ActionResult> AddFinalConsumption(FinalConsumption model, string UserName, string indexConsumptionId)
{
var consumption = new FinalConsumption();
consumption.Data = DateTime.Now;
consumption.FinalConsumptionId = Guid.NewGuid().ToString();
//consumption.IndexConsumptionId = _userRepository.GetIdConsumptionByName(UserName);
consumption.IndexConsumptionId = indexConsumptionId;
consumption.SmallUserId = _userRepository.GetIdByName(UserName);
consumption.nrAppliances = _consumptionContext.Appliances.Where(x => x.SmallUserId.Equals(consumption.SmallUserId)).Where(x => x.IndexConsumptionId.Equals(indexConsumptionId)).Count();
List <Appliance> allAppliances = new List <Appliance>();
allAppliances = _consumptionContext.Appliances.Where(x => x.IndexConsumptionId.Equals(consumption.IndexConsumptionId)).ToList();
consumption.nrKw = _applianceRepository.GetTotalKw(allAppliances);
consumption.Price = _applianceRepository.GetTotalPrice(allAppliances);
await _consumptionContext.FinalConsumptions.AddAsync(consumption);
await _consumptionContext.SaveChangesAsync();
return(Ok(consumption));
}
