PIES REport stuff

gistfile1.cs

            List<Part> parts = new List<Part>();
            int partcount = db.CustomerReportParts.Where(x => x.customerID.Equals(customerID)).Select(x => x.partID).Count();

            if (start == null) {
                if (partcount == 0) {
                    parts = db.Parts.OrderBy(x => x.partID).ToList<Part>();
                } else {
                    parts = (from p in db.Parts
                             join crp in db.CustomerReportParts on p.partID equals crp.partID
                             orderby p.partID
                             select p).ToList<Part>();
                }
            } else {
                if (partcount == 0) {
                    parts = db.Parts.Where(x => x.dateModified >= start).OrderBy(x => x.partID).ToList<Part>();
                } else {
                    parts = (from p in db.Parts
                             join crp in db.CustomerReportParts on p.partID equals crp.partID
                             where p.dateModified >= start
                             orderby p.partID
                             select p).ToList<Part>();
                }
            }