public MemoryStream LoadRents()
{
var billing = IocContainer.Get <IBillingManager>();
var sins = billing.GetSinsInGame();
var result = new List <RentaDto>();
foreach (var sin in sins)
{
var rentas = billing.GetRentas(sin.Character.Model);
result.AddRange(rentas.Rentas);
}
return(ExcelWriter.CreateExcelAsStream(result));
}
public MemoryStream LoadTransfers()
{
var billing = IocContainer.Get <IBillingManager>();
var sins = billing.GetSinsInGame();
var allTransfers = new List <TransferDto>();
foreach (var sin in sins)
{
var transfers = billing.GetTransfers(sin.Character.Model);
var filteredTransfers = transfers.Transfers.Where(t => t.TransferType == TransferType.Incoming.ToString());
allTransfers.AddRange(filteredTransfers);
}
return(ExcelWriter.CreateExcelAsStream(allTransfers));
}
public MemoryStream LoadMainExcel()
{
var billing = IocContainer.Get <IBillingManager>();
var settings = IocContainer.Get <ISettingsManager>();
var sins = billing.GetSinsInGame();
var result = new List <MainExcelDto>();
var ikarkoef = settings.GetDecimalValue(SystemSettingsEnum.ikar_k);
var karmakoef = settings.GetDecimalValue(SystemSettingsEnum.karma_k);
var inflationkoef = settings.GetDecimalValue(SystemSettingsEnum.pre_inflation);
var lifestyle = BillingHelper.GetLifeStyleDto();
foreach (var sin in sins)
{
var allRents = billing.GetRentas(sin.Character.Model);
decimal karma = 0;
try
{
var eService = new EreminService();
karma = eService.GetCharacter(sin.Character.Model)?.workModel?.karma?.spent ?? 0;
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
}
var excelCharacter = new MainExcelDto
{
Balance = sin.Wallet.Balance,
PersonName = sin.Passport?.PersonName,
KarmaKoef = karmakoef,
InflationKoef = inflationkoef,
ScoringFix = sin.Scoring.CurrentFix,
ScoringRelative = sin.Scoring.CurerentRelative,
ModelId = sin.Character.Model.ToString(),
LifeStyle = lifestyle.GetLifeStyle(sin.Wallet).ToString(),
SumRents = allRents.Sum,
Karma = karma
};
result.Add(excelCharacter);
}
return(ExcelWriter.CreateExcelAsStream(result));
}