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;
}
