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 bunifuDropdown1_onItemSelected_1(object sender, EventArgs e)
{
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 d1 = ClassConnection.FillDataReader(req1);
if (d1.Read())
{
Id_Client = (int)d1["IdClient"];
d1.Close();
}
string req3 = @"SELECT dbo.Material.Nom_Mt, dbo.Material.Nombre, dbo.Material.image, dbo.Material.Id_C, dbo.Material.Prix
FROM dbo.Client INNER JOIN
dbo.Commande ON dbo.Client.IdClient = dbo.Commande.IdClient INNER JOIN
dbo.Material ON dbo.Commande.Id_C = dbo.Material.Id_C where dbo.Client.IdClient =" + Id_Client + "";
ClassConnection.OpenCnx();
SqlDataReader d2 = ClassConnection.FillDataReader(req3);
dataGridView2.Rows.Clear();
while (d2.Read())
{
dataGridView2.Rows.Add(d2[0], d2[1], d2[2], d2[3], d2[4]);
}
d2.Close();
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (bunifuDropdown1.selectedIndex == -1)
{
MessageBox.Show("Selectioné un client", "Ereur", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (checkBox1.Checked == true)
{
ClassConnection.OpenCnx();
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 req2 = "insert into Commande values(" + Id_Client + ")";
dr1.Close();
ClassConnection.Excute(req2);
}
bunifuImageButton1.Enabled = true;
bunifuImageButton2.Enabled = true;
}
else
{
bunifuImageButton1.Enabled = false;
bunifuImageButton2.Enabled = false;
}
}
}
private void bunifuDropdown1_onItemSelected(object sender, EventArgs e)
{
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();
}
}
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 bunifuFlatButton1_Click_2(object sender, EventArgs e)
{
string req5 = "SELECT Id_C from Commande where IdClient=" + Id_Client + "";
ClassConnection.OpenCnx();
SqlDataReader dr1 = ClassConnection.FillDataReader(req5);
if (dr1.Read())
{
Id_C = (int)dr1["Id_C"];
dr1.Close();
RDV r = new RDV();
r.Pass((int)Id_C);
r.ShowDialog();
}
}
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);
}
}