public void worker_DoWork(object sender, DoWorkEventArgs e)
{
Thread.Sleep(2000);
ConnectionString.IsConnectionTrue = false;
ConnectionString.Connection = Environment.CurrentDirectory + @"\Data\DBOpenMiracle.mdf";
CallSP objCallSp = new CallSP();
if (objCallSp.GetCompanyName().Count > 0)
{
dtbl = objCallSp.GetCompanyName()[0];
}
else
{
string fullpath = string.Empty;
List<Process> taskBarProcesses = Process.GetProcesses().Where(p => !string.IsNullOrEmpty(p.MainWindowTitle)).ToList();
foreach (Process proc in taskBarProcesses)
{
if (proc.ProcessName.ToLower() == "open miracle")
{
fullpath = proc.MainModule.FileName;
fullpath = fullpath.Remove(fullpath.Length - 16);
ConnectionString.Connection = fullpath + @"Data\DBOpenMiracle.mdf";
break;
}
}
if (objCallSp.GetCompanyName().Count > 0)
{
dtbl = objCallSp.GetCompanyName()[0];
}
}
}
public void FunctionViewDetail()
{
dataGrid1.Dispatcher.Invoke(
new Action(
() =>
{
CallSP SPCall = new CallSP();
dataGrid1.ItemsSource = SPCall.GetViewDetailsFill()[0].DefaultView;
}));
}
public static List <AssetClass> ConstructTestData(CategoryInfo infoCatagory)
{
CallSP objCallSP = new CallSP();
List <DataTable> objList = objCallSP.GetPieChartDetails(infoCatagory);
List <AssetClass> assetClasses = new List <AssetClass>();
for (int i = 0; i < objList[0].Rows.Count; i++)
{
assetClasses.Add(new AssetClass()
{
Class = objList[0].Rows[i][0].ToString(), Value = Convert.ToDouble(objList[0].Rows[i][1])
});
}
return(assetClasses);
}
