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();
}
}
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");
}
}
