public void populateListView()
{
List <string> listItemsFac = new List <string>();
List <string> listItemsDim = new List <string>();
List <string> listItemsFun = new List <string>();
DataSet dimensions = DimensionHandler.getDimensions(Application.Current.Resources["ProjectPrefix"].ToString());
DataSet facts = FactHandler.getFacts(Application.Current.Resources["ProjectPrefix"].ToString());
DataSet functions = FunctionHandler.getFunctions(Application.Current.Resources["ProjectPrefix"].ToString());
foreach (DataRow row in dimensions.Tables["result"].Rows)
{
listItemsDim.Add(row[0].ToString());
}
foreach (DataRow row in facts.Tables["result"].Rows)
{
listItemsFac.Add(row[0].ToString());
}
foreach (DataRow row in functions.Tables["result"].Rows)
{
listItemsFun.Add(row[0].ToString());
}
listViewFacts.ItemsSource = listItemsFac;
listViewDim.ItemsSource = listItemsDim;
listViewFun.ItemsSource = listItemsFun;
}
public List <string> columnList(string tableName)
{
List <string> listItems = new List <string>();
DataSet testowy = DimensionHandler.getDimensionColumns(tableName);
foreach (DataRow row in testowy.Tables["result"].Rows)
{
listItems.Add(row[0].ToString());
}
return(listItems);
}
private void SetButtonDimensions()
{
DataSet testowy = DimensionHandler.getDimensions(Application.Current.Resources["ProjectPrefix"].ToString());
foreach (DataRow row in testowy.Tables["result"].Rows)
{
Button c = new Button();
c.Content = row[0].ToString();
c.Click += EditDimension_Click;
this.DimensionsContainer.Children.Add(c);
}
}
private void fillUpdateFields(string tableName)
{
DataSet testowy = DimensionHandler.getDimensionColumns(tableName);
int i = 0;
foreach (DataRow row in testowy.Tables["result"].Rows)
{
AddColumnBar();
ColumnList[i].TxtColumnName.Text = row[0].ToString();
ColumnList[i].TxtColumnType.Text = row[1].ToString() + "(" + row[2].ToString() + ")";
i++;
}
}
/// <summary>
/// Method itry to drop and create table
/// </summary>
/// <param name="prefix">Project prefix</param>
/// <param name="tableName">Table name</param>
/// <param name="tableType">New columns types</param>
/// <param name="columns">New table columns</param>
/// <param name="drop">If true table with the same name will be drop</param>
private static string tryCreateTable(string prefix, string tableName, string tableType, string columns, bool drop)
{
if (tableName != "" && tableType != "" && columns != "")
{
Result result;
if (tableType == "DIMENSION")
{
if (drop == true)
{
DimensionHandler.dropDimension(prefix, tableName);
}
result = DimensionHandler.addDimension(tableName, columns, prefix);
if (result.errormsg != "OK")
{
return("Import status: Cannot create table. Please check if old table contains foreign keys or if all required inforamtion are correct.");
}
return("OK");
}
else
{
if (drop == true)
{
FactHandler.dropFact(prefix, tableName);
}
result = FactHandler.addFact(tableName, columns, prefix);
if (result.errormsg != "OK")
{
return("Import status: Cannot create table. Please check if old table exists or contains foreign keys or if all required inforamtion are correct.");
}
return("OK");
}
if (tableType == "FUNCTION")
{
if (drop == true)
{
FunctionHandler.dropFunction(prefix + "_" + tableType + "_" + tableName);
}
result = FunctionHandler.addFunction(tableName, columns, prefix);
if (result.errormsg != "OK")
{
return("Import status: Cannot create table. Please check if old table exists or contains foreign keys or if all required inforamtion are correct.");
}
return("OK");
}
}
return("Import status: Please check if csv contains all required information - table type, table name and columns name with types");
}
private bool CreateNewDimension()
{
if (updating)
{
DimensionHandler.dropDimension(Application.Current.Resources["ProjectPrefix"].ToString(), TxtTableName.Text.ToString().ToUpper());
}
string tmpStr = "";
bool allFill = true;
foreach (ColumnBar2 tmp in ColumnList)
{
if (tmp.TxtColumnName.Text.ToString() == "" || tmp.TxtColumnType.Text.ToString() == "")
{
allFill = false;
}
tmpStr = tmpStr + tmp.TxtColumnName.Text.ToString() + " " + tmp.TxtColumnType.Text.ToString() + " " + tmp.TxtColumnCons.Text.ToString() + ",";
}
tmpStr = tmpStr.Remove(tmpStr.Length - 1);
if (TxtTableName.Text.ToString() == "")
{
allFill = false;
}
if (allFill)
{
Result wynik = new Result();
wynik = DimensionHandler.addDimension(TxtTableName.Text, tmpStr, Application.Current.Resources["ProjectPrefix"].ToString());
if (wynik.errormsg != "OK")
{
textBlockError.Text = wynik.errormsg;
}
else
{
Console.WriteLine(tmpStr);
DataSet testowy = DimensionHandler.getDimensions(Application.Current.Resources["ProjectPrefix"].ToString());
Console.WriteLine(testowy.Tables["result"].ToString());
return(true);
}
}
else
{
MessageBox.Show("Fill all Textbox!!!");
}
return(false);
}
public void populateListView(object selected)
{
if (selected == null)
{
List <string> listItems = new List <string>();
DataSet dimensions = DimensionHandler.getDimensions(Application.Current.Resources["ProjectPrefix"].ToString());
// DataSet facts = FactHandler.getFacts(Application.Current.Resources["ProjectPrefix"].ToString());
foreach (DataRow row in dimensions.Tables["result"].Rows)
{
listItems.Add(row[0].ToString());
}
listViewTables1.ItemsSource = listItems;
listViewTables2.ItemsSource = listItems;
}
else
{
List <string> listItems = new List <string>();
DataSet dimensions = DimensionHandler.getDimensions(Application.Current.Resources["ProjectPrefix"].ToString());
// DataSet facts = FactHandler.getFacts(Application.Current.Resources["ProjectPrefix"].ToString());
foreach (DataRow row in dimensions.Tables["result"].Rows)
{
if (row[0].ToString() != selected.ToString())
{
listItems.Add(row[0].ToString());
}
}
listViewTables2.ItemsSource = listItems;
}
}
public UIDimensionLoading(DimensionHandler currentHandlerToLoad)
{
currentHandler = currentHandlerToLoad;
}
