internal static IEnumerable <Shared.DTODefinition.IDtoObject> GetTableAuctionPage(int startRecord, int numRecords) { try { LinkedList <BidSoftware.Shared.DTODefinition.Auction> li = new LinkedList <BidSoftware.Shared.DTODefinition.Auction>(); BidSoftware.Shared.DTODefinition.Auction auc; using (var ctx = new SI2_Entities()) { foreach (var auction in ctx.vAuctions.Where(p => (p.ROW_NR >= startRecord) && (p.ROW_NR <= startRecord + numRecords))) { auc = new BidSoftware.Shared.DTODefinition.Auction(); auc.SaleId = auction.SaleId; auc.StartDate = auction.StartDate; auc.EndDate = auction.EndDate; auc.Location = auction.Location; auc.ItemId = auction.ItemId; auc.SaleValue = auction.SaleValue; auc.MinIncrement = auction.MinIncrement; li.AddLast(auc); } } return(li); } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }
internal static void DeleteAuctionRecord(Shared.DTODefinition.IDtoObject record) { using (var ctx = new SI2_Entities()) { BidSoftware.Shared.DTODefinition.Auction a = (BidSoftware.Shared.DTODefinition.Auction)record; ctx.sp_deleteAuctionSale(a.SaleId); } }
internal static void AddAuctionRecord(Shared.DTODefinition.IDtoObject record) { using (var ctx = new SI2_Entities()) { BidSoftware.Shared.DTODefinition.Auction rec = (BidSoftware.Shared.DTODefinition.Auction)record; ctx.sp_addAuctionSale(rec.ItemId, rec.SaleValue, rec.StartDate, rec.EndDate, rec.Location, rec.CountryNum, rec.MinIncrement); } }
internal static void UpdateAuctionRecord(Shared.DTODefinition.IDtoObject record) { BidSoftware.Shared.DTODefinition.Auction a = (BidSoftware.Shared.DTODefinition.Auction)record; using (var ctx = new SI2_Entities()) { a = (BidSoftware.Shared.DTODefinition.Auction)record; ctx.sp_editAuctionSale(a.SaleId, a.SaleValue, a.StartDate, a.EndDate, a.Location, a.MinIncrement, a.ItemId, a.CountryNum); } }