public void DeletePhoneNumber(BusinessObjects.PersonPhone phoneNumber)
{
// SQL query deleting row from Person.PersonPhone
string query = "DELETE FROM Person.PersonPhone "
+ "WHERE BusinessEntityID = @BusinessEntityID AND PhoneNumber = @PhoneNumber AND PhoneNumberTypeID = @PhoneNumberTypeID";
// Execute query
cnn.Execute(query, phoneNumber.MapToParams());
}
public void UpdateEmployee(BusinessObjects.Employee employee)
{
// Paramaterised SQL query, update both tables
string query = "UPDATE HumanResources.Employee SET JobTitle = @JobTitle WHERE BusinessEntityID = @BusinessEntityID; "
+ "UPDATE Person.Person SET FirstName = @FirstName, MiddleName = @MiddleName, LastName = @LastName WHERE BusinessEntityID = @BusinessEntityID";
// Send SQL to DB
int rowsAffected = cnn.Execute(query, employee.MapToParams());
}
public void AddPhoneNumber(BusinessObjects.PersonPhone phoneNumber)
{
// SQL query adding new row to Person.PersonPhone
string query = "INSERT INTO Person.PersonPhone (BusinessEntityID, PhoneNumber, PhoneNumberTypeID) "
+ "VALUES (@BusinessEntityID, @PhoneNumber, @PhoneNumberTypeID)";
// Execute query
cnn.Execute(query, phoneNumber.MapToParams());
}
