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