// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudePassenger()
{
var passenger = new CrudePassengerServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = passenger.FetchWithFilter(
Guid.Empty
, Guid.Empty
, Guid.Empty
, passengerTypeRefCombo.Text
, textBoxPassengerName.Text
, defaultStateRefCombo.Text
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudePassenger.AutoGenerateColumns = false;
dataGridViewCrudePassenger.DataSource = bindingSource;
dataGridViewCrudePassenger.AutoResizeColumns();
dataGridViewCrudePassenger.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
passenger.Close();
}
}
// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid passengerId)
{
var service = new CrudePassengerServiceClient();
_isNew = false;
try {
_contract = service.FetchByPassengerId(passengerId);
passengerTypeRefCombo.Text = _contract.PassengerTypeRcd != null ? _contract.PassengerTypeRcd : String.Empty;
textBoxPassengerName.Text = _contract.PassengerName;
defaultStateRefCombo.Text = _contract.DefaultStateRcd != null ? _contract.DefaultStateRcd : String.Empty;
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();
}
}
// 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 CrudePassengerServiceClient();
try {
_contract.PassengerTypeRcd = passengerTypeRefCombo.Text;
_contract.PassengerName = textBoxPassengerName.Text;
_contract.DefaultStateRcd = defaultStateRefCombo.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();
}
// populates the Picker with the first match from the SOAP service
// links:
// docLink: http://sql2x.org/documentationLink/3e8b9e1a-39eb-444f-9632-ce3406db3534
private void txtPassengerCode_Validating(object sender, CancelEventArgs e) {
if (!DesignMode) {
// empty picker on no code
if (string.IsNullOrEmpty(txtPassengerCode.Text)) {
_passengerId = Guid.Empty;
txtPassengerName.Text = string.Empty;
txtPassengerCode.Text = string.Empty;
return;
}
CrudePassengerServiceClient passenger = null;
try {
passenger = new CrudePassengerServiceClient();
CrudePassengerContract contract = passenger.FetchByPassengerName(txtPassengerCode.Text);
if (contract != null) {
txtPassengerCode.Text = contract.PassengerName;
txtPassengerName.Text = contract.PassengerName;
_passengerId = contract.PassengerId;
}
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
if (passenger != null) passenger.Close();
}
if (this.Picked != null)
this.Picked(new object(), new EventArgs());
}
}
