public void creatEquityTicket()
{
SqlConnection cn = new SqlConnection("Data Source=ZM-SQL-1;Initial Catalog=ZM_GALLAGHER; Integrated Security=SSPI;");
cn.Open();
SqlCommand CMD = new SqlCommand();
CMD = cn.CreateCommand();
SqlDataReader RDR;
//CMD.CommandText = "IF OBJECT_ID('EQUITY_TICKET', 'U') IS NOT NULL DROP TABLE EQUITY_TICKET;";
CMD.CommandText = "IF OBJECT_ID (N'EQUITY_TICKET',N'U') IS NOT NULL SELECT 1 AS RES ELSE SELECT 0 AS RES;";
RDR = CMD.ExecuteReader();
RDR.Read();
if (RDR.GetValue(0).ToString() == "0")
{
RDR.Close();
CMD.CommandText = "CREATE TABLE EQUITY_TICKET( [ID][int] IDENTITY(1, 1) NOT NULL, TKT_USER[VARCHAR](255) NOT NULL, " +
" TKT_ACCOUNT_ID [INT] NOT NULL, TKT_TICKER[VARCHAR](10) NOT NULL, TKT_DATE[datetime] NOT NULL )";
CMD.ExecuteNonQuery();
}
RDR.Close();
cn.Close();
}
private void quita()
{
MySqlConnection Conexion_BD = new MySqlConnection("server=127.0.0.1; database = gestor1; Uid=root; pwd=;");
//private SqlConnection Conexion_BD = new SqlConnection(Properties.Settings.Default.ConBDatos);
MySqlCommand CMD;
MySqlDataReader RDR;
MySqlCommand consulta = new MySqlCommand("select Tipo_usuario from usuarios where Tipo_usuario = 'ADMIN'");
consulta.Connection = Conexion_BD;
Conexion_BD.Open();
consulta.ExecuteNonQuery();
consulta.CommandType = CommandType.Text;
consulta.Parameters.Add(new MySqlParameter());
RDR = consulta.ExecuteReader();
if (RDR.Read())
{
CMB_TipUsu.Items.Remove("ADMIN");
}
Conexion_BD.Close();
//"select * from usuarios where Tipo_usuario = 'ADMIN'";
}
