public static MySqlConnection GetMySqlConnection() { if (connectionQueue.Count > 0) { lock (connectionQueue) { if (connectionQueue.Count > 0) { return(connectionQueue.Dequeue()); } else { MySqlConnection conection = (MySqlConnection)baseConnection.Clone(); conection.Open(); return(conection); } } } else { MySqlConnection conection = (MySqlConnection)baseConnection.Clone(); conection.Open(); return(conection); } }
/// <summary> /// تغییر وضعیت لیستی از رکوردها در مای اس کیو ال /// </summary> /// <param name="listDisabel">لیست شناسه ها</param> /// <returns></returns> public static bool UpdateTagRecordList(List <int> listDisabel) { string cs = @"server=localhost;port=3306;userid=ard;password=Ss987654;database=schooldb;SSL Mode = None"; using (var conn = new MySqlConnection(cs)) { try { conn.Open(); foreach (var id in listDisabel) { var cmdString = $"update schooldb.tagrecive set Registered = '0' where ID = '{id}' ;"; var cmd = new MySqlCommand(cmdString, conn); var result = cmd.ExecuteNonQuery(); } conn.Clone(); return(true); } catch (Exception e) { Logger.WriteErrorLog(e, "UpdateTagRecordList"); conn.Clone(); return(false); } } }
private static MySqlConnection GetMySqlConnection() { if (baseConnection == null) { baseConnection = new MySqlConnection(ConnectionString); } if (connectionQueue.Count > 0) { lock (connectionQueue) { if (connectionQueue.Count > 0) { return(connectionQueue.Dequeue()); } else { MySqlConnection conection = (MySqlConnection)baseConnection.Clone(); conection.Open(); return(conection); } } } else { MySqlConnection conection = (MySqlConnection)baseConnection.Clone(); conection.Open(); return(conection); } }
public void Insert(DataSet dataSet) { var insertQuery = $"INSERT INTO {_dbName}.{_tableName} ({String.Join(",", _columns.Select(c => c.Name))})"; var values = String.Join(",", dataSet.Rows.Select(row => { var rowStr = ""; for (var i = 0; i < row.Columns.Length; i++) { rowStr += ToMySqlValue(row.Values[i], row.Columns[i]); if (i < row.Columns.Length - 1) { rowStr += ","; } } return($"({rowStr})"); })); insertQuery += $"VALUES {values};"; using (var connection = (MySqlConnection)_connection.Clone()) { connection.Open(); var cmd = new MySqlCommand(insertQuery, connection); cmd.ExecuteNonQuery(); } }
/// <summary> /// خواندن ثبت جدید از بانک مای اس کیوال /// </summary> /// <returns></returns> public static List <View_TagList> ReaderSQL() { string cs = @"server=localhost;port=3306;userid=ard;password=Ss987654;database=schooldb;SSL Mode = None"; var list = new List <View_TagList>(); using (var conn = new MySqlConnection(cs)) { try { conn.Open(); var cmdString = "SELECT * FROM schooldb.tagrecive where Registered = '1'"; var cmd = new MySqlCommand(cmdString, conn); var result = cmd.ExecuteReader(); while (result.Read()) { list.Add(new View_TagList() { ID = result.GetInt32(0), Tag = result.GetString(1), dateRegister = result.GetDateTime(2), Reg = result.GetInt32(3), TypeImport = result.GetInt32(4), }); } conn.Clone(); return(list); } catch (Exception e) { Logger.WriteErrorLog(e, "ReaderSQL"); conn.Clone(); return(null); } } }
public async Task <DbGuild> FetchDbGuildAsync(ulong id) { var cached = DbGuild.GuildCache.GetCached(id); if (cached != null) { return(cached); } var con = (MySqlConnection)_baseConnection.Clone(); await con.OpenAsync(); var cmd = con.CreateCommand(); cmd.CommandText = "SELECT * FROM Guilds WHERE guildId=@Id;"; cmd.Parameters.AddWithValue("Id", id); var reader = await cmd.ExecuteReaderAsync(); if (!reader.HasRows) { return(null); } await reader.ReadAsync(); return(DbGuild.GuildCache.AddToCache(new DbGuild(reader))); }
public static void AddMaintenance(Maintenance maintenance) { MySqlConnection currentBDD = new MySqlConnection(ConfigurationManager.ConnectionStrings["connexionString"].ConnectionString); string sqlinsert = "INSERT INTO maintenance (incident_id, start_date, planned_date) VALUES (@incident_id, @dateDebut, @dateEstimee);"; using (MySqlCommand cmd = new MySqlCommand(sqlinsert, currentBDD)) { cmd.Parameters.AddWithValue("@incident_id", maintenance.Incident.Id); cmd.Parameters.AddWithValue("@dateDebut", maintenance.start_date); cmd.Parameters.AddWithValue("@dateEstimee", maintenance.planned_date); currentBDD.Open(); int result = cmd.ExecuteNonQuery(); currentBDD.Close(); } string sqlinsert2 = "UPDATE `plane` SET `state_id`= (Select id from state where libelle = \"En maintenance\") WHERE id = @plane_id;"; using (MySqlCommand cmd = new MySqlCommand(sqlinsert2, currentBDD)) { cmd.Parameters.AddWithValue("@plane_id", maintenance.Plane.Id); currentBDD.Open(); int result = cmd.ExecuteNonQuery(); currentBDD.Clone(); } int id; string sqlinsert3 = "SELECT id FROM maintenance WHERE end_date is NULL Order by id desc LIMIT 1"; MySqlCommand cmd3 = new MySqlCommand(sqlinsert3, currentBDD); using (MySqlDataReader rdr = cmd3.ExecuteReader()) { rdr.Read(); id = Convert.ToInt32(rdr[0]); } foreach (Employee employee in maintenance.Employees) { string sqlinsert4 = "INSERT INTO maintenance_employee (employee_id, maintenance_id, responsible) VALUES (@idEmploye, @id, @responsable);"; using (MySqlCommand cmd2 = new MySqlCommand(sqlinsert4, currentBDD)) { cmd2.Parameters.AddWithValue("@idEmploye", employee.Id); cmd2.Parameters.AddWithValue("@id", id); if (maintenance.Responsible.Id == employee.Id) { cmd2.Parameters.AddWithValue("@responsable", 1); } else { cmd2.Parameters.AddWithValue("@responsable", 0); } int result = cmd2.ExecuteNonQuery(); currentBDD.Clone(); } } }
public DataTable leerDatosEmpleado() { DataTable datos = new DataTable(); conexion(); MySqlCommand comando = new MySqlCommand("Select * from empleado", conectar); MySqlDataAdapter adaptador = new MySqlDataAdapter(comando); DataSet ds = new DataSet(); adaptador.Fill(ds, "empleado"); datos = ds.Tables["empleado"]; conectar.Clone(); return(datos); }
public Herbaceous Create(Herbaceous t) { MySqlConnection conn = DB.DBUtils.GetDBConnection(); conn.OpenAsync(); try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO warehouse.herbaceous(HerbaceousType,DealerCountry,Price,Count) VALUES(?Herbaceous,?DealerCountry,?Price,?Count)"; cmd.Connection = conn; cmd.Parameters.Add("?Price", MySqlDbType.VarChar).Value = t.Price; cmd.Parameters.Add("?Count", MySqlDbType.VarChar).Value = t.Count; cmd.Parameters.Add("?Herbaceous", MySqlDbType.VarChar).Value = t.Type; cmd.Parameters.Add("?DealerCountry", MySqlDbType.VarChar).Value = t.Country; cmd.ExecuteNonQueryAsync(); conn.Clone(); } catch (Exception e) { Console.WriteLine(e); throw; } return(t); }
//*******************************************************************************************************// // // // // // Metodo // // // // // //*******************************************************************************************************// //*******************************************************************************************************// // // // // // Excluir // // // // // //*******************************************************************************************************// #region Exclir private void excluiID() { try { //abrindo servirdor conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;"); //comando mySQL com parametros stringSQL = "DELETE FROM dados WHERE email = @email"; comando = new MySqlCommand(stringSQL, conexao); comando.Parameters.AddWithValue("@email", txtEmail.Text); //abrindo servidor conexao.Open(); //executando o comando comando.ExecuteNonQuery(); } catch (Exception ex) { //mensagem de erro MessageBox.Show(ex.Message); } finally { //fechando servidor conexao.Clone(); conexao = null; comando = null; } }
private void button2_Click(object sender, EventArgs e) { if (ad.Text.Trim() == "" || soyad.Text.Trim() == "") { MessageBox.Show("Lütfen ad ve soyad kısmını boş bırakmayınız"); } else { try { MySqlConnection baglanti = new MySqlConnection(Sinif_cek.baglan()); string Query = "UPDATE uyeler SET ad = '" + ad.Text + "',soyad='" + soyad.Text + "' WHERE ogrenci_no = " + ogr_no.Text + ""; MySqlCommand MyCommand2 = new MySqlCommand(Query, baglanti); MySqlDataReader MyReader2; baglanti.Open(); MyReader2 = MyCommand2.ExecuteReader(); baglanti.Close(); MessageBox.Show("Bilgiler Güncellendi."); sifre.Text = ""; ad.Text = ""; soyad.Text = ""; ogr_no.Text = ""; sifre_tekrar.Text = ""; baglanti.Clone(); ogrencileri_cek(); textBox1.Text = ""; textBox1.Focus(); } catch { MessageBox.Show("Hata!"); } } }
//*******************************************************************************************************// // // // // // Excluir // // // // // //*******************************************************************************************************// #region Excluir private void ExcluirDados() { InformaID(); exibir(); try { conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;"); stringSQL = "DELETE FROM produtos WHERE id_produto = @id_produto"; comando = new MySqlCommand(stringSQL, conexao); comando.Parameters.AddWithValue("@id_produto", NumUDID2.Value); conexao.Open(); comando.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Clone(); conexao = null; comando = null; } }
//méthode qui vérifie l'identifiant et le mot de passe public bool VerifUser(string id, string mdp) { string req = "SELECT * FROM utilisateur;"; List <string> identifiants = new List <string>(); List <string> mdps = new List <string>(); conn = new MySqlConnection(cs); MySqlCommand cmd = new MySqlCommand(req, conn); //ouverture de la connexion de l'objet portant les attributs contenu dans la variable cs (string) conn.Open(); //on stocke dans un objet MySqlReader les resultats de la requete MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { //liste.Add(reader[0].ToString());//on affecte dynamiquement l'élément pointé dans la liste identifiants.Add(reader["adresse_mail"].ToString()); mdps.Add(reader["password"].ToString()); } for (int i = 0; i < identifiants.Count; i++) { if (identifiants[i] == id && mdps[i] == mdp) { conn.Clone(); return(true); } } conn.Close(); return(false); }
//*******************************************************************************************************// // // // // // Exibir // // // // // //*******************************************************************************************************// #region Exibir //exibe as informações dos clientes no datagridview private void exibir() { try { conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;"); conexaoSQL.PagamentosExibirConSQL(); MySqlCommand comando = new MySqlCommand(conexaoSQL.PagamentosExibirConSQL(), conexao); DataTable dt = new DataTable(); MySqlDataAdapter da = new MySqlDataAdapter(comando); da.Fill(dt); dgvCaixa.DataSource = dt; conexao.Open(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Clone(); conexao = null; comando = null; } }
internal static void SetUserInfo(int ID) { //create connection and open it MySqlConnection connection = DbInfo.Connection(); //try to connect to database try { //Build Mysql command MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT `ID`, `Firstname`, `Middlename`, `Lastname`, `Email`, `Password`, `Pin` FROM `users` WHERE `ID`=" + ID; MySqlDataReader reader = cmd.ExecuteReader(); //if match is found if (reader.Read()) { //MessageBox.Show(reader["Firstname"] + " "+ reader["Middlename"].ToString()); Userinformation = new userinf(ID, reader["Firstname"].ToString(), reader["Middlename"].ToString(), reader["Lastname"].ToString(), reader["Email"].ToString()); } } //finally finally { //check state and clone if (connection.State == ConnectionState.Open) { connection.Clone(); } } }
public void InsertListwa(string symbol, string material, string kolor, bool ornament, string okleina, float kosztMb) { MySqlConnection connection = new MySqlConnection(MyConnectionString); MySqlCommand cmd; connection.Open(); try { cmd = connection.CreateCommand(); cmd.CommandText = "INSERT INTO listwa(symbol,material,kolor,ornament,okleina,kosztMb)VALUES(@symbol,@material,@kolor,@ornament,@okleina,@kosztMb)"; cmd.Parameters.AddWithValue("@symbol", symbol); cmd.Parameters.AddWithValue("@material", material); cmd.Parameters.AddWithValue("@kolor", kolor); cmd.Parameters.AddWithValue("@ornament", ornament); cmd.Parameters.AddWithValue("@okleina", okleina); cmd.Parameters.AddWithValue("@kosztMb", kosztMb); //cmd.Parameters.AddWithValue("@ornament"); cmd.ExecuteNonQuery(); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Clone(); } } }
public static Boolean HasOnDatabase(Int32 Id) { String connectionString = DatabaseControl.GetConnectionString(); MySqlConnection conn = new MySqlConnection(connectionString); try { var command = conn.CreateCommand(); MySqlDataReader rdr = null; conn.Open(); string stm = String.Format("SELECT * FROM md_propertydetails WHERE ID={0}", Id); MySqlCommand cmd = new MySqlCommand(stm, conn); rdr = cmd.ExecuteReader(); Int32 count = 0; while (rdr.Read()) { count++; break; } return(count > 0); }catch (Exception ex) { } finally { conn.Clone(); } return(false); }
//*******************************************************************************************************// // // // // // Editar // // // // // //*******************************************************************************************************// #region Editar private void edit() { InformaID(); exibir(); try { conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;"); stringSQL = "UPDATE produtos SET destribuidor = @destribuidor, marca = @marca, descricao_produto = @descricao_produto, tamanho_produto = @tamanho_produto" + ", sexo = @sexo, quantidade = @quantidade, preco = @preco, precoCliente = @precoCliente WHERE id_produto = @id_produto"; comando = new MySqlCommand(stringSQL, conexao); parametros(); conexao.Open(); comando.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Clone(); conexao = null; comando = null; } }
private void BotonAgregar_Click(object sender, EventArgs e) { //try //{ //varialbes para iinsertar en la base de datos int numero = Convert.ToInt32(ComboNumero1.Text); string tipos = ComboTipo1.Text; int numerocamas = Convert.ToInt32(ComboNumeroCama.Text); string tipocama = ComboTipoCama1.Text; int capcadidad = Convert.ToInt32(ComboCapacidad1.Text); decimal tarifa = Convert.ToDecimal(TxtTarifa1.Text); // conexion con la base de datos MySql.Data.MySqlClient.MySqlConnection conexion = new MySqlConnection(); //objeto string cadenaConexion = "server=192.168.1.50; uid=daviduxotto; pwd=daviduxotto; Port=3306; database=BDHotel"; conexion.ConnectionString = cadenaConexion; conexion.Open(); // abrimos conezion String consulta = "update Habitacion set Tipo='" +tipos + "', NumeroCamas=" + numerocamas + ",TipoCama='" + tipocama + "', Capacidad=" + capcadidad + ", Tarifa=" + tarifa + " where Id="+numero; // realizamos consulta MySqlCommand comando = new MySqlCommand(consulta, conexion); comando.ExecuteReader(); conexion.Clone(); MessageBox.Show("se ha actualizado con exito"); habitaciones habitacion = new habitaciones(); habitacion.Show(); this.Close(); // } //catch (Exception ex) // { // MessageBox.Show("se ha producido un error: " + ex); //} }
//guarda la nueva tela en la base de datos private void btn_guardar_Click(object sender, EventArgs e) { if (validarcampos() == true) { limpiariconos(); try { conectar.Open(); costo = Convert.ToInt32(tex_valor.Text); codigo = "INSERT INTO telas (Nombre,Metros,Costo) VALUES ('" + tex_nombre_tela.Text + "','" + tex_metros.Text + "','" + costo + "')"; MySqlCommand insertar = new MySqlCommand(codigo, conectar); insertar.ExecuteNonQuery(); } catch (Exception er) { MessageBox.Show("Hubo un Error " + er.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); } conectar.Clone(); MessageBox.Show("Se Creo La Tela con Exito", "Creación Exitosa", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); Limpiar(); } else { MessageBox.Show("Por favor Diligenciar Los Campos Requeridos ", "Advertencia", MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void BotonAgregar_Click(object sender, EventArgs e) { //try //{ //varialbes para iinsertar en la base de datos int numero = Convert.ToInt32(ComboCodigo2.Text); string nombre = ComboTipo.Text; decimal precio = Convert.ToDecimal(TxtTarifa.Text); // conexion con la base de datos MySql.Data.MySqlClient.MySqlConnection conexion = new MySqlConnection(); //objeto string cadenaConexion = "server=192.168.1.50; uid=daviduxotto; pwd=daviduxotto; Port=3306; database=BDHotel"; conexion.ConnectionString = cadenaConexion; conexion.Open(); // abrimos conezion String consulta = "update Comida set Nombre='" + nombre + "', Precio=" + precio + " where Id=" + numero; // realizamos consulta MySqlCommand comando = new MySqlCommand(consulta, conexion); comando.ExecuteReader(); conexion.Clone(); MessageBox.Show("se ha actualizado con exito"); ComidasPrincipal comida = new ComidasPrincipal(); comida.Show(); this.Close(); // } //catch (Exception ex) // { // MessageBox.Show("se ha producido un error: " + ex); //} }
//*******************************************************************************************************// // // // // // Metodo // // // // // //*******************************************************************************************************// //*******************************************************************************************************// // // // // // Excluir // // // // // //*******************************************************************************************************// #region Exclir //Exclui pedido realizado apartir do email private void excluiID() { try { conexao = new MySqlConnection("Server=localhost;Database=loja;User Id=root;"); conexaoSQL.PagamentosExcluiConSQL(); comando = new MySqlCommand(conexaoSQL.PagamentosExcluiConSQL(), conexao); comando.Parameters.AddWithValue("@email", txtEmail.Text); conexao.Open(); comando.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Clone(); conexao = null; comando = null; } }
void ConsultarID() { try { conexao = new MySqlConnection("Server=localhost;Database=Server=localhost;Database=Alunos;User Id=root;User Id=root;"); consql.StringNota(); comando = new MySqlCommand(consql.StringNota(), conexao); comando.Parameters.AddWithValue("@nome", txtNomeAluno.Text); conexao.Open(); Dr = comando.ExecuteReader(); while (Dr.Read()) { numUDAdobe.Value = Convert.ToInt32(Dr["notaAdobe"]); numUDCisco.Value = Convert.ToInt32(Dr["notaCisco"]); numUDLinux.Value = Convert.ToInt32(Dr["notaLinux"]); numUDMicrosoft.Value = Convert.ToInt32(Dr["notaMicrosoft"]); } } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { conexao.Clone(); conexao = null; comando = null; } }
private void buttonEx1_Click(object sender, EventArgs e) { MySqlConnection connection = new MySqlConnection(MyConnectionString); connection.Open(); try { MySqlCommand cmd = connection.CreateCommand(); cmd.CommandText = "SELECT EMPLOYEE_ID,NAME FROM hr_employee"; MySqlDataAdapter adap = new MySqlDataAdapter(cmd); DataSet ds = new DataSet(); adap.Fill(ds); dataGridViewEx1.DataSource = ds.Tables[0].DefaultView; Mes.Core.Service.MessageService.ShowMessage("show message"); Mes.Core.Utility.BindDataUtil.comboBoxBindData(Mes.Core.ApplicationObject.ComboBoxInitType.SQL, "SELECT NAME FROM hr_employee", this.comboBoxEx1); Mes.Core.Utility.BindDataUtil.comboBoxBindData(Mes.Core.ApplicationObject.ComboBoxInitType.FASTWITHNULL, "SYS_LANGUAGE", this.comboBoxEx1); } catch (Exception) { throw; } finally { if (connection.State == ConnectionState.Open) { connection.Clone(); } } }
private void button_Click(object sender, RoutedEventArgs e) { //Execute 执行 using (var connection = new MySqlConnection(conn)) { var result = connection.Execute("insert into admin set FUserName=@FUserName,ApiUrl=@ApiUrl", new[] { new { FUserName = "******", ApiUrl = "222" }, new { FUserName = "******", ApiUrl = "2" } }); } //WithTran 事务 string sql1 = "delete from admin where FUserName<>'000000'"; string sql2 = "ErrorSQL delete from admin where FUserName<>'000000'"; using (var connection = new MySqlConnection(conn)) { connection.Open(); MySqlTransaction transaction = connection.BeginTransaction(); try { connection.Execute(sql1, null, transaction); connection.Execute(sql2, null, transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); } finally { transaction.Dispose(); connection.Clone(); } } }
public DataTable SelectFuncionario(string campo) { try { conexao = new MySqlConnection(); string cs = "server=localhost;User id=root;password='';database=db_lojaRoupa"; conexao.ConnectionString = cs; conexao.Open(); string query = "select * from tb_funcionario where cpfFunc ='" + campo + "'"; MySqlDataAdapter adapter = new MySqlDataAdapter(query, conexao); DataSet ds = new DataSet(); adapter.Fill(ds); conexao.Clone(); return(ds.Tables[0]); } catch (Exception erro) { throw erro; } }
public Pork Create(Pork t) { MySqlConnection conn = DB.DBUtils.GetDBConnection(); conn.OpenAsync(); try { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO warehouse.pork(MeatFactoryName,MeatProductType,Price,Count) VALUES(?MeatProductType,?MeatFactoryName,?Price,?Count)"; cmd.Connection = conn; cmd.Parameters.Add("?Price", MySqlDbType.VarChar).Value = t.Price; cmd.Parameters.Add("?Count", MySqlDbType.VarChar).Value = t.Count; cmd.Parameters.Add("?MeatFactoryName", MySqlDbType.VarChar).Value = t.MeatFactoryName; cmd.Parameters.Add("?MeatProductType", MySqlDbType.VarChar).Value = t.MeatProductType; cmd.ExecuteNonQueryAsync(); conn.Clone(); } catch (Exception e) { Console.WriteLine(e); throw; } return(t); }