private void btnAdd_Click(object sender, RoutedEventArgs e) { if (lstCurrency.SelectedIndex == -1) { glb_function.MsgBox("الرجاء اختيار العملة"); lstCurrency.Focus(); return; } if (lstAccNo.SelectedIndex == -1) { glb_function.MsgBox("الرجاء تحديد الحساب"); lstAccNo.Focus(); return; } if (lstAccName.SelectedIndex == -1) { glb_function.MsgBox("الرجاء تحديد الحساب"); lstAccName.Focus(); return; } if (nmbCurrValue.Value <= 0) { glb_function.MsgBox("الرجاء ادخال المبلغ"); return; } if (txtCreditTotal.Text.Trim() == "") { txtCreditTotal.Text = "0"; } if (txtDeptTotal.Text.Trim() == "") { txtDeptTotal.Text = "0"; } clsJourDetail newRow = new clsJourDetail(); newRow.clmPKid = ""; newRow.clmDept = nmbDept.Value.ToString(); newRow.clmCredit = nmbCredit.Value.ToString(); newRow.clmCurrValue = nmbCurrValue.Value.ToString(); newRow.clmCurrencyId = lstCurrency.SelectedValue.ToString(); newRow.clmCurrencyName = lstCurrency.Text; newRow.clmAccId = lstAccName.SelectedValue.ToString(); newRow.clmAccNo = lstAccNo.Text; newRow.clmAccName = lstAccName.Text; newRow.clmJourNote = txtJourDetail.Text.Trim(); newRow.clmExchangeRate = nmbExchangeRate.Value.ToString(); dgvJourDetails.Items.Add(newRow); txtCreditTotal.Text = (Convert.ToDouble(txtCreditTotal.Text.Trim()) + Convert.ToDouble(newRow.clmCredit)).ToString(); txtDeptTotal.Text = (Convert.ToDouble(txtDeptTotal.Text.Trim()) + Convert.ToDouble(newRow.clmDept)).ToString(); if (txtCreditTotal.Text.Trim() == txtDeptTotal.Text.Trim()) { txtDeptTotal.Background = Brushes.LawnGreen; txtCreditTotal.Background = Brushes.LawnGreen; } else { txtDeptTotal.Background = Brushes.Red; txtCreditTotal.Background = Brushes.Red; } ClearDetail(); }
private void GetData(string strPkid) { new glb_function().clearItems(this); ConnectionToMySQL cnn = new ConnectionToMySQL(); DataTable dtJournalData = cnn.GetDataTable("SELECT h.Pkid, h.stat, Branch_id, jour_no, trans_name, trans_id, date_format(jour_date,'%d/%m/%Y') jour_date, jour_note,Person, " + " d.pkid dpkid, d.stat dstat, curr_id,(select c.curr_name from sales.currency c where c.pkid=d.curr_id) curr_name, acc_id, main_value, jour_value, exchange_Rate, jour_details, " + " a.acc_no, a.acc_name " + " FROM journal_header h " + " join journal_details d " + " join accounts a on(a.pkid = d.acc_id) " + " on(h.pkid = d.header_id) " + " where h.pkid = " + strPkid + " order by d.pkid"); bLoad = true; txtPkid.Text = strPkid; txtJourNo.Text = dtJournalData.Rows[0]["jour_no"].ToString(); dtpJourDate.SelectedDate = DateTime.ParseExact(dtJournalData.Rows[0]["jour_date"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture); txtHeaderNote.Text = dtJournalData.Rows[0]["jour_note"].ToString(); txtCreditTotal.Text = "0"; txtDeptTotal.Text = "0"; for (int i = 0; i < dtJournalData.Rows.Count; i++) { clsJourDetail newRow = new clsJourDetail(); if (Convert.ToDouble(dtJournalData.Rows[i]["main_value"].ToString()) > 0) { newRow.clmDept = dtJournalData.Rows[i]["main_value"].ToString(); newRow.clmCurrValue = dtJournalData.Rows[i]["jour_value"].ToString(); newRow.clmCredit = "0"; } else { newRow.clmCredit = (Convert.ToDouble(dtJournalData.Rows[i]["main_value"].ToString()) * -1).ToString(); newRow.clmCurrValue = (Convert.ToDouble(dtJournalData.Rows[i]["jour_value"].ToString()) * -1).ToString(); newRow.clmDept = "0"; } newRow.clmPKid = dtJournalData.Rows[i]["dpkid"].ToString(); newRow.clmCurrencyId = dtJournalData.Rows[i]["curr_id"].ToString(); newRow.clmCurrencyName = dtJournalData.Rows[i]["curr_name"].ToString(); newRow.clmAccId = dtJournalData.Rows[i]["acc_id"].ToString(); newRow.clmAccNo = dtJournalData.Rows[i]["acc_no"].ToString(); newRow.clmAccName = dtJournalData.Rows[i]["acc_name"].ToString(); newRow.clmJourNote = dtJournalData.Rows[i]["jour_details"].ToString(); newRow.clmExchangeRate = dtJournalData.Rows[i]["exchange_Rate"].ToString(); dgvJourDetails.Items.Add(newRow); txtCreditTotal.Text = (Convert.ToDouble(txtCreditTotal.Text.Trim()) + Convert.ToDouble(newRow.clmCredit)).ToString(); txtDeptTotal.Text = (Convert.ToDouble(txtDeptTotal.Text.Trim()) + Convert.ToDouble(newRow.clmDept)).ToString(); } if (txtCreditTotal.Text.Trim() == txtDeptTotal.Text.Trim()) { txtDeptTotal.Background = Brushes.LawnGreen; txtCreditTotal.Background = Brushes.LawnGreen; } else { txtDeptTotal.Background = Brushes.Red; txtCreditTotal.Background = Brushes.Red; } if (UserTemplate.HasPrivilege("btnUpdate")) { btnUpdate.IsEnabled = true; } btnSave.IsEnabled = false; bLoad = false; }