private void تعديلالفاتورةToolStripMenuItem_Click(object sender, EventArgs e) { ContractSales conFrm = new ContractSales(); BL.ProfitsClass pr = new BL.ProfitsClass(); DataTable d = new DataTable(); d = con.GetDetailsByOrderID(Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value.ToString())); conFrm.ConID.Text = this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); conFrm.Con_date.Value = (DateTime)this.dataGridView1.CurrentRow.Cells[1].Value; conFrm.Con_user.Text = this.dataGridView1.CurrentRow.Cells[5].Value.ToString(); conFrm.ConNote.Text = this.dataGridView1.CurrentRow.Cells[4].Value.ToString(); conFrm.custId.Text = this.dataGridView1.CurrentRow.Cells[2].Value.ToString(); conFrm.Total.Text = this.dataGridView1.CurrentRow.Cells[6].Value.ToString(); if (this.dataGridView1.CurrentRow.Cells[7].Value.ToString() != string.Empty) { conFrm.debit.Text = this.dataGridView1.CurrentRow.Cells[7].Value.ToString(); conFrm.paid.Text = Convert.ToString(Convert.ToDouble(this.dataGridView1.CurrentRow.Cells[6].Value.ToString()) - Convert.ToDouble(this.dataGridView1.CurrentRow.Cells[7].Value.ToString())); } conFrm.PricePrev = Convert.ToDouble(pr.GetProfitPeforeUpdating(Convert.ToInt32(this.dataGridView1.CurrentRow.Cells[0].Value.ToString())).Rows[0][0].ToString()); conFrm.dataGridView1.DataSource = d; conFrm.Text = " :تحديث بيانات الفاتورة المحددة " + this.dataGridView1.CurrentRow.Cells[0].Value.ToString(); conFrm.SaveSale.Text = "تحديث"; conFrm.ConState = "edit"; conFrm.newSale.Enabled = false; conFrm.Print.Enabled = false; conFrm.choosebtn.Enabled = false; conFrm.CustChoosBtn.Enabled = false; conFrm.SetDatatableForUpdate(d); conFrm.SaveSale.Enabled = true; // conFrm.paid.ReadOnly = true; conFrm.حذفالسطرالحاليToolStripMenuItem.Enabled = false; conFrm.حذفالكلToolStripMenuItem.Enabled = false; conFrm.ShowDialog(); if (conFrm.closed) { this.dataGridView1.DataSource = con.SearchOrders(textSearch.Text); this.dataGridView1.Columns[2].Visible = false; } }
private void SaveSale_Click(object sender, EventArgs e) { if (ConID.Text == string.Empty) { MessageBox.Show(" رقم الفاتورة غير موجود ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); newSale.Focus(); return; } if (ConNote.Text == string.Empty) { MessageBox.Show(" ادخل وصف للفاتورة ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); ConNote.Focus(); return; } if (custId.Text == string.Empty) { MessageBox.Show(" رقم الزبون غير موجود ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); CustChoosBtn.Focus(); return; } if (dataGridView1.Rows.Count <= 1) { MessageBox.Show(" لايوجد بيانات مدخلة لبيعها ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); choosebtn.Focus(); return; } if (Total.Text == string.Empty || Total.Text == "0") { MessageBox.Show(" تحقق من البيانات! لايوجد مجموع! ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); choosebtn.Focus(); return; } if (Convert.ToDouble(Total.Text) < 0) { MessageBox.Show("لايمكن أن يكون المجموع سالباً ", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning); choosebtn.Focus(); return; } if (Convert.ToDouble(paid.Text) > Convert.ToDouble(Total.Text)) { MessageBox.Show("لايمكن ان يكون النقد أكبر من المجموع ", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); paid.Focus(); paid.SelectionStart = 0; paid.SelectionLength = paid.Text.Length; } if (Convert.ToDouble(debit.Text) > Convert.ToDouble(Total.Text)) { MessageBox.Show("لايمكن ان يكون الآجل أكبر من المجموع ", "", MessageBoxButtons.OK, MessageBoxIcon.Warning); paid.Focus(); paid.SelectionStart = 0; paid.SelectionLength = paid.Text.Length; } /////////// add Contract if (ConState == "add") { if (MessageBox.Show("? هل تريد الحفظ", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) { if (id.Text == string.Empty && label.Text == string.Empty) { try { // VAlue gives a type Date //aDD_oRDER con.Add_Order(Convert.ToInt32(ConID.Text), ConNote.Text, Con_date.Value, Con_user.Text, Convert.ToInt32(custId.Text), Convert.ToDouble(Total.Text), Convert.ToDouble(debit.Text)); // ADD ORDER dETAILS for (int i = 0; i < this.dataGridView1.Rows.Count - 1; i++) { con.OrderDetails(this.dataGridView1.Rows[i].Cells[0].Value.ToString() , Convert.ToInt32(ConID.Text), Convert.ToInt32(this.dataGridView1.Rows[i].Cells[3].Value.ToString()), this.dataGridView1.Rows[i].Cells[2].Value.ToString() , Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString()), this.dataGridView1.Rows[i].Cells[4].Value.ToString() , this.dataGridView1.Rows[i].Cells[6].Value.ToString()); /// Add To Log con.OrderDetailsLog(Con_date.Value, Convert.ToInt32(ConID.Text), this.dataGridView1.Rows[i].Cells[0].Value.ToString() , Convert.ToInt32(this.dataGridView1.Rows[i].Cells[3].Value.ToString()), this.dataGridView1.Rows[i].Cells[2].Value.ToString() , Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString()), this.dataGridView1.Rows[i].Cells[4].Value.ToString() , this.dataGridView1.Rows[i].Cells[6].Value.ToString(), "الأصل"); } /// Add Profits To Profit BL.ProfitsClass pro = new BL.ProfitsClass(); int profId = Convert.ToInt32(pro.GetLastProfitsId().Rows[0][0].ToString()); pro.AddProfit(profId, this.Con_date.Value, Convert.ToDouble(paid.Text), Convert.ToInt32(custId.Text), Convert.ToInt32(ConID.Text), ConNote.Text); //add DEbit BL.DebitsClass deb = new BL.DebitsClass(); int debId = Convert.ToInt32(deb.GetLastDebitId().Rows[0][0].ToString()); deb.AddDebit(debId, this.Con_date.Value, Convert.ToDouble(debit.Text), Convert.ToInt32(custId.Text), Convert.ToInt32(ConID.Text), ConNote.Text); MessageBox.Show("تمت العملية بنجاح", "", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearData(); } catch (Exception ex) { MessageBox.Show(ex.ToString() + " أخفقت العملية ", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show(" عذراُ لايمكنك الحفظ .. هناك بيانات لم يتم حفظها ", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } } //// update else { if (MessageBox.Show("? هل تريد التعديل", "", MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) { try { if (id.Text == string.Empty && label.Text == string.Empty) { // VAlue gives a type Date //update_oRDER con.Update_Order(Convert.ToInt32(ConID.Text), Con_date.Value, ConNote.Text, Convert.ToInt32(custId.Text), Convert.ToDouble(Total.Text), Convert.ToDouble(debit.Text)); // update ORDER dETAILS for (int i = 0; i < this.dataGridView1.Rows.Count - 1; i++) { int QtyAfterUpdates = updateQty - Convert.ToInt32(this.dataGridView1.Rows[i].Cells[3].Value.ToString()); con.UpdateOrderDetails(this.dataGridView1.Rows[i].Cells[0].Value.ToString() , Convert.ToInt32(ConID.Text), Convert.ToInt32(this.dataGridView1.Rows[i].Cells[3].Value.ToString()), this.dataGridView1.Rows[i].Cells[2].Value.ToString() , Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString()), this.dataGridView1.Rows[i].Cells[4].Value.ToString() , this.dataGridView1.Rows[i].Cells[6].Value.ToString(), QtyAfterUpdates); /// Add To Log con.OrderDetailsLog(DateTime.Now, Convert.ToInt32(ConID.Text), this.dataGridView1.Rows[i].Cells[0].Value.ToString() , Convert.ToInt32(this.dataGridView1.Rows[i].Cells[3].Value.ToString()), this.dataGridView1.Rows[i].Cells[2].Value.ToString() , Convert.ToDouble(this.dataGridView1.Rows[i].Cells[5].Value.ToString()), this.dataGridView1.Rows[i].Cells[4].Value.ToString() , this.dataGridView1.Rows[i].Cells[6].Value.ToString(), "معدل"); } /// update Profits To Profit BL.ProfitsClass pro = new BL.ProfitsClass(); // double PrevPrice = Convert.ToDouble(pro.GetProfitPeforeUpdating(Convert.ToInt32(ConID.Text)).Rows[0][0].ToString()); pro.UpdateProfit(this.Con_date.Value, Convert.ToDouble(paid.Text), Convert.ToInt32(ConID.Text), ConNote.Text); //update DEbit BL.DebitsClass deb = new BL.DebitsClass(); int debId = Convert.ToInt32(deb.GetLastDebitId().Rows[0][0].ToString()); deb.UpdateDepit(this.Con_date.Value, Convert.ToDouble(debit.Text), Convert.ToInt32(custId.Text), Convert.ToInt32(ConID.Text), ConNote.Text, PricePrev); MessageBox.Show("تمت العملية بنجاح", "", MessageBoxButtons.OK, MessageBoxIcon.Information); ClearData(); } else { MessageBox.Show(" عذراُ لايمكنك الحفظ .. هناك بيانات لم يتم حفظها ", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.ToString() + " أخفقت العملية ", "", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { return; } } }