public void updatePasswordModel(tblNhanVienModel nhanvien, string taiKhoan)
{
//string sql = "Update tblNhanVien set MATKHAU='" + nhanvien.MatKhau + "'where TENTAIKHOAN='" + taiKhoan + "'";
//connectSer.ThucThiSQLTheoKetNoi(sql);
sqlCom = new SqlCommand();
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.CommandText = "USP_DoiMatKhau";
sqlCom.Parameters.Add("@TENTAIKHOAN", SqlDbType.VarChar).Value = taiKhoan;
sqlCom.Parameters.Add("@MATKHAU", SqlDbType.VarChar).Value = nhanvien.MatKhau;
sqlCom.Connection = connectSer.Connect();
sqlCom.ExecuteNonQuery();
}
public void updateModel(tblNhanVienModel nhanvien)
{
//string sql = "Update tblNhanVien set PHANQUYEN='" + nhanvien.PhanQuyen + "'where TENTAIKHOAN='" + nhanvien.TaiKhoan + "'";
//connectSer.ThucThiSQLTheoKetNoi(sql);
sqlCom = new SqlCommand();
sqlCom.CommandType = CommandType.StoredProcedure;
sqlCom.CommandText = "USP_UpdateNhanVien";
sqlCom.Parameters.Add("@TENTAIKHOAN", SqlDbType.VarChar).Value = nhanvien.TaiKhoan;
sqlCom.Parameters.Add("@PHANQUYEN", SqlDbType.NVarChar).Value = nhanvien.PhanQuyen;
sqlCom.Connection = connectSer.Connect();
sqlCom.ExecuteNonQuery();
}
public void createModel(tblNhanVienModel nhanvien)
{
string sql = "insert into tblNhanVien(TENTAIKHOAN,MATKHAU)values('" + nhanvien.TaiKhoan + "','" + nhanvien.MatKhau + "')";
connectSer.ThucThiSQLTheoKetNoi(sql);
//sqlCom = new SqlCommand();
//sqlCom.CommandType = CommandType.StoredProcedure;
//sqlCom.CommandText = "USP_InsertNhanVien";
//sqlCom.Parameters.Add("@TENTAIKHOAN", SqlDbType.VarChar).Value = nhanvien.TaiKhoan;
//sqlCom.Parameters.Add("@MATKHAU", SqlDbType.NVarChar).Value = nhanvien.MatKhau;
//sqlCom.Connection = connectSer.Connect();
//sqlCom.ExecuteNonQuery();
}
