private void orderDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { OrderLineDA olda = new OrderLineDA(); orderDetail = null; orderDetail = oda.getOneOrderByID(orderDataGridView.Rows[e.RowIndex].Cells["orderIdColumn"].Value.ToString(), conn); showOrderIdLabel.Text = orderDetail.getOrderID().ToString(); showOrderDateLabel.Text = orderDetail.getOrderDate().Date.ToLongDateString(); showNameLabel.Text = orderDetail.getCustName(); showAddressLabel.Text = orderDetail.getCustAddress(); showEmailLabel.Text = orderDetail.getCustEmail(); showMobileNoLabel.Text = orderDetail.getCustMobilePhoneNo(); OrderLine packageOl = olda.getPackageOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn); if (!string.IsNullOrEmpty(packageOl.getProductID())) { showPackageIdLabel.Text = packageOl.getProductID(); showPackageNameLabel.Text = packageOl.getProductName(); } else { showPackageIdLabel.Text = " "; showPackageNameLabel.Text = " "; } OrderLine bottleOl = olda.getBottleOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn); if (!string.IsNullOrEmpty(bottleOl.getProductID())) { showBottleIdLabel.Text = bottleOl.getProductID(); showBottleNameLabel.Text = bottleOl.getProductName(); showBottleCapacityLabel.Text = bottleOl.getBottleCapacity().ToString() + rs.GetString("mlText"); } else { showBottleIdLabel.Text = " "; showBottleNameLabel.Text = " "; showBottleCapacityLabel.Text = " "; } List <OrderLine> perfumeOlList = olda.getPerfumeOrderLine(showOrderIdLabel.Text, Language.getLanguageCode(), conn); if (perfumeOlList.Count > 0) { showPerfumeId0Label.Text = perfumeOlList.ElementAt(0).getProductID(); showPerfumeName0Label.Text = perfumeOlList.ElementAt(0).getProductName(); showPerfumeNote0Label.Text = rs.GetString(perfumeOlList.ElementAt(0).getNote() + "Text"); showPerfumeQty0Label.Text = perfumeOlList.ElementAt(0).getQty().ToString(); } else { showPerfumeId0Label.Text = " "; showPerfumeName0Label.Text = " "; showPerfumeNote0Label.Text = " "; showPerfumeQty0Label.Text = " "; } if (perfumeOlList.Count > 1) { showPerfumeId1Label.Text = perfumeOlList.ElementAt(1).getProductID(); showPerfumeName1Label.Text = perfumeOlList.ElementAt(1).getProductName(); showPerfumeNote1Label.Text = rs.GetString(perfumeOlList.ElementAt(1).getNote() + "Text"); showPerfumeQty1Label.Text = perfumeOlList.ElementAt(1).getQty().ToString(); } else { showPerfumeId1Label.Text = " "; showPerfumeName1Label.Text = " "; showPerfumeNote1Label.Text = " "; showPerfumeQty1Label.Text = " "; } if (perfumeOlList.Count > 2) { showPerfumeId2Label.Text = perfumeOlList.ElementAt(2).getProductID(); showPerfumeName2Label.Text = perfumeOlList.ElementAt(2).getProductName(); showPerfumeNote2Label.Text = rs.GetString(perfumeOlList.ElementAt(2).getNote() + "Text"); showPerfumeQty2Label.Text = perfumeOlList.ElementAt(2).getQty().ToString(); } else { showPerfumeId2Label.Text = " "; showPerfumeName2Label.Text = " "; showPerfumeNote2Label.Text = " "; showPerfumeQty2Label.Text = " "; } if (perfumeOlList.Count > 3) { showPerfumeId3Label.Text = perfumeOlList.ElementAt(3).getProductID(); showPerfumeName3Label.Text = perfumeOlList.ElementAt(3).getProductName(); showPerfumeNote3Label.Text = rs.GetString(perfumeOlList.ElementAt(3).getNote() + "Text"); showPerfumeQty3Label.Text = perfumeOlList.ElementAt(3).getQty().ToString(); } else { showPerfumeId3Label.Text = " "; showPerfumeName3Label.Text = " "; showPerfumeNote3Label.Text = " "; showPerfumeQty3Label.Text = " "; } if (perfumeOlList.Count > 4) { showPerfumeId4Label.Text = perfumeOlList.ElementAt(4).getProductID(); showPerfumeName4Label.Text = perfumeOlList.ElementAt(4).getProductName(); showPerfumeNote4Label.Text = rs.GetString(perfumeOlList.ElementAt(4).getNote() + "Text"); showPerfumeQty4Label.Text = perfumeOlList.ElementAt(4).getQty().ToString(); } else { showPerfumeId4Label.Text = " "; showPerfumeName4Label.Text = " "; showPerfumeNote4Label.Text = " "; showPerfumeQty4Label.Text = " "; } if (perfumeOlList.Count > 4) { showPerfumeId5Label.Text = perfumeOlList.ElementAt(5).getProductID(); showPerfumeName5Label.Text = perfumeOlList.ElementAt(5).getProductName(); showPerfumeNote5Label.Text = rs.GetString(perfumeOlList.ElementAt(5).getNote() + "Text"); showPerfumeQty5Label.Text = perfumeOlList.ElementAt(5).getQty().ToString(); } else { showPerfumeId5Label.Text = " "; showPerfumeName5Label.Text = " "; showPerfumeNote5Label.Text = " "; showPerfumeQty5Label.Text = " "; } reportDataGridView.Rows.Clear(); reportDataGridView.Refresh(); List <ProblemReport> list = prda.getReportsByOrderID(ulong.Parse(orderDataGridView.Rows[e.RowIndex].Cells["orderIdColumn"].Value.ToString()), conn); foreach (ProblemReport pr in list) { reportDataGridView.Rows.Add(pr.getProblemID(), pr.getReportDate().ToLongDateString() + ", " + pr.getReportDate().ToLongTimeString()); } reportDataGridView.ClearSelection(); showReportDateLabel.Enabled = true; reasonComboBox.Enabled = true; reasonComboBox.SelectedIndex = -1; reasonHintLabel.Enabled = true; reasonHintLabel.ForeColor = SystemColors.ControlText; photoBox.Enabled = true; photoBox.Image = null; browsePhotoButton.Enabled = true; zoomPhotoButton.Enabled = false; photoHintLabel.Enabled = true; photoHintLabel.ForeColor = SystemColors.ControlText; naReturnDateCheckBox.Enabled = true; naReturnDateCheckBox.Checked = true; returnDateTime.Enabled = false; addButton.Enabled = true; recordReturnDateButton.Enabled = false; } }