public NhanVienInfo SelectNhanVien_ByMaNV(String MaNhanVien) { string sql = @"Select * from NHANVIEN where MaNV=" + MaNhanVien; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { NhanVienInfo info = new NhanVienInfo { MaNV = (string)dr["MaNV"], TenNV = (string)dr["TenNV"], NgaySinh = (string)dr["NgaySinh"], GioiTinh = (string)dr["GioiTinh"], DiaChi = (string)dr["DiaChi"], SDT = (string)dr["SDT"] }; dr.Close(); return(info); } return(null); } }
public bool UpdateNhanVien(NhanVienInfo info) { string sql = @"Update NHANVIEN set TenNV=@TenNv, NgaySinh=@NgaySinh, GioiTinh=@GioiTinh, DiaChi=@DiaChi, SDT=@SDT where MaNV= @MaNV"; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { cmd.Parameters.Add(new SqlParameter("@MaNV", info.MaNV)); cmd.Parameters.Add(new SqlParameter("@TenNV", info.TenNV)); cmd.Parameters.Add(new SqlParameter("@NgaySinh", info.NgaySinh)); cmd.Parameters.Add(new SqlParameter("@GioiTinh", info.GioiTinh)); cmd.Parameters.Add(new SqlParameter("@DiaChi", info.DiaChi)); cmd.Parameters.Add(new SqlParameter("@SDT", info.SDT)); int t = (int)cmd.ExecuteNonQuery(); cmd.Clone(); return(t >= 1); } }
public bool InsertNhanVien(NhanVienInfo sach) { string sql = @"Insert into NHANVIEN (MaNV, TenNV, NgaySinh, GioiTinh, DiaChi, SDT) values(@MaNV, @TenNV, @NgaySinh, @GioiTinh, @DiaChi, @SDT)"; using (SqlCommand cmd = new SqlCommand(sql, getConnet())) { cmd.Parameters.Add(new SqlParameter("@MaNv", sach.MaNV)); cmd.Parameters.Add(new SqlParameter("@TenNV", sach.TenNV)); cmd.Parameters.Add(new SqlParameter("@NgaySinh", sach.NgaySinh)); cmd.Parameters.Add(new SqlParameter("@GioiTinh", sach.GioiTinh)); cmd.Parameters.Add(new SqlParameter("@DiaChi", sach.DiaChi)); cmd.Parameters.Add(new SqlParameter("@SDT", sach.SDT)); int t = (int)cmd.ExecuteNonQuery(); cmd.Clone(); return(t >= 1); } }