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);
}
}
}