public async Task <bool> AddSupplierResponse(List <AgencySupplierResponseEntity> message)
{
bool isUpdated = false;
try
{
using (var _ctx = new MediationEntities())
{
message.ForEach(_ =>
{
_ctx.tblAgencySeacrhDetails.Add(new tblAgencySeacrhDetail()
{
AgencyCode = _.AgencyCode,
SearchDateTime = _.SearchDateTime,
Status = _.Status,
SupplierCode = _.SupplierCode,
Search = _.Search,
Key = _.Key
});
});
await _ctx.SaveChangesAsync();
isUpdated = true;
return(isUpdated);
}
}
catch (DbEntityValidationException e)
{
var outputLines = new List <string>();
foreach (var eve in e.EntityValidationErrors)
{
outputLines.Add(string.Format("{0}: Entity of type \"{1}\" in state \"{2}\" has the following validation errors:", DateTime.Now, eve.Entry.Entity.GetType().Name, eve.Entry.State));
foreach (var ve in eve.ValidationErrors)
{
outputLines.Add(string.Format("- Property: \"{0}\", Error: \"{1}\"", ve.PropertyName, ve.ErrorMessage));
}
}
return(isUpdated);
}
catch (Exception ex)
{
throw;
}
}
