// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeBooking()
{
var booking = new CrudeBookingServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = booking.FetchWithFilter(
Guid.Empty
, textBoxReceivedFrom.Text
, Guid.Empty
, bookingSourceRefCombo.Text
, externalSystemPicker.SelectedValue
, agencyPicker.SelectedValue
, financialCurrencyPicker.SelectedValue
, financialCostcentrePicker.SelectedValue
, textBoxComment.Text
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeBooking.AutoGenerateColumns = false;
dataGridViewCrudeBooking.DataSource = bindingSource;
dataGridViewCrudeBooking.AutoResizeColumns();
dataGridViewCrudeBooking.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
booking.Close();
}
}
// shows the form in edit modus
// links:
// docLink: http://sql2x.org/documentationLink/49afd26c-4f21-4992-967b-be190eacef77
public void ShowAsEdit(System.Guid bookingId)
{
var service = new CrudeBookingServiceClient();
_isNew = false;
try {
_contract = service.FetchByBookingId(bookingId);
textBoxReceivedFrom.Text = _contract.ReceivedFrom;
bookingSourceRefCombo.Text = _contract.BookingSourceRcd != null ? _contract.BookingSourceRcd : String.Empty;
externalSystemPicker.SelectedValue = _contract.ExternalSystemId;
agencyPicker.SelectedValue = _contract.AgencyId;
financialCurrencyPicker.SelectedValue = _contract.FinancialCurrencyId;
financialCostcentrePicker.SelectedValue = _contract.FinancialCostcentreId;
textBoxComment.Text = _contract.Comment;
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 CrudeBookingEdit(
System.Guid bookingId
)
{
CrudeBookingContract contract = new CrudeBookingServiceClient().FetchByBookingId(bookingId);
ViewBag.BookingSourceRcd =
new SelectList(new CrudeBookingSourceRefServiceClient().FetchAll(),
"BookingSourceRcd",
"BookingSourceName",
contract.BookingSourceRcd
);
ViewBag.ExternalSystemId =
new SelectList(new CrudeExternalSystemServiceClient().FetchAll(),
"ExternalSystemId",
"ExternalSystemName",
contract.ExternalSystemId
);
ViewBag.AgencyId =
new SelectList(new CrudeAgencyServiceClient().FetchAll(),
"AgencyId",
"AgencyName",
contract.AgencyId
);
ViewBag.FinancialCurrencyId =
new SelectList(new CrudeFinancialCurrencyServiceClient().FetchAll(),
"FinancialCurrencyId",
"FinancialCurrencyTypeName",
contract.FinancialCurrencyId
);
ViewBag.FinancialCostcentreId =
new SelectList(new CrudeFinancialCostcentreServiceClient().FetchAll(),
"FinancialCostcentreId",
"FinancialCostcentreName",
contract.FinancialCostcentreId
);
ViewBag.DefaultUserName =
new CrudeDefaultUserServiceClient().FetchByDefaultUserId(contract.UserId).DefaultUserName;
return(View(
"~/Views/Crude/Booking/CrudeBooking/CrudeBookingEdit.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 CrudeBookingServiceClient();
try {
_contract.ReceivedFrom = textBoxReceivedFrom.Text;
_contract.BookingSourceRcd = bookingSourceRefCombo.Text;
_contract.ExternalSystemId = (Guid)externalSystemPicker.SelectedValue;
_contract.AgencyId = (Guid)agencyPicker.SelectedValue;
_contract.FinancialCurrencyId = (Guid)financialCurrencyPicker.SelectedValue;
_contract.FinancialCostcentreId = (Guid)financialCostcentrePicker.SelectedValue;
_contract.Comment = textBoxComment.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();
}
