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>();
}
