public int update(BaoHiemEntities obj)
{
int result = 0;
string strQuery = "update dbo.BaoHiem set MaNV='" + obj.Manv + "',NgayCapSo='" + obj.Songaycap + "',NoiCapSo='" + obj.Noicapso + "',GhiChu='" + obj.Ghichu + "' where MaSBH='" + obj.Masbh + "'";
DataConfig config = new DataConfig();
result = config.excuteNonquery(strQuery); //thucthi
return(result); //tra ve so ban ghi
}
/* public DataTable FindItem(string item)
* {
* DataTable result = new DataTable();
* DataConfig config = new DataConfig();
* string strQuery = "select *from dbo.BaoHiem where MaChucVu like '%" + item + "%' or TenChucvu '%" + item + "%'";
* result = config.GetData(strQuery);
* return result;
* }*/
public int Insert(BaoHiemEntities obj)
{
int result = 0;
string strQuery = "insert into dbo.BaoHiem(MaNV,MaSBH,NgayCapSo,NoiCapSo,GhiChu) values('" + obj.Manv + "','" + obj.Masbh + "','" + obj.Songaycap + "','" + obj.Noicapso + "','" + obj.Ghichu + "')";
DataConfig config = new DataConfig();
result = config.excuteNonquery(strQuery); //thucthi
return(result); //tra ve so ban ghi
}
