// refresh the grid
// links:
// docLink: http://sql2x.org/documentationLink/a90065e7-8ace-4de7-9367-d4653a7c637f
public void RefreshCrudeDefaultSystemReferenceTable()
{
var defaultSystemReferenceTable = new CrudeDefaultSystemReferenceTableServiceClient();
try {
var bindingSource = new BindingSource();
bindingSource.DataSource = defaultSystemReferenceTable.FetchWithFilter(
Guid.Empty
, textBoxDefaultSystemReferenceTableName.Text
, textBoxDefaultSystemReferenceDisplayName.Text
, Guid.Empty
, dateTimePickerDateTime.Checked ? Convert.ToDateTime(dateTimePickerDateTime.Value): DateTime.MinValue
);
dataGridViewCrudeDefaultSystemReferenceTable.AutoGenerateColumns = false;
dataGridViewCrudeDefaultSystemReferenceTable.DataSource = bindingSource;
dataGridViewCrudeDefaultSystemReferenceTable.AutoResizeColumns();
dataGridViewCrudeDefaultSystemReferenceTable.Refresh();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
defaultSystemReferenceTable.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 CrudeDefaultSystemReferenceTableServiceClient();
try {
_contract.DefaultSystemReferenceTableName = textBoxDefaultSystemReferenceTableName.Text;
_contract.DefaultSystemReferenceDisplayName = textBoxDefaultSystemReferenceDisplayName.Text;
_contract.DateTime = dateTimePickerDateTime.Checked ? Convert.ToDateTime(dateTimePickerDateTime.Value): DateTime.MinValue;
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 defaultSystemReferenceTableId, System.Guid defaultUserId)
{
var service = new CrudeDefaultSystemReferenceTableServiceClient();
_isNew = false;
try {
_contract = service.FetchByDefaultSystemReferenceTableId(defaultSystemReferenceTableId);
textBoxDefaultSystemReferenceTableName.Text = _contract.DefaultSystemReferenceTableName;
textBoxDefaultSystemReferenceDisplayName.Text = _contract.DefaultSystemReferenceDisplayName;
_contract.DefaultUserId = defaultUserId;
dateTimePickerDateTime.Value = _contract.DateTime != DateTime.MinValue ? _contract.DateTime : dateTimePickerDateTime.MinDate;
dateTimePickerDateTime.Checked = _contract.DateTime != DateTime.MinValue;
Show();
} catch (Exception ex) {
if (ex == null)
{
}
else
{
System.Diagnostics.Debugger.Break();
}
} finally {
service.Close();
}
}
public ActionResult CrudeDefaultSystemReferenceTableEdit(
System.Guid defaultSystemReferenceTableId
)
{
CrudeDefaultSystemReferenceTableContract contract = new CrudeDefaultSystemReferenceTableServiceClient().FetchByDefaultSystemReferenceTableId(defaultSystemReferenceTableId);
return(View(
"~/Views/Crude/Default/CrudeDefaultSystemReferenceTable/CrudeDefaultSystemReferenceTableEdit.cshtml",
contract
));
}
public ActionResult Index()
{
var obj = new CrudeDefaultSystemReferenceTableServiceClient();
List <CrudeDefaultSystemReferenceTableContract> refTables = obj.FetchAll();
foreach (CrudeDefaultSystemReferenceTableContract refTable in refTables)
{
refTable.DefaultSystemReferenceTableName = Nice(refTable.DefaultSystemReferenceTableName);
}
Logging.ActionLog(Request, "SystemReferenceTable" + " " + "Index" + " ( ASP MVC WCF )");
return(View(
"~/Views/Div/" + "SystemReferenceTable" + "/" + "Index" + ".cshtml",
refTables
));
}
private void btnSearch_Click(object sender, EventArgs e)
{
var crudeDefaultSystemReferenceTable = new CrudeDefaultSystemReferenceTableServiceClient();
var bindingSource = new BindingSource();
try {
bindingSource.DataSource = crudeDefaultSystemReferenceTable.FetchWithFilter(
Guid.Empty
, textBoxSystemReferenceTableName.Text
, textBoxSystemReferenceDisplayName.Text
, userPicker.SelectedValue
, DateTime.MinValue
);
dataGridViewCrudeDefaultSystemReferenceTable.AutoGenerateColumns = false;
dataGridViewCrudeDefaultSystemReferenceTable.DataSource = bindingSource;
dataGridViewCrudeDefaultSystemReferenceTable.AutoResizeColumns();
dataGridViewCrudeDefaultSystemReferenceTable.Refresh();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
} finally {
crudeDefaultSystemReferenceTable.Close();
}
}
