public async Task Update(FundDTO fundDTO)
{
var fund = _mapper.Map <Fund>(fundDTO);
await _fundRepo.Update(fund);
_db.Commit();
}
public static async Task <Fund> ToFund(
this FundDTO dto,
IRepository <Transaction> transactionsRepository) => new Fund()
{
Id = dto.Id,
Name = dto.Name,
Description = dto.Description,
Transactions = (List <Transaction>) await transactionsRepository.GetByIdsAsync(dto.TransactionsId)
};
public async Task <Guid> Add(FundDTO transactionDTO)
{
var fund = _mapper.Map <Fund>(transactionDTO);
fund.Id = Guid.NewGuid();
await _fundRepo.Add(fund);
_db.Commit();
return(fund.Id);
}
public async Task <Guid?> CreateAsync(FundDTO project)
{
var identityName = User.Identity.Name;
Guid userId = (Guid)ur.GetID(identityName);
project.id_user = userId;
var projectId = await _fundRepository.CreateAsync(project);
return(projectId);
}
public static FinancialAccount Translate(FundDTO inputAccount)
{
var financialAccount = new FinancialAccount
{
Id = inputAccount.Id,
Name = inputAccount.Name,
IsTaxDeductible = true
};
return(financialAccount);
}
public static async Task <Fund> ToEntityAsync(
this FundDTO item,
IRepository <Transaction> transactionsRepository,
CancellationToken token) =>
new Fund(
new Identificator(item.Id),
item.Name,
item.Description,
item.TransactionsIds != null ?
await transactionsRepository.GetByIdsAsync(
item?.TransactionsIds?.Select(t => new Identificator(t)).ToArray(), token) : null);
public static void Save(FundDTO fund)
{
DB DB = new DB();
Fund fundDal = DB.Funds.FirstOrDefault(f => f.FundId == fund.Id);
fundDal.required_vip = fund.required_vip;
//fundDal.remark= fund.remark;
fundDal.required_months = fund.Required_months;
DB.SaveChanges();
}
public static Fund DTOtoDAL(FundDTO fund)
{
Fund nFund = new Fund()
{
NameStatus = fund.Status,
comments = fund.Comments,
Date_create = fund.date_create,
fund_name = fund.Fund_name,
required_months = fund.Required_months,
required_vip = fund.required_vip,
Balance = fund.balance
};
return(nFund);
}
public static FundDTO DALtoDTO(Fund fund)
{
FundDTO Nfund = new FundDTO()
{
Comments = fund.comments,
date_create = (DateTime)fund.Date_create.GetValueOrDefault(),
Fund_name = fund.fund_name,
Id = fund.FundId,
Required_months = (int)fund.required_months.GetValueOrDefault(),
required_vip = (bool)fund.required_vip.GetValueOrDefault(),
Status = fund.NameStatus,
balance = fund.Balance
};
return(Nfund);
}
public static FundDTO GetById(string id)
{
FundDTO Fund = new FundDTO();
DB db = new DB();
foreach (Fund fund in db.Funds)
{
if (fund.FundId == id)
{
Fund = FundConvert.DALtoDTO(fund);
Fund.Futurbalance = GetFutureBalance(id, DateTime.Now.AddMonths(1));
return(Fund);
}
}
return(null);
}
/// <summary>
/// Get the Funds from PCO.
/// </summary>
/// <returns></returns>
private static List <FundDTO> GetFunds()
{
var funds = new List <FundDTO>();
var fundQuery = GetAPIQuery(ApiEndpoint.API_FUNDS);
if (fundQuery == null)
{
return(funds);
}
foreach (var item in fundQuery.Items)
{
var fund = new FundDTO(item);
if (fund != null)
{
funds.Add(fund);
}
}
return(funds);
}
public async Task <Guid?> AddNewFundAsync(FundDTO fund)
{
var sqlQuery = "INSERT INTO fund " +
"(name_text, description "
+ ") " +
"VALUES('"
+ fund.name_text + "','" + fund.description + "'"
+ ")"
+ " RETURNING fund.id";
try
{
using (var dbConnection = new NpgsqlConnection(connectionString))
{
this.LogQuery(sqlQuery);
Guid?fundId = await dbConnection.ExecuteScalarAsync <Guid>(sqlQuery, fund);
return((Guid)fundId);
}
}
catch (NpgsqlException exception)
{
this._loggerError.WriteLn(
$"Ошибка в {nameof(FundRepository)}.{nameof(FundRepository.AddNewFundAsync)} {nameof(NpgsqlException)} ",
exception);
return(null);
}
catch (Exception exception)
{
this._loggerError.WriteLn(
$"Ошибка в {nameof(FundRepository)}.{nameof(FundRepository.AddNewFundAsync)} {nameof(Exception)} ",
exception);
return(null);
}
}
public void Save([FromBody] FundDTO fund)
{
FundBL.Save(fund);
}
