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