// 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 CrudeAirlineServiceClient();
try {
_contract.AirlineName = textBoxAirlineName.Text;
_contract.AirlineTypeRcd = airlineTypeRefCombo.Text;
_contract.LegalName = textBoxLegalName.Text;
_contract.StockMarketSymbol = textBoxStockMarketSymbol.Text;
_contract.AircraftCount = maskedTextBoxAircraftCount.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxAircraftCount.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();
}
// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid airlineId)
{
var service = new CrudeAirlineServiceClient();
_isNew = false;
try {
_contract = service.FetchByAirlineId(airlineId);
textBoxAirlineName.Text = _contract.AirlineName;
airlineTypeRefCombo.Text = _contract.AirlineTypeRcd != null ? _contract.AirlineTypeRcd : String.Empty;
textBoxLegalName.Text = _contract.LegalName;
textBoxStockMarketSymbol.Text = _contract.StockMarketSymbol;
maskedTextBoxAircraftCount.Text = _contract.AircraftCount.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();
}
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeAirline()
{
var airline = new CrudeAirlineServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = airline.FetchWithFilter(
Guid.Empty
, textBoxAirlineName.Text
, airlineTypeRefCombo.Text
, textBoxLegalName.Text
, Guid.Empty
, Guid.Empty
, textBoxStockMarketSymbol.Text
, maskedTextBoxAircraftCount.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxAircraftCount.Text)
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeAirline.AutoGenerateColumns = false;
dataGridViewCrudeAirline.DataSource = bindingSource;
dataGridViewCrudeAirline.AutoResizeColumns();
dataGridViewCrudeAirline.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
airline.Close();
}
}
public ActionResult CrudeAirlineEdit(
System.Guid airlineId
)
{
CrudeAirlineContract contract = new CrudeAirlineServiceClient().FetchByAirlineId(airlineId);
ViewBag.AirlineTypeRcd =
new SelectList(new CrudeAirlineTypeRefServiceClient().FetchAll(),
"AirlineTypeRcd",
"AirlineTypeName",
contract.AirlineTypeRcd
);
ViewBag.ProductId =
new SelectList(new CrudeProductServiceClient().FetchAll(),
"ProductId",
"ProductName",
contract.ProductId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Airline/CrudeAirline/CrudeAirlineEdit.cshtml",
contract
));
}
// populates the Picker with the first match from the SOAP service
// links:
// docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534
private void txtAirlineCode_Validating(object sender, CancelEventArgs e)
{
if (!DesignMode)
{
// empty picker on no code
if (string.IsNullOrEmpty(txtAirlineCode.Text))
{
_airlineId = Guid.Empty;
txtAirlineName.Text = string.Empty;
txtAirlineCode.Text = string.Empty;
return;
}
CrudeAirlineServiceClient airline = null;
try {
airline = new CrudeAirlineServiceClient();
CrudeAirlineContract contract = airline.FetchByAirlineName(txtAirlineCode.Text);
if (contract != null)
{
txtAirlineCode.Text = contract.AirlineName;
txtAirlineName.Text = contract.AirlineName;
_airlineId = contract.AirlineId;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
if (airline != null)
{
airline.Close();
}
}
if (this.Picked != null)
{
this.Picked(new object(), new EventArgs());
}
}
}
