private void GroupByItem(List <int> billsid)
{
rItemviwers = new List <RItemviwer>();
betterListView1.AddColumns(new string[] { "Item", "Qty", "Unit", });
decimal total = 0;
var billitems = db.billitems.Where(o => billsid.Contains(o.bill_id.Value)).ToList();
foreach (var billitem in billitems)
{
if (rItemviwers.Count(o => o.id == billitem.item_id) == 0)
{
var viwer = new RItemviwer()
{
id = billitem.item_id.Value,
name = billitem.menuitem.name,
unit = billitem.menuitem.unit,
qty = billitem.qty.Value
};
rItemviwers.Add(viwer);
}
else
{
var viwer = rItemviwers.First(o => o.id == billitem.item_id);
viwer.qty += billitem.qty.Value;
}
}
foreach (var viwer in rItemviwers)
{
betterListView1.Items.Add(viwer.getLV());
}
}
private void GroupByItem(List <int> billsid)
{
rItemviwers = new List <RItemviwer>();
betterListView1.AddColumns(new string[] { "Item Name", "Qty", "Unit", "Date", "Time" });
decimal total = 0;
var p_item = db.issueitems.Where(o => billsid.Contains(o.id)).ToList();
foreach (var p_itmes in p_item)
{
if (rItemviwers.Count(o => o.id == p_itmes.id) == 0)
{
var viwer = new RItemviwer()
{
id = p_itmes.purchaseitem_id.Value,
name = p_itmes.purchaseitem.name,
qty = p_itmes.quantity,
unit = p_itmes.units,
date = p_itmes.date.Value,
time = p_itmes.issuetime
};
//viwer.pricing.Add(p_itmes.price.Value, p_itmes.qty.Value);
rItemviwers.Add(viwer);
}
else
{
var viwer = rItemviwers.First(o => o.id == p_itmes.id);
//viwer.nettotal +=p_itmes.;
viwer.qty += p_itmes.quantity;
//if (viwer.pricing.ContainsKey(p_itmes.price.Value))
//{
// viwer.pricing[p_itmes.price.Value] += p_itmes.qty.Value;
//}
//else
//{
// viwer.pricing.Add(p_itmes.price.Value, p_itmes.qty.Value);
//}
}
}
foreach (var viwer in rItemviwers)
{
betterListView1.Items.Add(viwer.getLV());
}
//betterListView1.Add(new string[] { "Total", rItemviwers.Sum(o => o.qty).ToString("0.###"), "--", rItemviwers.Sum(o => o.nettotal).ToString("0.###") });
}
private void GroupByItem(List <int> billsid)
{
rItemviwers = new List <RItemviwer>();
betterListView1.AddColumns(new string[] { "Item", "Qty", "Unit" });
decimal total = 0;
var billitems = db.manufacureduseitems.Where(o => billsid.Contains(o.manufacureditems_id.Value)).ToList();
foreach (var billitem in billitems)
{
if (rItemviwers.Count(o => o.id == billitem.purchaseitem_id) == 0)
{
var viwer = new RItemviwer()
{
id = billitem.purchaseitem_id.Value,
name = billitem.purchaseitem.name,
qty = billitem.qty.Value,
unit = billitem.purchaseitem.unit
};
//viwer.pricing.Add(billitem.unitrate.Value, billitem.qty.Value);
rItemviwers.Add(viwer);
}
else
{
var viwer = rItemviwers.First(o => o.id == billitem.purchaseitem_id);
viwer.qty += billitem.qty.Value;
//if (viwer.pricing.ContainsKey(billitem.unitrate.Value))
//{
// viwer.pricing[billitem.unitrate.Value] += billitem.qty.Value;
//}
//else
//{
// viwer.pricing.Add(billitem.unitrate.Value, billitem.qty.Value);
//}
}
}
foreach (var viwer in rItemviwers)
{
betterListView1.Items.Add(viwer.getLV());
}
betterListView1.Add(new string[] { "Total", rItemviwers.Sum(o => o.qty).ToString("0.###"), "--" });
}
private void GroupByItem(List <int> billsid)
{
rItemviwers = new List <RItemviwer>();
betterListView1.AddColumns(new string[] { "Item", "Qty", "Pricing", "Net Total" });
decimal total = 0;
var p_item = db.purchaseinvoiceitems.Where(o => billsid.Contains(o.purchaseinvoice_id.Value)).ToList();
foreach (var p_itmes in p_item)
{
if (rItemviwers.Count(o => o.id == p_itmes.purchaseitems_id) == 0)
{
var viwer = new RItemviwer()
{
id = p_itmes.purchaseitems_id.Value,
name = p_itmes.purchaseitem.name,
pricing = new Dictionary <decimal, decimal>(),
qty = p_itmes.qty.Value
};
viwer.pricing.Add(p_itmes.price.Value, p_itmes.qty.Value);
rItemviwers.Add(viwer);
}
else
{
var viwer = rItemviwers.First(o => o.id == p_itmes.purchaseitems_id);
//viwer.nettotal +=p_itmes.;
viwer.qty += p_itmes.qty.Value;
if (viwer.pricing.ContainsKey(p_itmes.price.Value))
{
viwer.pricing[p_itmes.price.Value] += p_itmes.qty.Value;
}
else
{
viwer.pricing.Add(p_itmes.price.Value, p_itmes.qty.Value);
}
}
}
foreach (var viwer in rItemviwers)
{
betterListView1.Items.Add(viwer.getLV());
}
betterListView1.Add(new string[] { "Total", rItemviwers.Sum(o => o.qty).ToString("0.###"), "--", rItemviwers.Sum(o => o.nettotal).ToString("0.###") });
}
private void GroupByItem(List <int> billsid)
{
rItemviwers = new List <RItemviwer>();
betterListView1.AddColumns(new string[] { "Item", "Qty", "Pricing", "Net Total" });
decimal total = 0;
var billitems = db.billitems.Where(o => billsid.Contains(o.bill_id.Value)).ToList();
foreach (var billitem in billitems)
{
if (rItemviwers.Count(o => o.id == billitem.item_id) == 0)
{
var viwer = new RItemviwer()
{
id = billitem.item_id.Value,
name = billitem.menuitem.name,
nettotal = billitem.nettotal,
pricing = new Dictionary <decimal, decimal>(),
qty = billitem.qty.Value
};
viwer.pricing.Add(billitem.unitrate.Value, billitem.qty.Value);
rItemviwers.Add(viwer);
}
else
{
var viwer = rItemviwers.First(o => o.id == billitem.item_id);
viwer.nettotal += billitem.nettotal;
viwer.qty += billitem.qty.Value;
if (viwer.pricing.ContainsKey(billitem.unitrate.Value))
{
viwer.pricing[billitem.unitrate.Value] += billitem.qty.Value;
}
else
{
viwer.pricing.Add(billitem.unitrate.Value, billitem.qty.Value);
}
}
}
foreach (var viwer in rItemviwers)
{
betterListView1.Items.Add(viwer.getLV());
}
betterListView1.Add(new string[] { "Total", rItemviwers.Sum(o => o.qty).ToString("0.###"), "--", rItemviwers.Sum(o => o.nettotal).ToString("0.###") });
}
