public static string GetBarData()
{
//string constring = @"Data Source=(localdb)\v11.0;Initial Catalog=WebAnalytics;Persist Security Info=True;Integrated Security=true;";
string retval = "test";
DataHelper dh = new DataHelper();
DataSet ds = new DataSet();
dh.AddParameterToSQLCommand("@compapp1", SqlDbType.VarChar, 100);
dh.AddParameterToSQLCommand("@compapp2", SqlDbType.VarChar, 100);
string qrytxt = "select Count(*) AS [COUNT],AppID, CONVERT(VARCHAR(3),DateName( month , DateAdd( month , DATEPART(mm,HitDateTime) , 0 ) - 1 )) + '-'+CONVERT(VARCHAR(10),DATEPART(year,HitDateTime)) AS [TIMELINE] FROM Pagestats WHERE Action = 'load' GROUP BY APPID,CONVERT(VARCHAR(3),DateName( month , DateAdd( month , DATEPART(mm,HitDateTime) , 0 ) - 1 ))+'-'+CONVERT(VARCHAR(10),DATEPART(year,HitDateTime))";
ds = dh.GetDatasetByCommand("AppCompareBar", CommandType.StoredProcedure);
retval = JsonConvert.SerializeObject(ds);
return retval;
}
public static string GetLineData()
{
//string constring = @"Data Source=(localdb)\v11.0;Initial Catalog=WebAnalytics;Persist Security Info=True;Integrated Security=true;";
string retval = "test";
DataHelper dh = new DataHelper();
DataSet ds = new DataSet();
dh.AddParameterToSQLCommand("@compapp1", SqlDbType.VarChar, 100);
dh.AddParameterToSQLCommand("@compapp2", SqlDbType.VarChar, 100);
ds = dh.GetDatasetByCommand("AreaChartComapreApps", CommandType.StoredProcedure);
retval = JsonConvert.SerializeObject(ds);
return retval;
}
