// Function Load database to grid wiew
private void loadDataTable()
{
table_bill.DataSource = bill.GetAll();
table_bill.MainView.PopulateColumns();
((GridView)table_bill.MainView).Columns[0].Caption = "Mã hóa đơn";
((GridView)table_bill.MainView).Columns[1].Caption = "Mã Sim";
((GridView)table_bill.MainView).Columns[2].Caption = "Ngày xuất phiếu";
((GridView)table_bill.MainView).Columns[2].DisplayFormat.FormatType = FormatType.DateTime;
((GridView)table_bill.MainView).Columns[2].DisplayFormat.FormatString = "dd/MM/yyyy";
((GridView)table_bill.MainView).Columns[3].Caption = "Ngày cắt";
((GridView)table_bill.MainView).Columns[3].DisplayFormat.FormatType = FormatType.DateTime;
((GridView)table_bill.MainView).Columns[3].DisplayFormat.FormatString = "dd/MM/yyyy";
((GridView)table_bill.MainView).Columns[4].Caption = "Cước thuê bao";
((GridView)table_bill.MainView).Columns[5].Caption = "Cước phí hàng tháng";
((GridView)table_bill.MainView).Columns[6].Caption = "Tình trạng";
((GridView)table_bill.MainView).Columns[7].Visible = false;
}
private void ShowAllBill()
{
lvBill.Items.Clear();
List <Bill> bills = billBUS.GetAll();
foreach (Bill bill in bills)
{
ListViewItem item = new ListViewItem(bill.ID.ToString());
item.SubItems.Add(bill.Name);
item.SubItems.Add(bill.Datetime.ToString("dd/MM/yyyy hh:mm:ss"));
item.SubItems.Add(bill.Total.ToString());
item.SubItems.Add(bill.Status.ToString());
item.Tag = bill;
if (bill.Status == BillStatus.Unprocessed)
{
item.Group = lvBill.Groups["lvgUnprocessed"];
}
else if (bill.Status == BillStatus.Processing)
{
item.Group = lvBill.Groups["lvgProcessing"];
}
else if (bill.Status == BillStatus.Shipping)
{
item.Group = lvBill.Groups["lvgShipping"];
}
else if (bill.Status == BillStatus.Done)
{
item.Group = lvBill.Groups["lvgDone"];
}
else if (bill.Status == BillStatus.Cancel)
{
item.Group = lvBill.Groups["lvgCancel"];
}
lvBill.Items.Add(item);
}
}
