public bool deleteNK(DTO.NhapKho nk)
{
string sql = "DELETE FROM tb_importwarehouse WHERE id_nk=@id";
MySqlConnection con = dc.getConnection();
try
{
cmd = new MySqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("id", MySqlDbType.VarChar).Value = nk.id_nk;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
return(false);
}
return(true);
}
private void btnDeleteImport_Click(object sender, EventArgs e)
{
if (id1 != 0)
{
DialogResult result = MessageBox.Show("Xác nhân xóa thông tin nhập kho", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
DTO.NhapKho nk = new DTO.NhapKho();
nk.id_nk = id1;
bll.deleteNK(nk);
reset();
dgvImportWarehouse.DataSource = bll.getAllNhapkho();
}
}
else
{
MessageBox.Show("Chưa chọn thông tin nhập xóa", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool insertNK(DTO.NhapKho nk)
{
string sql = "INSERT INTO tb_importwarehouse(id_hh, namecommodity, unitprice, number,totalprice,time) VALUES (@id_hh, @namecommodity, @unitprice, @number, @totalprice,@time)";
MySqlConnection con = dc.getConnection();
try
{
cmd = new MySqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("id_hh", MySqlDbType.VarChar).Value = nk.id_hh;
cmd.Parameters.Add("namecommodity", MySqlDbType.VarChar).Value = nk.namecommodity;
cmd.Parameters.Add("unitprice", MySqlDbType.VarChar).Value = nk.unitprice;
cmd.Parameters.Add("number", MySqlDbType.VarChar).Value = nk.number;
cmd.Parameters.Add("totalprice", MySqlDbType.VarChar).Value = nk.totalprice;
cmd.Parameters.Add("time", MySqlDbType.VarChar).Value = nk.time;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool deleteNK(DTO.NhapKho nk)
{
return(dalk.deleteNK(nk));
}
public bool insertNK(DTO.NhapKho nk)
{
return(dalk.insertNK(nk));
}
