private void SaveToDB() { try { ImportExportDAL importExportDAL = new ImportExportDAL(); if (ValidateData()) { importExport.CheckNo = int.Parse(txtCheckNo.Text); importExport.Date = DateTime.ParseExact(txtDay.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); if (radioButtonImport.Checked) { importExport.ImEx = "Nhập"; } else if (radioButtonExport.Checked) { importExport.ImEx = "Xuất"; } importExport.Type = cbType.SelectedItem.ToString(); CustomerDAL customerDAL = new CustomerDAL(); importExport.CustomerID = customerDAL.GetCustomerbyName(txtCustomerName.Text).CustomerID; } bool rs; if (isAdd) { rs = importExportDAL.CreateIE(importExport); } else { rs = importExportDAL.UpdateIE(importExport); } if (rs) { MessageBox.Show("Đã lưu !"); groupBoxDetail.Enabled = false; txtCheckNo.ReadOnly = true; LoadAllData(); } else { MessageBox.Show("Không thể lưu !"); } } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }
private void dataGridView1_Click(object sender, EventArgs e) { try { isAdd = false; radioButtonExport.Enabled = false; radioButtonImport.Enabled = false; importExport.CheckNo = (int)dataGridView1.SelectedRows[0].Cells[0].Value; importExport.Date = (DateTime)dataGridView1.SelectedRows[0].Cells[1].Value; importExport.ImEx = dataGridView1.SelectedRows[0].Cells[3].Value.ToString(); importExport.Type = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(); groupBoxDetail.Enabled = true; CustomerDAL cusDAL = new CustomerDAL(); string CusName = dataGridView1.SelectedRows[0].Cells[4].Value.ToString(); importExport.CustomerID = cusDAL.GetCustomerbyName(CusName).CustomerID; txtCheckNo.Text = dataGridView1.SelectedRows[0].Cells[0].Value.ToString(); txtCheckNo.ReadOnly = true; txtDay.Text = String.Format("{0:dd/MM/yyyy}", dataGridView1.SelectedRows[0].Cells[1].Value); string ImEx = dataGridView1.SelectedRows[0].Cells[3].Value.ToString(); if (String.Compare(ImEx, "Nhập", true) == 0) { radioButtonImport.Checked = true; } else { radioButtonExport.Checked = true; } string type = dataGridView1.SelectedRows[0].Cells[2].Value.ToString(); if (String.Compare(type, "Ký gửi", true) == 0) { cbType.SelectedIndex = 0; } if (String.Compare(type, "Bán lẻ", true) == 0) { cbType.SelectedIndex = 1; } if (String.Compare(type, "Nhập trả", true) == 0 && String.Compare(importExport.ImEx, "Nhập", true) == 0) { cbType.SelectedIndex = 2; } if (String.Compare(type, "Lưu kho", true) == 0 && String.Compare(importExport.ImEx, "Xuất", true) == 0) { cbType.SelectedIndex = 2; } if (String.Compare(type, "Trả hàng", true) == 0 && String.Compare(importExport.ImEx, "Xuất", true) == 0) { cbType.SelectedIndex = 3; } txtCustomerName.Text = dataGridView1.SelectedRows[0].Cells[4].Value.ToString(); } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }