public IEnumerable <CumulativeView> GetCumulativeViews(CumulativeViewsParameters parameters)
{
parameters.ValidateParameters();
var dt = m_storageEngine.GetCumulativeViews(parameters);
var result = Map(dt);
return(result);
}
private CumulativeViewsParameters MapParameters(CumulativeViewsRequest request)
{
var parameters = new CumulativeViewsParameters();
var startTime = request.Start;
var dueTime = request.Due;
if (startTime.HasValue)
{
parameters.StartTime = startTime.Value.UnixTimeStampToDateTime().StartOfDay();
}
if (dueTime.HasValue)
{
parameters.DueTime = dueTime.Value.UnixTimeStampToDateTime().EndOfDay();
}
return(parameters);
}
public DataTable GetCumulativeViews(CumulativeViewsParameters searchParameters)
{
var result = new DataTable();
using (var conn = new SqlConnection(m_connectionString))
{
var sqlComm = new SqlCommand("GetCumulativeViews", conn);
sqlComm.Parameters.AddWithValue("@StartTime", searchParameters.StartTime);
sqlComm.Parameters.AddWithValue("@DueTime", searchParameters.DueTime);
sqlComm.CommandType = CommandType.StoredProcedure;
var da = new SqlDataAdapter();
da.SelectCommand = sqlComm;
da.Fill(result);
return(result);
}
}
