public List <ActiveData_VM> GetActiveData(SafetyDashboard_VM Model)
        {
            var query = new List <ActiveData_VM>();

            try
            {
                using (var db = new DBConnection())
                {
                    var ds  = new DataSet();
                    var par = new SqlParameter[] {
                        new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID)),
                        new SqlParameter("@p_ModuleCode", GetDBNULL(Model.CurrentModuleCode)),
                        new SqlParameter("@p_ServiceLineCode", GetDBNULL(Model.CurrentServiceLineCode)),
                        new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
                        new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset)),
                        new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
                        new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
                        new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
                        new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint)),
                    };

                    ds    = db.ExecuteDataSet("GetCustomerSafetyDashboardActiveAssetsPlansDeviations", par);
                    query = ConvertToList <ActiveData_VM>(ds.Tables[0]);
                }
            }
            catch (Exception ex)
            {
                logger.Error("CustomerDashboardRepository_GetActiveData Error: ", ex);
                throw;
            }

            return(query);
        }
        public List <SafetyDashboardYearlyChart_VM> GetDashboardYearlySnapshot(SafetyDashboard_VM Model)
        {
            var query = new List <SafetyDashboardYearlyChart_VM>();

            try
            {
                using (var db = new WebPortalEntities())
                {
                    var config = new MapperConfiguration(cfg => cfg.CreateMap <GetCustomerSafetyDashboardYearlyChart_Result, SafetyDashboardYearlyChart_VM>());
                    var mapper = config.CreateMapper();

                    var data = db.GetCustomerSafetyDashboardYearlyChart(Model.CustomerID, Model.CurrentModuleCode, Model.CurrentServiceLineCode, Model.CurrentLanguageCode,
                                                                        Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint).ToList();
                    return(mapper.Map <List <GetCustomerSafetyDashboardYearlyChart_Result>, List <SafetyDashboardYearlyChart_VM> >(data, query));
                }
            }
            catch (Exception ex)
            {
                logger.Error("CustomerDashboardRepository_GetDashboardYearlySnapshot Error: ", ex);
                throw;
            }
        }