public Contact Add(Contact contact) { var sql = "INSERT INTO Person.Contact (FirstName, LastName) VALUES(@FirstName, @LastName); " + "SELECT CAST(SCOPE_IDENTITY() as int)"; var id = this.db.Query<int>(sql, contact).Single(); contact.ContactID = id; return contact; }
public Contact Update(Contact contact, int key) { var sql = "UPDATE Person.Contact " + "SET FirstName = @FirstName, " + " LastName = @LastName, " + " Email = @Email, " + " Company = @Company, " + " Title = @Title " + "WHERE ContactID = @Id"; this.db.Execute(sql, contact); return contact; }
public void Delete(Contact contact) { this.db.Execute("DELETE FROM Person.Contact WHERE Id = @Id", new { contact.ContactID }); }
public Task<Contact> UpdateAsync(Contact updated, int key) { throw new NotImplementedException(); }
public Task<int> DeleteAsync(Contact t) { throw new NotImplementedException(); }
public Task<Contact> AddAsync(Contact t) { throw new NotImplementedException(); }