public static int AddNewProduct(NorthwindContext dbContext, ProductDTO newProduct)
{
try
{
Product dataBaseProduct = newProduct.GetDataBaseProductObject();
dbContext.Products.Add(dataBaseProduct);
dbContext.SaveChanges();
return(dataBaseProduct.ProductId);
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToAdd(InstanceName, ex.InnerException));
throw;
}
catch (Exception ex) when(ExceptionTypes.IsDbException(ex))
{
ex.SetMessage(DbExceptionMessages.UnexpectedFailure(ex));
throw;
}
}
public static string AddNewCustomer(NorthwindContext dbContext, CustomerDTO newCustomer)
{
try
{
Customer dataBaseCustomer = newCustomer.GetDataBaseCustomerObject();
dbContext.Customers.Add(dataBaseCustomer);
dbContext.SaveChanges();
return(dataBaseCustomer.CustomerId);
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToAdd(InstanceName, ex.InnerException));
throw;
}
catch (Exception ex) when(ExceptionTypes.IsDbException(ex))
{
ex.SetMessage(DbExceptionMessages.UnexpectedFailure(ex));
throw;
}
}
public static int AddNewEmployee(NorthwindContext dbContext, EmployeeDTO newEmployee)
{
try
{
Employee dataBaseEmployee = newEmployee.GetDataBaseEmployeeObject();
dbContext.Employees.Add(dataBaseEmployee);
dbContext.SaveChanges();
return(dataBaseEmployee.EmployeeId);
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToAdd(InstanceName, ex.InnerException));
throw;
}
catch (Exception ex) when(ExceptionTypes.IsDbException(ex))
{
ex.SetMessage(DbExceptionMessages.UnexpectedFailure(ex));
throw;
}
}