private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
BUSHeTHong bus = new BUSHeTHong();
DTOThongTin thongTin = new DTOThongTin()
{
tendonvi = textEdit1.Text,
diachi = textEdit2.Text,
dienthoai = textEdit3.Text,
fax = textEdit4.Text,
website = textEdit5.Text,
email = textEdit6.Text,
gpkd = textEdit8.Text,
linhvuc = comboBoxEdit1.Text,
masothue = textEdit7.Text
};
bus.updateLinhVuc(thongTin);
MessageBox.Show("Cập nhật thông tin thành công");
}
public void updateLinhVuc(DTOThongTin thongtin)
{
string query = string.Format($"select * from THONGTIN");
if (ExecSelectedCount(query) > 0)
{
var _cmd = new SqlCommand();
_cmd.CommandText = "update THONGTIN set tendonvi=@tendonvi,diachi=@diachi,dienthoai=@dienthoai,fax=@fax,website=@website,email=@email,linhvuc=@linhvuc,masothue=@masothue,gpkd=@gpkd";
_cmd.CommandType = CommandType.Text;
_cmd.Connection = connection;
_cmd.Parameters.Add("@tendonvi", SqlDbType.Text).Value = thongtin.tendonvi;
_cmd.Parameters.Add("@diachi", SqlDbType.Text).Value = thongtin.diachi;
_cmd.Parameters.Add("@dienthoai", SqlDbType.Text).Value = thongtin.dienthoai;
_cmd.Parameters.Add("@fax", SqlDbType.Text).Value = thongtin.fax;
_cmd.Parameters.Add("@website", SqlDbType.Text).Value = thongtin.website;
_cmd.Parameters.Add("@email", SqlDbType.Text).Value = thongtin.email;
_cmd.Parameters.Add("@linhvuc", SqlDbType.Text).Value = thongtin.linhvuc;
_cmd.Parameters.Add("@masothue", SqlDbType.Text).Value = thongtin.masothue;
_cmd.Parameters.Add("@gpkd", SqlDbType.Text).Value = thongtin.gpkd;
OpenConn();
var i = _cmd.ExecuteNonQuery();
CloseConn();
}
else
{
var _cmd = new SqlCommand();
_cmd.CommandText = "insert into THONGTIN value(tendonvi=@tendonvi,diachi=@diachi,dienthoai=@dienthoai,fax=@fax,website=@website,email=@email,linhvuc=@linhvuc,masothue=@masothue,gpkd=@gpkd)";
_cmd.CommandType = CommandType.Text;
_cmd.Connection = connection;
_cmd.Parameters.Add("@tendonvi", SqlDbType.Text).Value = thongtin.tendonvi;
_cmd.Parameters.Add("@diachi", SqlDbType.Text).Value = thongtin.diachi;
_cmd.Parameters.Add("@dienthoai", SqlDbType.Text).Value = thongtin.dienthoai;
_cmd.Parameters.Add("@fax", SqlDbType.Text).Value = thongtin.fax;
_cmd.Parameters.Add("@website", SqlDbType.Text).Value = thongtin.website;
_cmd.Parameters.Add("@email", SqlDbType.Text).Value = thongtin.email;
_cmd.Parameters.Add("@linhvuc", SqlDbType.Text).Value = thongtin.linhvuc;
_cmd.Parameters.Add("@masothue", SqlDbType.Text).Value = thongtin.masothue;
_cmd.Parameters.Add("@gpkd", SqlDbType.Text).Value = thongtin.gpkd;
OpenConn();
var i = _cmd.ExecuteNonQuery();
CloseConn();
}
}
public void updateLinhVuc(DTOThongTin thongTin)
{
DALHeThong um = new DALHeThong();
um.updateLinhVuc(thongTin);
}
