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