/// <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;
}
public void RemoveItemsRow(ItemsRow row)
{
this.Rows.Remove(row);
}
public void AddItemsRow(ItemsRow row)
{
this.Rows.Add(row);
}
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
});
}
}
}
}
