void ganDuLieu(NhanVienObjTH Obj) { Obj.manv = txt_manv.Text.Trim();; Obj.tennv = txt_tennv.Text.Trim(); Obj.ngaysinh = dt_ngaysinh.Text.Trim(); Obj.diachi = txt_diachi.Text.Trim(); Obj.gioitinh = cb_gioitinh.Text.Trim(); Obj.sdt = txt_sdt.Text.Trim(); }
public bool AddData(NhanVienObjTH Obj) { cmd.CommandText = " insert into NhanVien (MaNV,TenNV,NgaySinh,GioiTinh,DiaChi,SDT) values('" + Obj.manv + "',N'" + Obj.tennv + "',convert(date,'" + Obj.ngaysinh + "'),N'" + Obj.gioitinh + "',N'" + Obj.diachi + "','" + Obj.sdt + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
public bool UpDate(NhanVienObjTH Obj) { cmd.CommandText = " update NhanVien set TenNV = N'" + Obj.tennv + "' , NgaySinh = '" + Obj.ngaysinh + "' , GioiTinh = '" + Obj.gioitinh + "' , DiaChi = N'" + Obj.diachi + "' , SDT = '" + Obj.sdt + "' where MaNV = '" + Obj.manv + "'"; cmd.CommandType = CommandType.Text; cmd.Connection = con.Connection; try { con.OpenConn(); cmd.ExecuteNonQuery(); return(true); } catch (Exception ex) { string mex = ex.Message; cmd.Dispose(); con.CloseConn(); } return(false); }
public bool upData(NhanVienObjTH nvObj) { return(nvMod.UpDate(nvObj)); }
public bool addData(NhanVienObjTH nvObj) { return(nvMod.AddData(nvObj)); }