public static void databaseFileRead(string varID, string varPathToNewLocation)
{
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 connection = new MySqlConnection(connString);
connection.Open();
using (var varConnection = connection)
using (var sqlQuery = new MySqlCommand("SELECT pdfSigned FROM login WHERE id = '" + varID + "'", varConnection))
{
sqlQuery.Parameters.AddWithValue("@varID", varID);
using (var sqlQueryResult = sqlQuery.ExecuteReader())
if (sqlQueryResult != null)
{
sqlQueryResult.Read();
var blob = new Byte[(sqlQueryResult.GetBytes(0, 0, null, 0, int.MaxValue))];
sqlQueryResult.GetBytes(0, 0, blob, 0, blob.Length);
using (var fs = new FileStream(varPathToNewLocation, FileMode.Create, FileAccess.Write))
fs.Write(blob, 0, blob.Length);
}
}
connection.Close();
}
public Form1()
{
InitializeComponent();
panel1.Height = label2.Height;
ucHome1.BringToFront();
panel1.Height = label2.Height;
panel1.Top = label2.Top;
try
{
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 connection = new MySqlConnection(connString);
connection.Open();
connection.Close();
}
catch
{
MessageBox.Show("Vous n'avez pas accès à internet, veuillez relancer l'application une fois connecté");
this.Close();
}
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs 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 connection = new MySqlConnection(connString);
connection.Open();
int insertRow = Convert.ToInt32(dataGridView1.CurrentRow.Index);
if (dataGridView1.Columns[e.ColumnIndex].Name == "Valider")
{
try
{
dataGridView1.Rows[insertRow].Cells["Validate"].Value = "0";
string updateValidated = "update slips set Validated = 'True' where id = '" + dataGridView1.Rows[insertRow].Cells["Id"].Value.ToString() + "'";
MySqlCommand putUpdateValid = new MySqlCommand(updateValidated, connection);
putUpdateValid.ExecuteNonQuery();
}
catch
{
MessageBox.Show("Un soucis est survenu lors de la validation");
}
}
if (dataGridView1.Columns[e.ColumnIndex].Name == "Modifier")
{
try
{
string updateSlip = "update slips set date = '" + dataGridView1.Rows[insertRow].Cells["date"].Value.ToString() + "' , pattern = '" + dataGridView1.Rows[insertRow].Cells["pattern"].Value.ToString() + "' , path = '" + dataGridView1.Rows[insertRow].Cells["path"].Value.ToString() + "' , kmsTraveled = '" + dataGridView1.Rows[insertRow].Cells["kmsTraveled"].Value.ToString() + "' , pathCost = '" + dataGridView1.Rows[insertRow].Cells["pathCost"].Value.ToString() + "' , tollCost = '" + dataGridView1.Rows[insertRow].Cells["tollCost"].Value.ToString() + "' , mealCost = '" + dataGridView1.Rows[insertRow].Cells["mealCost"].Value.ToString() + "' , accomodationCost = '" + dataGridView1.Rows[insertRow].Cells["accommodationCost"].Value.ToString() + "' , totalCost = '" + dataGridView1.Rows[insertRow].Cells["totalCost"].Value.ToString() + "' where id = '" + dataGridView1.Rows[insertRow].Cells["Id"].Value.ToString() + "'";
MySqlCommand updateSlipDB = new MySqlCommand(updateSlip, connection);
updateSlipDB.ExecuteNonQuery();
}
catch
{
MessageBox.Show("Modifications impossibles");
}
}
connection.Close();
}
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.Rows.Clear();
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 connection = new MySqlConnection(connString);
connection.Open();
try
{
string select = "select idLogin from adherents where firstName = '" + textBox1.Text + "' and name = '" + textBox2.Text + "' and numLicence = '" + textBox3.Text + "'";
MySqlDataAdapter getID = new MySqlDataAdapter(select, connection);
DataTable idDt = new DataTable();
getID.Fill(idDt);
idUser = idDt.Rows[0][0].ToString();
if (idDt.Rows[0][0].ToString() != null)
{
try
{
string getInfo = "SELECT * FROM slips WHERE idMember = '" + idDt.Rows[0][0] + "'";
MySqlDataAdapter coInfo = new MySqlDataAdapter(getInfo, connection);
DataTable getDt = new DataTable();
coInfo.Fill(getDt);
string ouech = getDt.Rows[0][0].ToString();
foreach (DataRow dt in getDt.Rows)
{
comptSlip++;
slipBindingSource1.Add(new Slip
{
Id = Convert.ToInt32(dt["Id"]),
SlipDate = dt["date"].ToString(),
SlipPattern = dt["pattern"].ToString(),
SlipPath = dt["path"].ToString(),
SlipKilometers = Convert.ToInt32(dt["kmsTraveled"]),
PathCost = Convert.ToInt32(dt["pathCost"]),
TollCost = Convert.ToInt32(dt["tollCost"]),
MealCost = Convert.ToInt32(dt["mealCost"]),
AccommodationCost = Convert.ToInt32(dt["accomodationCost"]),
TotalCost = Convert.ToInt32(dt["totalCost"]),
});
}
}
catch
{
MessageBox.Show("Aucun bordereau n'a encore été completé par l'utilisateur");
}
}
else
{
MessageBox.Show("Veuillez renseigner un utilisateur valide.");
}
}
catch
{
MessageBox.Show("Veuillez renseigner un utilisateur valide.");
}
connection.Close();
}
