// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/f5685d96-a0bb-4f7b-beaa-b3d578c7cf28
public void ShowAsAdd(string airlineName, string airlineTypeRcd, string legalName, System.Guid addressId, System.Guid productId, string stockMarketSymbol, int aircraftCount, System.Guid userId)
{
try {
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.AirlineName = airlineName;
textBoxAirlineName.Text = _contract.AirlineName;
_contract.AirlineTypeRcd = airlineTypeRcd;
airlineTypeRefCombo.Text = _contract.AirlineTypeRcd != null ? _contract.AirlineTypeRcd : String.Empty;
_contract.LegalName = legalName;
textBoxLegalName.Text = _contract.LegalName;
_contract.AddressId = addressId;
_contract.ProductId = productId;
_contract.StockMarketSymbol = stockMarketSymbol;
textBoxStockMarketSymbol.Text = _contract.StockMarketSymbol;
_contract.AircraftCount = aircraftCount;
maskedTextBoxAircraftCount.Text = _contract.AircraftCount.ToString();
_contract.UserId = userId;
userPicker.SelectedValue = userId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// 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();
}
}
// bring up add form for Airline
// links:
// docLink: http://sql2x.org/documentationLink/c0944961-8179-40a2-a561-c8873b691f2c
public void ShowAsAdd()
{
_contract = new CrudeAirlineContract();
_isNew = true;
RefreshAirline();
Show();
}
// bring up add form for Airline by foreign key Address
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByAddress(System.Guid addressId)
{
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AddressId = addressId;
RefreshAirline();
Show();
}
// bring up add form for Airline by foreign key AirlineType
// links:
// docLink: http://sql2x.org/documentationLink/2461e69c-dd05-47db-8f32-27ac1641a8d9
public void ShowAsAddByAirlineType(string airlineTypeRcd)
{
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AirlineTypeRcd = airlineTypeRcd;
airlineTypeRefCombo.Text = _contract.AirlineTypeRcd != null ? _contract.AirlineTypeRcd : String.Empty;
RefreshAirline();
Show();
}
// bring up add form for Airline with rules
// links:
// docLink: http://sql2x.org/documentationLink/6018e96e-28a1-4df4-879b-01a6bda81cc7
public void ShowAsAddByRules(System.Guid userId)
{
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.UserId = userId;
userPicker.SelectedValue = _contract.UserId;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
RefreshAirline();
Show();
}
public ActionResult CrudeAirlineCreate([Bind()] CrudeAirlineContract contract)
{
if (ModelState.IsValid)
{
new CrudeAirlineServiceClient().Insert(contract);
return(RedirectToAction("CrudeAirlineIndex"));
}
return(View(
"~/Views/Crude/Airline/CrudeAirline/CrudeAirlineCreate.cshtml",
contract
));
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/e04d0806-55ef-41cc-8669-acf0ddd850c7
public void ShowAsAdd()
{
try {
_contract = new CrudeAirlineContract();
_isNew = true;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
public ActionResult CrudeAirlineEdit([Bind()] CrudeAirlineContract contract)
{
if (ModelState.IsValid)
{
contract.DateTime = DateTime.UtcNow;
new CrudeAirlineServiceClient().Update(contract);
return(RedirectToAction("CrudeAirlineIndex"));
}
return(View(
"~/Views/Crude/Airline/CrudeAirline/CrudeAirlineEdit.cshtml",
contract
));
}
public ActionResult CrudeAirlineCreate(System.Guid?addressId, System.Guid?productId, System.Guid?userId)
{
var contract = new CrudeAirlineContract();
if (addressId != null)
{
contract.AddressId = (System.Guid)addressId;
}
if (productId != null)
{
contract.ProductId = (System.Guid)productId;
}
if (userId != null)
{
contract.UserId = (System.Guid)userId;
}
ViewBag.AirlineTypeRcd =
new SelectList(new CrudeAirlineTypeRefServiceClient().FetchAll(),
"AirlineTypeRcd",
"AirlineTypeName",
contract.AirlineTypeRcd
);
ViewBag.ProductId =
new SelectList(new CrudeProductServiceClient().FetchAll(),
"ProductId",
"ProductName",
contract.ProductId
);
if (userId == null)
{
contract.UserId = new System.Guid("{FFFFFFFF-5555-5555-5555-FFFFFFFFFFFF}");
}
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
contract.DateTime = DateTime.UtcNow;
return(View(
"~/Views/Crude/Airline/CrudeAirline/CrudeAirlineCreate.cshtml",
contract
));
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByAddress(System.Guid addressId)
{
try {
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AddressId = addressId;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// shows by foreign keys
// links:
// docLink: http://sql2x.org/documentationLink/f21e72c1-2d57-44c1-a9c1-1b80bad6a391
public void ShowAsAddByAirlineType(string airlineTypeRcd)
{
try {
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.DateTime = DateTime.UtcNow;
dateTimePickerDateTime.Text = _contract.DateTime.ToString();
_contract.AirlineTypeRcd = airlineTypeRcd;
airlineTypeRefCombo.Text = _contract.AirlineTypeRcd != null ? _contract.AirlineTypeRcd : String.Empty;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
}
}
// shows the form with default values for comboboxes and pickers
// links:
// docLink: http://sql2x.org/documentationLink/599dcb45-f71b-4672-bb18-46975a4fe9b3
public void ShowAsAddByRules(System.Guid userId)
{
try {
_contract = new CrudeAirlineContract();
_isNew = true;
_contract.UserId = userId;
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();
}
}
}
// 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());
}
}
}
