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()); }