private void ViewBills_Load(object sender, EventArgs e) { dgvBills.AutoGenerateColumns = false; dgvBills.Columns.Clear(); // add(string nameColumn,string HeaderText) dgvBills.Columns.Add("id", "Bill ID"); //id 1 - NameColumn id 2 - property of Member dgvBills.Columns["id"].DataPropertyName = "billID"; dgvBills.Columns.Add("dateOfBill", "Bill Date"); dgvBills.Columns["dateOfBill"].DataPropertyName = "dateOfBill"; dgvBills.Columns.Add("employeeID", "Employee ID"); dgvBills.Columns["employeeID"].DataPropertyName = "employeeID"; dgvBills.Columns.Add("firstName", "Employee Name"); dgvBills.Columns["firstName"].DataPropertyName = "firstName"; DataGridViewButtonColumn btnColumn = new DataGridViewButtonColumn(); btnColumn.HeaderText = "Detail"; btnColumn.Name = "detailButton"; btnColumn.Text = "Detail"; btnColumn.UseColumnTextForButtonValue = true; dgvBills.Columns.Add(btnColumn); DataGridViewButtonColumn exportButtonColumn = new DataGridViewButtonColumn(); exportButtonColumn.HeaderText = "Export"; exportButtonColumn.Name = "Export"; exportButtonColumn.Text = "Export"; exportButtonColumn.UseColumnTextForButtonValue = true; dgvBills.Columns.Add(exportButtonColumn); dgvBills.DataSource = BillList.GetAllBills(); }
private void btnSearch_Click(object sender, EventArgs e) { if (btnCheckDate.Checked == true) { if (dateFrom.Value >= dateTo.Value) { MessageBox.Show("The To date must be after the From date"); } else { if (txtBillID.Text != "" && txtEmployeeName.Text == "") { int value; if (int.TryParse(txtBillID.Text, out value)) { dgvBills.DataSource = BillList.getBillByIDAndDate(txtBillID.Text, dateFrom.Value.ToString(), dateTo.Value.ToString()); } else { dgvBills.DataSource = BillList.getBillByName("!"); } } if (txtEmployeeName.Text != "" && txtBillID.Text == "") { int value; if (int.TryParse(txtBillID.Text, out value)) { dgvBills.DataSource = BillList.getBillByEmployeeNameAndDate(txtEmployeeName.Text, dateFrom.Value.ToString(), dateTo.Value.ToString()); } else { dgvBills.DataSource = BillList.getBillByName("!"); } } if (txtEmployeeName.Text != "" && txtBillID.Text != "") { dgvBills.DataSource = BillList.getBillByBillIdAndEmployeeNameAndDate(txtBillID.Text, txtEmployeeName.Text, dateFrom.Value.ToString(), dateTo.Value.ToString()); } if (txtEmployeeName.Text == "" && txtBillID.Text == "") { dgvBills.DataSource = BillList.getBillByDate(dateFrom.Value.ToString(), dateTo.Value.ToString()); } } } else { if (txtBillID.Text == "" && txtEmployeeName.Text == "") { dgvBills.DataSource = BillList.GetAllBills(); } if (txtBillID.Text != "" && txtEmployeeName.Text == "") { int value; if (int.TryParse(txtBillID.Text, out value)) { dgvBills.DataSource = BillList.getBillById(txtBillID.Text); } else { dgvBills.DataSource = BillList.getBillByName("!"); } } if (txtEmployeeName.Text != "" && txtBillID.Text == "") { dgvBills.DataSource = BillList.getBillByName(txtEmployeeName.Text); } if (txtEmployeeName.Text != "" && txtBillID.Text != "") { int value; if (int.TryParse(txtBillID.Text, out value)) { dgvBills.DataSource = BillList.getBillByIdAndName(txtBillID.Text, txtEmployeeName.Text); } else { dgvBills.DataSource = BillList.getBillByName("!"); } } } }