public void load(CleansingDisplay l, int change, string tablename)
{
{
try
{
l.load(change, tablename);
}
catch
{
if (l.InvokeRequired)
{
SetCallback d = new SetCallback(load);
l.Invoke(d, new object[] { l, change, tablename });
}
}
}
}
public void shiftData()
{
string[] prefix = username.Split('_');
string tablename = prefix[0] + "_" + OLTPName + "Setting";
string[] settings = q.getOLTPSetting(tablename);
DataTable dt;
string[] CommonTitles = settings[3].Split('@');
string tablenames = q.getOLTPTables(OLTPName);
if (tablenames == null)
{
return;
}
string[] tables = tablenames.Split('@');
string[] companyPrefix = username.Split('_');
string[] keyvalues = settings[5].Split('@');
if (settings[6] == "0")
{
return;
}
//for (int index = Application.OpenForms.Count - 1; index >= 0; index--)
//{
// if (Application.OpenForms[index].Name == "MainBackend")
// {
// MainBackend m = (MainBackend)Application.OpenForms[index];
// m.WindowState = FormWindowState.Minimized;
// }
//}
CleansingDisplay cld = new CleansingDisplay();
Thread t = new Thread(() => loadCleansingDisplay(cld));
t.Start();
for (int i = 0; i < keyvalues.Length; i++)
{
string[] temp = keyvalues[i].Split(',');
if (temp[0] != null && temp[1] != null)
{
d.Add(temp[0], temp[1]);
}
}
for (int k = 0; k < tables.Length; k++)
{
////////////////////////////////////////////////////////////////
//////////// Extract /////////////////
////////////////////////////////////////////////////////////////
load(cld, 2, companyPrefix[0] + "_" + OLTPName + "_" + tables[k]);
dt = q.pulldata(companyPrefix[0] + "_" + OLTPName + "_" + tables[k]);
////////////////////////////////////////////////////////////////
//////////// Transform /////////////////
////////////////////////////////////////////////////////////////
load(cld, 3, companyPrefix[0] + "_" + OLTPName + "_" + tables[k]);
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
string s = dt.Rows[i].ItemArray[j].ToString();
if (s != null)
{
s = Abrreviations(s);
if (settings[2] == "1")
{
s = RemoveTitles(s, CommonTitles);
}
if (settings[0] == "1")
{
s = camelcase(s);
}
if (settings[1] == "1")
{
s = MultipleSpaces(s);
}
dt.Rows[i][j] = s;
}
}
}
////////////////////////////////////////////////////////////////
//////////// Load /////////////////
////////////////////////////////////////////////////////////////
load(cld, 4, companyPrefix[0] + "_" + OLTPName + "_" + tables[k]);
q.copyBulkDataDW(dt, companyPrefix[0] + "_" + OLTPName + "_" + tables[k]);
}
load(cld, 5, companyPrefix[0] + "_" + OLTPName);
//for (int index = Application.OpenForms.Count - 1; index >= 0; index--)
//{
// Application.OpenForms[index].WindowState = FormWindowState.Maximized;
//}
}
public void loadCleansingDisplay(CleansingDisplay cld)
{
cld.ShowDialog();
}
