private void bunifuFlatButton1_Click(object sender, EventArgs e)
{
if (strFilePath == "")
{
if (ImageByteArray.Length != 0)
{
ImageByteArray = new byte[] { }
}
;
}
else
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByteArray = strm.ToArray();
}
string req4 = "update Material set Nombre=" + textBox5.Text + ", image='" + ImageByteArray + "',Prix=" + textBox4.Text + " where Nom_Mt='" + textBox6.Text + "'";
ClassConnection.Excute(req4);
dataGridView2.Rows.Clear();
dataGridView2.Columns[2].Visible = false;
string req = "SELECT * FROM Material";
SqlDataReader dr = ClassConnection.FillDataReader(req);
while (dr.Read())
{
dataGridView2.Rows.Add(dr[1], dr[2], dr[3], dr[4], dr[5]);
}
dr.Close();
ClassConnection.CloseCnx();
}
private void LoadNextImage()
{
ClassConnection.OpenCnx();
SqlCommand cmd = new SqlCommand("select Image from Image where ImageID=" + imageNumber + "", ClassConnection.cnx);
string req = "select Image from Image where ImageID=" + imageNumber + "";
SqlCommand cmd2 = new SqlCommand("SELECT COUNT(*) FROM Image", ClassConnection.cnx);
SqlDataReader reader = ClassConnection.FillDataReader(req);
if (reader.Read())
{
byte[] picData = reader["Image"] as byte[] ?? null;
reader.Close();
if (picData != null)
{
using (MemoryStream ms = new MemoryStream(picData))
{
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(ms);
Int32 count = (Int32)cmd2.ExecuteScalar();
slidePic.Image = Image.FromStream(ms);
if (imageNumber == count)
{
imageNumber = 1;
}
else
{
imageNumber++;
}
}
}
}
ClassConnection.CloseCnx();
}
private void bunifuImageButton4_Click_1(object sender, EventArgs e)
{
try
{
if (bunifuDropdown1.selectedIndex == -1 || NomMtxt.selectedIndex == -1 || nbMtxt.Text == string.Empty || prixMtxt.Text == string.Empty)
{
MessageBox.Show("Tu doit Remlir tout les champs", "Ereur", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
string delimiteur = " ";
char[] limite = delimiteur.ToCharArray();
string value = bunifuDropdown1.selectedValue;
string[] split = value.Split(limite);
string req1 = "select IdClient from Client where Nom='" + split[1] + "'";
SqlDataReader dr1 = ClassConnection.FillDataReader(req1);
if (dr1.Read())
{
Id_Client = (int)dr1["IdClient"];
string req3 = "SELECT Id_C from Commande where IdClient=" + Id_Client + "";
ClassConnection.OpenCnx();
dr1.Close();
SqlDataReader dr2 = ClassConnection.FillDataReader(req3);
if (dr2.Read())
{
Id_C = (int)dr2["Id_C"];
}
dr2.Close();
if (strFilePath == "")
{
if (ImageByteArray.Length != 0)
{
ImageByteArray = new byte[] { }
}
;
}
else
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByteArray = strm.ToArray();
}
string req4 = "insert into Material values('" + NomMtxt.selectedValue + "'," + nbMtxt.Text + ",'" + ImageByteArray + "'," + Id_C.ToString() + "," + prixMtxt.Text + ")";
dr2.Close();
ClassConnection.Excute(req4);
ClassConnection.CloseCnx();
MessageBox.Show("la Commande effectuer", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
}
catch
{
MessageBox.Show("Problem d'ajouter la Commande", "Ereur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void bunifuImageButton8_Click(object sender, EventArgs e)
{
try
{
if (bunifuDropdown1.selectedIndex == -1 || Plattxt.selectedIndex == -1 || platnbtxt.Text == string.Empty || prixplattxt.Text == string.Empty)
{
MessageBox.Show("Tu doit Remlir tout les champs", "Ereur", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
string req3 = "SELECT Id_C from Commande where IdClient=" + Id_Client + "";
ClassConnection.OpenCnx();
SqlDataReader dr2 = ClassConnection.FillDataReader(req3);
if (dr2.Read())
{
Id_C = (int)dr2["Id_C"];
}
dr2.Close();
if (strFilePath == "")
{
if (ImageByteArray.Length != 0)
{
ImageByteArray = new byte[] { }
}
;
}
else
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByteArray = strm.ToArray();
}
string req4 = "insert into Plats values('" + Plattxt.selectedValue + "'," + platnbtxt.Text + ",'" + ImageByteArray + "'," + Id_C.ToString() + "," + prixplattxt.Text + ")";
ClassConnection.Excute(req4);
ClassConnection.CloseCnx();
MessageBox.Show("la Commande effectuer", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
dr2.Close();
}
}
catch
{
MessageBox.Show("Problem d'ajouter la Commande", "Ereur", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}