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 PaymentReportForm_Load(object sender, EventArgs e) { dtmStartDate.Format = DateTimePickerFormat.Custom; dtmStartDate.CustomFormat = "yyyy-MMMM-dd"; dtmEndDate.Format = DateTimePickerFormat.Custom; dtmEndDate.CustomFormat = "yyyy-MMMM-dd"; paymentList = paymentDao.GetPaymentList(); foreach (Payment payment in paymentList) { string[] row = { payment.PaymentID.ToString(), payment.PayDate.ToString(), payment.EmployeeID.ToString(), payment.Detail.ToString(), payment.TotalFee.ToString() }; ListViewItem item = new ListViewItem(row); lsvGeneralReport.Items.Add(item); } }