internal static void DeleteItemRecord(Shared.DTODefinition.IDtoObject record) { using (var ctx = new SI2_Entities()) { BidSoftware.Shared.DTODefinition.Item i = (BidSoftware.Shared.DTODefinition.Item)record; ctx.sp_deleteItem(i.ItemId); } }
internal static void AddItemRecord(Shared.DTODefinition.IDtoObject record) { using (var ctx = new SI2_Entities()) { BidSoftware.Shared.DTODefinition.Item rec = (BidSoftware.Shared.DTODefinition.Item)record; ctx.sp_addItem(rec.Description, rec.ItemConditionId, rec.UserEmail); } }
internal static void UpdateItemRecord(Shared.DTODefinition.IDtoObject record) { BidSoftware.Shared.DTODefinition.Item i = (BidSoftware.Shared.DTODefinition.Item)record; using (var ctx = new SI2_Entities()) { i = (BidSoftware.Shared.DTODefinition.Item)record; ctx.sp_editItem(i.ItemId, i.Description, i.ItemConditionId, i.UserEmail); } }
internal static IEnumerable <Shared.DTODefinition.IDtoObject> GetTableItemPage(int startRecord, int numRecords) { try { int idx = 0; LinkedList <BidSoftware.Shared.DTODefinition.Item> li = new LinkedList <BidSoftware.Shared.DTODefinition.Item>(); using (var ctx = new SI2_Entities()) { foreach (var item in ctx.vItems.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords))) { BidSoftware.Shared.DTODefinition.Item it = new BidSoftware.Shared.DTODefinition.Item(); it.ItemId = item.ItemId; it.Description = item.Description; it.ItemConditionId = item.ItemConditionId; it.UserEmail = item.UserEmail; li.AddLast(it); } } return(li); } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }