public int GetTimeSum(WebTimeGetBinding binding) { using (var db = GetSqlConnection()) { var parameters = new { DeviceValueId = binding.DeviceId, DomainValueId = binding.DomainId, WebValueId = binding.WebId, IsSecured = binding.IsSecured, From = binding.From, To = binding.To, UserId = UserId }; return(db.ExecuteScalar <int>(SqlLoader.Load(SqlScripts.GetWebTimeTotal), parameters)); } }
public IEnumerable <TimeByDay> GetTimeTotalByDay(WebTimeGetBinding binding) { using (var db = GetSqlConnection()) { var parameters = new { DeviceValueId = binding.DeviceId, DomainValueId = binding.DomainId, WebValueId = binding.WebId, IsSecured = binding.IsSecured, From = binding.From, To = binding.To, UserId = UserId }; var command = new CommandDefinition(SqlLoader.Load(SqlScripts.GetWebTimeTotalByDay), parameters); return(db.Query <TimeByDay>(command)); } }
public IEnumerable <GroupedByMonth <int> > GetTimeTotalByMonth(WebTimeGetBinding binding) { using (var db = GetSqlConnection()) { var parameters = new { DeviceValueId = binding.DeviceId, DomainValueId = binding.DomainId, WebValueId = binding.WebId, IsSecured = binding.IsSecured, From = binding.From, To = binding.To, UserId = UserId }; var command = new CommandDefinition(SqlLoader.Load(SqlScripts.GetWebTimeTotalByMonth), parameters); return(db.Query <GetWebTimeTotalByMonth>(command) .Select(x => new GroupedByMonth <int>(x.Seconds, x.Year, x.Month))); } }
public IEnumerable <KeyValuePair <int, int> > GetTimeTotalByYear(WebTimeGetBinding binding) { using (var db = GetSqlConnection()) { var parameters = new { DeviceValueId = binding.DeviceId, DomainValueId = binding.DomainId, WebValueId = binding.WebId, IsSecured = binding.IsSecured, From = binding.From, To = binding.To, UserId = UserId }; var command = new CommandDefinition(SqlLoader.Load(SqlScripts.GetWebTimeTotalByYear), parameters); return(db.Query <GetWebTimeTotalByYear>(command) .OrderByDescending(x => x.Year) .Select(x => new KeyValuePair <int, int>(x.Year, x.Seconds))); } }