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.###") }); }