private void FormPDFUser_Load(object sender, EventArgs e) { getContent returnInfo = new getContent(); MySqlConnectionStringBuilder conn = new MySqlConnectionStringBuilder(); conn.Server = returnInfo.getServer(); conn.UserID = returnInfo.getId(); conn.Password = returnInfo.getPassword(); conn.Database = returnInfo.getDb(); var connString = conn.ToString(); MySqlConnection connec = new MySqlConnection(connString); connec.Open(); UCHome getTokTri = new UCHome(); UCTreasure getTokMember = new UCTreasure(); string requeteStatut = "select statut from login where id = '" + getTokTri.returnToken() + "'"; MySqlDataAdapter getStatut = new MySqlDataAdapter(requeteStatut, connec); DataTable dbStatut = new DataTable(); getStatut.Fill(dbStatut); statutGot = dbStatut.Rows[0][0].ToString(); if (statutGot == "user") { UCHome tokos = new UCHome(); string tokenA = tokos.returnToken().ToString(); axAcroPDF1.src = pathpath + @"\bordereauUser" + tokenA + ".pdf"; databaseFilePut(pathpath + @"\bordereauUser" + tokenA + ".pdf"); } else if (statutGot == "treasure") { UCTreasure tokas = new UCTreasure(); string tokenB = tokas.getIdMember(); axAcroPDF1.src = pathpath + @"\bordereauUser" + tokenB + ".pdf"; databaseFilePut(pathpath + @"\bordereauUser" + tokenB + ".pdf"); } }
public static void databaseFilePut(string varFilePath) { getContent returnInfo = new getContent(); MySqlConnectionStringBuilder conn = new MySqlConnectionStringBuilder(); conn.Server = returnInfo.getServer(); conn.UserID = returnInfo.getId(); conn.Password = returnInfo.getPassword(); conn.Database = returnInfo.getDb(); var connString = conn.ToString(); MySqlConnection connec = new MySqlConnection(connString); connec.Open(); UCHome getTokTri = new UCHome(); UCTreasure getTokMember = new UCTreasure(); string requeteStatut = "select statut from login where id = '" + getTokTri.returnToken() + "'"; MySqlDataAdapter getStatut = new MySqlDataAdapter(requeteStatut, connec); DataTable dbStatut = new DataTable(); getStatut.Fill(dbStatut); statutGot = dbStatut.Rows[0][0].ToString(); if (statutGot == "user") { byte[] file; using (var stream = new FileStream(varFilePath, FileMode.Open, FileAccess.Read)) { using (var reader = new BinaryReader(stream)) { file = reader.ReadBytes((int)stream.Length); } } using (var varConnection = connec) using (var sqlWrite = new MySqlCommand(@"update login set pdfNotSigned = @File where id = '" + getTokTri.returnToken() + "'", varConnection)) { sqlWrite.Parameters.Add("@File", MySqlDbType.VarBinary, file.Length).Value = file; sqlWrite.ExecuteNonQuery(); } connec.Close(); } else if (statutGot == "treasure") { byte[] file; using (var stream = new FileStream(varFilePath, FileMode.Open, FileAccess.Read)) { using (var reader = new BinaryReader(stream)) { file = reader.ReadBytes((int)stream.Length); } } using (var varConnection = connec) using (var sqlWrite = new MySqlCommand(@"update login set pdfNotSigned = @File where id = '" + getTokMember.getIdMember() + "'", varConnection)) { sqlWrite.Parameters.Add("@File", MySqlDbType.VarBinary, file.Length).Value = file; sqlWrite.ExecuteNonQuery(); } connec.Close(); } }