using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using Neo.LegitimateLicences.Common;
using Neo.Afx.ComponentModel;
using Neo.Afx.Security;
using Neo.LegitimateLicences.Common.Helpers;
using System.Threading;
using System.Data.Entity;

namespace Neo.LegitimateLicences.Data.Models
{
    public partial class LegitimateDatabase 
    {
        #region GetApplicationSummaryDashboard
        public List<DashboardOutcome> GetApplicationSummaryDashboard(long userId)
        {
            return Context.Pr_Dashboard_ApplicationSummaryGet(userId).ToList();
        }
        #endregion

        #region GetLicenceIssuingDashboard
        public List<DashboardOutcome> GetLicenceIssuingSummaryDashboard(long userId)
        {
            return Context.Pr_Dashboard_LicenceIssuingSummaryGet(userId).ToList();
        }
        #endregion

        #region GetLicenceCancelSummaryDashboard
        public List<DashboardOutcome> GetLicenceCancelSummaryDashboard(long userId)
        {
            return Context.Pr_Dashboard_LicenceCancelSummaryGet(userId).ToList();
        }
        #endregion

        #region GetAccreditationIssuingDashboard
        public List<DashboardOutcome> GetAccreditationIssuingSummaryDashboard(long userId)
        {
            return Context.Pr_Dashboard_AccreditationIssuingSummaryGet(userId).ToList();
        }
        #endregion

        #region GetAverageProcessingTime
        public Pr_Dashboard_AvgProcessingTime_Result GetAverageProcessingTime(string applicationRequestTypeIDs,DateTime dateFrom, DateTime dateTo, long userID)
        {
            return Context.Pr_Dashboard_AvgProcessingTime(applicationRequestTypeIDs, dateFrom, dateTo, userID).FirstOrDefault();
        }
        #endregion

        #region GetNewRouteRequestDashboard
        public List<DashboardOutcome>  GetNewRouteRequestDashboard(long userID)
        {
            return Context.Pr_Dashboard_NewRouteRequestSummaryGet(userID).ToList();
        }
        #endregion

        #region GetGazetteSummaryDashboard
        public List<DashboardOutcome>  GetGazetteSummaryDashboard(long userID)
        {
            return Context.Pr_Dashboard_GazetteSummaryGet(userID).ToList();
        }
        #endregion

        #region GetAdjudicationSummaryDashboard
        public List<DashboardOutcome>  GetAdjudicationSummaryDashboard(long userID)
        {
            return Context.Pr_Dashboard_AdjudicationSummaryGet(userID).ToList();
        }
        #endregion

        #region GetAdjudicationSummaryExceptionsDashboard
        public List<DashboardOutcome> GetAdjudicationSummaryExceptionsDashboard(long userID)
        {
            return Context.Pr_Dashboard_AdjudicationSummaryExceptionsGet(userID).ToList();
        }
        #endregion

        #region GetApplicationAwaitingCorrections
        public List<Pr_ApplicationAwaitingCorrectionsGet_Result> GetApplicationAwaitingCorrections(long assignedToID,long userID)
        {
            return Context.Pr_ApplicationAwaitingCorrectionsGet(assignedToID, userID).ToList();
        }
        #endregion

        #region GetApplicationAnalytics_ApplicationRequestTypeSummmary
        public List<DashboardOutcome> GetApplicationAnalytics_ApplicationRequestTypeSummmary(DateTime fromDate, DateTime toDate, long userID)
        {
            return Context.Pr_ApplicationAnalytics_ApplicationRequestTypeSummmary(fromDate, toDate, userID).ToList();
        }
        #endregion

        #region GetApplicationAnalytics_ApplicationCreatedBySummmary
        public List<DashboardOutcome> GetApplicationAnalytics_ApplicationCreatedBySummmary(DateTime fromDate, DateTime toDate, long userID)
        {
            return Context.Pr_ApplicationAnalytics_ApplicationCreatedBySummmary(fromDate, toDate, userID).ToList();
        }
        #endregion

        #region GetApplicationAnalytics_ApplicationPerRegion
        public List<DashboardOutcome> GetApplicationAnalytics_ApplicationPerRegion(DateTime fromDate, DateTime toDate, long userID)
        {
            return Context.Pr_ApplicationAnalytics_ApplicationPerRegion(fromDate, toDate, userID).ToList();
        }
        #endregion

    }
}