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;
}
