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