public async Task <Guid?> CreateAsync(IndividualDTO project)
{
var identityName = User.Identity.Name;
Guid userId = (Guid)ur.GetID(identityName);
project.ID_User = userId;
var projectId = await _individRepository.CreateAsync(project);
return(projectId);
}
public async Task <Guid?> AddNewIndividAsync(IndividualDTO individ)
{
var sqlQuery = "INSERT INTO individual " +
"(name_text_first, description_first, name_text_second, description_second, name_text_third, description_third, name_text_fourth, description_fourth, name_text_fifth, description_fifth, date_time_added, id_user "
+ ") " +
"VALUES('"
+ individ.name_text_first + "','" + individ.description_first + "'"
+ individ.name_text_second + "','" + individ.description_second + "'"
+ individ.name_text_third + "','" + individ.description_third + "'"
+ individ.name_text_fourth + "','" + individ.description_fourth + "'"
+ individ.name_text_fifth + "','" + individ.description_fifth + "'"
+ individ.data_create + "','" + individ.ID_User + "'"
+ ")"
+ " RETURNING individual.id";
try
{
using (var dbConnection = new NpgsqlConnection(connectionString))
{
this.LogQuery(sqlQuery);
Guid?individId = await dbConnection.ExecuteScalarAsync <Guid>(sqlQuery, individ);
return((Guid)individId);
}
}
catch (NpgsqlException exception)
{
this._loggerError.WriteLn(
$"Ошибка в {nameof(IndividualRepository)}.{nameof(IndividualRepository.AddNewIndividAsync)} {nameof(NpgsqlException)} ",
exception);
return(null);
}
catch (Exception exception)
{
this._loggerError.WriteLn(
$"Ошибка в {nameof(IndividualRepository)}.{nameof(IndividualRepository.AddNewIndividAsync)} {nameof(Exception)} ",
exception);
return(null);
}
}
