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