private void addLetter() { try { int bankId = Convert.ToInt32(cbBank.SelectedValue); if (!fEditMode) { letter_of_credits _validation = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Reference == txtReference.Text && x.BankId == bankId && x.FundId == manager.Selected); if (_validation != null) { MessageBox.Show("Duplicated reference."); return; } letter_of_credits _letter = new letter_of_credits(); _letter.Reference = txtReference.Text; _letter.BankId = bankId; _letter.FundId = manager.Selected; _letter.Amount = Math.Round(decimal.Parse(txtAmount.Text), 2); manager.My_db.letter_of_credits.Add(_letter); manager.My_db.SaveChanges(); } else { int _id = int.Parse(listBox1.SelectedValue.ToString()); letter_of_credits _validation = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Id != _id && x.Reference == txtReference.Text && x.BankId == bankId && x.FundId == manager.Selected); if (_validation != null) { MessageBox.Show("Duplicated reference."); return; } letter_of_credits _selected = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Id == _id); if (_selected != null) { _selected.Reference = txtReference.Text; _selected.Amount = Math.Round(decimal.Parse(txtAmount.Text), 2); _selected.BankId = Convert.ToInt32(cbBank.SelectedValue); manager.My_db.SaveChanges(); } } loadLettersData(); cmdCancel_Click(null, null); } catch (Exception _ex) { ErrorMessage.showErrorMessage(_ex); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { try { int shipmentId = 0; if (listBox1.SelectedValue != null && int.TryParse(listBox1.SelectedValue.ToString(), out shipmentId)) { Shipment _selected = manager.My_db.Shipments.FirstOrDefault(x => x.Id == shipmentId); if (_selected != null) { fEditMode = true; cmdAdd.Text = "Save"; txtNumber.Text = _selected.Number; txtValue.Text = String.Format("{0:n}", _selected.Value); letter_of_credits letter = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Id == _selected.LetterOfCreditId); foreach (DataRowView _item in cbLetter.Items) { if (_item.Row[0].ToString() == letter.Id.ToString()) { cbLetter.SelectedItem = _item; break; } } cmdCancel.Visible = true; } } } catch (Exception _ex) { MessageBox.Show("Error: " + _ex.Message); } }
private void listBox1_SelectedIndexChanged(object sender, EventArgs e) { try { int letterId = 0; if (listBox1.SelectedValue != null && int.TryParse(listBox1.SelectedValue.ToString(), out letterId)) { letter_of_credits _selected = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Id == letterId); if (_selected != null) { fEditMode = true; cmdAdd.Text = "Save"; txtReference.Text = _selected.Reference; txtAmount.Text = String.Format("{0:n}", _selected.Amount); Bank bank = manager.My_db.Banks.FirstOrDefault(x => x.Id == _selected.BankId); foreach (DataRowView _item in cbBank.Items) { if (_item.Row[0].ToString() == bank.Id.ToString()) { cbBank.SelectedItem = _item; break; } } cmdCancel.Visible = true; } } } catch (Exception _ex) { MessageBox.Show("Error: " + _ex.Message); } }
private void lvDisbursements_SelectedIndexChanged(object sender, EventArgs e) { try { if (lvDisbursements.SelectedIndices.Count > 0) { if (lvDisbursements.SelectedIndices[0] == lvDisbursements.Items.Count - 1) { lvDisbursements.SelectedIndices.Clear(); } else { Disbursement selected = disbursements[lvDisbursements.SelectedIndices[0]]; if (selected.pay_date.HasValue) { lvDisbursements.SelectedIndices.Clear(); MessageBox.Show("This disbursement has been already paid."); } } } if (lvDisbursements.SelectedIndices.Count > 0) { fEditMode = true; cmdDeleteDisbursement.Enabled = true; cmdAddDisbursement.Enabled = true; cmdAddDisbursement.Text = "Save Disbursement"; cmdCancel.Visible = true; Disbursement selected = disbursements[lvDisbursements.SelectedIndices[0]]; txtAmount.Text = String.Format("{0:0.00}", selected.amount * (decimal)selected.exchange_rate); if (selected.currency_id > 0) { for (int i = 0; i < cbCurrency.Items.Count; i++) { cbCurrency.SelectedIndex = i; if (cbCurrency.SelectedValue.ToString() == selected.currency_id.ToString()) { break; } } } txtExchangeRate.Text = String.Format("{0:0.0000000}", selected.exchange_rate); txtProfitShare.Text = String.Format("{0:0.00}", selected.profit_share); txtNumber.Text = selected.number; txtTotalToBeCollected.Text = String.Format("{0:0.00}", selected.Euro_collection); if (selected.client_id > 0) { for (int i = 0; i < cbClient.Items.Count; i++) { cbClient.SelectedIndex = i; if (cbClient.SelectedValue.ToString() == selected.client_id.ToString()) { break; } } } if (selected.underlying_debtor_id > 0) { for (int i = 0; i < cbUnderlyingDebtor.Items.Count; i++) { cbUnderlyingDebtor.SelectedIndex = i; if (cbUnderlyingDebtor.SelectedValue.ToString() == selected.underlying_debtor_id.ToString()) { break; } } } if (selected.bank_risk_id > 0) { for (int i = 0; i < cbBank.Items.Count; i++) { cbBank.SelectedIndex = i; if (cbBank.SelectedValue.ToString() == selected.bank_risk_id.ToString()) { break; } } } if (selected.shipment_id > 0) { Shipment shipment = manager.My_db.Shipments.FirstOrDefault(x => x.Id == selected.shipment_id); if (shipment != null) { letter_of_credits letter = manager.My_db.letter_of_credits.FirstOrDefault(x => x.Id == shipment.LetterOfCreditId); if (letter != null) { this.letter_of_creditsTableAdapter.FillByBank(this.fundsDBDataSet.letter_of_credits, manager.Selected, int.Parse(cbBank.SelectedValue.ToString())); for (int i = 0; i < cbLetterOfCredit.Items.Count; i++) { cbLetterOfCredit.SelectedIndex = i; if (cbLetterOfCredit.SelectedValue.ToString() == letter.Id.ToString()) { this.shipmentsTableAdapter.FillByLetterWithEmpty(this.fundsDBDataSet.Shipments, int.Parse(cbLetterOfCredit.SelectedValue.ToString())); for (int j = 0; j < cbShipment.Items.Count; j++) { cbShipment.SelectedIndex = j; if (cbShipment.SelectedValue.ToString() == shipment.Id.ToString()) { break; } } break; } } } } } if (selected.sector_id > 0) { for (int i = 0; i < cbSector.Items.Count; i++) { cbSector.SelectedIndex = i; if (cbSector.SelectedValue.ToString() == selected.sector_id.ToString()) { break; } } } fItemIds.Clear(); lbISelectedItems.Items.Clear(); lbISelectedItems.Text = ""; foreach (int itemId in selected.ItemsIds) { fItemIds.Add(itemId); for (int i = 0; i < cbItems.Items.Count; i++) { cbItems.SelectedIndex = i; if (cbItems.SelectedValue.ToString() == itemId.ToString()) { string name = ((FundsManager.FundsDBDataSet.ItemsRow)((System.Data.DataRowView)cbItems.Items[i]).Row).name; lbISelectedItems.Items.Add(name); } } } dtpCollectionDate.Value = selected.collection_date; dtpDisbursementDate.Value = selected.date; } else { fEditMode = false; cmdDeleteDisbursement.Enabled = false; cmdAddDisbursement.Text = "Add Disbursement"; cmdCancel.Visible = false; } } catch (Exception _ex) { Console.WriteLine("Error in InvestmentsForm.lvDisbursements_SelectedIndexChanged: " + _ex.Message); } }