public void getqry()
{
//try{
string s = "select * from getallprocesses()";
helper.hlpDbConnect1 db = new helper.hlpDbConnect1(clsglobal.cn);
coreprocess txt = new coreprocess();
var allrows = db.getmylist(s);
if (allrows.Count > 0)
{
foreach (shlpMyDictionary a in allrows)
{
if (a.getint("coreid") != txt.coreid)
{
txt.setcoreid(a.getint("coreid"));
getwebfile.rooturl = a.getvalue("rootlnk");
}
txt.queryid = a.getint("qryprocessid");
string strtbl = a.getvalue("storetable");
txt.processtxt(strtbl);
}
// running post download
s = "exec [dbo].[spCleantblStore]";
int res = db.getfirstint(s);
}
//}
//catch (Exception e){}
}
public bool getallprocesses()
{
string s = "select * from fncGetAllCores() order by coreid";
try
{
helper.hlpDbConnect1 db = new helper.hlpDbConnect1(clsglobal.cn);
var allrows = db.getmylist(s);
if (allrows.Count > 0)
{
foreach (shlpMyDictionary b in allrows)
{
int i = b.getint("coreid");
string ds = b.getvalue("descript");
string l = b.getvalue("rootlnk");
coreprocess c = new coreprocess(i, ds, l);
prs.Add(c);
}
}
}
catch (Exception e)
{
msg = e.Message;
return(false);
}
return(true);
}