private void btnAdd_Click(object sender, EventArgs e)
{
frmFieldSetup setup = new frmFieldSetup()
{
theSystemDBTag = this.theSystemDBTag, UserCurrentInfo = this.UserCurrentInfo
};
setup.formAction1 = currentAction.caAdd;
setup.TempId = TempID;
setup.ShowDialog();
//tableGrid.Clear();
MWDataManager.clsDataAccess _dbManGrid = new MWDataManager.clsDataAccess();
_dbManGrid.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManGrid.SqlStatement = "select Distinct pf.FieldID [FieldID],pf.FieldName [Field Name],ppf.fieldDescription [Field Type],pf2.FieldName[Parent] from PlanProt_Fields pf " +
"left outer join " +
"PlanProt_FieldTypes ppf " +
"on pf.FieldType = ppf.fieldTypeID " +
"left outer join " +
"PlanProt_Fields pf2 " +
"on pf.ParentID = pf2.FieldID " +
" where pf.TemplateID = '" + TempID + "'";
_dbManGrid.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManGrid.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManGrid.ExecuteInstruction();
gridOutput.DataSource = _dbManGrid.ResultsDataTable; // Populate Grid
}
private void btnEdit_Click(object sender, EventArgs e)
{
FieldID = Convert.ToInt32(tableGrid.Rows[viewFields.FocusedRowHandle]["FieldID"].ToString());
frmFieldSetup fieldSetup = new frmFieldSetup {
theSystemDBTag = this.theSystemDBTag, UserCurrentInfo = this.UserCurrentInfo
};
fieldSetup.formAction1 = currentAction.caEdit;
fieldSetup.TempId = TempID;
fieldSetup.FieldID = FieldID;
MWDataManager.clsDataAccess _dbManGrid = new MWDataManager.clsDataAccess();
_dbManGrid.ConnectionString = TConnections.GetConnectionString(theSystemDBTag, UserCurrentInfo.Connection);
_dbManGrid.SqlStatement = "select Distinct pf.FieldID [FieldID],pf.FieldName [Field Name],ppf.fieldDescription [Field Type],pf2.FieldName[Parent] from PlanProt_Fields pf " +
"left outer join " +
"PlanProt_FieldTypes ppf " +
"on pf.FieldType = ppf.fieldTypeID " +
"left outer join " +
"PlanProt_Fields pf2 " +
"on pf.ParentID = pf2.FieldID " +
" where pf.TemplateID = '" + TempID + "'";
_dbManGrid.queryExecutionType = MWDataManager.ExecutionType.GeneralSQLStatement;
_dbManGrid.queryReturnType = MWDataManager.ReturnType.DataTable;
_dbManGrid.ExecuteInstruction();
gridOutput.DataSource = _dbManGrid.ResultsDataTable;
fieldSetup.ShowDialog();
}