public IEnumerable <PartNumberHit> GetPartNumberHits() { const string MethodName = "GetPartNumberHits()"; try { using (QuantumEntities dc = new QuantumEntities()) { var query = (from quotedetail in dc.CQ_DETAIL where quotedetail.CQ_HEADER.DATE_CREATED.Value.Day == DateTime.Now.Day && quotedetail.CQ_HEADER.DATE_CREATED.Value.Month == DateTime.Now.Month && quotedetail.CQ_HEADER.DATE_CREATED.Value.Year == DateTime.Now.Year && (quotedetail.ROUTE_DESC != "Misc" && quotedetail.ROUTE_DESC != "Freight" && quotedetail.ROUTE_DESC != "Labor") && quotedetail.PARTS_MASTER.PN != "DOT31FP COMPLIANT BOX" orderby quotedetail.CQ_HEADER.DATE_CREATED.Value descending group quotedetail by quotedetail.PARTS_MASTER.PN into grp where grp.Count() > 2 select new PartNumberHit { PartNumber = grp.Key, Hits = grp.Count() }).OrderByDescending(y => y.Hits); return(query.Take(5).ToList()); } } catch (Exception ex) { throw new Exception(CLASSID + ":" + MethodName + " " + ex.Message); } }
public IEnumerable <Quote> GetQuoteFeeds() { const string MethodName = "GetQuoteFeeds()"; try { using (QuantumEntities dc = new QuantumEntities()) { var query = from quotedetail in dc.CQ_DETAIL where quotedetail.CQ_HEADER.DATE_CREATED.Value.Day == DateTime.Now.Day && quotedetail.CQ_HEADER.DATE_CREATED.Value.Month == DateTime.Now.Month && quotedetail.CQ_HEADER.DATE_CREATED.Value.Year == DateTime.Now.Year orderby quotedetail.CQ_HEADER.DATE_CREATED.Value descending select new Quote { QuoteNumber = quotedetail.CQ_HEADER.CQ_NUMBER, PartNumber = quotedetail.PARTS_MASTER.PN, Description = quotedetail.PARTS_MASTER.DESCRIPTION, Date = quotedetail.CQ_HEADER.DATE_CREATED.Value, Type = quotedetail.ROUTE_DESC, Currency = quotedetail.CQ_HEADER.CURRENCY.CURRENCY_CODE, UnitPrice = quotedetail.CUSTOMER_PRICE.Value, Customer = quotedetail.CQ_HEADER.BILL_NAME, Employee = quotedetail.SYS_USERS.EMPLOYEE_CODE, Quantity = quotedetail.QTY_QUOTED.Value, TotalAmount = (quotedetail.CUSTOMER_PRICE.Value * quotedetail.QTY_QUOTED.Value) }; return(query.ToList()); } } catch (Exception ex) { throw new Exception(CLASSID + ":" + MethodName + " " + ex.Message); } }
public QuantumRepository(QuantumEntities context) { this.context = context; this.dbset = context.Set <T>(); }