public void FillGeneralFollowUpsWithProductGroups()
{
GeneralFollowUps.Clear();
var tempGroupsAdded = new List <string>();
var products = from d in db.Product
select d;
var cps = from c in db.CostProduct
select c;
foreach (var product in products)
{
foreach (var cp in cps)
{
if (product.ProductID.Equals(cp.CeProductID))
{
GeneralFollowUp gfu = new GeneralFollowUp();
gfu.ObjectID = product.ProductGroupID;
gfu.ObjectName = product.ProductGroup.ProductGroupName;
gfu.Date = cp.CeIncomeDate;
// Prevent same department from being added more than once
if (!tempGroupsAdded.Contains(product.ProductGroupID))
{
GeneralFollowUps.Add(gfu);
}
tempGroupsAdded.Add(product.ProductGroupID);
}
}
}
}
public void FillGeneralFollowUpsWithCompany()
{
GeneralFollowUps.Clear();
var products = from d in db.CostProduct
select d;
GeneralFollowUp gfu = new GeneralFollowUp();
DateTime date = DateTime.ParseExact("20000101", "yyyyMMdd", CultureInfo.InvariantCulture);
foreach (var item in products)
{
gfu.Costs += item.CeAmount;
if (item.CeIncomeDate > date)
{
date = item.CeIncomeDate;
}
}
gfu.ObjectName = "Företag";
gfu.ObjectID = "FÖ";
gfu.Date = date;
GeneralFollowUps.Add(gfu);
}
public void FillGeneralFollowUpsWithProducts()
{
GeneralFollowUps.Clear();
foreach (var item in db.CostProduct)
{
GeneralFollowUp gfu = new GeneralFollowUp
{
ObjectID = item.CeProductID,
ObjectName = item.CeProductName,
Date = item.CeIncomeDate
};
GeneralFollowUp gfuToRemove = null;
foreach (var tempGFU in GeneralFollowUps
.Where(tempGFU => tempGFU.ObjectID.Equals(gfu.ObjectID) && tempGFU.Date <= gfu.Date))
{
gfuToRemove = tempGFU;
}
if (gfuToRemove != null)
{
GeneralFollowUps.Remove(gfuToRemove);
}
GeneralFollowUps.Add(gfu);
}
}
public void FillGeneralFollowUpsWithCompany()
{
GeneralFollowUps.Clear();
GeneralFollowUp gfu = new GeneralFollowUp {
ObjectName = "IT-Service"
};
GeneralFollowUps.Add(gfu);
}
public void FillGeneralFollowUpsWithProducts()
{
GeneralFollowUps.Clear();
foreach (GeneralFollowUp gfu in db.Product.Select(item => new GeneralFollowUp
{
ObjectID = item.ProductID,
ObjectName = item.ProductName
}))
{
GeneralFollowUps.Add(gfu);
}
}
