// fetch all rows from the SOAP layer and populate the ComboBox with it
// links:
// docLink: http://sql2x.org/documentationLink/4ccfdfd8-9986-4cfe-8743-e0bcde887284
public void PopulateCombo()
{
if (!DesignMode && cboRef.DataSource == null)
{
CrudeClientTypeRefServiceClient clientTypeRef = null;
try {
clientTypeRef = new CrudeClientTypeRefServiceClient();
List <CrudeClientTypeRefContract> contracts = clientTypeRef.FetchAll();
cboRef.DataSource = contracts;
cboRef.DisplayMember = "ClientTypeName";
cboRef.ValueMember = "ClientTypeRcd";
} catch (Exception ex) {
if (ex != null)
{
}
} finally {
if (clientTypeRef != null)
{
clientTypeRef.Close();
}
}
}
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeClientTypeRef()
{
var clientTypeRef = new CrudeClientTypeRefServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = clientTypeRef.FetchWithFilter(
textBoxClientType.Text
, textBoxClientTypeName.Text
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeClientTypeRef.AutoGenerateColumns = false;
dataGridViewCrudeClientTypeRef.DataSource = bindingSource;
dataGridViewCrudeClientTypeRef.AutoResizeColumns();
dataGridViewCrudeClientTypeRef.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
clientTypeRef.Close();
}
}
// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeClientTypeRef()
{
var clientTypeRef = new CrudeClientTypeRefServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = clientTypeRef.FetchWithFilter(
textBoxClientType.Text
, textBoxClientTypeName.Text
, textBoxClientTypeDescription.Text
, Convert.ToBoolean(checkBoxActiveFlag.Checked)
, maskedTextBoxSortOrder.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxSortOrder.Text)
, Guid.Empty
, DateTime.MinValue
);
dataGridViewCrudeClientTypeRef.AutoGenerateColumns = false;
dataGridViewCrudeClientTypeRef.DataSource = bindingSource;
dataGridViewCrudeClientTypeRef.AutoResizeColumns();
dataGridViewCrudeClientTypeRef.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
clientTypeRef.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 CrudeClientTypeRefServiceClient();
try {
_contract.ClientTypeRcd = textBoxClientType.Text;
_contract.ClientTypeName = textBoxClientTypeName.Text;
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(string clientTypeRcd, System.Guid userId)
{
var service = new CrudeClientTypeRefServiceClient();
_isNew = false;
try {
_contract = service.FetchByClientTypeRcd(clientTypeRcd);
textBoxClientType.Text = _contract.ClientTypeRcd;
textBoxClientTypeName.Text = _contract.ClientTypeName;
_contract.UserId = 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 CrudeClientTypeRefServiceClient();
try {
_contract.ClientTypeRcd = textBoxClientType.Text;
_contract.ClientTypeName = textBoxClientTypeName.Text;
_contract.ClientTypeDescription = textBoxClientTypeDescription.Text;
_contract.ActiveFlag = Convert.ToBoolean(checkBoxActiveFlag.Checked);
_contract.SortOrder = maskedTextBoxSortOrder.Text == String.Empty ? 0 : Convert.ToInt32(maskedTextBoxSortOrder.Text);
if (_isNew)
{
service.Insert(_contract);
}
else
{
service.Update(_contract);
}
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
service.Close();
}
Close();
}
public ActionResult CrudeClientTypeRefEdit(
System.String clientTypeRcd
)
{
CrudeClientTypeRefContract contract = new CrudeClientTypeRefServiceClient().FetchByClientTypeRcd(clientTypeRcd);
return(View(
"~/Views/Crude/Client/CrudeClientTypeRef/CrudeClientTypeRefEdit.cshtml",
contract
));
}