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