private void btnDelete_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Bạn có muốn xóa ?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int no = Convert.ToInt32(dataGridView1.SelectedRows[0].Cells[0].Value); ImportExportDAL DAL = new ImportExportDAL(); DAL.DeleteIE(no); } ClearAll(); LoadAllData(); } catch (SqlException sqlEx) { MessageBox.Show("Vui lòng xóa toàn bộ sách trong phiếu trước khi xóa phiếu !"); logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + sqlEx.Message + "'"); } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }
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 btnSearch_Click(object sender, EventArgs e) { try { if (rbExport.Checked) { ImportExportDAL IEDAL = new ImportExportDAL(); if (IEDAL.GetExport() != null) { List<OpenImportExport> list = new List<OpenImportExport>(); list = IEDAL.GetExport(); dataGridView1.DataSource = list; dataGridView1.Refresh(); } else { MessageBox.Show("Không có kết quả được tìm thấy"); LoadAllData(); } } else if (rbImport.Checked) { ImportExportDAL IEDAL = new ImportExportDAL(); if (IEDAL.GetImport() != null) { List<OpenImportExport> list = new List<OpenImportExport>(); list = IEDAL.GetImport(); dataGridView1.DataSource = list; dataGridView1.Refresh(); } else { MessageBox.Show("Không có kết quả được tìm thấy"); LoadAllData(); } } } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }
private void LoadAllData() { try { List<ImportExport> list1 = new List<ImportExport>(); List<OpenImportExport> list2 = new List<OpenImportExport>(); ImportExportDAL importexportDAL = new ImportExportDAL(); list1 = importexportDAL.GetAllIE(); list2 = importexportDAL.GetAllOpenIE(list1); dataGridView1.DataSource = list2; } catch (Exception ex) { logger.MyLogFile(DateTime.Now.ToString(), "' Error '" + ex.Message + "'"); } }
public List<OpenImportExport> GetExport() { List<OpenImportExport> list = new List<OpenImportExport>(); ImportExportDAL IEDAL = new ImportExportDAL(); string cs = CocBook.Properties.Settings.Default.connectionString; SqlConnection con = new SqlConnection(cs); SqlCommand cmd = new SqlCommand("Select * from ImportExport where ImportExport = @E", con); cmd.Parameters.AddWithValue("E", "Xuất"); con.Open(); SqlDataReader sdr = cmd.ExecuteReader(); while (sdr.Read()) { OpenImportExport openIE = new OpenImportExport(); CustomerDAL customerDAL = new CustomerDAL(); openIE.CheckNo = (int)sdr["CheckNo"]; openIE.Date = (DateTime)sdr["Date"]; openIE.Type = (string)sdr["Type"]; openIE.ImEx = (string)sdr["ImportExport"]; int customerID = (int)sdr["CustomerID"]; openIE.CustomerName = customerDAL.GetCustomerbyID(customerID).CustomerName; list.Add(openIE); } con.Close(); return list; }