private void btnCreateOffer_Click(object sender, EventArgs e) { try { if (gridView2.SelectedRowsCount > 0 && txtOfferName.Text != "" && txtPrice.Text != "") { string query = "select Offer_Name from offer where Offer_Name='" + txtOfferName.Text + "'"; MySqlCommand comand = new MySqlCommand(query, dbconnection); dbconnection.Open(); MySqlDataReader dr = comand.ExecuteReader(); while (dr.Read()) { if (dr["Offer_Name"].ToString() == txtOfferName.Text) { MessageBox.Show("هذا العرض موجود من قبل"); dr.Close(); dbconnection.Close(); return; } } dr.Close(); dbconnection.Close(); double price = 0; if (!double.TryParse(txtPrice.Text, out price)) { MessageBox.Show("السعر يجب ان يكون عدد"); dbconnection.Close(); return; } dbconnection.Open(); query = "insert into offer (Offer_Name,Price,Delegate_Percent,Description) values (@Offer_Name,@Price,@Delegate_Percent,@Description)"; MySqlCommand com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Offer_Name", MySqlDbType.VarChar); com.Parameters["@Offer_Name"].Value = txtOfferName.Text; com.Parameters.Add("@Price", MySqlDbType.Decimal); com.Parameters["@Price"].Value = price; com.Parameters.Add("@Delegate_Percent", MySqlDbType.Decimal); com.Parameters["@Delegate_Percent"].Value = txtDelegatePercent.Text; com.Parameters.Add("@Description", MySqlDbType.VarChar); com.Parameters["@Description"].Value = txtDescription.Text; com.ExecuteNonQuery(); query = "select Offer_ID from offer order by Offer_ID desc limit 1"; com = new MySqlCommand(query, dbconnection); int id = Convert.ToInt32(com.ExecuteScalar()); for (int i = 0; i < gridView2.RowCount; i++) { DataRowView item = (DataRowView)gridView2.GetRow(i); query = "insert offer_details (Offer_ID,Data_ID,Quantity) values (@Offer_ID,@Data_ID,@Quantity)"; com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Offer_ID", MySqlDbType.Int16); com.Parameters["@Offer_ID"].Value = id; com.Parameters.Add("@Data_ID", MySqlDbType.Int16); com.Parameters["@Data_ID"].Value = Convert.ToInt32(item[0].ToString()); com.Parameters.Add("@Quantity", MySqlDbType.Decimal); com.Parameters["@Quantity"].Value = Convert.ToDouble(item["الكمية"].ToString()); com.ExecuteNonQuery(); } if (selectedImage != null) { query = "insert into offer_photo (Offer_ID,Photo) values (@Offer_ID,@Photo)"; com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Offer_ID", MySqlDbType.Int16); com.Parameters["@Offer_ID"].Value = id; com.Parameters.Add("@Photo", MySqlDbType.LongBlob); com.Parameters["@Photo"].Value = selectedImage; com.ExecuteNonQuery(); } UserControl.ItemRecord("offer", "اضافة", id, DateTime.Now, "", dbconnection); clear(tableLayoutPanel1); offerForm.DisplayOffer(); offerForm.loadDataToBox(); } else { MessageBox.Show("يجب ادخال البيانات كاملة"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }