public IAddReferenceListSyntax AddItem(long value, string item, Int64?orderIndex = null, string description = null)
{
var listItem = new ReferenceListItemDefinition {
Item = item,
ItemValue = value,
OrderIndex = orderIndex,
Description = description
};
var addRefListItem = new AddReferenceListItemExpression
{
Item = listItem,
Namespace = Expression.Namespace,
Name = Expression.Name
};
_context.Expressions.Add(addRefListItem);
return(this);
}
internal Guid InsertReferenceListItem(Guid refListId, ReferenceListItemDefinition item)
{
var id = Guid.NewGuid();
var sql = @"INSERT INTO Frwk_ReferenceListItems
(Id
,TenantId
,Description
,HardLinkToApplication
,Item
,ItemValue
,OrderIndex
,ParentId
,ReferenceListId)
VALUES
(@Id
,@TenantId
,@Description
,@HardLinkToApplication
,@Item
,@ItemValue
,@OrderIndex
,@ParentId
,@ReferenceListId)";
ExecuteNonQuery(sql, command => {
command.AddParameter("@Id", id);
command.AddParameter("@TenantId", null);
command.AddParameter("@Description", item.Description);
command.AddParameter("@HardLinkToApplication", 0);
command.AddParameter("@Item", item.Item);
command.AddParameter("@ItemValue", item.ItemValue);
command.AddParameter("@OrderIndex", item.OrderIndex ?? item.ItemValue);
command.AddParameter("@ParentId", null);
command.AddParameter("@ReferenceListId", refListId);
});
return(id);
}