/// <summary> /// Gets an item with the specified name. /// Name cannot be null or empty string. /// Side effects: If the name is not found in the table, a new /// row is created. /// </summary> /// <param name="itemName">The name to search for.</param> /// <returns>The ItemsRow containing the specified item name.</returns> public ItemsRow GetItem(string itemName) { if (string.IsNullOrEmpty(itemName)) { throw new ArgumentNullException("itemName"); } // Max length of items allowed in database. if (itemName.Length > 32) { itemName = itemName.Substring(0, 32); } ItemsRow item = null; // Get the row for the action name item = FindByItemName(itemName); if (item == null) { item = AddItemsRow(itemName); } return(item); }
public ItemsRow AddItemsRow(int isbn, int title_no, string translation, string cover, string loanable, string title, string author, string synopsis, int isbn1, short copy_no, int title_no2, short member_no, System.DateTime out_date, System.DateTime due_date, string on_loan) { ItemsRow rowItemsRow = ((ItemsRow)(this.NewRow())); rowItemsRow.ItemArray = new object[] { isbn, title_no, translation, cover, loanable, null, title, author, synopsis, isbn1, copy_no, title_no2, member_no, out_date, due_date, on_loan }; this.Rows.Add(rowItemsRow); return(rowItemsRow); }
public AddOrUpdateItems(int id) { InitializeComponent(); row = itemsTableAdapter1.GetData().FirstOrDefault(p => p.Id == id); txtName.Text = row.Name; isNew = false; }
public override bool CopyItem( [NotNull] ItemDefinition source, [NotNull] ItemDefinition destination, [NotNull] string copyName, [NotNull] ID copyID, [NotNull] CallContext context) { lock (this) { var item = Items[source.ID]; Items[copyID] = new ItemsRow { ItemID = copyID, Name = item.Name, ParentID = destination.ID, TemplateID = item.TemplateID, BranchID = item.BranchID }; Items[destination.ID].Children.Add(copyID); Action <Dictionary <ID, List <FieldsRow> > > copyList = dict => dict[copyID] = new List <FieldsRow>( dict[source.ID].Select( field => new FieldsRow { FieldID = field.FieldID, ItemID = copyID, Language = field.Language, Version = field.Version, Value = field.Value })); copyList(SharedFields); copyList(UnversionedFields); copyList(VersionedFields); return(true); } }
public override bool CreateItem( [NotNull] ID itemID, [NotNull] string itemName, [NotNull] ID templateID, [NotNull] ItemDefinition parent, [NotNull] CallContext context) { Assert.ArgumentNotNullOrEmpty(itemID, nameof(itemID)); Assert.ArgumentNotNullOrEmpty(itemName, nameof(itemName)); Assert.ArgumentNotNullOrEmpty(templateID, nameof(templateID)); Assert.ArgumentNotNull(parent, nameof(parent)); Assert.ArgumentNotNull(context, nameof(context)); lock (this) { if (ItemExists(itemID)) { return(true); } Items[itemID] = new ItemsRow { ItemID = itemID, Name = itemName, TemplateID = templateID, BranchID = Data.ID.Null, ParentID = parent.ID }; ItemsRow parentItem; if (Items.TryGetValue(parent.ID, out parentItem)) { parentItem.Children.Add(itemID); } return(true); } }
/// <summary> /// Saves the specified itm in the configuration data set. /// </summary> /// <param name="item">The item.</param> /// <param name="parentKey">The parent key.</param> /// <returns></returns> public long Save(Opc.Da.Item item, long parentKey) { ItemsRow row = NewItemsRow(); //TODO assign rw.Async = ???? //TODO assign rw.Conversion = ????? row.ID_Subscription = parentKey; row.RequestedType = item.ReqType; if (item.MaxAgeSpecified) { row.MaxAge = item.MaxAge; } if (item.ActiveSpecified) { row.Active = item.Active; } if (item.DeadbandSpecified) { row.Deadband = item.Deadband; } if (item.SamplingRateSpecified) { row.SamplingRate = item.SamplingRate; } if (item.EnableBufferingSpecified) { row.EnableBuffering = item.EnableBuffering; } row.Name = item.ItemName; if (!string.IsNullOrEmpty(item.ItemPath)) { row.ItemPath = item.ItemPath; } this.AddItemsRow(row); return(row.ID); }
public ItemsRowChangeEvent(ItemsRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }
public OrderDetailsRow AddOrderDetailsRow(OrdersRow parentOrdersRowByFK_OrderDetails_Orders, ItemsRow parentItemsRowByFK_OrderDetails_Items, string ItemCode, string ItemName, string MeasureCode, string MeasureName, double Quantity, double UnitPrice, double TaxPct, int TrxType, string Remarks, OrdersRow parentOrdersRowByFK_OrderDetails_Reference, string ReferenceNo, System.DateTime ReferenceDate, double ReferenceValue) { OrderDetailsRow rowOrderDetailsRow = ((OrderDetailsRow)(this.NewRow())); object[] columnValuesArray = new object[] { null, null, null, ItemCode, ItemName, MeasureCode, MeasureName, Quantity, UnitPrice, TaxPct, TrxType, Remarks, null, ReferenceNo, ReferenceDate, ReferenceValue}; if ((parentOrdersRowByFK_OrderDetails_Orders != null)) { columnValuesArray[1] = parentOrdersRowByFK_OrderDetails_Orders[0]; } if ((parentItemsRowByFK_OrderDetails_Items != null)) { columnValuesArray[2] = parentItemsRowByFK_OrderDetails_Items[0]; } if ((parentOrdersRowByFK_OrderDetails_Reference != null)) { columnValuesArray[12] = parentOrdersRowByFK_OrderDetails_Reference[0]; } rowOrderDetailsRow.ItemArray = columnValuesArray; this.Rows.Add(rowOrderDetailsRow); return rowOrderDetailsRow; }
public ItemInventoriesRow AddItemInventoriesRow(ItemsRow parentItemsRowByFK_ItemInventories_Items, string ItemCode, string ItemName, WarehousesRow parentWarehousesRowByFK_ItemInventories_Warehouse, string WarehouseCode, string WarehouseName, double Quantity, string MeasureCode, string MeasureName) { ItemInventoriesRow rowItemInventoriesRow = ((ItemInventoriesRow)(this.NewRow())); object[] columnValuesArray = new object[] { null, ItemCode, ItemName, null, WarehouseCode, WarehouseName, Quantity, MeasureCode, MeasureName}; if ((parentItemsRowByFK_ItemInventories_Items != null)) { columnValuesArray[0] = parentItemsRowByFK_ItemInventories_Items[0]; } if ((parentWarehousesRowByFK_ItemInventories_Warehouse != null)) { columnValuesArray[3] = parentWarehousesRowByFK_ItemInventories_Warehouse[0]; } rowItemInventoriesRow.ItemArray = columnValuesArray; this.Rows.Add(rowItemInventoriesRow); return rowItemInventoriesRow; }
public void RemoveItemsRow(ItemsRow row) { this.Rows.Remove(row); }
public void AddItemsRow(ItemsRow row) { this.Rows.Add(row); }
public ItemsRowChangeEvent(ItemsRow row, System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; }
private void LoadItem(string file) { using (var reader = File.OpenText(file)) { var item = SyncItem.ReadItem(new Tokenizer(reader)); var itemId = new ID(item.ID); var parentId = new ID(item.ParentID); var templateId = new ID(item.TemplateID); var branchId = new ID(item.BranchId); if (!Items.ContainsKey(itemId)) { Items[itemId] = new ItemsRow { ItemID = itemId, Name = item.Name, ParentID = parentId, BranchID = branchId, TemplateID = templateId }; } Items[itemId].ParentID = parentId; Items[itemId].TemplateID = templateId; Items[itemId].BranchID = branchId; Items[itemId].Name = item.Name; if (parentId != Data.ID.Null) { if (!Items.ContainsKey(parentId)) { Items[parentId] = new ItemsRow { ItemID = parentId, Name = "(unknown)", ParentID = Data.ID.Null, BranchID = Data.ID.Null, TemplateID = Data.ID.Null }; } Items[parentId].Children.Add(itemId); } foreach (var field in item.SharedFields) { var fieldId = new ID(field.FieldID); SharedFields[itemId].Add( new FieldsRow { ItemID = itemId, FieldID = fieldId, Value = field.FieldValue }); } foreach (var version in item.Versions) { var versionNumber = MainUtil.GetInt(version.Version, 0); foreach (var field in version.Fields) { var fieldId = new ID(field.FieldID); VersionedFields[itemId].Add( new FieldsRow { ItemID = itemId, FieldID = fieldId, Language = version.Language, Version = versionNumber, Value = field.FieldValue }); } } } }