public void byDay() { lsvGeneralReport.Items.Clear(); //in ReceiptDao r = new ReceiptDao(); var incomes = r.GetReceiptList(); IDictionary <DateTime, double> list = new Dictionary <DateTime, double>(); list.Add(incomes[0].PrintDate.Date, incomes[0].Total + incomes[0].AdditionalFee); for (int i = 1; i < incomes.Count; i++) { if (!list.ContainsKey(incomes[i].PrintDate.Date)) { list.Add(incomes[i].PrintDate.Date, incomes[i].Total + incomes[i].AdditionalFee); } else { list[incomes[i].PrintDate.Date] += incomes[i].Total + incomes[i].AdditionalFee; } } //out PaymentDao p = new PaymentDao(); var outcomes = p.GetPaymentList(); IDictionary <DateTime, double> list1 = new Dictionary <DateTime, double>(); list1.Add(outcomes[0].PayDate.Date, outcomes[0].TotalFee); for (int i = 1; i < outcomes.Count; i++) { if (!list1.ContainsKey(outcomes[i].PayDate.Date)) { list1.Add(outcomes[i].PayDate.Date, outcomes[i].TotalFee); } else { list1[outcomes[i].PayDate.Date] += outcomes[i].TotalFee; } } foreach (KeyValuePair <DateTime, double> kvp in list) { string[] row = { kvp.Key.ToString(), kvp.Value.ToString(), "", (kvp.Value - 0).ToString() }; ListViewItem item = new ListViewItem(row); lsvGeneralReport.Items.Add(item); foreach (KeyValuePair <DateTime, double> kvp1 in list1) { if (kvp1.Key.Date == kvp.Key.Date) { string[] rows = { kvp.Key.ToString(), kvp.Value.ToString(), kvp1.Value.ToString(), (kvp.Value - kvp1.Value).ToString() }; item = new ListViewItem(rows); lsvGeneralReport.Items.RemoveAt(lsvGeneralReport.Items.Count - 1); lsvGeneralReport.Items.Add(item); } } } }
private void LoadReceipsToForm() { ReceiptDao dao = new ReceiptDao(); List <Receipt> receipts = dao.GetReceiptList(); receipts.ForEach(receipt => { string[] row = { receipt.ReceiptID.ToString(), receipt.PrintDate.ToString(), receipt.EmployeeID.ToString(), receipt.Total.ToString() }; ListViewItem item = new ListViewItem(row); lsvReceipt.Items.Add(item); }); }
public void byMonth() { lsvGeneralReport.Items.Clear(); ReceiptDao r = new ReceiptDao(); PaymentDao p = new PaymentDao(); var incomes = r.GetReceiptList(); for (int i = 1; i <= 12; i++) { if (i >= 10) { string[] rows = { "Tháng " + i, "" + r.GetByMonth(i.ToString()), "" + p.GetByMonth(i.ToString()), (r.GetByMonth(i.ToString()) - p.GetByMonth(i.ToString())).ToString() }; ListViewItem item = new ListViewItem(rows); lsvGeneralReport.Items.Add(item); } else { string[] rowss = { "Tháng " + i, "" + r.GetByMonth("0" + i.ToString()), "" + p.GetByMonth("0" + i.ToString()), (r.GetByMonth("0" + i.ToString()) - p.GetByMonth("0" + i.ToString())).ToString() }; var item = new ListViewItem(rowss); lsvGeneralReport.Items.Add(item); } } }