private bool CanRequestNotifications()
{
// In order to use the callback feature of the
// SqlDependency, the application must have
// the SqlClientPermission permission.
try
{
SqlClientPermission perm =
new SqlClientPermission(
PermissionState.Unrestricted);
perm.Demand();
return(true);
}
catch (SecurityException se)
{
MessageBox.Show(se.Message, "Permission Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
catch (Exception e)
{
MessageBox.Show(e.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public void ActivarSqlDependency()
{
try
{
SqlClientPermission permission = new SqlClientPermission(PermissionState.Unrestricted);
SqlDependency.Stop(_connectionString);
if (!SqlDependency.Start(_connectionString))
{
throw new Exception("No es posible iniciar el agente de escucha para recibir notificaciones de cambio de dependencia desde la instancia de SQL Server especificada por la cadena de conexión");
}
}
catch (System.Security.SecurityException)
{
throw new Exception("No existe los permisos necesarios en el SqlClient");
}
catch (System.Data.SqlClient.SqlException ex)
{
throw new Exception("El usuario utilizado no tiene los privilegios necesarios o no se logro establecer comunicación a la instancia de SQL Server");
}
catch (Exception)
{
throw new Exception("No se logro establecer comunicación a la instancia de SQL Server");
}
}
public BangGiaTrucTuyen()
{
InitializeComponent();
try
{
SqlClientPermission ss = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
ss.Demand();
}
catch (Exception)
{
throw;
}
SqlDependency.Stop(m_connect);
SqlDependency.Start(m_connect);
Program.conn = new SqlConnection(m_connect);
string strLenh = "EXEC SP_BangGiaTrucTuyen";
Program.myReader = Program.ExecSqlDataReader(strLenh);
if (Program.myReader == null)
{
return;
}
Program.myReader.Close();
}
internal static bool HasSqlClientPermission()
{
NamedPermissionSet permissionset = HttpRuntime.NamedPermissionSet;
// If we don't have a NamedPermissionSet, we're in full trust
if (permissionset == null)
{
return(true);
}
// Check that the user has unrestricted SqlClientPermission
IPermission allowedPermission = permissionset.GetPermission(typeof(SqlClientPermission));
if (allowedPermission == null)
{
return(false);
}
IPermission askedPermission = null;
try {
askedPermission = new SqlClientPermission(PermissionState.Unrestricted);
}
catch {
return(false);
}
return(askedPermission.IsSubsetOf(allowedPermission));
}
private void StartNotifyConnection()
{
_sqlConn = new SqlConnection(_connectString);
// check if hosting enviromnet can listen to exceptions
SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted);
try
{
perm.Demand();
}
catch (Exception ex)
{
var secEx = new Exception("The hosting enviromnent does not have SqlClientPermission", ex);
broadCastException(secEx);
throw secEx;
}
try
{
_sqlConn.Open();
SqlDependency.Stop(_connectString);
SqlDependency.Start(_connectString);
StartNotifying();
}
catch (Exception ex)
{
broadCastException(ex);
throw;
}
}
private void BtnUnLoadAppDomain_Click(object sender, EventArgs e)
{
var sqlPerm =
new SqlClientPermission(PermissionState.Unrestricted);
sqlPerm.Assert();
if (txtAppDomainAddress.Text.Equals("N/A"))
{
MessageBox.Show(@"The application domain is not loaded");
return;
}
btnUnloadAppDomain.Enabled = false;
btnLoadAppDomain.Enabled = false;
btnGetHtml.Enabled = false;
var permissionSet = txtPermissionSet.Text;
_connectionString = DataAccess.GetConnectionString(txtServer.Text, cmbDatabase.Text,
cmbAuth.SelectedIndex == 0, txtUserName.Text, txtPassword.Text);
if (Monitor.ReleaseMemory(_connectionString, "[" + listBoxAssemblies.Text + "]", permissionSet))
{
BindAssemblyList(listBoxAssemblies.Text);
}
else
{
MessageBox.Show(@"I'm not able to unload the application domain!");
}
btnUnloadAppDomain.Enabled = true;
btnLoadAppDomain.Enabled = true;
btnGetHtml.Enabled = true;
}
internal static bool HasSqlClientPermission()
{
NamedPermissionSet namedPermissionSet = HttpRuntime.NamedPermissionSet;
if (namedPermissionSet == null)
{
return(true);
}
IPermission target = namedPermissionSet.GetPermission(typeof(SqlClientPermission));
if (target == null)
{
return(false);
}
IPermission permission2 = null;
try
{
permission2 = new SqlClientPermission(PermissionState.Unrestricted);
}
catch
{
return(false);
}
return(permission2.IsSubsetOf(target));
}
private void Form1_Load(object sender, EventArgs e)
{
SqlClientPermission sqlClientPermission = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
sqlClientPermission.Demand();
SqlDependency.Start(connectionString);
LoadData();
}
public void Unrestricted_Add()
{
SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted);
Check("Unrestricted-NoChild", perm, false, true, 0);
perm.Add("data source=localhost;", String.Empty, KeyRestrictionBehavior.AllowOnly);
// note: Lost unrestricted state when children was added
Check("Unrestricted-WithChild", perm, false, false, 1);
}
private void InitSqlDependency()
{
LazyInitializer.EnsureInitialized(ref _sqlDependencyInit, () =>
{
SqlDependency.Start(_connectionString);
var perm = new SqlClientPermission(PermissionState.Unrestricted);
perm.Demand();
return(new object());
});
}
internal CSQLClientPermControls(IPermission perm, Object oParent) : base(perm, oParent)
{
// If they don't have a permission for this permission set, we will
// feed our property page a 'none' permission state.
if (perm == null)
{
m_perm = new SqlClientPermission(PermissionState.None);
}
}// CSQLClientPermControls
//check if user has permission
private bool DoesUserHavePermission()
{
try {
SqlClientPermission clientPermission =
new SqlClientPermission(PermissionState.Unrestricted);
clientPermission.Demand();
return(true);
}
catch {
return(false);
}
}
public bool CanRequestNotifications()
{
try
{
var perm = new SqlClientPermission(PermissionState.Unrestricted);
perm.Demand();
return(true);
}
catch
{
return(false);
}
}
bool DoesHavePermitions()
{
try
{
SqlClientPermission clientPermition = new SqlClientPermission(PermissionState.Unrestricted);
clientPermition.Demand();
return(true);
}
catch (Exception e)
{
return(false);
}
}
//kiểm tra dịch vụ SQL Broker
private bool CanRequestNotifications()
{
try
{
SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted);
perm.Demand();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private bool CanRequestNotifications()
{
SqlClientPermission permission = new SqlClientPermission(PermissionState.Unrestricted);
try
{
permission.Demand();
return(true);
}
catch (System.Exception)
{
return(false);
}
}
public Real_Time_Nofication()
{
InitializeComponent();
try
{
SqlClientPermission perm = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
perm.Demand();
}
catch
{
throw new ApplicationException("No permission");
}
}
public void None()
{
SqlClientPermission perm = new SqlClientPermission(PermissionState.None);
Check("None-1", perm, false, false, 0);
perm.AllowBlankPassword = true;
Check("None-2", perm, true, false, 0);
SqlClientPermission copy = (SqlClientPermission)perm.Copy();
Check("Copy_None-1", copy, true, false, 0);
copy.AllowBlankPassword = false;
Check("Copy_None-2", copy, false, false, 0);
}
static private bool HasEnoughPermission()
{
SqlClientPermission permsission = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
try
{
permsission.Demand();
return(true);
}
catch (System.Exception)
{
return(false);
}
}
private void Form1_Load(object sender, EventArgs e)
{
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(Screen.PrimaryScreen.WorkingArea.Width - this.Width,
Screen.PrimaryScreen.WorkingArea.Height - this.Height);
string connectionString = @"data source=localhost;
initial catalog = BondDB; persist security info = True;
Integrated Security = SSPI; ";
SqlClientPermission sqlClientPermission = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
sqlClientPermission.Demand();
SqlDependency.Start(connectionString);
LoadData();
}
// --------------- ZONE NGOC CODE ----------------- //
private Boolean canRequestNotifications()
{
try
{
SqlClientPermission permision = new SqlClientPermission(PermissionState.Unrestricted);
permision.Demand();
return(true);
}
catch (Exception ex)
{
Console.WriteLine(ex);
return(false);
}
}
public static void InsertLatestStockPrice(string symbol)
{
try
{
PermissionSet perms = new PermissionSet(PermissionState.None);
string url = "http://finance.yahoo.com/d/quotes.csv?s=" + symbol +
"&f=sl1d1t1c1ov";
WebPermission webPerm = new WebPermission(NetworkAccess.Connect, url);
perms.AddPermission(webPerm);
SqlClientPermission sqlPerm = new SqlClientPermission(
PermissionState.None);
sqlPerm.Add("context connection=true", "",
KeyRestrictionBehavior.AllowOnly);
perms.AddPermission(sqlPerm);
perms.PermitOnly();
string[] data = HttpFileReader.ReadFile(url);
string[] cols = data[0].Split(new char[] { ',' });
string date = cols[2].Substring(1, cols[2].Length - 2);
string time = cols[3].Substring(1, cols[3].Length - 2);
DateTime tradetime = DateTime.Parse(date + " " + time);
double price = Double.Parse(cols[1]);
double change = Double.Parse(cols[4]);
SqlDouble openprice = cols[5] == "N/A" ? SqlDouble.Null :
SqlDouble.Parse(cols[5]);
int volume = Int32.Parse(cols[6]);
using (SqlConnection cn = new SqlConnection("context connection=true"))
{
cn.Open();
string cmdStr = "INSERT INTO StockPrices VALUES (@symbol, @price, @tradetime, @change, @openprice, @volume)";
SqlCommand cmd = new SqlCommand(cmdStr, cn);
cmd.Parameters.AddWithValue("@symbol", symbol);
cmd.Parameters.AddWithValue("@price", price);
cmd.Parameters.AddWithValue("@tradetime", tradetime);
cmd.Parameters.AddWithValue("@change", change);
cmd.Parameters.AddWithValue("@openprice", openprice);
cmd.Parameters.AddWithValue("@volume", volume);
cmd.ExecuteNonQuery();
}
}
catch (Exception e)
{
SqlPipe pipe = SqlContext.Pipe;
pipe.Send(e.Message);
}
}
public THONGTIN()
{
InitializeComponent();
try
{
SqlClientPermission ss = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
ss.Demand();
}
catch (Exception)
{
throw;
}
SqlDependency.Start(m_connect);
con = new SqlConnection(m_connect);
}
public void Unrestricted()
{
SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted);
Check("Unrestricted-1", perm, false, true, 0);
perm.AllowBlankPassword = true;
Check("Unrestricted-2", perm, true, true, 0);
SqlClientPermission copy = (SqlClientPermission)perm.Copy();
// note: Unrestricted is always created with default values (so AllowBlankPassword is false)
Check("Copy_Unrestricted-1", copy, false, true, 0);
copy.AllowBlankPassword = true;
Check("Copy_Unrestricted-2", copy, true, true, 0);
}
/// <summary>
/// Constructor
/// </summary>
public Chat_User_Tes()
{
InitializeComponent();
// Make sure client has permissions
try
{
SqlClientPermission perm = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
perm.Demand();
}
catch
{
throw new ApplicationException("No permission");
}
}
public frmTheoDoiCongViec()
{
InitializeComponent();
try
{
SqlClientPermission sq = new SqlClientPermission(System.Security.Permissions.PermissionState.Unrestricted);
sq.Demand();
}
catch (Exception)
{
}
//SqlDependency.Stop(Global.ConnectionString);
//SqlDependency.Start(Global.ConnectionString);
}
}// PutValuesinPage
internal override IPermission GetCurrentPermission()
{
SqlClientPermission perm;
if (m_radUnrestricted.Checked == true)
{
perm = new SqlClientPermission(PermissionState.Unrestricted);
}
else
{
perm = new SqlClientPermission(PermissionState.None);
}
return(perm);
}// GetCurrentPermissions
private bool CheckPermission()
{
try
{
SqlClientPermission clientPermission =
new SqlClientPermission(PermissionState.Unrestricted);
clientPermission.Demand();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return(false);
}
}
private bool CanRequestNotifications()
{
try
{
SqlClientPermission perm = new SqlClientPermission(PermissionState.Unrestricted);
perm.Demand();
return(true);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Notification", MessageBoxButtons.OK);
return(false);
}
}
}// InsertPropSheetPageControls
protected override void PutValuesinPage()
{
SqlClientPermission perm = (SqlClientPermission)m_perm;
if (perm.IsUnrestricted())
{
m_radUnrestricted.Checked = true;
}
else
{
m_radGrantFollowingPermission.Checked = true;
m_chkAllowBlankPasswords.Checked = perm.AllowBlankPassword;
}
onChangeUnRestrict(null, null);
}// PutValuesinPage
