public bool CapNhat(NhanVien obj)
{
string strsql = "update NhanVien set TenNhanVien = @TenNhanVien, GioiTinh = @GioiTinh,DiaChi = @DiaChi,NgaySinh= @NgaySinh, SoDT= @SoDT , ChucVu = @ChucVu, TaiKhoan = @TaiKhoan where MaNV = @MaNV";
SqlParameter[] pars = new SqlParameter[9];
pars[0] = new SqlParameter("@MaNV", SqlDbType.NChar, 5);
pars[0].Value = obj.MaNV;
pars[1] = new SqlParameter("@TenNhanVien", SqlDbType.NChar, 30);
pars[1].Value = obj.TenNhanVien;
pars[2] = new SqlParameter("GioiTinh", SqlDbType.NChar, 4);
pars[2].Value = obj.GioiTinh;
pars[3] = new SqlParameter("DiaChi", SqlDbType.NChar, 30);
pars[3].Value = obj.DiaChi;
pars[4] = new SqlParameter("NgaySinh", SqlDbType.DateTime);
pars[4].Value = obj.NgaySinh;
pars[5] = new SqlParameter("SoDT", SqlDbType.NChar, 10);
pars[5].Value = obj.SDT;
pars[6] = new SqlParameter("ChucVu", SqlDbType.NChar, 10);
pars[6].Value = obj.ChucVu;
pars[7] = new SqlParameter("TaiKhoan", SqlDbType.NChar, 50);
pars[7].Value = obj.TaiKhoan;
pars[8] = new SqlParameter("MatKhau", SqlDbType.NChar, 50);
pars[8].Value = obj.MatKhau;
return(ConnectSQL.ThucHien(strsql, pars));
}
public bool ThemMoi(NhanVien objNV)
{
string sqlstr = "insert into NhanVien(MaNV, TenNhanVien, GioiTinh, DiaChi, NgaySinh, SoDT, ChucVu, TaiKhoan, MatKhau) values (@MaNV, @TenNhanVien,@GioiTinh,@DiaChi,@NgaySinh,@SoDT,@ChucVu,@TaiKhoan,@MatKhau)";
SqlParameter[] pars = new SqlParameter[9];
pars[0] = new SqlParameter("@MaNV", SqlDbType.NChar, 5);
pars[0].Value = objNV.MaNV;
pars[1] = new SqlParameter("@TenNhanVien", SqlDbType.NChar, 30);
pars[1].Value = objNV.TenNhanVien;
pars[2] = new SqlParameter("@GioiTinh", SqlDbType.NChar, 4);
pars[2].Value = objNV.GioiTinh;
pars[3] = new SqlParameter("@DiaChi", SqlDbType.NChar, 30);
pars[3].Value = objNV.DiaChi;
pars[4] = new SqlParameter("@NgaySinh", SqlDbType.DateTime);
pars[4].Value = objNV.NgaySinh;
pars[5] = new SqlParameter("@SoDT", SqlDbType.NChar, 10);
pars[5].Value = objNV.SDT;
pars[6] = new SqlParameter("@ChucVu", SqlDbType.NChar, 10);
pars[6].Value = objNV.ChucVu;
pars[7] = new SqlParameter("@TaiKhoan", SqlDbType.NChar, 50);
pars[7].Value = objNV.TaiKhoan;
pars[8] = new SqlParameter("@MatKhau", SqlDbType.NChar, 50);
pars[8].Value = objNV.MatKhau;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
public bool Xoa(string MaNV)
{
//Lay manv
string strDel = "delete from NhanVien where MaNV = '" + MaNV + "'";
return(ConnectSQL.ThucHien(strDel));
}
public bool CapNhat(MayBay objMB)
{
string sqlstr = "Update MayBay set MaMayBay = @MaMayBay, TenMayBay = @TenMayBay, HangSanXuat = @HangSanXuat, SoLuongGhe1 = @SoLuongGhe1, SoLuongGhe2 = @SoLuongGhe2 where MaMayBay = @MaMayBay ";
SqlParameter[] pars = new SqlParameter[5];
pars[0] = new SqlParameter("@MaMayBay", SqlDbType.NChar, 5);
pars[0].Value = objMB.MaMayBay;
pars[1] = new SqlParameter("@TenMayBay", SqlDbType.NChar, 30);
pars[1].Value = objMB.TenMayBay;
pars[2] = new SqlParameter("@HangSanXuat", SqlDbType.NChar, 30);
pars[2].Value = objMB.HangSanXuat;
pars[3] = new SqlParameter("@SoLuongGhe1", SqlDbType.Int);
pars[3].Value = objMB.SoLuongGhe1;
pars[4] = new SqlParameter("@SoLuongGhe2", SqlDbType.Int);
pars[4].Value = objMB.SoLuongGhe2;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
public bool ThemMoi(MayBay objMB)
{
string sqlstr = "insert into MayBay(MaMayBay, TenMayBay, HangSanXuat, SoLuongGhe1, SoLuongGhe2) values (@MaMayBay, @TenMayBay, @HangSanXuat, @SoLuongGhe1, @SoLuongGhe2)";
SqlParameter[] pars = new SqlParameter[5];
pars[0] = new SqlParameter("@MaMayBay", SqlDbType.NChar, 5);
pars[0].Value = objMB.MaMayBay;
pars[1] = new SqlParameter("@TenMayBay", SqlDbType.NChar, 30);
pars[1].Value = objMB.TenMayBay;
pars[2] = new SqlParameter("@HangSanXuat", SqlDbType.NChar, 30);
pars[2].Value = objMB.HangSanXuat;
pars[3] = new SqlParameter("@SoLuongGhe1", SqlDbType.Int);
pars[3].Value = objMB.SoLuongGhe1;
pars[4] = new SqlParameter("@SoLuongGhe2", SqlDbType.Int);
pars[4].Value = objMB.SoLuongGhe2;
return(ConnectSQL.ThucHien(sqlstr, pars));
}
public bool Xoa(string MaMB)
{
string sqlstr = "delete from MayBay where MaMayBay = '" + MaMB + "'";
return(ConnectSQL.ThucHien(sqlstr));
}
