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);
}
}
