public List <DTO_Offer> GetOffersByPartDesc(DTO_Part p) { //string partDesc = p.partDesc; DB_111206_scrapEntities db = new DB_111206_scrapEntities(); var listOffers = db.Offers.ToList(); var matches = listOffers.Where(x => x.Part.partDesc.Contains(p.Description)).ToList(); List <DTO_Offer> offers = new List <DTO_Offer>(); foreach (var offer in matches) { var o = new DTO_Offer { Id = offer.offerID, /* Parts = offer.partsID,// partsID), * Seller = Convert.ToInt32(offer.sellerID), */ Price = Convert.ToInt32(offer.price), Ostat = Convert.ToInt32(offer.ostat), DT = offer.offerDate }; offers.Add(o); } return(offers); }
public List <DTO_Offer> GetOffers() { DB_111206_scrapEntities db = new DB_111206_scrapEntities(); List <DTO_Offer> returnOffers = new List <DTO_Offer>(); var offersTable = db.Offers.ToList(); foreach (var o in offersTable) { DTO_Offer tempO = new DTO_Offer { DT = o.offerDate, Id = o.offerID, Ostat = Convert.ToInt32(o.ostat), PartId = Convert.ToInt32(o.partsID), Price = Convert.ToDouble(o.price), SellerId = Convert.ToInt32(o.sellerID) }; returnOffers.Add(tempO); } return(returnOffers); }
public List <DTO_Offer> GetOffersByUser(DTO_User user) { List <DTO_Offer> offers = new List <DTO_Offer>(); using (DB_111206_scrapEntities db = new DB_111206_scrapEntities()) { var match = db.Users.Where(u => u.email == user.Email && u.pwd == user.Password).FirstOrDefault(); if (match != null) { var offers_ = match.Offers.ToList(); foreach (var i in offers_) { DTO_Offer bid = new DTO_Offer(); i.offerID = bid.Id; i.offerDate = bid.DT; i.price = (decimal)bid.Price; offers.Add(bid); } } } return(offers); }