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); } }