public async Task AddAdvert(BeanCreateAdvertDTO advert)
{
var formattedDate = advert.Date.ToString("yyyy MM dd");
var formattedString = formattedDate.Replace(" ", "-");
// SQL
try
{
using (var cmd = new NpgsqlCommand($"INSERT INTO beanadverts(bean_id,advert_date) VALUES({advert.BeanId},'{formattedString}')", _sqlConnection))
{
await cmd.ExecuteNonQueryAsync();
cmd.Dispose();
_sqlConnection.Close();
}
}
catch (Exception ex)
{
// Post errors to a logging service
Console.WriteLine(ex.InnerException);
}
}
public async Task <ActionResult> AddAdvert(BeanCreateAdvertDTO req)
{
await _adRepo.AddAdvert(req);
return(NoContent());
}
