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