public static DataSet GetTrafficHandledL2Dataset(string Frequency, string Direction, string From = null, string To = null)
{
DataSet ds = new DataSet();
var sqlParam = new SqlParameter[4];
sqlParam[0] = new SqlParameter("@Frequency", Frequency)
{
SqlDbType = SqlDbType.NVarChar
};
sqlParam[1] = new SqlParameter("@From", From)
{
SqlDbType = SqlDbType.DateTime
};
sqlParam[2] = new SqlParameter("@To", null)
{
SqlDbType = SqlDbType.DateTime
};
sqlParam[3] = new SqlParameter("@Direction", Direction)
{
SqlDbType = SqlDbType.NVarChar
};
ds = SqlDBHelper.ExecuteQueryGetDataset("sp_TrafficHandled_L2", sqlParam);
return(ds);
}
public static DataSet GetTrafficHandledDataset(string Frequency, string From = "", string To = "")
{
DataSet dt = new DataSet();
var sqlParam = new SqlParameter[3];
sqlParam[0] = new SqlParameter("@Frequency", Frequency)
{
SqlDbType = SqlDbType.NVarChar
};
sqlParam[1] = new SqlParameter("@From", From)
{
SqlDbType = SqlDbType.NVarChar
};
sqlParam[2] = new SqlParameter("@To", To)
{
SqlDbType = SqlDbType.NVarChar
};
dt = SqlDBHelper.ExecuteQueryGetDataset("sp_TrafficHandled_L1", sqlParam);
return(dt);
}
