public static void DeleteCustomer(NorthwindContext dbContext, string id)
{
try
{
Customer dataBaseCustomer = GetCustomerById(dbContext, id);
dbContext.Customers.Remove(dataBaseCustomer);
dbContext.SaveChanges();
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToDelete(InstanceName, id, ex.InnerException));
throw;
}
catch (Exception ex) when(ExceptionTypes.IsDbException(ex))
{
ex.SetMessage(DbExceptionMessages.UnexpectedFailure(ex));
throw;
}
}
public static void DeleteProduct(NorthwindContext dbContext, int id)
{
try
{
Product dataBaseProduct = GetProductById(dbContext, id);
dbContext.Products.Remove(dataBaseProduct);
dbContext.SaveChanges();
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToDelete(InstanceName, id, ex.InnerException));
throw;
}
catch (Exception ex) when(ExceptionTypes.IsDbException(ex))
{
ex.SetMessage(DbExceptionMessages.UnexpectedFailure(ex));
throw;
}
}
public static void UpdateEmployee(NorthwindContext dbContext, int id, EmployeeDTO modifiedEmployee)
{
try
{
Employee dataBaseEmployee = GetEmployeeById(dbContext, id);
modifiedEmployee.ModifyDataBaseEmployee(dataBaseEmployee);
dbContext.SaveChanges();
}
catch (Exception ex) when(ExceptionTypes.IsSqlException(ex))
{
ex.SetMessage(DbExceptionMessages.FailedToUpdate(InstanceName, id, 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 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 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;
}
}