private IEnumerable <IRecordView> GetTableActiveAuctionsPage() { try { LinkedList <BidSoftware.Shared.DTODefinition.ActiveAuction> li = new LinkedList <BidSoftware.Shared.DTODefinition.ActiveAuction>(); BidSoftware.Shared.DTODefinition.ActiveAuction a; using (var ctx = new SI2_Entities()) { foreach (var auc in ctx.V_ActiveAuctions) { a = new BidSoftware.Shared.DTODefinition.ActiveAuction(); a.SaleId = auc.SaleId; a.StartDate = auc.StartDate; a.EndDate = auc.EndDate; a.Description = auc.Description; a.UserEmail = auc.UserEmail; a.Value = Convert.ToDecimal(auc.Value); li.AddLast(a); } } return(li); } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }
public void AddBid(int saleId, string userName, decimal value) { try { using (var ctx = new SI2_Entities()) { ctx.sp_addBid(saleId, userName, value); } } catch (Exception ex) { throw new DisconnectException(Utils.whatexception(ex).Message, ex); } }
public void TestConnection() { //simplesmente para testar a ligação try { using (var ctx = new SI2_Entities()) { var cond = ctx.ItemConditions.Where(p => p.Id == 1); if (cond == null) { throw new DisconnectException("Não foi detectado condições de itens"); } } } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }
public bool IsValidUser(Credentials creds) { try { //credentials = creds; using (var ctx = new SI2_Entities()) { ObjectParameter result = new ObjectParameter("result", typeof(int)); var a = ctx.sp_validateUser(creds.Username, creds.Password, result); bool re = Convert.ToBoolean(result.Value); return(re); } } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }
public Shared.Export.Auction ExportAuctionData(int auctionId) { List <BidSoftware.Shared.Export.Bid> lb = new List <BidSoftware.Shared.Export.Bid>(); try { using (var ctx = new SI2_Entities()) { var auc = ctx.vAuctions.Where(a => a.SaleId == auctionId).SingleOrDefault(); if (auc == null) { throw new ArgumentException("Não existe o leilão com id " + auctionId); } var bids = ctx.vBids.Where(b => b.SaleId == auctionId); foreach (var bi in bids) { BidSoftware.Shared.Export.Bid newbid = new BidSoftware.Shared.Export.Bid(); newbid.UserId = bi.UserEmail; newbid.Datetime = bi.Stamp.ToString(); lb.Add(newbid); } Shared.Export.Auction auctionExport = new Shared.Export.Auction() { Id = "cenas entity", Info = new Info() { InitialDate = auc.StartDate.ToString(), MinimumBid = auc.MinIncrement.ToString(), ReservationPrice = auc.SaleValue.ToString() }, Bids = new Bids() { Num = lb.Count().ToString(), ArrayBid = lb.ToArray() } }; return(auctionExport); } } catch (Exception ex) { throw new DisconnectException(ex.Message, ex); } }