private void button1_Click(object sender, EventArgs e) { try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE result"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("INSERT INTO result SELECT ok.id_dog FROM ok,import_adress WHERE import_adress.id=ok.id_dog"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myConnection.Close(); MessageBox.Show("Result!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button5_Click(object sender, EventArgs e) { try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE export_double"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос // добавить проверку на уникальность myCommand.CommandText = string.Format("INSERT INTO export_double select id_dog, count(*) from import_double group by id_dog having count(*) > 1"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("select count(id_dog) from export_double"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос int count = Convert.ToInt32(myCommand.ExecuteScalar()); myConnection.Close(); MessageBox.Show("Все export_double! " + count); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public void PutAnswerTest(int trueanswer, int answer, string[] answer_task) { try { new I18N.West.CP1250(); string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=utf8"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("INSERT INTO test_history (idstudent,idtest,false_quest,true_quest) VALUES ('{0}','{1}','{2}','{3}')", Student.idStudent, Student.idTest, trueanswer, answer); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос int idTestH = (int)myCommand.LastInsertedId; //результат запроса if (Test.TheTaskIs) { foreach (string str in answer_task) { myCommand.CommandText = string.Format("INSERT INTO task_history (idstudent,idtest,idhistory_quest,answer) VALUES ('{0}','{1}','{2}','{3}')", Student.idStudent, Student.idTest, idTestH, str); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос } } myConnection.Close(); } catch (Exception e) { Console.Write(e.Message); } }
private void button4_Click(object sender, EventArgs e) { try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;default command timeout = 240;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE export_adress_gis"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("INSERT INTO export_adress_gis SELECT result.id,import_adress.full_adr,import_adress.houseguid FROM result,import_adress WHERE result.id=import_adress.id"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("TRUNCATE TABLE export_with"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("INSERT INTO export_with SELECT import_with.A,import_with.B,import_with.C, import_with.DATA1,import_with.DATA2 FROM import_with,result WHERE result.id=import_with.A"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myConnection.Close(); MessageBox.Show("Готово! Бегом в БД (export_adress_gis) :)"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button2_Click(object sender, EventArgs e) { try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE ok"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос // добавить проверку на уникальность myCommand.CommandText = string.Format("INSERT INTO ok SELECT id_gis,id_dog,status FROM import_project WHERE status='{0}'", textBox1.Text); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myConnection.Close(); MessageBox.Show("Все OK!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void button3_Click(object sender, EventArgs e) { List <String> ListNameId = new List <String>(); try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;default command timeout = 240;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE export"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("INSERT INTO export SELECT final.A,final.PUBL_B,final.NUM_DOG_C,final.DAT_DOG_D,final.DAT_VST_E,final.F,final.G,final.H,final.FAMIL_NAME_R,final.IMEN_NAME_R,final.OTCH_NAME_R,final.POL_L,final.M,final.SNILS,final.O,final.P,final.Q,final.R,final.SROK1,final.СЛЕДУЮЩЕГОМЕСЯЦАЗАРАСЧЕТНЫМ,final.SROR2,final.СЛЕДУЮЩЕГОМЕСЯЦАЗАРАСЧЕТНЫМ2,final.DAT_NACH,final.НЕТ,final.DAT_OK,final.НЕТ2,final.id_gis FROM final,result WHERE final.NUM_DOG_C = result.id"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("update export, ok set export.id_gis = ok.id_gis where export.NUM_DOG_C = ok.id_dog"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myConnection.Close(); MessageBox.Show("Готово! Бегом в БД :) export"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public ReportData getPatientReport(int patientID) { ReportData reportData = new ReportData(); using (MySqlConnection conn = new MySqlConnection(connectionString)) { conn.Open(); MySqlCommand cmd = new MySqlCommand(); cmd.Connection = conn; cmd.CommandText = "SELECT * FROM patient where patientID=@pID"; cmd.Prepare(); cmd.Parameters.Add("@pID", MySqlDbType.Int32).Value = patientID; using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { reportData.PatientData.PatientID = rdr.GetInt32("patientID"); reportData.PatientData.FirstName = rdr.GetString("firstName"); reportData.PatientData.LastName = rdr.GetString("lastName"); reportData.PatientData.DateAdmitted = rdr.GetDateTime("dateAdmitted"); } } //TODO new reach specific, fix later cmd.CommandText = "SELECT * FROM reach where patientID=@pID"; cmd.Prepare(); using (MySqlDataReader rdr = cmd.ExecuteReader()) { while (rdr.Read()) { ExerciseData exerciseData = new ExerciseData(); exerciseData.ExerciseName = "reach"; exerciseData.PatientID = rdr.GetInt32("patientID"); exerciseData.EmployeeID = rdr.GetInt32("employeeID"); exerciseData.SessionID = rdr.GetInt32("sessionID"); //specific to reach exerciseData.Hands = rdr.GetString("hands"); exerciseData.Angle = rdr.GetDouble("angle"); exerciseData.Date = rdr.GetDateTime("exerciseDate"); exerciseData.Time = rdr.GetDouble("time"); reportData.ExerciseDataList.Add(exerciseData); } } } return reportData; }
public async Task <string> GetAccountAuth(string login, string pass) { try { new I18N.West.CP1250(); string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=utf8"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("SELECT login FROM Student WHERE login='******' AND password='******' ", login, pass); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос string LoginGlobal = (string)myCommand.ExecuteScalar(); //результат запроса if (LoginGlobal == login) { myCommand.CommandText = string.Format("SELECT id FROM Student WHERE login='******'", login); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос Student.idStudent = (int)myCommand.ExecuteScalar(); //результат запроса myConnection.Close(); MainPage.AuthStudent = true; return(await Task <string> .FromResult("Вы зашли как студент")); } else { myCommand.CommandText = string.Format("SELECT login FROM teacher WHERE login='******' AND password='******' ", login, pass); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос LoginGlobal = (string)myCommand.ExecuteScalar(); //результат запроса if (LoginGlobal == login) { myConnection.Close(); MainPage.AuthTeacher = true; return(await Task <string> .FromResult("Вы зашли как преподаватель")); } else { myConnection.Close(); return(await Task <string> .FromResult("Логин или пароль не совпадают")); } } } catch (Exception ex) { return(await Task <string> .FromResult(ex.Message)); } }
public bool SalvarFornecedor(Fornecedor f) { try { String insertDados = "INSERT INTO fornecedor(nome, contato, razaosocial, cnpj, " + "logradouro, bairro, cidade, estado, cep, complemento) " + "VALUES (@nome, @contato, @razaosocial, @cnpj, @logradouro, @bairro, @cidade, @estado, @cep, @complemento);"; conn = new MySqlConnection(connectionString); conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", f.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("contato", f.contato)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("razaosocial", f.razaoSocial)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cnpj", f.cnpj)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("logradouro", f.logradouro)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("bairro", f.bairro)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cidade", f.cidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("estado", f.estado)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cep", f.cep)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("complemento", f.complemento)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception ex) { MessageBox.Show("Erro ou cadastrar cliente, verifique a conexão com o banco de dados: " + ex.ToString()); return(false); } }
public void DeleteCategorie(int categorie_id) { try { conn.Open(); string insertString = @"delete from categorie where categorie_Id=@categorie_id"; MySqlCommand cmd = new MySqlCommand(insertString, conn); MySqlParameter sportParam = new MySqlParameter("@categorie_id", MySqlDbType.Int32); sportParam.Value = categorie_id; cmd.Parameters.Add(sportParam); cmd.Prepare(); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.Write("categorie niet verwijderd: " + e); throw e; } finally { conn.Close(); } }
public bool SalvarVenda(Vendas v) { try { conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO vendas(nome, precounidade, quantidade, total)" + " VALUES (@nome, @precoUnidade, @quantidade, @total);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", v.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("precounidade", v.precoUnidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("quantidade", v.quantidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("total", v.total)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception ex) { MessageBox.Show("Erro ao adicionar o produto: " + ex.ToString()); return(false); } }
public bool SalvarCliente(Clientes c) { try { conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO cliente(nome, datanascimento, celular, " + "cidade, logradouro, bairro, sexo, cpf, telfixo, cep, uf, complemento) " + "VALUES (@nome, @datanascimento, @celular, @cidade, @logradouro, " + "@bairro, @sexo, @cpf, @telfixo, @cep, @uf, @complemento);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", c.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("datanascimento", c.dataNascimento)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("celular", c.celular)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cidade", c.cidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("logradouro", c.logradouro)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("sexo", c.sexo)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cpf", c.cpf)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("telfixo", c.telfixo)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cep", c.cep)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("uf", c.uf)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("complemento", c.complemento)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("bairro", c.bairro)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar o cliente, verifique a conexão com o banco de dados: " + ex.ToString()); return(false); } }
public bool SalvarProduto(Produto p) { try { conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO produto(nome, quantidade, descricao, precovenda, precocusto, modelo)" + " VALUES (@nome, @quantidade, @descricao, @precovenda, @precocusto, @modelo);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", p.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("quantidade", p.quantidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("descricao", p.descricao)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("precovenda", p.precoVenda)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("precocusto", p.precoCusto)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("modelo", p.modelo)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); }catch (Exception ex) { MessageBox.Show("Erro ao salvar o produto: " + ex.ToString()); return(false); } }
public bool AtualizaFornecedor(Fornecedor f) { try { conn = new MySqlConnection(connectionString); String query = "UPDATE fornecedor SET nome=@nome, contato=@contato, razaoSocial=@razaoSocial," + "cnpj=@cnpj, logradouro=@logradouro, bairro=@bairro, cidade=@cidade, estado=@estado, " + "estado=estado, cep=@cep, complemento=@complemento WHERE id=@id;"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id", f.id_fornecedor)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", f.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("contato", f.contato)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("razaosocial", f.razaoSocial)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cnpj", f.cnpj)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("logradouro", f.logradouro)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("bairro", f.bairro)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cidade", f.cidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("estado", f.estado)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("cep", f.cep)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("complemento", f.complemento)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { MessageBox.Show("Erro ao atualizar o cliente: " + e.ToString()); return(false); } }
private void get_1k_resule(String Connection) { MySql.Data.MySqlClient.MySqlConnection conn; MySql.Data.MySqlClient.MySqlCommand cmd; conn = new MySql.Data.MySqlClient.MySqlConnection(); cmd = new MySql.Data.MySqlClient.MySqlCommand(); conn.ConnectionString = Connection; try { conn.Open(); cmd.Connection = conn; cmd.CommandText = "SELECT * FROM `laneheartbeat`;"; cmd.Prepare(); MySqlDataAdapter sda = new MySqlDataAdapter("SELECT * FROM `laneheartbeat` LIMIT 500", conn); Log_Textblock.Text = cmd.ExecuteScalar().ToString(); DataSet ds = new DataSet(); ds.Clear(); DataTable dt = new DataTable(); sda.Fill(ds, "dt"); Result_DataGrid.DataContext = ds; } catch (MySql.Data.MySqlClient.MySqlException ex) { MessageBox.Show("Error " + ex.Number + " has occurred: " + ex.Message, "Error"); } }
public void SalvarViagem(Viagem v) { try { MySqlConnection conn = new ConexaoBancoMySQL().getConnection(); conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO viagem(id_motorista, id_veiculo, id_cidade_destino, id_cidade_origem, dta_saida, km_cidade_origem, passageiro_viagem)" + "VALUES (?, ?, ?, ?, ?, ?, ?);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id_motorista", v.Id_motorista)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id_veiculo", v.Id_veiculo)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id_cidade_destino", v.Id_cidadeDestino)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id_cidade_origem", v.Id_cidadeSaida)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("dta_saida", v.DtaSaida)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("km_cidade_origem", v.KmSaida)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("passageiro_viagem", v.passageiro)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar a viagem, verifique a conexão com o banco de dados: " + ex.ToString()); } }
public void BaixarRelatorio(ManutencaoRelatorio m) { try { MySqlConnection conn = new ConexaoBancoMySQL().getConnection(); conn = new MySqlConnection(connectionString); String insertDados = "UPDATE relatorio SET pendente_status = 'S', observacaoBaixa = @observacaoBaixa, requisito_correcao = @reqCorrecao WHERE id_relatorio = @id_relatorio"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("observacaoBaixa", m.ObservacaoBaixa)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("reqCorrecao", m.RequisitoCorrecao)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id_relatorio", m.Id_relatorio)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Relatorio Baixado com sucesso!"); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar o usuario, verifique a conexão com o banco de dados: " + ex.ToString()); } }
/// <summary> /// Inserts solutions into the database table all_slutions using a prepared statement /// </summary> /// <param name="slns"> the solutions to be inserted</param> public void insertIntoAllSolutions(IEnumerable <ISolution> slns) { // get the connection object (The using statement handles closing of the connection no need to handle it separately) using (var dbcon = new DBConnection(ConnectionRetriever).Instance()) { if (dbcon.IsConnect()) { // create the command using (var cmd = new MySql.Data.MySqlClient.MySqlCommand()) { cmd.Connection = dbcon.Connection; // the insert statement cmd.CommandText = @"INSERT INTO all_solutions(solution_id,batch_id,serialized_data) VALUES(@slnid,@batchid,@slr)"; cmd.Prepare(); cmd.Parameters.Add(new MySqlParameter("@slnid", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@batchid", MySqlDbType.Int32)); cmd.Parameters.Add(new MySqlParameter("@slr", MySqlDbType.JSON)); foreach (var sln in slns) { cmd.Parameters["@slnid"].Value = sln.solutionid; cmd.Parameters["@batchid"].Value = sln.batchid; cmd.Parameters["@slr"].Value = JsonConvert.SerializeObject(sln); cmd.ExecuteNonQuery(); // returns each object one at a time // the returned object can then be used by accesing the iterator defined in the calling method //yield return sln; } } } } }
public static ArrayList buscarPendentes(Emprestimo emprestimo) { ArrayList emprestimos = new ArrayList(); MySqlCommand cmd; string sql = "SELECT * FROM " + TABELA + " WHERE entregue = false;"; // Associação do comando à conexão. cmd = new MySqlCommand(sql, BancoDados.recuperarConexao()); cmd.Prepare(); // Execução da sentença SQL, com dados de retorno // associados a um objeto para posterior leitura. MySqlDataReader leitor = cmd.ExecuteReader(); while (leitor.Read()) { emprestimos.Add( new Emprestimo(int.Parse(leitor["id"].ToString()), DateTime.Parse(leitor["dataemprestimo"].ToString()), bool.Parse(leitor["entregue"].ToString()),int.Parse(leitor["fk_destinatario"].ToString()), int.Parse(leitor["fk_item"].ToString()))); } leitor.Close(); return emprestimos; }
public void SalvarUsuario(Usuario u) { try { MySqlConnection conn = new ConexaoBancoMySQL().getConnection(); conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO cadastro_usuario(nome_usuario, senha_usuario, ativo)" + "VALUES (?, MD5(?), ?);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", u.Nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("senha", u.Senha)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("ativo", u.Ativo)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar o usuario, verifique a conexão com o banco de dados: " + ex.ToString()); } }
public void Salvar(Contato contato) { try { MySqlConnection conn = new ConexaoBancoMySql().getConnection(); conn = new MySqlConnection(connectionString); String insertDados = "INSERT INTO contato(nome, telefone)" + "VALUES (?,?);"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(insertDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", contato.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("telefone", contato.telefone)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar contato, verifique a conexão com o banco de dados: " + ex.ToString()); } }
public static void setSession(string userid) { LoginInfo.UserID = userid; LoginInfo.inTime = DateTime.Now; LoginInfo.computer_name = Environment.MachineName; LoginInfo.ipAddress = Dns.GetHostAddresses(Environment.MachineName)[0].ToString(); DBConnector dbcon = new DBConnector(); dbcon.openConnection(); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO login_session (in_time, computer_name, ip_address, user_iduser) VALUES ('" + LoginInfo.inTime.ToString("yyyy-MM-dd HH:mm:ss") + "', N'" + LoginInfo.computer_name + "', '" + LoginInfo.ipAddress + "', "+int.Parse(LoginInfo.UserID)+")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); cmd.CommandText = "SELECT * FROM login_session ORDER BY idlogin_session DESC LIMIT 1"; cmd.Connection = dbcon.connection; MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { LoginInfo.sessionID = int.Parse(reader.GetString(0)); //Console.Write(LoginInfo.sessionID); } dbcon.closeConnection(); }
public void addEntry(TrackingEntry entry) { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = connection; cmd.CommandText = "INSERT INTO tracking_entry VALUES (NULL, @taggerID, @type, @isTagged," + " @taggerName, @entryDate, @tagNumber, @species, @city, @state, @country," + " @longitude, @latitude, @temperature, @precipitation, @windSpeed," + " @windDirection);"; cmd.Prepare(); cmd.Parameters.AddWithValue("@taggerID", entry.taggerID); cmd.Parameters.AddWithValue("@type", entry.type); cmd.Parameters.AddWithValue("@isTagged", entry.isTagged); cmd.Parameters.AddWithValue("@taggerName", entry.taggerName); cmd.Parameters.AddWithValue("@entryDate", entry.entryDate); cmd.Parameters.AddWithValue("@tagNumber", entry.tagNumber); cmd.Parameters.AddWithValue("@species", entry.species); cmd.Parameters.AddWithValue("@city", entry.city); cmd.Parameters.AddWithValue("@state", entry.state); cmd.Parameters.AddWithValue("@country", entry.country); cmd.Parameters.AddWithValue("@longitude", entry.longitude); cmd.Parameters.AddWithValue("@latitude", entry.latitude); cmd.Parameters.AddWithValue("@temperature", entry.temperature); cmd.Parameters.AddWithValue("@precipitation", entry.precipitation); cmd.Parameters.AddWithValue("@windSpeed", entry.windSpeed); cmd.Parameters.AddWithValue("@windDirection", entry.windDirection); cmd.ExecuteNonQuery(); }
public static bool Delete(int id) { try { String delete_sql = "DELETE FROM " + TABLE_NAME + " WHERE ID=@id"; //Sql command sql_command = new MySqlCommand(); sql_command.Connection = (MySqlConnection)database.OpenConnection(); sql_command.CommandText = delete_sql; sql_command.Parameters.AddWithValue("@id", id); sql_command.Prepare(); //execute command database.Update(sql_command); return true; } catch (Exception) { return false; } finally { CloseDatabaseConnection(); } }
public MailSession() { string cs = @"server=localhost;userid=timetracker;password=DdCyzpALrxndc6BY;database=timetracker"; MySqlConnection connect = null; MySqlDataReader reader = null; try { connect = new MySqlConnection (cs); connect.Open (); MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "SELECT * FROM `email`"; cmd.Prepare(); cmd.ExecuteNonQuery(); reader = cmd.ExecuteReader(); while (reader.Read()) { //Console.WriteLine(reader.GetInt32(0) + ": " + reader.GetString(1)); } } catch (Exception ex) { } finally { if (connect != null) { connect.Close(); } } }
public static bool addPassport(Passport p) { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO passport (rank, post, passport_no, place_of_issue, date_of_issue, date_of_renewal, status, employee_idemployee) VALUES (N'" + p.rank + "', N'" + p.post + "', N'" + p.number + "', N'" + p.place_of_issue + "', '" + p.getdate_of_issue().ToString("yyyy-MM-dd") + "', '" + p.getdate_of_renewal().ToString("yyyy-MM-dd") + "', " + p.status + ", " + Employee.employee_id + ")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { dbcon.closeConnection(); return false; } //} //catch (MySqlException e) //{ //int errorcode = e.Number; //dbcon.closeConnection(); //return false; //} }
public bool AtualizaProduto(Produto p) { try { conn = new MySqlConnection(connectionString); String query = "UPDATE produto SET modelo=@modelo, nome=@nome," + " quantidade=@quantidade, precocusto=@precoCusto, precovenda=@precoVenda," + "descricao=@descricao WHERE id=@id;"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(query, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id", p.idProduto)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("modelo", p.modelo)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", p.nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("quantidade", p.quantidade)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("precocusto", p.precoCusto)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("precovenda", p.precoVenda)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("descricao", p.descricao)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); return(true); } catch (Exception e) { MessageBox.Show("Erro ao atualizar o produto: " + e.ToString()); return(false); } }
public void AnnulerenBestelling(int bestellingscode) { try { conn.Open(); string insertString = @"UPDATE factuur " + "SET status=@status " + "WHERE factuur_code=@factuur_code"; MySqlCommand cmd = new MySqlCommand(insertString, conn); MySqlParameter bestellingscodeParam = new MySqlParameter("@factuur_code", MySqlDbType.Int32); MySqlParameter statusParam = new MySqlParameter("@status", MySqlDbType.Enum); bestellingscodeParam.Value = bestellingscode; statusParam.Value = "Geannulleerd"; cmd.Parameters.Add(bestellingscodeParam); cmd.Parameters.Add(statusParam); cmd.Prepare(); cmd.ExecuteNonQuery(); } catch (Exception e) { Console.Write("Updaten bestelling niet gelukt: " + e); throw e; } finally { conn.Close(); } }
private void buttonCadastrar_Click(object sender, EventArgs e) { MySqlConnection conn = null; try { conn = Conexao.getConexao(); MySqlCommand cmd = new MySqlCommand("call cadastra_pizza(@nome, @tamanho, @preco)", conn); cmd.Prepare(); cmd.Parameters.AddWithValue("@nome", this.txt_nome.Text); cmd.Parameters.AddWithValue("@tamanho", this.cmb_tamanho.Text); cmd.Parameters.AddWithValue("@preco", this.txt_preco.Text); MySqlDataReader rs = cmd.ExecuteReader(); rs.Read(); if (!rs.HasRows) { conn.Close(); new SuccessDialog("Pizza cadastrada com sucesso!"); this.Close(); } else { String error = rs.GetString(0); conn.Close(); new ErrorDialog(error); } } catch (Exception err) { if (conn != null) conn.Close(); new ErrorDialog(err.Message); } }
public String consultaSaldo(string email) { try { string saldo = ""; DB db = new DB(); db.OpenConnection(); String sql = "SELECT c.saldo, c.email, s.`desc` FROM contas c inner join situacao_conta s on c.idsituacao = s.idsituacao where email=@email;"; MySqlCommand cmd = new MySqlCommand(sql, db.con); cmd.Prepare(); cmd.Parameters.AddWithValue("@email", email); db.result = cmd.ExecuteReader(); if (db.result.Read()) { saldo = db.result.GetString(0); } db.CloseConnection(); return saldo; } catch { return "erro"; } }
public void create() { db = new Database(); if (officeVerification()) { try { officeQuery = new MySqlCommand(); officeQuery.Connection = db.Connection(); officeQuery.CommandText = "INSERT INTO office(officedescription) VALUES(@Description)"; officeQuery.Prepare(); officeQuery.Parameters.AddWithValue("@Description", officedescription); officeQuery.ExecuteNonQuery(); MessageBox.Show("A Descrição Cargo Assinatura " + officedescription + " foi criada com sucesso."); } catch (MySqlException ex) { MessageBox.Show("Ocurreu um erro"); Console.WriteLine("Error: {0}", ex.ToString()); } finally { db.Close(); } } }
public void GravarRetornoViagem(Viagem v) { try { MySqlConnection conn = new ConexaoBancoMySQL().getConnection(); conn = new MySqlConnection(connectionString); String alteratDados = "UPDATE viagem set dta_retorno = @dtaRetornoViagem, km_cidade_retorno = @kmRetorno where id_viagem = @id"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(alteratDados, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("dtaRetornoViagem", v.DtaRetorno)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("id", v.Id_viagem)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("kmRetorno", v.KmRetorno)); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); } catch (Exception ex) { MessageBox.Show("Erro ao cadastrar o usuario, verifique a conexão com o banco de dados: " + ex.ToString()); } }
public int retrieveAlbumId() { DBConnect connection = new DBConnect(); string query = "SELECT albumId FROM Album WHERE albumName LIKE @albumName;"; try { MySqlCommand cmd = new MySqlCommand(query, connection.OpenConnection()); cmd.CommandText = query; cmd.Prepare(); cmd.Parameters.AddWithValue("@albumName", this.albumName); albumId = int.Parse(cmd.ExecuteScalar() + ""); cmd.ExecuteNonQuery(); connection.CloseConnection(); return albumId; } catch (Exception ex) { return -1; } }
public void DeleteInschrijving(int studentID, int evenementID) { MySqlTransaction trans = null; try { conn.Open(); trans = conn.BeginTransaction(); string insertString = @"delete from inschrijving where student_id=@studentid and evenement_id=@evenementid"; MySqlCommand cmd = new MySqlCommand(insertString, conn); MySqlParameter studentidParam = new MySqlParameter("@studentid", MySqlDbType.Int32); MySqlParameter evenementidParam = new MySqlParameter("@evenementid", MySqlDbType.Int32); studentidParam.Value = studentID; evenementidParam.Value = evenementID; cmd.Parameters.Add(studentidParam); cmd.Parameters.Add(evenementidParam); cmd.Prepare(); cmd.ExecuteNonQuery(); trans.Commit(); } catch (Exception e) { trans.Rollback(); Console.Write("Inschrijving niet verwijderd: " + e); throw e; } finally { conn.Close(); } }
public static bool addResignationRecord() { DBConnector dbcon = new DBConnector(); //try //{ if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO resignation (letter_submitted_date, resignation_date, employee_idemployee) VALUES ('" + DateTime.Now.ToString("yyyy-MM-dd") + "', '" + DateTime.Now.ToString("yyyy-MM-dd") + "', " + Employee.employee_id + ")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { dbcon.closeConnection(); return false; } /*} catch (MySqlException e) { int errorcode = e.Number; dbcon.closeConnection(); return false; }*/ }
public void BinaryAndVarBinaryParameters() { if (Version < new Version(5, 0)) return; execSQL("CREATE PROCEDURE spTest(OUT out1 BINARY(20), OUT out2 VARBINARY(20)) " + "BEGIN SET out1 = 'out1'; SET out2='out2'; END"); MySqlCommand cmd = new MySqlCommand("spTest", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("out1", MySqlDbType.Binary); cmd.Parameters[0].Direction = ParameterDirection.Output; cmd.Parameters.Add("out2", MySqlDbType.VarBinary); cmd.Parameters[1].Direction = ParameterDirection.Output; if (prepare) cmd.Prepare(); cmd.ExecuteNonQuery(); byte[] out1 = (byte[])cmd.Parameters[0].Value; Assert.AreEqual('o', out1[0]); Assert.AreEqual('u', out1[1]); Assert.AreEqual('t', out1[2]); Assert.AreEqual('1', out1[3]); out1 = (byte[])cmd.Parameters[1].Value; Assert.AreEqual('o', out1[0]); Assert.AreEqual('u', out1[1]); Assert.AreEqual('t', out1[2]); Assert.AreEqual('2', out1[3]); }
public async Task <bool> CheckTestForStudent() { bool check = false; int test = 0; try { new I18N.West.CP1250(); string Connect = "Database=u0354899_diplom;Data Source=31.31.196.162;User Id=u0354899_vlad;Password=vlad19957;charset=utf8"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("SELECT count(*) From test_history WHERE idstudent = '{0}' AND idtest = '{1}'", Student.idStudent, Student.idTest); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос test = Convert.ToInt32(myCommand.ExecuteScalar()); //результат запроса if (test == 0) { check = true; } else { check = false; } myConnection.Close(); } catch (Exception e) { Console.Write(e.Message); } return(await Task <bool> .FromResult(check)); }
public UserModel(int id) { try { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "SELECT username,currency,avatar,email FROM users WHERE id = @id"; cmd.Prepare(); cmd.Parameters.AddWithValue("@id", id); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read()) { username = rdr[0].ToString(); currency = Convert.ToInt32(rdr[1]); avatar = rdr[2].ToString(); if (avatar.Length == 0) { avatar = "data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wBDAAMCAgICAgMCAgIDAwMDBAYEBAQEBAgGBgUGCQgKCgkICQkKDA8MCgsOCwkJDRENDg8QEBEQCgwSExIQEw8QEBD/2wBDAQMDAwQDBAgEBAgQCwkLEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBD/wAARCACAAIADASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9Cvh98PvBGpeCNDvr7wtps9xPYxSSyyW6lnYrySe5rof+FX/D3/oTtJ/8Blo+F/8AyT3w9/2Dof8A0GuooA5f/hV/w9/6E7Sf/AZaP+FX/D3/AKE7Sf8AwGWuoooA5f8A4Vf8Pf8AoTtJ/wDAZaP+FX/D3/oTtJ/8BlrpnbaMk4A5NeB/FH9sDwL4Ge407w3bN4k1G2bZIYpRFaI3cedgliP9hSOoyCKAPVT8Mfh4P+ZN0r/wFWmn4a/DlfveENIGfW2UV8XeKf26vif4gs5dO8P6bpOgvPkfaYUaaaIf7Jc7cn1K14TrnjHxD4mvXv8AxF4l1K/uZDkvd3Tyc+wJwPwFAH6jD4bfDhjtXwjo5Ptboaf/AMKw+Hv/AEJuk/8AgKtflXaanrGmTpfaZqt9aTxnKzWd26Op+qkGvc/hV+2j8R/BFzDZeNpW8WaIXVJGlwt9bpkAlH4EmB/C/J/vCgD7i/4Vf8Pf+hO0n/wGWj/hV/w9/wChO0n/AMBlqXwH4/8AC3xL8NWvizwdqsd9p91xuUYeNxjdG6nlXGeQa6OgDl/+FX/D3/oTtJ/8Blo/4Vf8Pf8AoTtJ/wDAZa6iigDl/wDhV/w9/wChO0n/AMBlrA8f/D3wPp3gnXL6y8K6bBPBYTSRSx26hkYIcEHsa9Hrmfib/wAk98Rf9g2f/wBANADfhf8A8k98Pf8AYOh/9BrqK5f4X/8AJPfD3/YOh/8AQa6igApDxS0h6GgD5Z/bM+OFz4ZtYvhj4eupIbu/hE2pyxnDCBiQkKt2LkEtjnaAOjV8QapfuqNIzK7qMEn7kZ/uqP612X7Q/ie68QfF/wAU6rNMWA1Ke3hy33Ujbyhj/gKD868qdrvWLhbOzRtoOM9gPU0Aauk5MJvmJbMmATznjmrl9YGeQyWThJgMmI9/pXf/AAc+H8nirX4rY2zto9hDKtzPt+V5HQptU9CfmJ46Y965/wAZ+EL/AMJ61L4b16J4JoSTa3QBCzx/wup7j19DkHpQBws93dWblbuCSIj+LkU5dWS6+WZgGHCyDg/j61fuTrVl8txEl5CO5XPFZ1xe6a+d+kmJj1KnFAHpn7P/AMdNY+BnjuDVxLLL4e1GRINasl5DxZ4mQdpE6g9xlT14/U/T9Qs9VsbfUtPuEntbuJJ4ZUYFZI2GVYHuCCDX4uXFzaPZtGVJPbNfoz+wT4/m8YfA9NCvJHe58J3r6XuY5LQECWLHsFk2D/coA+kqKKKACuZ+Jv8AyT3xF/2DZ/8A0A101cz8Tf8AknviL/sGz/8AoBoAb8L/APknvh7/ALB0P/oNdRXL/C//AJJ74e/7B0P/AKDXUUAFIelLSHoaAPyR+LNotv8AEjxLp16zI1rrN8jDHJ/fvg/lzXuHwI/ZfXxJocPivxTDJBp9wBJb2Y+V5l7PI3XaecKMccn0rR+P3whsrL9qXRLzWLNh4e8aXMVwGHCtcqAskR9MsIz7iQ+lfYmn2MFro8dtbRqqRoFUKMAADoKAPIbbwxpugQpp2mWUVtBDwkcahVUewAqh4k8F+H/F1h/ZviPSbe+g5Khwd0Z9UYcqfoa7zVbHFy3bmqn2E0AfOmu/sraS7GTwp4ovLAE5+z3kYuI/wIKsPxzXGaz+y/43iUvbXOgX4HTEkkTn80I/Wvr1rE4qhf22yMnHOKAPgjxv8FPHXhnR7rWb/wALiK0s13zXEd1E6oucZwG3dT6V9N/8E0Yp/wDhHPHkxJ8k6jZovp5gict+jJUnx4lS0+EPiZ5cASW6QrnuzSqB/OvXf2OvhfcfDD4K6fb6paNb6trsraxfRsPmRpQBGh91iWMEdjkUAe40UUUAFcz8Tf8AknviL/sGz/8AoBrpq5n4m/8AJPfEX/YNn/8AQDQA34X/APJPfD3/AGDof/Qa6iuX+F//ACT3w9/2Dof/AEGuooAKQjIxS0UAcX8VPhno3xQ8NDRdRdre7tJ0vdMv4xmWyu0OUlX19CO4JFWtKa9toFsNUCfakRVkMedhbHJXPOD2rqqzdW09rgLdQD99F0H94elAHNatYZkLqvBrN+yAcba6cYuYwGGD3BqpLY7DwKAMFrQY6ViawgUbAOc11t3GIkzWPa6Lca1qAiRSBnliOFHc0AYem/Cuy8fzafL4gG/R9Mv476S1K5W7mj5jVs9UViGI7lVHTOfa1UKMAVBp9hb6baRWdsu2OIYHv71ZoAKKKKACuZ+Jv/JPfEX/AGDZ/wD0A101cz8Tf+Se+Iv+wbP/AOgGgBvwv/5J74e/7B0P/oNdRXL/AAv/AOSe+Hv+wdD/AOg11FABRRSE4oAWkPSua8QeN7DSWa1tEN5drwUU4RD/ALTdvoMmuXsNS8R+K5Lua81OS3t4AQtrakxgkDPzMDuPUd6AMXU/HGr+E/FuqSTW0mo6NJdMdiHEkBwASh7jOTtNdXpnxJ8A6vDmDxRZRSAZaG5k8mRD7q+KwrXSo7lSlwgYt97POapXvwo0HU5fNms0JPPK0AWPEfxU8IxE2mgXI1y9J2iKzOY1Pq8hGAPpk1rfCK71W5n1aXW7hWuZ/JdIl4SNBuGFHpz+tZ1l4G0vRExa2iL9FFMbQV1O6+yedc2/BIltrh4ZEI6EOhBGPy9c0AeucUtfGGq/tM/Eb4NeO9Q8F65f2/iuxtZUEEl6BFOUZQwUyxjhsEDlW5r6C+E/7QPgD4sg2Wj3j2Wrxpvk027wsuMcmMg4kUc5K8juBQB6bRSA5GaWgArmfib/AMk98Rf9g2f/ANANdNXM/E3/AJJ74i/7Bs//AKAaAG/C/wD5J74e/wCwdD/6DXUVy/wv/wCSe+Hv+wdD/wCg11FABXCeNfFs4uW8OaJLibGbqdf+WQP8I/2sd+31ro/Fmtr4e0G61TAaSNdsKn+KRuFH5n9K8r0yF7Wykvrpy882ZJHY8sx6mgCO7lg0+EwoQT3PqfU1lWXivUvCepDWLK3N7auuy9s0IDyL2dCeN65PBwGHGQQDWfqepmW4YbuAaqvcgp1oA9d8P+IvBHi1Td6Hq8XmrxNByksTdw8bfMp57iumhtIY1yt2rD3NfK2u6LYakRO8SiWPlHA+ZD6qeqn3BBrCuNW8d6NGItO8Va4I1GFH9oyvj/vtiaAPsC7t7MKWmvEUD3rx74qftAeCPh3Y3Wn+H5otX17aUFvE2VgYg4MzjIQd9udxHQdx80eJ9f8AG2ro0Gqazrl5GScxS30xjb/eQNtP0IrhL3S9VnURpbCBAcD+EAeyigDmvFural4n16W/vLlp729uDPPKe5JyT7D0HQDApbfV9U0TUINU029ntLq1kEsE8LlZInHRlI6HmtiLw6tpudstI33nI6j0+lZ2tWax27H2oA+9v2YP2kLf4u6X/wAIx4mmig8WabCHlCgKl9CMDzkHZgSA6joTkcHj3vIr8avCvjjW/AvijTvFPh67aDUdKuFuIG6gkdVI7qwJUjuDX62/C/x5pfxN8BaL470jIt9XtVm2HrFJ0kjPurhl/CgDqa5n4m/8k98Rf9g2f/0A101cz8Tf+Se+Iv8AsGz/APoBoAb8L/8Aknvh7/sHQ/8AoNdPXMfC/wD5J74e/wCwdD/6DXSySpEu5zgUAeefFq5LyaJphfCTTyTMM9SoAH/oZrl/EFyLfTW2nAP8q6D4rwprNha3GnyYvtNlaWNScCVSMMmfXgEfSvK9a8VC508W0wKSrwQwwc/SgDHkvQ0rEtnmlN4Mdf1rAF8pY8jrTjerjr+tAGnNdjaR1rMup1IO7mq02oKB1rMutRUZ5oAjvjEx3ECucv1hGcKKtX+rxKuN2a5fU9eRQQOT+VAEOpSIiN2xXD+Jr9I4HG4HIIGKu6vrkzhljDd64XW5Ly5LCTPP5UAc1dT7rglWOMnNfoT/AME4fF11q3w28R+FLqcuND1VZrdeflhuE3Y/7+RyH8a/PiPTL+8ulsrK0mubiQ7UihQu7nsAq5J/Kv0b/Yg+G958IvBGp3PilfJ1rxJcx3D23VreCNSsaPg435Z2IHTcB1FAH1SK5r4m/wDJPfEX/YNn/wDQDXQwXEU6ho2zXPfE3/knviL/ALBs/wD6AaAG/C//AJJ74e/7B0P/AKDXQ3duLmPZmvP/AIe+P/BOneB9Dsr7xVpcE8FjFHLFJcorIwXkEZ4NdD/wsz4e/wDQ5aR/4Fp/jQBm654QubrcUJwa858QfDK+uixNuX9CVzXq/wDwsz4e/wDQ5aR/4Fp/jSN8Sfh0ww3jDRz9bpP8aAPnK++FmsQsxhhcY6cGsi48C+IYOlux/wCA19Pv4/8AhlJ9/wAVaIf+3lP8agfxl8KpPveJ9E/8Ck/xoA+VpvB/iPPNmx/A1m3PgzxG5wtkfzP+FfWreJ/hK/XxPon/AIFJ/jUR8QfCM8jxRov/AIEp/jQB8eXPw38TzglbRfpk/wCFUJPgz4sujxbQqD2Jb/CvtMeIfhHjnxPov/gSn+NPXxL8JU6eJ9F/8Ck/xoA+Jk/Zx8UXzAS3kcIJydtuXJHsSRXQab+ybYzlP7V/tC75yV3iNT/3yAf1r6+Txh8KkOV8UaJ/4FJ/jVhPHvwxj+54q0Qf9vKf40AeJ+B/gRp3hbb/AGH4ftrFsbWkjiG9h7v94/ia9X0LwVdWu0uMAVtL8R/hyn3fF+jD6XSf40//AIWZ8Pf+hy0j/wAC0/xoA2rCx+yIAWyQKxfib/yT3xF/2DZ//QDR/wALM+Hv/Q5aR/4Fp/jXP+P/AB/4I1HwRrtjY+K9LnnnsJo4oo7lGd3KHAAzzQB//9k="; } email = rdr[3].ToString(); } else { username = "******"; currency = 0; avatar = ""; } Conn.Close(); } catch (Exception e) { } }
public static bool addQualification(Qualification q) { DBConnector dbcon = new DBConnector(); try { if (dbcon.openConnection()) { MySqlCommand cmd = new MySqlCommand(); cmd.CommandText = "INSERT INTO qualification (qualification_no, institute, months, occupation_relevant, highest_qualification, status, note, qualification, year, employee_idemployee) VALUES (N'" + q.qualification_no + "', N'" + q.institute + "', N'" + q.months + "', " + q.occupation_relevant + ", " + q.highest_qualification + ", N'" + q.status + "', N'" + q.note + "', N'" + q.qualification + "', N'" + q.year + "', " + Employee.employee_id + ")"; cmd.Connection = dbcon.connection; cmd.Prepare(); cmd.ExecuteNonQuery(); dbcon.closeConnection(); return true; } else { dbcon.closeConnection(); return false; } } catch (MySqlException e) { int errorcode = e.Number; dbcon.closeConnection(); return false; } }
public static DepartmentModel Load(int id) { using (var connection = new MySqlConnection(Settings.Default.ConnectionString)) { connection.Open(); var query = "SELECT Id, Name FROM Department WHERE Id = @id"; MySqlCommand cmd = new MySqlCommand(query, connection); cmd.Parameters.Add(new MySqlParameter("@id", MySqlDbType.Int32)); cmd.Prepare(); cmd.Parameters["@id"].Value = id; MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read() && !reader.IsDBNull(0)) { var department = new DepartmentModel { Id = reader.GetInt32("Id"), Name = reader.GetString("Name") }; return department; } else { //throw new NotSupportedArgument("Id not found"); return null; } } }
public void create() { db = new Database(); if (vendorVerification()) { try { vendorQuery = new MySqlCommand(); vendorQuery.Connection = db.Connection(); vendorQuery.CommandText = "INSERT INTO vendor(vendorname) VALUES(@Name)"; vendorQuery.Prepare(); vendorQuery.Parameters.AddWithValue("@Name", vendorname); vendorQuery.ExecuteNonQuery(); MessageBox.Show("O fornecedor " + vendorname + " foi criado com sucesso."); } catch (MySqlException ex) { MessageBox.Show("Ocurreu um erro"); Console.WriteLine("Error: {0}", ex.ToString()); } finally { db.Close(); } } }
private void btnEnvoyer_Click(object sender, EventArgs e) { MySqlCommand cmd; //Global.Connection.Open(); try { if (comboBox1.Text == "Sélectionnez la nature de votre requête") { MessageBox.Show("Veuillez renseigner la nature de votre requête", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); }else if(rtbContenu.Text == "") { MessageBox.Show("Veuillez écrire votre requête", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { cmd = new MySqlCommand("INSERT INTO requetecontact(idUtilisateur, contenu, dateContact, dateTraitement) VALUES(@idUtilisateur, @contenu, now(), '1000-01-01 00:00:00')", Global.Connection); MySqlParameter pIdUtilisateur = new MySqlParameter("@idUtilisateur", MySqlDbType.Int16); MySqlParameter pContenu = new MySqlParameter("@contenu", MySqlDbType.Text); pIdUtilisateur.Value = Global.userId; pContenu.Value = comboBox1.Text + " : " + rtbContenu.Text; cmd.Parameters.Add(pIdUtilisateur); cmd.Parameters.Add(pContenu); cmd.Prepare(); cmd.ExecuteNonQuery(); MessageBox.Show("Votre reqûete a bien été prise en compte, nos équipes sont au travail ! ", "Succès", MessageBoxButtons.OK, MessageBoxIcon.Information); rtbContenu.Text = ""; comboBox1.SelectedItem = "Sélectionnez la nature de votre requête"; } } catch (MySqlException) { MessageBox.Show("Une erreur est survenue. Impossible de contiuer.", "Erreur", MessageBoxButtons.OK, MessageBoxIcon.Error); rd.Close(); Global.Connection.Close(); } }
/// <summary> /// Ajoute une salle à base de donneés. /// </summary> /// <param name="connectionString">Les paramètres de connexion à la base de données.</param> /// <param name="salleDTO">Représente la salle qui sera ajouté.</param> public void Add(string connectionString, SalleDTO salleDTO) { if (string.IsNullOrEmpty(connectionString)) { throw new DAOException("Les paramètres de connexion n'ont pas été initialisé."); } try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand addPreparedStatement = new MySqlCommand(SalleDAO.ADD_REQUEST, connection); addPreparedStatement.Parameters.AddWithValue("@numero", salleDTO.Numero); addPreparedStatement.Parameters.AddWithValue("@etage", salleDTO.Etage); addPreparedStatement.Parameters.AddWithValue("@bloc", salleDTO.Bloc); addPreparedStatement.Prepare(); addPreparedStatement.ExecuteNonQuery(); } } catch (SqlException sqlException) { throw new DAOException(sqlException.Message, sqlException); } }
public void create() { db = new Database(); space = new Space(); try { pathQuery = new MySqlCommand(); pathQuery.Connection = db.Connection(); pathQuery.CommandText = "INSERT INTO path(path) VALUES(@Path)"; pathQuery.Prepare(); pathQuery.Parameters.AddWithValue("@Path", path); pathQuery.ExecuteNonQuery(); MessageBox.Show("O Caminho " + path + " foi criado com sucesso."); } catch (MySqlException ex) { MessageBox.Show("Ocurreu um erro"); Console.WriteLine("Error: {0}", ex.ToString()); } finally { db.Close(); } }
public void ProcessRequest(HttpContext context) { int count = context.Request.GetQueryStringInteger("queries", 1).Clamp(1, 500); World[] worlds = new World[count]; Random random = new Random(); using (MySqlConnection connection = new MySqlConnection(ConnectionString)) { connection.Open(); using (MySqlCommand command = new MySqlCommand(DB_QUERY, connection)) { command.Prepare(); command.Parameters.Add("@id", MySqlDbType.Int32); for (int i = 0; i < count; i++) { int id = random.Next(1, DB_ROWS); command.Parameters["@id"].Value = id; using (MySqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { worlds[i] = new World(id, reader.GetInt32("randomNumber")); } } } } } JsonHelpers.WriteJson(worlds, context); }
public void create() { db = new Database(); if (categoryVerification()) { try { actiontypeQuery = new MySqlCommand(); actiontypeQuery.Connection = db.Connection(); actiontypeQuery.CommandText = "INSERT INTO actiontype(actiontypedescription) VALUES(@Description)"; actiontypeQuery.Prepare(); actiontypeQuery.Parameters.AddWithValue("@Description", actiontypedescription); actiontypeQuery.ExecuteNonQuery(); MessageBox.Show("O tipo de ação " + actiontypedescription + " foi criado com sucesso."); } catch (MySqlException ex) { MessageBox.Show("Ocurreu um erro"); Console.WriteLine("Error: {0}", ex.ToString()); } finally { db.Close(); } } }
public bool AutenticarUsuario(Usuario u) { try { MySqlConnection conn = new ConexaoBancoMySQL().getConnection(); conn = new MySqlConnection(connectionString); String validarUsuario = "SELECT * FROM cadastro_usuario WHERE nome_usuario = @nome AND senha_usuario = MD5(@senha) AND ativo = 's';"; conn.Open(); MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand(validarUsuario, conn); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("nome", u.Nome)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("senha", u.Senha)); cmd.Parameters.Add(new MySql.Data.MySqlClient.MySqlParameter("ativo", u.Ativo)); int retorno = Convert.ToInt32(cmd.ExecuteScalar()); cmd.Prepare(); cmd.ExecuteNonQuery(); conn.Close(); if (retorno > 0) { return(true); } else { return(false); } } catch (Exception ex) { MessageBox.Show("Dados incorretos, informe novamente! " + ex.ToString()); return(false); } }
public void DeleteGenre(int genreId) { MySqlTransaction trans = null; try { conn.Open(); trans = conn.BeginTransaction(); string insertString = @"delete from genre where genre_id=@id"; MySqlCommand cmd = new MySqlCommand(insertString, conn); MySqlParameter idParam = new MySqlParameter("@id", MySqlDbType.Int32); idParam.Value = genreId; cmd.Parameters.Add(idParam); cmd.Prepare(); cmd.ExecuteNonQuery(); trans.Commit(); } catch (Exception e) { trans.Rollback(); Console.Write("Genre niet verwijderd: " + e); throw e; } finally { conn.Close(); } }
public int GetFactuurId() { int id = 0; try { conn.Open(); string getQuery = @"select max(factuur_code) as factuur_code from factuur"; MySqlCommand cmd = new MySqlCommand(getQuery, conn); cmd.Prepare(); MySqlDataReader dataReader = cmd.ExecuteReader(); if (dataReader.Read()) { id = GetFactuurIdFromDataReader(dataReader); } } catch (Exception e) { // Moet naar error page, niet alleen throw e throw e; } finally { conn.Close(); } return id; }
public bool DeleteMemberType(int memberTypeId) { MySqlConnection cnn = DBUtility.getConnection(); if (cnn != null) { try { cnn.Open(); const string SQL = @"DELETE FROM membertypes WHERE membertypeid = @membertypeid"; MySqlCommand command = new MySqlCommand(SQL, cnn); command.Prepare(); command.Parameters.AddWithValue("@membertypeid", memberTypeId); if (command.ExecuteNonQuery() > 0) { return true; } } catch (MySqlException e) { Console.WriteLine(e); } finally { cnn.Close(); } } return false; }
/// <summary> /// Ajoute un entraineur à la base de données. /// </summary> /// <param name="connectionString">Les paramètres de connexion à la base de données.</param> /// <param name="entraineurDTO">Représente l'entraineur qui sera ajouté.</param> public void Add(string connectionString, EntraineurDTO entraineurDTO) { if (string.IsNullOrEmpty(connectionString)) { throw new DAOException("Les paramètres de connexion n'ont pas été initialisé."); } try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand addPreparedStatement = new MySqlCommand(EntraineurDAO.ADD_REQUEST, connection); addPreparedStatement.Parameters.AddWithValue("@nom", entraineurDTO.Nom); addPreparedStatement.Parameters.AddWithValue("@prenom", entraineurDTO.Prenom); addPreparedStatement.Parameters.AddWithValue("@adresse", entraineurDTO.Adresse); addPreparedStatement.Parameters.AddWithValue("@ville", entraineurDTO.Ville); addPreparedStatement.Parameters.AddWithValue("@telephone", entraineurDTO.Telephone); addPreparedStatement.Parameters.AddWithValue("@email", entraineurDTO.Email); addPreparedStatement.Parameters.AddWithValue("@sexe", entraineurDTO.Sexe); addPreparedStatement.Parameters.AddWithValue("@dateNaissance", entraineurDTO.DateNaissance); addPreparedStatement.Prepare(); addPreparedStatement.ExecuteNonQuery(); } } catch (SqlException sqlException) { throw new DAOException(sqlException.Message, sqlException); } }
/// <summary> /// Ajoute une activité. /// </summary> /// <param name="connectionString">Les paramètres de connexion à la base de données.</param> /// <param name="activiteDTO">Représente l'activité qui sera ajouté.</param> public void Add(string connectionString, ActiviteDTO activiteDTO) { if (string.IsNullOrEmpty(connectionString)) { throw new DAOException("Les paramètres de connexion n'ont pas été initialisé."); } try { using (MySqlConnection connection = new MySqlConnection(connectionString)) { connection.Open(); MySqlCommand addPreparedStatement = new MySqlCommand(ActiviteDAO.ADD_REQUEST, connection); addPreparedStatement.Parameters.AddWithValue("@nom", activiteDTO.Nom); addPreparedStatement.Parameters.AddWithValue("@cout", activiteDTO.Cout); addPreparedStatement.Parameters.AddWithValue("@duree", activiteDTO.Duree); addPreparedStatement.Parameters.AddWithValue("@description", activiteDTO.Description); addPreparedStatement.Prepare(); addPreparedStatement.ExecuteNonQuery(); } } catch (SqlException sqlException) { throw new DAOException(sqlException.Message, sqlException); } }
public static bool updateStatus(int status,int idShop) { using (MySqlConnection conn = new MySqlConnection(DiscountStringConnecting)) { try { conn.Open(); MySqlCommand cmd = new MySqlCommand("UPDATE mag_status SET `status` = @val1 WHERE id = @val2 ", conn); cmd.CommandTimeout = Connector.commandTimeout; cmd.Parameters.AddWithValue("@val1", status); cmd.Parameters.AddWithValue("@val2", idShop); cmd.Prepare(); int i = cmd.ExecuteNonQuery(); if (i == 1) { Color.WriteLineColor("Shop [" + idShop + "] обновлен статус - " + Common.returnStatusText(status), ConsoleColor.Yellow); return true; } else { Color.WriteLineColor("Shop [" + idShop + "] Не удалось обновить статус.", ConsoleColor.Red); return false; } } catch (Exception exc) { Color.WriteLineColor("[updateStatus]" + exc.Message, ConsoleColor.Red); Log.Write(exc.Message, "[updateStatus]"); return false; } } }
public PasswordModel(int id, string oldPassword, string newPassword, string Confirm) { passwordError = newpasswordError = confirmError = ""; success = true; if (oldPassword.Length == 0) { success = false; passwordError = "Please enter your old password"; } if (newPassword.Length == 0) { success = false; newpasswordError = "Enter a new password!!"; } if (Confirm.Length == 0) { success = false; confirmError = "CONFIRM YOUR PASSWORD!"; } if (success == true && !newPassword.Equals(Confirm)) { success = false; confirmError = "Your passwords do not match."; } if (success == true) { try { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "SELECT password FROM users WHERE id=" + id; //cmd.Prepare(); //cmd.Parameters.AddWithValue("@src", src); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read() && Crypto.VerifyHashedPassword(rdr[0].ToString(), oldPassword)) { cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Close(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "UPDATE users SET password=@myawesomepassword WHERE id=" + id; cmd.Prepare(); cmd.Parameters.AddWithValue("@myawesomepassword", Crypto.HashPassword(newPassword)); cmd.ExecuteNonQuery(); Conn.Close(); } else { passwordError = "Your old password is incorrect"; } } catch (Exception e) { confirmError = e.Message; } } }
public PaymentModel(int id, string amount, string name, string cardNumber, string cvc, string expires, string password) { success = true; amountError = nameError = cardNumberError = cvcError = expiresError = passwordError = ""; if (amount.Length == 0) { success = false; amountError = "Enter an Amount"; } if (name.Length == 0) { success = false; nameError = "Enter the Name on the Card"; } if (cardNumber.Length == 0) { success = false; cardNumberError = "Enter Card Number"; } if (cvc.Length == 0) { success = false; cvcError = "Enter the Card's CVC"; } if (expires.Length == 0) { success = false; expiresError = "Enter the Card's expiration date"; } if (expires.Length == 0) { success = false; passwordError = "Enter your password"; } if (success) { try { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "INSERT INTO payment_info (user_id, name, card_number, cvc) VALUES (@id, @name, @card_number, @cvc)"; cmd.Prepare(); cmd.Parameters.AddWithValue("@id", id); cmd.Parameters.AddWithValue("@name", name); cmd.Parameters.AddWithValue("@card_number", cardNumber); cmd.Parameters.AddWithValue("@cvc", cvc); success = cmd.ExecuteNonQuery() > 0; amountError = cmd.LastInsertedId.ToString(); Conn.Close(); } catch (Exception ex) { amountError = ex.Message; } } }
private void button6_Click(object sender, EventArgs e) { try { string Connect = "Database=vlad_m;Data Source=192.168.27.79;User Id=vlad_m;charset=cp1251;default command timeout = 240;Password=vlad19957"; MySql.Data.MySqlClient.MySqlConnection myConnection = new MySql.Data.MySqlClient.MySqlConnection(Connect); MySql.Data.MySqlClient.MySqlCommand myCommand = new MySql.Data.MySqlClient.MySqlCommand(); myConnection.Open(); myCommand.Connection = myConnection; myCommand.CommandText = string.Format("TRUNCATE TABLE export_error"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("insert into export_error " + "SELECT * FROM import_error_gis " + "WHERE NOT EXISTS(" + "SELECT * FROM import_error_LS " + "WHERE import_error_LS.id = import_error_gis.id " + "and import_error_LS.lastname = import_error_gis.lastname " + "and import_error_LS.firtname = import_error_gis.firtname " + "and import_error_LS.lastname = import_error_gis.lastname)"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос myCommand.CommandText = string.Format("select count(id) from export_error"); //запрос: если есть такой логин в таблице myCommand.Prepare(); //подготавливает строку myCommand.ExecuteNonQuery(); //выполняет запрос int count = Convert.ToInt32(myCommand.ExecuteScalar()); myConnection.Close(); MessageBox.Show("Готово export_error! Господи, спаси меня это этого: " + count); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
public AvatarModel(int id, string src) { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "UPDATE users SET avatar=@src WHERE id=" + id; cmd.Prepare(); cmd.Parameters.AddWithValue("@src", src); //MySqlDataReader rdr = cmd.ExecuteReader(); cmd.ExecuteNonQuery(); Conn.Close(); }
public void updateState() { string output = JsonConvert.SerializeObject(data); MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "INSERT INTO games VALUES output "; cmd.Prepare(); MySqlDataReader rdr = cmd.ExecuteReader(); Conn.Close(); }
public EmailModel(int id, string email, string password) { success = true; passwordError = emailError = ""; if (email.Length == 0) { success = false; emailError = "Enter your new email"; } if (password.Length == 0) { success = false; passwordError = "Enter your password"; } if (success == true) { try { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Close(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "SELECT password FROM users WHERE id=" + id; //cmd.Prepare(); //cmd.Parameters.AddWithValue("@src", src); MySqlDataReader rdr = cmd.ExecuteReader(); if (rdr.Read() && Crypto.VerifyHashedPassword(rdr[0].ToString(), password)) { cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Close(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "UPDATE users SET email=@newemail WHERE id=" + id; cmd.Prepare(); cmd.Parameters.AddWithValue("@newemail", email); cmd.ExecuteNonQuery(); Conn.Close(); } else { passwordError = "Your password is incorrect"; } } catch (Exception e) { passwordError = e.Message; } } }
public string getState() { MySqlConnection Conn = new MySqlConnection("server=sql9.freemysqlhosting.net;database=sql9140372;user=sql9140372;password=WSx2C8iRZx;"); var cmd = new MySql.Data.MySqlClient.MySqlCommand(); Conn.Open(); cmd.Connection = Conn; cmd.CommandText = "SELECT jsondata FROM games"; cmd.Prepare(); MySqlDataReader rdr = cmd.ExecuteReader(); string json = (string)rdr["jsondata"]; //change to point to data class held by this data = JsonConvert.DeserializeObject <GameData>(json); Conn.Close(); return(json); }