public void Insert(ClientDomain newItem) { var sql = Sql.Builder.Append(" INSERT INTO Client (TypeId, FirstName, Surname, BusinessName) ") .Append(" VALUES (@0, @1, @2, @3) ", EnumHelper.EnumTextToInt(newItem.ClientType, typeof(Enums.ClientType)), newItem.FirstName, newItem.Surname, newItem.BusinessName); DataContext.Execute(sql); }
public void Update(ClientDomain editedItem) { var sql = Sql.Builder.Append("UPDATE Client ") .Append(" SET TypeId = @0, FirstName = @1, Surname = @2, BusinessName = @3 ", EnumHelper.EnumTextToInt(editedItem.ClientType, typeof(Enums.ClientType)), editedItem.FirstName, editedItem.Surname, editedItem.BusinessName) .Append(" WHERE ID = @0 ", editedItem.Id); DataContext.Execute(sql); }