public string AddJob(Job jobDetails, DbContextType dbContextType)
{
var result = string.Empty;
try {
switch (dbContextType)
{
case DbContextType.RFSTAGINGCONTEXT:
_dbContextRFStaging.Jobs.Add(jobDetails);
_dbContextRFStaging.SaveChanges();
break;
case DbContextType.SOURCEDATACONTEXT:
_dbContextSourceData.Jobs.Add(jobDetails);
_dbContextSourceData.SaveChanges();
break;
default:
throw new NotImplementedException();
}
return(jobDetails.JobId.ToString());
}
catch (DbEntityValidationException e) {
result = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
result += string.Format("{0}: {1} || ", ve.PropertyName, ve.ErrorMessage);
}
}
return(result);
}
catch (Exception ex) {
return(ex.Message.ToString());
}
}
public string AddJob(DTO.Job jobDetails)
{
var result = string.Empty;
try {
_dbContextRFStaging.Jobs.Add(jobDetails);
_dbContextRFStaging.SaveChanges();
return(jobDetails.JobId.ToString());
}
catch (DbEntityValidationException e) {
result = string.Empty;
foreach (var eve in e.EntityValidationErrors)
{
foreach (var ve in eve.ValidationErrors)
{
result += string.Format("{0}: {1} || ", ve.PropertyName, ve.ErrorMessage);
}
}
return(result);
}
catch (Exception ex) {
return(ex.Message.ToString());
}
}
