private void btnDelete_Click(object sender, EventArgs e) { try { DataRowView row1 = (DataRowView)(((GridView)dataGridView1.MainView).GetRow(((GridView)dataGridView1.MainView).GetSelectedRows()[0])); if (row1 != null) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the item?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { string query = "delete from storage where Storage_ID=" + row1[0].ToString(); MySqlCommand comand = new MySqlCommand(query, dbconnection); dbconnection.Open(); comand.ExecuteNonQuery(); UserControl.ItemRecord("storage", "حذف", Convert.ToInt16(row1[0].ToString()), DateTime.Now, "", dbconnection); displayProducts(); } else if (dialogResult == DialogResult.No) { } } else { MessageBox.Show("you must select an item"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
void delete(GridView view) { int[] selRows = ((GridView)gridControl1.MainView).GetSelectedRows(); if (selRows.Length > 0) { if (MessageBox.Show("هل انت متاكد انك تريد الحذف؟", "تحذير", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes) { return; } conn.Open(); for (int i = 0; i < selRows.Length; i++) { DataRowView selRow = (DataRowView)(((GridView)gridControl1.MainView).GetRow(selRows[i])); string query = "delete from customer_phone where Customer_ID=" + selRow[0].ToString(); MySqlCommand comand = new MySqlCommand(query, conn); comand.ExecuteNonQuery(); query = "delete from customer where Customer_ID=" + selRow[0].ToString(); comand = new MySqlCommand(query, conn); comand.ExecuteNonQuery(); UserControl.ItemRecord("customer", "حذف", Convert.ToInt16(selRow[0].ToString()), DateTime.Now, "", conn); } conn.Close(); search(); } else { MessageBox.Show("يجب ان تختار عنصر للحذف"); } }
void delete() { string query = "delete from area where Area_ID=" + areaId; MySqlCommand com = new MySqlCommand(query, dbConnection); com.ExecuteNonQuery(); UserControl.ItemRecord("area", "حذف", areaId, DateTime.Now, null, dbConnection); }
void delete() { string query = "delete from zone where Zone_ID=" + zoneId; MySqlCommand com = new MySqlCommand(query, dbConnection); com.ExecuteNonQuery(); UserControl.ItemRecord("zone", "حذف", zoneId, DateTime.Now, null, dbConnection); }
private void btnDelete_Click(object sender, EventArgs e) { try { dbconnection.Open(); DataRowView row1 = (DataRowView)(((GridView)gridControl1.MainView).GetRow(((GridView)gridControl1.MainView).GetSelectedRows()[0])); if (chBoxSelectAll.Checked) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the item?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { string query = "delete from sellprice where SellPrice_ID='" + dataTable.Rows[i][0].ToString() + "'"; MySqlCommand comand = new MySqlCommand(query, dbconnection); comand.ExecuteNonQuery(); UserControl.ItemRecord("sellprice", "حذف", Convert.ToInt16(row1[0].ToString()), DateTime.Now, "", dbconnection); dbconnection.Open(); } } } else if (row1 != null) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the item?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { string query = "delete from sellprice where SellPrice_ID='" + row1[0].ToString() + "'"; MySqlCommand comand = new MySqlCommand(query, dbconnection); comand.ExecuteNonQuery(); UserControl.ItemRecord("sellprice", "حذف", Convert.ToInt16(row1[0].ToString()), DateTime.Now, "", dbconnection); } else if (dialogResult == DialogResult.No) { } } else { MessageBox.Show("you must select an item"); } displayProducts(); } catch { MessageBox.Show("you must select an item"); } dbconnection.Close(); }
private void btnAddNewArea_Click(object sender, EventArgs e) { try { if (txtArea.Text != "") { dbConnection.Open(); string q = "select Area_Name from area where Area_Name='" + txtArea.Text + "'"; MySqlCommand c = new MySqlCommand(q, dbConnection); if (c.ExecuteScalar() == null) { string query = "insert into area (Area_Name) values (@Area_Name)"; MySqlCommand com = new MySqlCommand(query, dbConnection); com.Parameters.Add("@Area_Name", MySqlDbType.VarChar).Value = txtArea.Text; com.ExecuteNonQuery(); txtArea.Text = ""; q = "select Area_ID from area order by Area_ID desc limit 1"; c = new MySqlCommand(q, dbConnection); int areId = Convert.ToInt16(c.ExecuteScalar().ToString()); UserControl.ItemRecord("area", "اضافة", areId, DateTime.Now, null, dbConnection); updateLists(); displayAllAreas(); MessageBox.Show("تم الاضافة"); } else { MessageBox.Show("هذه المنطقة تم اضافتها من قبل"); } } else { MessageBox.Show("يجب ادخال البيانات كاملة"); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } dbConnection.Close(); }
private void radNewBill_Click(object sender, EventArgs e) { try { dbconnection.Open(); int id = 0; string query = "select Bill_Number from dash where Branch_ID=" + EmpBranchId + " order by Dash_ID desc limit 1"; MySqlCommand cmd = new MySqlCommand(query, dbconnection); if (cmd.ExecuteScalar() != null) { id = Convert.ToInt16(cmd.ExecuteScalar()); } id = id + 1; //txtBill.Visible = true; //labBill.Visible = true; //btnConfirm.Visible = true; txtBill.Enabled = false; txtBill.Text = id.ToString(); //txtBill.TextAlign = ContentAlignment.MiddleCenter; query = "insert into dash (Delegate_ID,Delegate_Name,Bill_Number,Branch_ID,Bill_Date) values (@Delegate_ID,@Delegate_Name,@Bill_Number,@Branch_ID,@Bill_Date)"; MySqlCommand com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Delegate_ID", MySqlDbType.Int16).Value = delId; com.Parameters.Add("@Delegate_Name", MySqlDbType.VarChar).Value = delName; com.Parameters.Add("@Bill_Number", MySqlDbType.Int16).Value = id; com.Parameters.Add("@Branch_ID", MySqlDbType.Int16).Value = EmpBranchId; com.Parameters.Add("@Bill_Date", MySqlDbType.DateTime).Value = DateTime.Now; com.ExecuteNonQuery(); string q = "select Dash_ID from dash where Branch_ID=" + EmpBranchId + " and Bill_Number=" + id + " order by Dash_ID desc limit 1"; MySqlCommand command = new MySqlCommand(q, dbconnection); int dashId = Convert.ToInt16(command.ExecuteScalar().ToString()); UserControl.ItemRecord("dash", "اضافة", dashId, DateTime.Now, null, dbconnection); dbconnection.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnDelete_Click(object sender, EventArgs e) { try { dbconnection.Open(); DataRowView offerRow = (DataRowView)(((GridView)dataGridView1.MainView).GetRow(((GridView)dataGridView1.MainView).GetSelectedRows()[0])); if (offerRow != null) { DialogResult dialogResult = MessageBox.Show("Are you sure you want to delete the item?", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult == DialogResult.Yes) { deleteOffer(Convert.ToInt16(offerRow[0].ToString())); string query = "ALTER TABLE offer AUTO_INCREMENT = 1;"; MySqlCommand com = new MySqlCommand(query, dbconnection); com.ExecuteNonQuery(); UserControl.ItemRecord("offer", "حذف", Convert.ToInt16(offerRow[0].ToString()), DateTime.Now, "", dbconnection); dbconnection.Close(); DisplayOffer(); loadDataToBox(); } else if (dialogResult == DialogResult.No) { } } else { MessageBox.Show("select row"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { try { if (txtCode.Text != "" || chBoxSelectAll.Checked) { dbconnection.Open(); double price = double.Parse(txtPrice.Text); double SellPercent = double.Parse(txtSell.Text); if (radioQata3y.Checked == true) { #region set qata3yPrice for list item if (txtCode.Text == "" && chBoxSelectAll.Checked) { double NormalPercent = double.Parse(txtNormal.Text); double UnNormalPercent = double.Parse(txtUnNormal.Text); DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { string query = "INSERT INTO sellprice (Sell_Discount,Price_Type, Sell_Price, ProfitRatio, Data_ID, Price,Last_Price, PercentageDelegate,Date) VALUES(?Sell_Discount,?Price_Type,?Sell_Price,?ProfitRatio,?Data_ID,?Price,?Last_Price,?PercentageDelegate,?Date)"; MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("?Price_Type", "قطعى"); command.Parameters.AddWithValue("?Sell_Price", calSellPrice()); command.Parameters.AddWithValue("?Data_ID", dataTable.Rows[i][0].ToString()); command.Parameters.AddWithValue("?ProfitRatio", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("?Price", price); command.Parameters.AddWithValue("?Last_Price", calSellPrice()); command.Parameters.AddWithValue("?Sell_Discount", 0.0); command.Parameters.AddWithValue("?PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.Parameters.Add("?Date", MySqlDbType.Date); command.Parameters["?Date"].Value = DateTime.Now.Date; command.ExecuteNonQuery(); } } #endregion #region set qata3yPrice for one item else { if (id != 0) { string query = "INSERT INTO sellprice (Sell_Discount,Price_Type,Last_Price, Sell_Price, ProfitRatio, Data_ID, Price, PercentageDelegate,Date) VALUES(?Sell_Discount,?Price_Type,?Last_Price,?Sell_Price,?ProfitRatio,?Data_ID,?Price,?PercentageDelegate,?Date)"; MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("?Price_Type", "قطعى"); command.Parameters.AddWithValue("?Sell_Price", calSellPrice()); command.Parameters.AddWithValue("?Data_ID", id); command.Parameters.AddWithValue("?ProfitRatio", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("?Price", price); command.Parameters.AddWithValue("?Last_Price", calSellPrice()); command.Parameters.AddWithValue("?Sell_Discount", 0.0); command.Parameters.AddWithValue("?PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.Parameters.Add("?Date", MySqlDbType.Date); command.Parameters["?Date"].Value = DateTime.Now.Date; command.ExecuteNonQuery(); } else { MessageBox.Show("error in Data_ID"); dbconnection.Close(); return; } } #endregion } else { #region set priceList for collection of items if (txtCode.Text == "" && chBoxSelectAll.Checked) { double NormalPercent = double.Parse(txtNormal.Text); double unNormalPercent = double.Parse(txtUnNormal.Text); double sellPrice = (price + NormalPercent) - ((price + NormalPercent) * SellPercent / 100.0); sellPrice = sellPrice + unNormalPercent; DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { string query = "INSERT INTO sellprice (Last_Price,Price_Type,Sell_Price,Data_ID,Sell_Discount,Price,Normal_Increase,Categorical_Increase,PercentageDelegate,Date) VALUES (?Last_Price,?Price_Type,?Sell_Price,?Data_ID,?Sell_Discount,?Price,?Normal_Increase,?Categorical_Increase,?PercentageDelegate,?Date)"; MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "لستة"); command.Parameters.AddWithValue("@Sell_Price", calSellPrice()); command.Parameters.AddWithValue("?Data_ID", dataTable.Rows[i][0].ToString()); command.Parameters.AddWithValue("@Sell_Discount", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Last_Price", lastPrice()); command.Parameters.AddWithValue("@Normal_Increase", double.Parse(txtNormal.Text)); command.Parameters.AddWithValue("@Categorical_Increase", double.Parse(txtUnNormal.Text)); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.Parameters.Add("?Date", MySqlDbType.Date); command.Parameters["?Date"].Value = DateTime.Now.Date; command.ExecuteNonQuery(); } } #endregion #region set priceList for one item else { if (id != 0) { double NormalPercent = double.Parse(txtNormal.Text); double unNormalPercent = double.Parse(txtUnNormal.Text); double sellPrice = (price + NormalPercent) - ((price + NormalPercent) * SellPercent / 100.0); sellPrice = sellPrice + unNormalPercent; string query = "INSERT INTO sellprice (Last_Price,Price_Type,Sell_Price,Data_ID,Sell_Discount,Price,Normal_Increase,Categorical_Increase,PercentageDelegate,Date) VALUES (?Last_Price,?Price_Type,?Sell_Price,?Data_ID,?Sell_Discount,?Price,?Normal_Increase,?Categorical_Increase,?PercentageDelegate,?Date)"; MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "لستة"); command.Parameters.AddWithValue("@Sell_Price", calSellPrice()); command.Parameters.AddWithValue("?Data_ID", id); command.Parameters.AddWithValue("@Sell_Discount", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Last_Price", lastPrice()); command.Parameters.AddWithValue("@Normal_Increase", double.Parse(txtNormal.Text)); command.Parameters.AddWithValue("@Categorical_Increase", double.Parse(txtUnNormal.Text)); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.Parameters.Add("?Date", MySqlDbType.Date); command.Parameters["?Date"].Value = DateTime.Now.Date; command.ExecuteNonQuery(); } else { MessageBox.Show("error in Data_ID"); dbconnection.Close(); return; } } #endregion } int sellPrice_ID = 0; string queryx = "select SellPrice_ID from sellprice order by SellPrice_ID desc limit 1"; MySqlCommand com = new MySqlCommand(queryx, dbconnection); if (com.ExecuteScalar() != null) { sellPrice_ID = Convert.ToInt16(com.ExecuteScalar()); } foreach (DataGridViewRow item in dataGridView1.Rows) { double addational = Convert.ToDouble(item.Cells[0].Value); queryx = "insert into additional_increase_sellprice (SellPrice_ID,AdditionalValue,Type,Description) values (@SellPrice_ID,@AdditionalValue,@Type,@Description)"; com = new MySqlCommand(queryx, dbconnection); com.Parameters.AddWithValue("@SellPrice_ID", sellPrice_ID); com.Parameters.AddWithValue("@Type", item.Cells[1].Value); com.Parameters.AddWithValue("@AdditionalValue", item.Cells[0].Value); com.Parameters.AddWithValue("@Description", item.Cells[2].Value); com.ExecuteNonQuery(); } UserControl.ItemRecord("sellprice", "اضافة", sellPrice_ID, DateTime.Now, "", dbconnection); MessageBox.Show("Done"); Clear(); productsSellPriceForm.displayProducts(); } else { MessageBox.Show("select item"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
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.ToInt16(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.ToInt16(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(); }
void delete(GridView view) { int[] selRows = ((GridView)gridControl1.MainView).GetSelectedRows(); // && gridView1.GetRowCellDisplayText(gridView1.GetSelectedRows()[0], "Error") == "0" if (selRows.Length > 0) { if (MessageBox.Show("هل انت متاكد انك تريد الحذف؟", "تحذير", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes) { return; } Form prompt = new Form() { Width = 500, Height = 220, FormBorderStyle = FormBorderStyle.FixedDialog, Text = "", StartPosition = FormStartPosition.CenterScreen, MaximizeBox = false, MinimizeBox = false }; Label textLabel = new Label() { Left = 340, Top = 20, Text = "ما هو سبب الحذف؟" }; TextBox textBox = new TextBox() { Left = 50, Top = 50, Width = 385, Multiline = true, Height = 80, RightToLeft = RightToLeft }; Button confirmation = new Button() { Text = "تأكيد", Left = 200, Width = 100, Top = 140, DialogResult = DialogResult.OK }; prompt.Controls.Add(textBox); prompt.Controls.Add(confirmation); prompt.Controls.Add(textLabel); prompt.AcceptButton = confirmation; if (prompt.ShowDialog() == DialogResult.OK) { if (textBox.Text != "") { conn.Open(); for (int i = 0; i < selRows.Length; i++) { DataRowView selRow = (DataRowView)(((GridView)gridControl1.MainView).GetRow(selRows[i])); string query = "delete from dash_details where DashDetails_ID=" + selRow[0].ToString(); MySqlCommand comand = new MySqlCommand(query, conn); comand.ExecuteNonQuery(); main.test(delegateID, billNum); UserControl.ItemRecord("dash_details", "حذف", Convert.ToInt16(selRow[0].ToString()), DateTime.Now, textBox.Text, conn); } conn.Close(); search(); } else { MessageBox.Show("يجب كتابة السبب"); } } else { } } else { MessageBox.Show("تاكد من اختيارك"); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (Customer_Type == "عميل" && flag) { if (comEnginner.Text != "") { } else { MessageBox.Show("يجب اختيار الضامن"); dbconnection.Close(); return; } } Form prompt = new Form() { Width = 500, Height = 220, FormBorderStyle = FormBorderStyle.FixedDialog, Text = "", StartPosition = FormStartPosition.CenterScreen, MaximizeBox = false, MinimizeBox = false }; Label textLabel = new Label() { Left = 340, Top = 20, Text = "ما هو سبب التعديل؟" }; TextBox textBox = new TextBox() { Left = 50, Top = 50, Width = 385, Multiline = true, Height = 80, RightToLeft = RightToLeft }; Button confirmation = new Button() { Text = "تأكيد", Left = 200, Width = 100, Top = 140, DialogResult = DialogResult.OK }; prompt.Controls.Add(textBox); prompt.Controls.Add(confirmation); prompt.Controls.Add(textLabel); prompt.AcceptButton = confirmation; if (prompt.ShowDialog() == DialogResult.OK) { if (textBox.Text != "") { dbconnection.Open(); string query = "update customer set Customer_NationalID=@Customer_NationalID,Customer_Email=@Customer_Email,Customer_Address=@Customer_Address,Customer_Info=@Customer_Info,Customer_Type=@Customer_Type where Customer_ID=" + selRow[0].ToString(); MySqlCommand com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Customer_Address", MySqlDbType.VarChar, 255); com.Parameters["@Customer_Address"].Value = txtAddress.Text; com.Parameters.Add("@Customer_Email", MySqlDbType.VarChar, 255); com.Parameters["@Customer_Email"].Value = txtEmail.Text; if (txtNationalID.Text != "") { com.Parameters.Add("@Customer_NationalID", MySqlDbType.VarChar, 255); com.Parameters["@Customer_NationalID"].Value = txtNationalID.Text; } else { com.Parameters.Add("@Customer_NationalID", MySqlDbType.VarChar, 255); com.Parameters["@Customer_NationalID"].Value = null; } com.Parameters.Add("@Customer_Info", MySqlDbType.VarChar, 255); com.Parameters["@Customer_Info"].Value = txtINF.Text; if (Customer_Type != "") { com.Parameters.Add("@Customer_Type", MySqlDbType.VarChar, 255); com.Parameters["@Customer_Type"].Value = Customer_Type; } else { MessageBox.Show("برجاء اختيار النوع"); dbconnection.Close(); return; } com.ExecuteNonQuery(); if (Customer_Type == "عميل" && flag) { AddClientToEng_Con(); } UserControl.ItemRecord("customer", "تعديل", Convert.ToInt16(selRow[0].ToString()), DateTime.Now, textBox.Text, dbconnection); //MessageBox.Show("تم"); //clear(); xtraTabPage.ImageOptions.Image = null; MainForm.objFormCustomer.search(); MainForm.tabControlSales.TabPages.Remove(MainForm.MainTabPageUpdateCustomer); } else { MessageBox.Show("يجب كتابة السبب"); } } else { } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { try { dbconnection.Open(); double price = double.Parse(txtPrice.Text); double SellPercent = double.Parse(txtSell.Text); if (radioQata3y.Checked == true) { #region set qata3yPrice for list item double NormalPercent = double.Parse(txtNormal.Text); double UnNormalPercent = double.Parse(txtUnNormal.Text); DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { String query = "update sellprice set Sell_Discount=@Sell_Discount,Normal_Increase=@Normal_Increase,Categorical_Increase=@Categorical_Increase,Price_Type=@Price_Type,Sell_Price=@Sell_Price,ProfitRatio=@ProfitRatio,Price=@Price,PercentageDelegate=@PercentageDelegate where SellPrice_ID=" + dataTable.Rows[i][0].ToString(); MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "قطعى"); command.Parameters.AddWithValue("@Sell_Price", price + (price * SellPercent / 100.0)); command.Parameters.AddWithValue("@ProfitRatio", SellPercent); command.Parameters.AddWithValue("@Sell_Discount", 0.00); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Normal_Increase", 0.00); command.Parameters.AddWithValue("@Categorical_Increase", 0.00); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.ExecuteNonQuery(); UserControl.ItemRecord("sellprice", "تعديل", Convert.ToInt16(dataTable.Rows[i][0].ToString()), DateTime.Now, "", dbconnection); dbconnection.Open(); } #endregion } else { #region set priceList for collection of items double NormalPercent = double.Parse(txtNormal.Text); double unNormalPercent = double.Parse(txtUnNormal.Text); double sellPrice = (price + NormalPercent) - ((price + NormalPercent) * SellPercent / 100.0); sellPrice = sellPrice + unNormalPercent; DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { string query = "update sellprice set ProfitRatio=@ProfitRatio, Price_Type=@Price_Type,Sell_Price=@Sell_Price,Sell_Discount=@Sell_Discount,Price=@Price,Normal_Increase=@Normal_Increase,Categorical_Increase=@Categorical_Increase,PercentageDelegate=@PercentageDelegate where SellPrice_ID =" + dataTable.Rows[i][0].ToString(); MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "لستة"); command.Parameters.AddWithValue("@Sell_Price", sellPrice); command.Parameters.AddWithValue("@ProfitRatio", 0.00); command.Parameters.AddWithValue("@Sell_Discount", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Normal_Increase", double.Parse(txtNormal.Text)); command.Parameters.AddWithValue("@Categorical_Increase", double.Parse(txtUnNormal.Text)); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.ExecuteNonQuery(); UserControl.ItemRecord("sellprice", "تعديل", Convert.ToInt16(dataTable.Rows[i][0].ToString()), DateTime.Now, "", dbconnection); dbconnection.Open(); } #endregion } displayData(); productsSellPriceForm.displayProducts(); XtraTabPage xtraTabPage = getTabPage("تعديل اسعار البنود"); xtraTabPage.ImageOptions.Image = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnDelete_Click(object sender, EventArgs e) { try { int[] selRows = ((GridView)gridControl1.MainView).GetSelectedRows(); if (selRows.Length > 0) { if (MessageBox.Show("هل انت متاكد انك تريد الحذف؟", "تحذير", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) != DialogResult.Yes) { return; } Form prompt = new Form() { Width = 500, Height = 220, FormBorderStyle = FormBorderStyle.FixedDialog, Text = "", StartPosition = FormStartPosition.CenterScreen, MaximizeBox = false, MinimizeBox = false }; Label textLabel = new Label() { Left = 340, Top = 20, Text = "ما هو سبب الحذف؟" }; TextBox textBox = new TextBox() { Left = 50, Top = 50, Width = 385, Multiline = true, Height = 80, RightToLeft = RightToLeft }; Button confirmation = new Button() { Text = "تأكيد", Left = 200, Width = 100, Top = 140, DialogResult = DialogResult.OK }; prompt.Controls.Add(textBox); prompt.Controls.Add(confirmation); prompt.Controls.Add(textLabel); prompt.AcceptButton = confirmation; if (prompt.ShowDialog() == DialogResult.OK) { if (textBox.Text != "") { conn.Open(); for (int i = 0; i < gridView1.SelectedRowsCount; i++) { DataRowView selRow = (DataRowView)(((GridView)gridControl1.MainView).GetRow(selRows[i])); string Query = "update attendance set Error=1 where Attendance_ID=" + Convert.ToInt16(selRow[0].ToString()); MySqlCommand MyCommand = new MySqlCommand(Query, conn); MyCommand.ExecuteNonQuery(); UserControl.ItemRecord("attendance", "حذف", Convert.ToInt16(selRow[0].ToString()), DateTime.Now, textBox.Text, conn); } search(); } else { MessageBox.Show("يجب كتابة السبب"); } } else { } } else { MessageBox.Show("يجب ان تختار عنصر للحذف"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }
private void btnCreateOffer_Click(object sender, EventArgs e) { try { if (gridView2.SelectedRowsCount > 0 && txtPrice.Text != "") { double price = 0; if (!double.TryParse(txtPrice.Text, out price)) { MessageBox.Show("السعر يجب ان يكون عدد"); dbconnection.Close(); return; } dbconnection.Open(); string query = "update offer set Price=@Price,Delegate_Percent=@Delegate_Percent,Description=@Description where Offer_ID=" + rowOffer[0].ToString(); MySqlCommand com = new MySqlCommand(query, dbconnection); 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(); //فك كمية البنود dbconnection3.Open(); query = "select storage.Store_ID,sum(Total_Meters) as 'الكمية' from storage where Offer_ID=" + rowOffer[0].ToString() + " group by storage.Store_ID,storage.Offer_ID"; com = new MySqlCommand(query, dbconnection3); MySqlDataReader dr = com.ExecuteReader(); if (dr.HasRows) { while (dr.Read()) { RecordOfferQuantityInStorage(Convert.ToInt16(rowOffer[0].ToString()), Convert.ToInt16(dr["Store_ID"].ToString())); increaseItemsQuantityInDB(Convert.ToDouble(dr["الكمية"].ToString()), Convert.ToInt16(rowOffer[0].ToString()), Convert.ToInt16(dr["Store_ID"].ToString())); } dr.Close(); } //////////////////// query = "delete from offer_details where Offer_ID=" + rowOffer[0].ToString(); com = new MySqlCommand(query, dbconnection); com.ExecuteNonQuery(); 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 = rowOffer[0].ToString(); com.Parameters.Add("@Data_ID", MySqlDbType.Int16); com.Parameters["@Data_ID"].Value = Convert.ToInt16(item[0].ToString()); com.Parameters.Add("@Quantity", MySqlDbType.Decimal); com.Parameters["@Quantity"].Value = Convert.ToDouble(item["الكمية"].ToString()); com.ExecuteNonQuery(); } if (selectedImage != null) { //selectedImage = ImageToByte(ImageProduct.Image); query = "select Photo from offer_photo where Offer_ID=" + rowOffer[0].ToString(); com = new MySqlCommand(query, dbconnection); if (com.ExecuteScalar() != null) { query = "update offer_photo set Photo=@Photo where Offer_ID=" + rowOffer[0].ToString(); com = new MySqlCommand(query, dbconnection); com.Parameters.Add("@Photo", MySqlDbType.LongBlob); com.Parameters["@Photo"].Value = selectedImage; com.ExecuteNonQuery(); } else { 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 = rowOffer[0].ToString(); com.Parameters.Add("@Photo", MySqlDbType.LongBlob); com.Parameters["@Photo"].Value = selectedImage; com.ExecuteNonQuery(); } } else { query = "select Photo from offer_photo where Offer_ID=" + rowOffer[0].ToString(); com = new MySqlCommand(query, dbconnection); if (com.ExecuteScalar() != null) { query = "delete from offer_photo where Offer_ID=" + rowOffer[0].ToString(); com = new MySqlCommand(query, dbconnection); com.ExecuteNonQuery(); } } UserControl.ItemRecord("offer", "تعديل", Convert.ToInt16(rowOffer[0].ToString()), DateTime.Now, "", dbconnection); //clear(tableLayoutPanel1); offerForm.DisplayOffer(); offerForm.loadDataToBox(); XtraTabPage xtraTabPage = getTabPage("تعديل عرض"); tabControlSalesContent.TabPages.Remove(xtraTabPage); } else { MessageBox.Show("يجب ادخال البيانات كاملة"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); dbconnection1.Close(); dbconnection2.Close(); dbconnection3.Close(); }
private void addNewZone() { if (txtZoneNameAdd.Text != "") { bool flag = false; string q = "select Zone_Name from zone where Zone_Name='" + txtZoneNameAdd.Text + "'"; MySqlCommand c = new MySqlCommand(q, dbConnection); if (c.ExecuteScalar() == null) { int zonId = 0; foreach (DataRowView item in checkedListBoxAreas.CheckedItems) { string areaName = item["Area_Name"].ToString(); if (!flag) { flag = true; string query = "insert into zone (Zone_Name) values (@Zone_Name)"; MySqlCommand com = new MySqlCommand(query, dbConnection); com.Parameters.Add("@Zone_Name", MySqlDbType.VarChar).Value = txtZoneNameAdd.Text; com.ExecuteNonQuery(); q = "select Zone_ID from zone order by Zone_ID desc limit 1"; c = new MySqlCommand(q, dbConnection); zonId = Convert.ToInt16(c.ExecuteScalar().ToString()); /*q = "select Zone_ID from area where Area_ID="+ item["Area_ID"].ToString(); * c = new MySqlCommand(q, dbConnection); * if (c.ExecuteScalar() == null) * {*/ query = "update area set Zone_ID=@Zone_ID where area_ID=" + item["Area_ID"].ToString(); com = new MySqlCommand(query, dbConnection); com.Parameters.Add("@Zone_ID", MySqlDbType.VarChar).Value = zonId; com.ExecuteNonQuery(); /*} * else * {}*/ } else { string query2 = "update area set Zone_ID=@Zone_ID where area_ID=" + item["Area_ID"].ToString(); MySqlCommand com = new MySqlCommand(query2, dbConnection); com.Parameters.Add("@Zone_ID", MySqlDbType.VarChar).Value = zonId; com.ExecuteNonQuery(); } } if (!flag) { string query = "insert into zone (Zone_Name) values (@Zone_Name)"; MySqlCommand com = new MySqlCommand(query, dbConnection); com.Parameters.Add("@Zone_Name", MySqlDbType.VarChar).Value = txtZoneNameAdd.Text; com.ExecuteNonQuery(); } UserControl.ItemRecord("zone", "اضافة", zoneId, DateTime.Now, null, dbConnection); updateLists();//update combox1 displayAllZones(); panelUpdateZone.Visible = false; panelAddZone.Visible = false; MessageBox.Show("تم الاضافة"); } else { MessageBox.Show("هذه الزون تم اضافتها من قبل"); dbConnection.Close(); return; } } else { MessageBox.Show("يجب ادخال الاسم"); dbConnection.Close(); return; } }
private void btnAddProduct_Click(object sender, EventArgs e) { try { if (dataGridView2.Rows.Count > 0) { if (txtSetName.Text != "") { string query = "select Set_Name from sets where Set_Name='" + txtSetName.Text + "'"; MySqlCommand comand = new MySqlCommand(query, dbconnection); dbconnection.Open(); MySqlDataReader dr = comand.ExecuteReader(); while (dr.Read()) { if (dr["Set_Name"].ToString() == txtSetName.Text) { MessageBox.Show("this set already exist"); dr.Close(); dbconnection.Close(); return; } } dr.Close(); if (selectedImage == null) { query = "INSERT INTO sets (Set_Name,Factory_ID,Type_ID,Group_ID) VALUES (@Set_Name,@Factory_ID,@Type_ID,@Group_ID)"; comand = new MySqlCommand(query, dbconnection); comand.Parameters.AddWithValue("@Set_Name", txtSetName.Text); string q = "select Type_ID from type where Type_Name='" + dataGridView2.Rows[0].Cells[3].Value.ToString() + "'"; MySqlCommand com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Type_ID", MySqlDbType.Int16); comand.Parameters["@Type_ID"].Value = com.ExecuteScalar(); q = "select Factory_ID from factory where Factory_Name='" + dataGridView2.Rows[0].Cells[4].Value.ToString() + "'"; com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Factory_ID", MySqlDbType.Int16); comand.Parameters["@Factory_ID"].Value = com.ExecuteScalar(); q = "select Group_ID from groupo where Group_Name='" + dataGridView2.Rows[0].Cells[5].Value.ToString() + "'"; com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Group_ID", MySqlDbType.Int16); comand.Parameters["@Group_ID"].Value = com.ExecuteScalar(); comand.ExecuteNonQuery(); } else { query = "INSERT INTO sets (Set_Name,Factory_ID,Type_ID,Group_ID) VALUES (@Set_Name,@Factory_ID,@Type_ID,@Group_ID)"; comand = new MySqlCommand(query, dbconnection); comand.Parameters.AddWithValue("@Set_Name", txtSetName.Text); string q = "select Type_ID from type where Type_Name='" + dataGridView2.Rows[0].Cells[3].Value.ToString() + "'"; MySqlCommand com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Type_ID", MySqlDbType.Int16); comand.Parameters["@Type_ID"].Value = com.ExecuteScalar(); q = "select Factory_ID from factory where Factory_Name='" + dataGridView2.Rows[0].Cells[4].Value.ToString() + "'"; com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Factory_ID", MySqlDbType.Int16); comand.Parameters["@Factory_ID"].Value = com.ExecuteScalar(); q = "select Group_ID from groupo where Group_Name='" + dataGridView2.Rows[0].Cells[5].Value.ToString() + "'"; com = new MySqlCommand(q, dbconnection); comand.Parameters.Add("@Group_ID", MySqlDbType.Int16); comand.Parameters["@Group_ID"].Value = com.ExecuteScalar(); comand.ExecuteNonQuery(); } query = "select Set_ID from sets order by Set_ID desc limit 1"; comand = new MySqlCommand(query, dbconnection); int set_id = Convert.ToInt16(comand.ExecuteScalar().ToString()); foreach (DataGridViewRow item in dataGridView2.Rows) { query = "INSERT INTO set_Details (Set_ID,Data_ID,Quantity) VALUES (@Set_ID,@Data_ID,@Quantity)"; comand = new MySqlCommand(query, dbconnection); comand.Parameters.AddWithValue("@Set_ID", set_id); comand.Parameters.AddWithValue("@Data_ID", item.Cells[0].Value); comand.Parameters.AddWithValue("@Quantity", double.Parse(item.Cells[2].Value.ToString())); comand.ExecuteNonQuery(); } query = "INSERT INTO set_photo (Set_ID,Photo) VALUES (@Set_ID,@Photo)"; comand = new MySqlCommand(query, dbconnection); comand.Parameters.AddWithValue("@Set_ID", set_id); comand.Parameters.Add("@Photo", MySqlDbType.LongBlob); comand.Parameters["@Photo"].Value = selectedImage; comand.ExecuteNonQuery(); UserControl.ItemRecord("sets", "add", Convert.ToInt16(set_id.ToString()), DateTime.Now, "", dbconnection); MessageBox.Show("Done"); clear(); ataqm.DisplayAtaqm(); } else { MessageBox.Show("Please fill all fields with right format"); } } else { MessageBox.Show("Please insert at least one item"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { try { if (txtQuantity.Text != "" && comStore.Text != "") { double quantity = 0; if (double.TryParse(txtQuantity.Text, out quantity)) { conn.Open(); if (!checkQuantityInStore(quantity)) { MessageBox.Show("لا يوجد كمية كافية من العنصر فى المخزن"); conn.Close(); return; } cartons = 0; if (selRow["الكود"].ToString().Length >= 20) { string q = "select Carton from data where Code='" + selRow["الكود"].ToString() + "'"; MySqlCommand c = new MySqlCommand(q, conn); if (c.ExecuteScalar() != null) { if (Convert.ToDouble(c.ExecuteScalar().ToString()) > 0) { if (cartonNumCheck()) { } else { conn.Close(); return; } } } } Form prompt = new Form() { Width = 500, Height = 220, FormBorderStyle = FormBorderStyle.FixedDialog, Text = "", StartPosition = FormStartPosition.CenterScreen, MaximizeBox = false, MinimizeBox = false }; Label textLabel = new Label() { Left = 340, Top = 20, Text = "ما هو سبب التعديل؟" }; TextBox textBox = new TextBox() { Left = 50, Top = 50, Width = 385, Multiline = true, Height = 80, RightToLeft = RightToLeft }; Button confirmation = new Button() { Text = "تأكيد", Left = 200, Width = 100, Top = 140, DialogResult = DialogResult.OK }; prompt.Controls.Add(textBox); prompt.Controls.Add(confirmation); prompt.Controls.Add(textLabel); prompt.AcceptButton = confirmation; if (prompt.ShowDialog() == DialogResult.OK) { if (textBox.Text != "") { /*string query = "select sum(storage.Total_Meters) from storage where storage.Code='" + selRow["الكود"].ToString() + "' group by storage.Code"; * MySqlCommand comand = new MySqlCommand(query, conn); * double TotalMeters = Convert.ToDouble(comand.ExecuteScalar());*/ //quantity <= TotalMeters string query = "update dash_details set Quantity=" + quantity + ",Cartons=" + cartons + ", Store_ID=" + comStore.SelectedValue.ToString() + " , Store_Name='" + comStore.Text + "' where DashDetails_ID=" + Convert.ToInt16(selRow[0].ToString()); MySqlCommand comand = new MySqlCommand(query, conn); comand.ExecuteNonQuery(); UserControl.ItemRecord("dash_details", "تعديل", Convert.ToInt16(selRow[0].ToString()), DateTime.Now, textBox.Text, conn); conn.Close(); MainForm.ProductsDetailsReport.loadFunc(); this.Close(); } else { MessageBox.Show("يجب كتابة السبب"); } } } else { MessageBox.Show("الكمية يجب ان تكون عدد"); } } else { MessageBox.Show("يجب ادخال البيانات كاملة"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }
private void btnAdd_Click(object sender, EventArgs e) { try { dbconnection.Open(); if (!chBoxSpecialIncrease.Checked) { double price = double.Parse(txtPrice.Text); double SellPercent = double.Parse(txtSell.Text); if (radioQata3y.Checked == true) { #region set qata3yPrice for list item double NormalPercent = double.Parse(txtNormal.Text); double UnNormalPercent = double.Parse(txtUnNormal.Text); DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { String query = "update sellprice set Sell_Discount=@Sell_Discount,Normal_Increase=@Normal_Increase,Categorical_Increase=@Categorical_Increase,Price_Type=@Price_Type,Sell_Price=@Sell_Price,ProfitRatio=@ProfitRatio,Price=@Price,PercentageDelegate=@PercentageDelegate where SellPrice_ID=" + dataTable.Rows[i][0].ToString(); MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "قطعى"); command.Parameters.AddWithValue("@Sell_Price", price + (price * SellPercent / 100.0)); command.Parameters.AddWithValue("@ProfitRatio", SellPercent); command.Parameters.AddWithValue("@Sell_Discount", 0.00); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Normal_Increase", 0.00); command.Parameters.AddWithValue("@Categorical_Increase", 0.00); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.ExecuteNonQuery(); } #endregion } else { #region set priceList for collection of items double NormalPercent = double.Parse(txtNormal.Text); double unNormalPercent = double.Parse(txtUnNormal.Text); double sellPrice = (price + NormalPercent) - ((price + NormalPercent) * SellPercent / 100.0); sellPrice = sellPrice + unNormalPercent; DataTable dataTable = (DataTable)gridControl1.DataSource; for (int i = 0; i < dataTable.Rows.Count; i++) { string query = "update sellprice set ProfitRatio=@ProfitRatio, Price_Type=@Price_Type,Sell_Price=@Sell_Price,Sell_Discount=@Sell_Discount,Price=@Price,Normal_Increase=@Normal_Increase,Categorical_Increase=@Categorical_Increase,PercentageDelegate=@PercentageDelegate where SellPrice_ID =" + dataTable.Rows[i][0].ToString(); MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Price_Type", "لستة"); command.Parameters.AddWithValue("@Sell_Price", sellPrice); command.Parameters.AddWithValue("@ProfitRatio", 0.00); command.Parameters.AddWithValue("@Sell_Discount", double.Parse(txtSell.Text)); command.Parameters.AddWithValue("@Price", price); command.Parameters.AddWithValue("@Normal_Increase", double.Parse(txtNormal.Text)); command.Parameters.AddWithValue("@Categorical_Increase", double.Parse(txtUnNormal.Text)); command.Parameters.AddWithValue("@PercentageDelegate", double.Parse(txtPercentageDelegate.Text)); command.ExecuteNonQuery(); } #endregion } int sellPrice_ID = 0; string queryx = "select SellPrice_ID from sellprice order by SellPrice_ID desc limit 1"; MySqlCommand com = new MySqlCommand(queryx, dbconnection); if (com.ExecuteScalar() != null) { sellPrice_ID = Convert.ToInt16(com.ExecuteScalar()); } queryx = "delete from additional_increase_sellprice where SellPrice_ID=" + sellPrice_ID; com = new MySqlCommand(queryx, dbconnection); com.ExecuteNonQuery(); foreach (DataGridViewRow item in dataGridView1.Rows) { double addational = Convert.ToDouble(item.Cells[0].Value); queryx = "insert into additional_increase_sellprice (SellPrice_ID,AdditionalValue,Type,Description) values (@SellPrice_ID,@AdditionalValue,@Type,@Description)"; com = new MySqlCommand(queryx, dbconnection); com.Parameters.AddWithValue("@SellPrice_ID", sellPrice_ID); com.Parameters.AddWithValue("@Type", item.Cells[1].Value); com.Parameters.AddWithValue("@AdditionalValue", item.Cells[0].Value); com.Parameters.AddWithValue("@Description", item.Cells[2].Value); com.ExecuteNonQuery(); } UserControl.ItemRecord("sellprice", "تعديل", sellPrice_ID, DateTime.Now, "", dbconnection); } else { double addationalValue = 0.0; DataGridView DataGridView = (DataGridView)panContent.Controls["panContent"].Controls["dataGridView1"]; foreach (DataGridViewRow item1 in DataGridView.Rows) { addationalValue += Convert.ToDouble(item1.Cells[0].Value); } int[] rows = (((GridView)gridControl1.MainView).GetSelectedRows()); List <DataRowView> recordList = new List <DataRowView>(); for (int i = 0; i < rows.Length; i++) { DataRowView a = (DataRowView)(((GridView)gridControl1.MainView).GetRow(rows[i])); recordList.Add(a); } foreach (DataRowView item in recordList) { String query = "update sellprice set Sell_Price=@Sell_Price where SellPrice_ID=" + item[0].ToString(); MySqlCommand command = new MySqlCommand(query, dbconnection); command.Parameters.AddWithValue("@Sell_Price", Convert.ToDouble(item["سعر البيع"]) + addationalValue); command.ExecuteNonQuery(); foreach (DataGridViewRow item1 in DataGridView.Rows) { double addational = Convert.ToDouble(item1.Cells[0].Value); string queryx = "insert into special_increase (SellPrice_ID,Value,Description,Date) values (@SellPrice_ID,@Value,@Description,@Date)"; MySqlCommand com = new MySqlCommand(queryx, dbconnection); com.Parameters.AddWithValue("@SellPrice_ID", item[0]); com.Parameters.AddWithValue("@Value", item1.Cells[0].Value); com.Parameters.AddWithValue("@Description", item1.Cells[1].Value); com.Parameters.Add("@Date", MySqlDbType.Date); com.Parameters["@Date"].Value = DateTime.Now.Date; com.ExecuteNonQuery(); } } } displayData(); productsSellPriceForm.displayProducts(); XtraTabPage xtraTabPage = getTabPage("تعديل اسعار البنود"); xtraTabPage.ImageOptions.Image = null; } catch (Exception ex) { MessageBox.Show(ex.Message); } dbconnection.Close(); }
private void btnAddProduct_Click(object sender, EventArgs e) { try { if (txtFactory.Text != "" && txtGroup.Text != "" && txtProduct.Text != "" && txtType.Text != "") { int color_id = 0; int size_id = 0; int sort_id = 0; double carton = 0; string classification, description = ""; if (comColour.Text != "") { color_id = Convert.ToInt16(txtColor.Text); } if (comSize.Text != "") { size_id = Convert.ToInt16(txtSize.Text); } if (comSort.Text != "") { sort_id = Convert.ToInt16(txtSort.Text); } if (txtCarton.Text != "") { if (double.TryParse(txtCarton.Text, out carton)) { } else { MessageBox.Show("carton must be numeric"); return; } } classification = txtClassification.Text; description = txtDescription.Text; string q = "SELECT Data_ID from data where Color_ID=" + color_id + " and Size_ID=" + size_id + " and Sort_ID=" + sort_id + " and Description='" + description + "' and Carton=" + carton + " and Type_ID=" + txtType.Text + " and Factory_ID=" + txtFactory.Text + " and Group_ID=" + txtGroup.Text + " and Product_ID=" + txtProduct.Text + " and Classification='" + classification + "'"; MySqlCommand comand = new MySqlCommand(q, conn); conn.Open(); var resultValue = comand.ExecuteReader(); if (!resultValue.HasRows) { conn.Close(); MySqlCommand command = conn.CreateCommand(); string code = txtType.Text; int typecount = txtType.Text.Length; int factorycount = txtFactory.Text.Length; int groupcount = txtGroup.Text.Length; int productcount = txtProduct.Text.Length; while (typecount < 4) { code = "0" + code; typecount++; } string code2 = txtFactory.Text; while (factorycount < 4) { code2 = "0" + code2; factorycount++; } code = code + code2; string code3 = txtGroup.Text; while (groupcount < 4) { code3 = "0" + code3; groupcount++; } code = code + code3; string code4 = txtProduct.Text; while (productcount < 4) { code4 = "0" + code4; productcount++; } code = code + code4; string query2 = "SELECT count(Code) FROM data where Type_ID=" + txtType.Text + " and Factory_ID=" + txtFactory.Text + " and Group_ID=" + txtGroup.Text + " and Product_ID=" + txtProduct.Text; conn.Open(); MySqlCommand adpt = new MySqlCommand(query2, conn); int result = Convert.ToInt16(adpt.ExecuteScalar().ToString()); result = result + 1; conn.Close(); int resultcount = result.ToString().Length; string code5 = result.ToString(); while (resultcount < 4) { code5 = "0" + code5; resultcount++; } code = code + code5; command.CommandText = "INSERT INTO data (Color_ID,Size_ID,Sort_ID,Description,Carton,Code,Type_ID,Factory_ID,Group_ID,Product_ID,Classification,Data_Date) VALUES (?Color_ID,?Size_ID,?Sort_ID,?Description,?Carton,?Code,?Type_ID,?Factory_ID,?Group_ID,?Product_ID,?Classification,?Data_Date)"; command.Parameters.AddWithValue("?Color_ID", color_id); command.Parameters.AddWithValue("?Size_ID", size_id); command.Parameters.AddWithValue("?Sort_ID", sort_id); command.Parameters.AddWithValue("?Description", description); command.Parameters.AddWithValue("?Carton", carton); command.Parameters.AddWithValue("?Code", code); command.Parameters.AddWithValue("?Type_ID", int.Parse(txtType.Text)); command.Parameters.AddWithValue("?Factory_ID", int.Parse(txtFactory.Text)); command.Parameters.AddWithValue("?Group_ID", int.Parse(txtGroup.Text)); command.Parameters.AddWithValue("?Product_ID", int.Parse(txtProduct.Text)); command.Parameters.AddWithValue("?Classification", classification); command.Parameters.AddWithValue("?Data_Date", DateTime.Now.Date); conn.Open(); command.ExecuteNonQuery(); query2 = "select Data_ID from data order by Data_ID desc limit 1"; comand = new MySqlCommand(query2, conn); int data_ID = Convert.ToInt16(comand.ExecuteScalar()); //save image as bytes command = conn.CreateCommand(); if (selectedImage != null) { command.CommandText = "INSERT INTO data_photo (Data_ID,Photo,Type) VALUES (?Data_ID,?Photo,?Type)"; command.Parameters.AddWithValue("?Data_ID", data_ID); command.Parameters.AddWithValue("?Photo", selectedImage); command.Parameters.AddWithValue("?Type", "بند"); command.ExecuteNonQuery(); } products.displayProducts(); UserControl.ItemRecord("data", "اضافة", data_ID, DateTime.Now, "", conn); clear(); comType.Focus(); } else { MessageBox.Show("This item already exist"); } } else { MessageBox.Show("you should fill all fields"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } conn.Close(); }