// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeFinancialFare()
{
var financialFare = new CrudeFinancialFareServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = financialFare.FetchWithFilter(
Guid.Empty
, financialFareTypeRefCombo.Text
, departureAirportPicker.SelectedValue
, arrivalAirportPicker.SelectedValue
, dateTimePickerValidFromFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidFromFlightDateTime.Value): DateTime.MinValue
, dateTimePickerValidUntilFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidUntilFlightDateTime.Value): DateTime.MinValue
, maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text)
, financialCurrencyPicker.SelectedValue
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeFinancialFare.AutoGenerateColumns = false;
dataGridViewCrudeFinancialFare.DataSource = bindingSource;
dataGridViewCrudeFinancialFare.AutoResizeColumns();
dataGridViewCrudeFinancialFare.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
financialFare.Close();
}
}
// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid financialFareId)
{
var service = new CrudeFinancialFareServiceClient();
_isNew = false;
try {
_contract = service.FetchByFinancialFareId(financialFareId);
financialFareTypeRefCombo.Text = _contract.FinancialFareTypeRcd != null ? _contract.FinancialFareTypeRcd : String.Empty;
departureAirportPicker.SelectedValue = _contract.DepartureAirportId;
arrivalAirportPicker.SelectedValue = _contract.ArrivalAirportId;
dateTimePickerValidFromFlightDateTime.Value = _contract.ValidFromFlightDateTime != DateTime.MinValue ? _contract.ValidFromFlightDateTime : dateTimePickerValidFromFlightDateTime.MinDate;
dateTimePickerValidFromFlightDateTime.Checked = _contract.ValidFromFlightDateTime != DateTime.MinValue;
dateTimePickerValidUntilFlightDateTime.Value = _contract.ValidUntilFlightDateTime != DateTime.MinValue ? _contract.ValidUntilFlightDateTime : dateTimePickerValidUntilFlightDateTime.MinDate;
dateTimePickerValidUntilFlightDateTime.Checked = _contract.ValidUntilFlightDateTime != DateTime.MinValue;
maskedTextBoxAmount.Text = _contract.Amount.ToString();
financialCurrencyPicker.SelectedValue = _contract.FinancialCurrencyId;
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();
}
}
public ActionResult CrudeFinancialFareEdit(
System.Guid financialFareId
)
{
CrudeFinancialFareContract contract = new CrudeFinancialFareServiceClient().FetchByFinancialFareId(financialFareId);
ViewBag.FinancialFareTypeRcd =
new SelectList(new CrudeFinancialFareTypeRefServiceClient().FetchAll(),
"FinancialFareTypeRcd",
"FinancialFareTypeName",
contract.FinancialFareTypeRcd
);
ViewBag.DepartureAirportId =
new SelectList(new CrudeAirportServiceClient().FetchAll(),
"AirportId",
"AirportName",
contract.DepartureAirportId
);
ViewBag.ArrivalAirportId =
new SelectList(new CrudeAirportServiceClient().FetchAll(),
"AirportId",
"AirportName",
contract.ArrivalAirportId
);
ViewBag.FinancialCurrencyId =
new SelectList(new CrudeFinancialCurrencyServiceClient().FetchAll(),
"FinancialCurrencyId",
"FinancialCurrencyTypeName",
contract.FinancialCurrencyId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Financial/CrudeFinancialFare/CrudeFinancialFareEdit.cshtml",
contract
));
}
// 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 CrudeFinancialFareServiceClient();
try {
_contract.FinancialFareTypeRcd = financialFareTypeRefCombo.Text;
_contract.DepartureAirportId = (Guid)departureAirportPicker.SelectedValue;
_contract.ArrivalAirportId = (Guid)arrivalAirportPicker.SelectedValue;
_contract.ValidFromFlightDateTime = dateTimePickerValidFromFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidFromFlightDateTime.Value): DateTime.MinValue;
_contract.ValidUntilFlightDateTime = dateTimePickerValidUntilFlightDateTime.Checked ? Convert.ToDateTime(dateTimePickerValidUntilFlightDateTime.Value): DateTime.MinValue;
_contract.Amount = maskedTextBoxAmount.Text == String.Empty ? 0 : Convert.ToDecimal(maskedTextBoxAmount.Text);
_contract.FinancialCurrencyId = (Guid)financialCurrencyPicker.SelectedValue;
_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();
}
