//Form loads...
private void frmOrder_Load(object sender, EventArgs e)
{
//BLL Access
handlerOrder = new Handler_Order();
handlerOrderLine = new Handler_OrderLine();
handlerCustomer = new Handler_Customer();
handlerProduct = new Handler_Product();
handlerPayment = new Handler_Payment();
handlerDiscount = new Handler_Discount();
//Bind Data
try
{
BindData_Product();
BindData_Payment();
BindData_Discount();
}
catch (Exception ex)
{
MessageBox.Show("Error connection to the database!" + Environment.NewLine + Environment.NewLine + ex.Message);
this.Close();
}
//Focus controls
tabCtrlOrder.SelectedTab = tabCustomer;
tbxName.Focus();
}
//Select Order
private void SelectOrder()
{
int rowIndex = dgvOrders.CurrentCell.RowIndex;
int orderNumber = Convert.ToInt32(dgvOrders.Rows[rowIndex].Cells[0].Value.ToString());
selectedOrderNum = orderNumber;
//Display all items in the order
handlerOrderLines = new Handler_OrderLine();
BindData_OrderLines(orderNumber);
//Display order details
lblOrderNumber.Text = dgvOrders.Rows[rowIndex].Cells[0].Value.ToString();
lblCustomer.Text = dgvOrders.Rows[rowIndex].Cells[7].Value.ToString();
lblDate.Text = (dgvOrders.Rows[rowIndex].Cells[3].Value.ToString()).Substring(0, 10);
lblTime.Text = (dgvOrders.Rows[rowIndex].Cells[4].Value.ToString()).Substring(11);
if (Convert.ToBoolean(dgvOrders.Rows[rowIndex].Cells[5].Value.ToString()) == true)
{
lblCompletion.Text = "Yes";
}
else
{
lblCompletion.Text = "No";
}
if (Convert.ToBoolean(dgvOrders.Rows[rowIndex].Cells[6].Value.ToString()) == true)
{
lblCollection.Text = "Yes";
}
else
{
lblCollection.Text = "No";
}
lblSalesperson.Text = dgvOrders.Rows[rowIndex].Cells[2].Value.ToString();
}
