private void LoadAllCustomer()
{
LazyWorker <Customer> .LoadAllToGridView
(
CustomerGridView,
new string[]
{ "Id", "FullName", "DateOfBirth", "Sex", "RealLifeIdNumber" }
);
CustomerGridView.Columns["Id"].Visible = false;
CustomerGridView.Columns["FullName"].Width = 100;
CustomerGridView.Columns["FullName"].HeaderText = "Họ tên";
CustomerGridView.Columns["DateOfBirth"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
CustomerGridView.Columns["DateOfBirth"].HeaderText = "Ngày sinh";
CustomerGridView.Columns["Sex"].Visible = false;
CustomerGridView.Columns["RealLifeIdNumber"].Width = 100;
CustomerGridView.Columns["RealLifeIdNumber"].HeaderText = "Số CMND";
CustomerGridView.Columns["Filter"].Visible = false;
}
private void LoadBillsServices(List <ServiceMapped> services = null)
{
LazyWorker <ServiceMapped> .LoadAllToGridView
(
ServiceListGridView,
new string[]
{
"Id", "ServiceName", "Price", "RoomId",
"BelongToRoom", "Count", "BillId"
},
services ?? LessLazyWorker.GetMappedServiceByBill(currentBill.Id)
);
ServiceListGridView.Columns["Id"].Visible = false;
ServiceListGridView.Columns["RoomId"].Visible = false;
ServiceListGridView.Columns["BillId"].Visible = false;
ServiceListGridView.Columns["Filter"].Visible = false;
ServiceListGridView.Columns["BillDetailId"].Visible = false;
ServiceListGridView.Columns["ServiceName"].HeaderText = "Tên dịch vụ";
ServiceListGridView.Columns["Price"].HeaderText = "Giá";
ServiceListGridView.Columns["Count"].HeaderText = "Số lượng";
ServiceListGridView.Columns["BelongToRoom"].HeaderText = "Thuộc về phòng";
ServiceListGridView.Columns["ServiceName"].Width = 150;
ServiceListGridView.Columns["Price"].DefaultCellStyle.Format = "### ### ### ###";
ServiceListGridView.Columns["Price"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
ServiceListGridView.Columns["Count"].Width = 100;
ServiceListGridView.Columns["BelongToRoom"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
}
private void LoadAllEmployees()
{
LazyWorker <Employee> .LoadAllToGridView(gridView : EmployeeGridView,
columnNames : new string[] { "Id", "Username", "Password", "IsAdmin",
"RealLifeIdNumber", "FullName", "DateOfBirth", "Sex",
"Address", "Phonenumber" });
EmployeeGridView.Columns["Id"].Visible = false;
EmployeeGridView.Columns["Username"].Width = 110;
EmployeeGridView.Columns["Username"].HeaderText = "Tên đăng nhập";
EmployeeGridView.Columns["Password"].Width = 100;
EmployeeGridView.Columns["Password"].HeaderText = "Mật khẩu";
EmployeeGridView.Columns["Password"].Visible = false;
EmployeeGridView.Columns["IsAdmin"].HeaderText = "Là quản trị viên?";
EmployeeGridView.Columns["IsAdmin"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
EmployeeGridView.Columns["RealLifeIdNumber"].HeaderText = "Số CMND";
EmployeeGridView.Columns["RealLifeIdNumber"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
EmployeeGridView.Columns["FullName"].HeaderText = "Họ tên";
EmployeeGridView.Columns["FullName"].Width = 125;
EmployeeGridView.Columns["DateOfBirth"].HeaderText = "Ngày sinh";
EmployeeGridView.Columns["DateOfBirth"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
EmployeeGridView.Columns["Sex"].HeaderText = "Giới tính";
EmployeeGridView.Columns["Sex"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
EmployeeGridView.Columns["Sex"].Visible = false;
EmployeeGridView.Columns["Address"].HeaderText = "Địa chỉ";
EmployeeGridView.Columns["Address"].Width = 125;
EmployeeGridView.Columns["Phonenumber"].HeaderText = "Số điện thoại";
EmployeeGridView.Columns["Phonenumber"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
EmployeeGridView.Columns["Filter"].Visible = false;
}
private void LoadAllBills()
{
LazyWorker <BillDisplay> .LoadAllToGridView
(
BillGridView,
new string[] { "Id", "Customer_", "Employee_", "CreatingDay" },
LessLazyWorker.GetAllBills()
);
DataTable table = (DataTable)BillGridView.DataSource;
table.Columns.Add("Customer");
table.Columns.Add("Employee");
LessLazyWorker.SetColumnsOrder(table,
new string[] { "Customer", "Employee", "CreatingDay", "TotalPrice" });
foreach (DataRow row in table.Rows)
{
BillDisplay bill = LazyWorker <BillDisplay> .DataRowToObject(row);
row["Customer"] = bill.Customer_ != null ? bill.Customer_.FullName : "";
row["Employee"] = bill.Employee_ != null ? bill.Employee_.FullName : "";
}
BillGridView.DataSource = table;
BillGridView.Columns["Id"].Visible = false;
BillGridView.Columns["Filter"].Visible = false;
BillGridView.Columns["Customer_"].Visible = false;
BillGridView.Columns["Employee_"].Visible = false;
BillGridView.Columns["CreatingDay"].HeaderText = "Ngày khởi tạo";
BillGridView.Columns["Customer"].HeaderText = "Tên khách";
BillGridView.Columns["Employee"].HeaderText = "Tạo bởi";
BillGridView.Columns["TotalPrice"].HeaderText = "Tổng tiền";
BillGridView.Columns["TotalPrice"].DefaultCellStyle.Format = "### ### ### ###";
}
private void LoadAllServices()
{
LazyWorker <ServiceDisplay> .LoadAllToGridView
(
ServiceGridView,
new string[] { "Id", "ServiceName", "Price", "BelongToRoom" },
LessLazyWorker.GetAllServices()
);
ServiceGridView.Columns["Id"].Visible = false;
ServiceGridView.Columns["ServiceName"].HeaderText = "Tên dịch vụ";
ServiceGridView.Columns["ServiceName"].Width = 150;
ServiceGridView.Columns["Price"].HeaderText = "Giá dịch vụ";
ServiceGridView.Columns["Price"].AutoSizeMode
= DataGridViewAutoSizeColumnMode.AllCells;
ServiceGridView.Columns["Price"].DefaultCellStyle.Format = "### ### ### ###";
ServiceGridView.Columns["BelongToRoom"].HeaderText = "Thuộc về phòng";
ServiceGridView.Columns["BelongToRoom"].Width = 150;
ServiceGridView.Columns["Filter"].Visible = false;
}
