private void reportDataGridView_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { ProblemReport pr = prda.getOneReportByID((int)reportDataGridView.Rows[e.RowIndex].Cells["problemIdColumn"].Value, conn); showReportDateLabel.Text = pr.getReportDate().ToLongDateString(); reasonComboBox.SelectedValue = pr.getReason(); photoBox.Image = pr.getPhoto(); showReportDateLabel.Enabled = false; reasonComboBox.Enabled = false; reasonHintLabel.Enabled = false; photoBox.Enabled = false; browsePhotoButton.Enabled = false; zoomPhotoButton.Enabled = true; photoHintLabel.Enabled = false; if (pr.getReturnDate() == null) { naReturnDateCheckBox.Checked = true; naReturnDateCheckBox.Enabled = true; returnDateTime.Enabled = false; } else { naReturnDateCheckBox.Checked = false; naReturnDateCheckBox.Enabled = false; returnDateTime.Enabled = false; } addButton.Enabled = false; recordReturnDateButton.Enabled = false; } }
public int update(ProblemReport problemReport, MySqlConnection conn) { conn.Open(); MySqlCommand cmd = new MySqlCommand("UPDATE `problem_report` SET `Photo`=@photo,`Reason`=@reason,`Order_ID`=@orderID,`Report_date`=@reportDate,`Return_date`=@returnDate WHERE `Problem_ID`=@problemID", conn); cmd.Parameters.AddWithValue("@problemID", problemReport.getProblemID()); cmd.Parameters.AddWithValue("@photo", ImageConverter.imageToByteArray(problemReport.getPhoto())); cmd.Parameters.AddWithValue("@reason", problemReport.getReason()); cmd.Parameters.AddWithValue("@orderID", problemReport.getOrderID()); cmd.Parameters.AddWithValue("@reportDate", problemReport.getReportDate().ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@returnDate", (problemReport.getReturnDate() != null) ? problemReport.getReturnDate().Value.ToString("yyyy-MM-dd HH:mm:ss") : null); cmd.Prepare(); int i = cmd.ExecuteNonQuery(); conn.Close(); return(i); }
public int insert(ProblemReport problemReport, MySqlConnection conn) { conn.Open(); MySqlCommand cmd = new MySqlCommand("INSERT INTO `problem_report`(`Photo`, `Reason`, `Order_ID`, `Report_date`, `Return_date`) " + "VALUES(@photo, @reason, @orderID, @reportDate, @returnDate)", conn); cmd.Parameters.AddWithValue("@photo", ImageConverter.imageToByteArray(problemReport.getPhoto())); cmd.Parameters.AddWithValue("@reason", problemReport.getReason()); cmd.Parameters.AddWithValue("@orderID", problemReport.getOrderID()); cmd.Parameters.AddWithValue("@reportDate", problemReport.getReportDate().ToString("yyyy-MM-dd HH:mm:ss")); cmd.Parameters.AddWithValue("@returnDate", (problemReport.getReturnDate() != null) ? problemReport.getReturnDate().Value.ToString("yyyy-MM-dd HH:mm:ss") : null); cmd.Prepare(); int i = cmd.ExecuteNonQuery(); problemReport.setProblemID((int.Parse(cmd.LastInsertedId.ToString()))); conn.Close(); return(i); }
private void addButton_Click(object sender, EventArgs e) { bool error = false; if (string.IsNullOrWhiteSpace(reasonComboBox.Text)) { reasonHintLabel.ForeColor = Color.Red; error = true; } else { reasonHintLabel.ForeColor = SystemColors.ControlText; } if (photoBox.Image == null) { photoHintLabel.ForeColor = Color.Red; error = true; } else { photoHintLabel.ForeColor = SystemColors.ControlText; } if (!error) { if (MessageBox.Show((!naReturnDateCheckBox.Checked) ? rs.GetString("askAddReportDialogbox") : rs.GetString("askAddReportExceptReturnDateDialogbox"), "", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ProblemReport pr = new ProblemReport(); pr.setOrderID(orderDetail.getOrderID()); pr.setReportDate(DateTime.Now); showReportDateLabel.Enabled = false; pr.setReason(reasonComboBox.SelectedValue.ToString()); reasonComboBox.Enabled = false; reasonHintLabel.Enabled = false; pr.setPhoto(photoBox.Image); photoBox.Enabled = false; browsePhotoButton.Enabled = false; photoHintLabel.Enabled = false; if (!naReturnDateCheckBox.Checked) { pr.setReturnDate(returnDateTime.Value); naReturnDateCheckBox.Checked = false; naReturnDateCheckBox.Enabled = false; returnDateTime.Enabled = false; recordReturnDateButton.Enabled = false; } addButton.Enabled = false; int i = prda.insert(pr, conn); MessageBox.Show(rs.GetString("addNewReportSuccessMsg")); reportDataGridView.Rows.Add(pr.getProblemID(), pr.getReportDate().ToLongDateString() + ", " + pr.getReportDate().ToLongTimeString()); reportDataGridView.ClearSelection(); foreach (DataGridViewRow row in reportDataGridView.Rows) { if ((pr.getProblemID().ToString()).Equals(row.Cells["problemIdColumn"].Value.ToString())) { row.Selected = true; reportDataGridView.FirstDisplayedScrollingRowIndex = row.Index; } } } } }