// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid financialCurrencyId)
{
var service = new CrudeFinancialCurrencyServiceClient();
_isNew = false;
try {
_contract = service.FetchByFinancialCurrencyId(financialCurrencyId);
financialCurrencyTypeRefCombo.Text = _contract.FinancialCurrencyTypeRcd != null ? _contract.FinancialCurrencyTypeRcd : String.Empty;
textBoxFinancialCurrencyTypeCode.Text = _contract.FinancialCurrencyTypeCode;
textBoxFinancialCurrencyTypeName.Text = _contract.FinancialCurrencyTypeName;
financialCurrencyAgainstFinancialCurrencyTypeRefCombo.Text = _contract.FinancialCurrencyAgainstFinancialCurrencyTypeRcd != null ? _contract.FinancialCurrencyAgainstFinancialCurrencyTypeRcd : String.Empty;
dateTimePickerValidFromDateTime.Value = _contract.ValidFromDateTime != DateTime.MinValue ? _contract.ValidFromDateTime : dateTimePickerValidFromDateTime.MinDate;
dateTimePickerValidFromDateTime.Checked = _contract.ValidFromDateTime != DateTime.MinValue;
dateTimePickerValidUntilDateTime.Value = _contract.ValidUntilDateTime != DateTime.MinValue ? _contract.ValidUntilDateTime : dateTimePickerValidUntilDateTime.MinDate;
dateTimePickerValidUntilDateTime.Checked = _contract.ValidUntilDateTime != DateTime.MinValue;
maskedTextBoxAmount.Text = _contract.Amount.ToString();
maskedTextBoxEqualsAmount.Text = _contract.EqualsAmount.ToString();
maskedTextBoxDecimalCount.Text = _contract.DecimalCount.ToString();
userPicker.SelectedValue = _contract.UserId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
service.Close();
}
}
// populates the Picker with the first match from the SOAP service
// links:
// docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534
private void txtFinancialCurrencyCode_Validating(object sender, CancelEventArgs e)
{
if (!DesignMode)
{
// empty picker on no code
if (string.IsNullOrEmpty(txtFinancialCurrencyCode.Text))
{
_financialCurrencyId = Guid.Empty;
txtFinancialCurrencyName.Text = string.Empty;
txtFinancialCurrencyCode.Text = string.Empty;
return;
}
CrudeFinancialCurrencyServiceClient financialCurrency = null;
try {
financialCurrency = new CrudeFinancialCurrencyServiceClient();
CrudeFinancialCurrencyContract contract = financialCurrency.FetchByFinancialCurrencyTypeCode(txtFinancialCurrencyCode.Text);
if (contract != null)
{
txtFinancialCurrencyCode.Text = contract.FinancialCurrencyTypeCode;
txtFinancialCurrencyName.Text = contract.FinancialCurrencyTypeName;
_financialCurrencyId = contract.FinancialCurrencyId;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
if (financialCurrency != null)
{
financialCurrency.Close();
}
}
if (this.Picked != null)
{
this.Picked(new object(), new EventArgs());
}
}
}
// saves the form
// links:
// docLink: http://sql2x.org/documentationLink/c9522930-91f8-4468-a936-8030bb2a6482
private void buttonSave_Click(object sender, EventArgs e)
{
var service = new CrudeFinancialCurrencyServiceClient();
try {
_contract.FinancialCurrencyTypeRcd = financialCurrencyTypeRefCombo.Text;
_contract.FinancialCurrencyTypeCode = textBoxFinancialCurrencyTypeCode.Text;
_contract.FinancialCurrencyTypeName = textBoxFinancialCurrencyTypeName.Text;
_contract.FinancialCurrencyAgainstFinancialCurrencyTypeRcd = financialCurrencyAgainstFinancialCurrencyTypeRefCombo.Text;
_contract.ValidFromDateTime = dateTimePickerValidFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidFromDateTime.Value): DateTime.MinValue;
_contract.ValidUntilDateTime = dateTimePickerValidUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidUntilDateTime.Value): DateTime.MinValue;
_contract.Amount = maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text);
_contract.EqualsAmount = maskedTextBoxEqualsAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxEqualsAmount.Text);
_contract.DecimalCount = maskedTextBoxDecimalCount.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxDecimalCount.Text);
_contract.UserId = (Guid)userPicker.SelectedValue;
if (_isNew)
{
service.Insert(_contract);
}
else
{
service.Update(_contract);
}
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
service.Close();
}
Close();
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeFinancialCurrency()
{
var financialCurrency = new CrudeFinancialCurrencyServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = financialCurrency.FetchWithFilter(
Guid.Empty
, textBoxFinancialCurrencyType.Text
, textBoxFinancialCurrencyAgainstFinancialCurrencyType.Text
, Guid.Empty
, DateTime.MinValue
, dateTimePickerValidFromDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidFromDateTime.Value): DateTime.MinValue
, dateTimePickerValidUntilDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidUntilDateTime.Value): DateTime.MinValue
, maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text)
, maskedTextBoxEqualsAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxEqualsAmount.Text)
, maskedTextBoxDecimalCount.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxDecimalCount.Text)
, textBoxFinancialCurrencyTypeCode.Text
, textBoxFinancialCurrencyTypeName.Text
);
dataGridViewCrudeFinancialCurrency.AutoGenerateColumns = false;
dataGridViewCrudeFinancialCurrency.DataSource = bindingSource;
dataGridViewCrudeFinancialCurrency.AutoResizeColumns();
dataGridViewCrudeFinancialCurrency.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
financialCurrency.Close();
}
}