public static WindowMetaList WinMetadataList(Int32 tabId) //Returns the list of metadata values for a window { NpgsqlConnection controlDb = new NpgsqlConnection(ApplicationEnviroment.ConnectionString("control")); WindowMetaList metaList = new WindowMetaList { //Set the control connections ControlDb = controlDb }; //get the table string values NpgsqlCommand getTab = new NpgsqlCommand { CommandText = ControlDatabaseSql.TableMetadata(), CommandType = CommandType.Text, Connection = controlDb }; getTab.Parameters.AddWithValue("@tabId", tabId); controlDb.Open(); NpgsqlDataReader getTabReader = getTab.ExecuteReader(); getTabReader.Read(); metaList.ApplicationName = getTabReader["application_name"].ToString(); metaList.TableId = Convert.ToInt32(getTabReader["application_table_id"]); metaList.TableKey = getTabReader["table_key"].ToString(); metaList.TableName = getTabReader["table_name"].ToString(); metaList.TableLabel = getTabReader["table_label"].ToString(); metaList.TableDml = getTabReader["table_dml"].ToString(); metaList.TableOrderBy = getTabReader["table_order_by"].ToString(); metaList.PageRowCount = getTabReader["page_row_count"].ToString(); metaList.SchemaName = getTabReader["schema_name"].ToString(); metaList.SchemaLabel = getTabReader["schema_label"].ToString(); controlDb.Close(); //set the application connection NpgsqlConnection applicationDb = new NpgsqlConnection(ApplicationEnviroment.ConnectionString(metaList.ApplicationName)); metaList.ApplicationDb = applicationDb; metaList.Columns = WindowBuildUtils.PopulateColumnMetadata(metaList); //metaList.Columns.Add(new ColumMetadata { }) return(metaList); }
public static void WinSetMode(String winMode, Window winNew, Button btnSave, Button btnNew, Button btnDelete, Button btnExit, Button btnClear, WindowMetaList windowMetaList, TextBox tbWinMode) //Sets the various mode for the winow { switch (winMode) { case "SELECT": btnSave.IsEnabled = true; btnNew.IsEnabled = true; btnDelete.IsEnabled = false; btnExit.IsEnabled = true; btnClear.IsEnabled = true; break; case "NEW": btnSave.IsEnabled = true; btnNew.IsEnabled = false; btnDelete.IsEnabled = false; btnExit.IsEnabled = true; btnClear.IsEnabled = true; break; case "EDIT": btnSave.IsEnabled = true; btnNew.IsEnabled = true; btnDelete.IsEnabled = true; btnExit.IsEnabled = true; btnClear.IsEnabled = true; break; case "CLEAR": btnSave.IsEnabled = false; btnNew.IsEnabled = true; btnDelete.IsEnabled = false; btnExit.IsEnabled = true; btnClear.IsEnabled = true; winMode = "SELECT"; break; } tbWinMode.Text = ApplicationEnviroment.ApplicationMessage(winMode); windowMetaList.WinMode = winMode; }