private void UpdateProductData(Product existed_product) { List <string> old_data = new List <string>(); List <string> new_data = new List <string>(); new_data.Add(combo_units.Text); new_data.Add(text_amount.Text); new_data.Add(text_purchasing_price.Text); new_data.Add(text_selling_price.Text); new_data.Add(text_profit_margin.Text); if (new FormExistedDataMessage().ShowDialog(combo_categories.Text, existed_product, new_data) == DialogResult.OK) { string update_product_data = string.Format(@" UPDATE products SET unit_id = {0}, amount = {1}, purchasing_price = {2}, selling_price = {3}, profit_margin = {4} WHERE product_id = {5} " , combo_units.SelectedValue.ToString(), text_amount.Text, text_purchasing_price.Text, text_selling_price.Text, text_profit_margin.Text, existed_product.ProductID); db.ExecuteNonQuery(update_product_data); } }
private void btn_save_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(text_new_category.Text)) { MessageBox.Show("حقل فارغ", "رسالة خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error); text_new_category.Focus(); return; } string sql = string.Format("INSERT INTO categories VALUES (NULL, '{0}')", text_new_category.Text); DataAccessLayer.DBHandler db = new DataAccessLayer.DBHandler(); if (db.ExecuteNonQuery(sql) == "Constraint") { MessageBox.Show("هذا القسم موجود بالفعل !", "رسالة خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error); text_new_category.Focus(); text_new_category.SelectAll(); return; } (new System.Windows.Forms.NotifyIcon() { Visible = true, Icon = System.Drawing.SystemIcons.Information, BalloonTipText = "تم الحفظ بنجاح", }).ShowBalloonTip(1000); OnCategoriewUpdated(); }