public static List <VME> GetProductBusiness(DateTime fromdate, DateTime todate, string reference) { List <VME> BusinessList = new List <VME>(); erp_dataEntities2 db = new erp_dataEntities2(); var list = (from n in db.Invoices join c in db.InvoiceItems on n.Id equals c.IdInvoice join cl in db.Clients on n.IdClient equals cl.Id where (n.CreationDate >= fromdate) where (n.CreationDate < todate) where c.Code == reference group c by cl.Title into g select new { quantity = g.Sum(c => c.quantity), Client_Title = g.Key }).ToList(); foreach (var item in list) { Client client = UsersManager.GetClientByTitle(item.Client_Title); VME vme = new VM.VME() { quantity = item.quantity, ClientTitle = item.Client_Title, code = reference, color = client.Color }; BusinessList.Add(vme); } return(BusinessList); }
public static List <VME> GetBusinessNumber(string strDate) { DateTime date = Convert.ToDateTime(strDate); List <VME> BusinessList = new List <VME>(); for (int i = 1; i < 12; i++) { DateTime dateIn = date.AddDays(30 * (i - 1)); DateTime dateout = date.AddDays(30 * (i)); erp_dataEntities2 db = new erp_dataEntities2(); var BN = (from n in db.Invoices where (n.CreationDate >= dateIn) where (n.CreationDate < dateout) select new { BusinessNumber = n.TotalPrice }).Sum(x => x.BusinessNumber); decimal decBusinessNumber = 0; if (BN != null) { decBusinessNumber = Convert.ToDecimal(BN); } VME vme = new VM.VME() { BusinessNumber = decBusinessNumber }; BusinessList.Add(vme); } return(BusinessList); }