Пример #1
0
        public List <HSCodeGraphData> GetHSCodeGraphData(DashboardSearch obj)
        {
            List <HSCodeGraphData> objHSCodeGraphList = new List <HSCodeGraphData>();
            DashboardDataManager   objDDM             = new DashboardDataManager();
            DataSet ds = objDDM.GetHsCodeGraphData(obj);

            if (ds != null)
            {
                int tblIndex = -1;

                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        HSCodeGraphData objD = new HSCodeGraphData();
                        objD.NotificationCount = Convert.ToInt32(dr["NotificationCount"]);
                        objD.HSCode            = Convert.ToString(dr["HSCode"]);
                        objD.Text = Convert.ToString(dr["Text"]);
                        objHSCodeGraphList.Add(objD);
                    }
                }
            }
            return(objHSCodeGraphList);
        }
Пример #2
0
        public HSCodeCountry GetHsCodeGraphDataCountryWise(DashboardSearch obj)
        {
            HSCodeCountry            objHSCodeCountry     = new HSCodeCountry();
            List <HSCodeCountryData> objHSCodeCountryList = new List <HSCodeCountryData>();
            DashboardDataManager     objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetHsCodeGraphDataCountryWise(obj);

            if (ds != null)
            {
                int tblIndex = -1;

                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        HSCodeCountryData objD = new HSCodeCountryData();
                        objD.NotificationCount = Convert.ToInt32(dr["NotificationCount"]);
                        objD.Country           = Convert.ToString(dr["Country"]);
                        objD.ColorCode         = Convert.ToString(dr["ColorCode"]);
                        objD.CountryCode       = Convert.ToString(dr["CountryCode"]);
                        objD.CountryId         = Convert.ToString(dr["CountryId"]);
                        objHSCodeCountryList.Add(objD);
                    }
                    objHSCodeCountry.objHSCodeCountryData = objHSCodeCountryList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    objHSCodeCountry.CountryCount = Convert.ToString(ds.Tables[tblIndex].Rows[0]["TotalCountries"]);
                    objHSCodeCountry.HSCode       = Convert.ToString(ds.Tables[tblIndex].Rows[0]["HSCode"]);
                }
            }
            return(objHSCodeCountry);
        }
Пример #3
0
        public List <NotificationGraphData> GetNotificationGraphDataMonthly(DashboardSearch obj)
        {
            List <NotificationGraphData> objNotificationGraphList = new List <NotificationGraphData>();
            DashboardDataManager         objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetNotificationGraphDataMonthly(obj);

            if (ds != null)
            {
                int tblIndex = -1;
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationGraphData objD = new NotificationGraphData();
                        objD.NotificationCount = Convert.ToInt32(dr["NotificationCount"]);
                        objD.InProcessCount    = Convert.ToInt32(dr["InProcessCount"]);
                        objD.UnderActionCount  = Convert.ToInt32(dr["UnderActionCount"]);
                        objD.ClosedCount       = Convert.ToInt32(dr["ClosedCount"]);
                        objD.LapsedCount       = Convert.ToInt32(dr["LapsedCount"]);
                        objD.MonthName         = Convert.ToString(dr["MONTHNAME"]);
                        objD.StartDate         = Convert.ToString(dr["StartDate"]);
                        objD.EndDate           = Convert.ToString(dr["EndDate"]);
                        objNotificationGraphList.Add(objD);
                    }
                }
            }
            return(objNotificationGraphList);
        }
Пример #4
0
        public List <NotificationPendingCount_Action> GetDashboardAction(DashboardSearch obj)
        {
            List <NotificationPendingCount_Action> objNotificationDashboardAction = new List <NotificationPendingCount_Action>();
            DashboardDataManager objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetDashboardPendingCount_Action(obj);

            if (ds != null)
            {
                int tblIndex = -1;
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationPendingCount_Action objD = new NotificationPendingCount_Action();
                        objD.Action    = Convert.ToString(dr["Action"]);
                        objD.ColorCode = Convert.ToString(dr["ColorCode"]);
                        objD.Total     = Convert.ToInt32(dr["Total"]);
                        objD.Completed = Convert.ToInt32(dr["Completed"]);
                        objD.Pending   = Convert.ToInt32(dr["Pending"]);
                        objD.Overdue   = Convert.ToInt32(dr["Overdue"]);
                        objD.ActionId  = Convert.ToInt32(dr["ActionId"]);
                        objNotificationDashboardAction.Add(objD);
                    }
                }
            }
            return(objNotificationDashboardAction);
        }
Пример #5
0
        public Dashboard_PendingCounts GetDashboard_PendingCounts(Dashboard obj)
        {
            Dashboard_PendingCounts objR   = new Dashboard_PendingCounts();
            DashboardDataManager    objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetDashboard_PendingCounts(obj);

            if (ds != null)
            {
                int tblIndex = -1;

                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <Count_Discussion> Count_DiscussionList = new List <Count_Discussion>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        Count_Discussion objD = new Count_Discussion();
                        objD.StatusId        = Convert.ToInt32(dr["StatusId"]);
                        objD.Status          = Convert.ToString(dr["Status"]);
                        objD.PendingFromUser = Convert.ToInt64(dr["PendingFromUser"]);
                        objD.TotalPending    = Convert.ToInt64(dr["TotalPending"]);
                        objD.CssColor        = Convert.ToString(dr["CssColor"]);
                        objD.Icon            = Convert.ToString(dr["IconImage"]);
                        Count_DiscussionList.Add(objD);
                    }
                    objR.PendingDiscussions = Count_DiscussionList;
                }

                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <Count_Action> Count_ActionList = new List <Count_Action>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        Count_Action objD = new Count_Action();
                        objD.ActionId = Convert.ToInt32(dr["ActionId"]);
                        objD.Action   = Convert.ToString(dr["Action"]);
                        objD.Total    = Convert.ToInt32(dr["TotalCount"]);
                        objD.OverDue  = Convert.ToInt32(dr["DueCount"]);
                        objD.CssColor = Convert.ToString(dr["CssColor"]);
                        Count_ActionList.Add(objD);
                    }
                    objR.PendingActions = Count_ActionList;
                }
            }
            return(objR);
        }
Пример #6
0
        public NotificationProcessingStatus GetNotificationCountProcessingStatus(DashboardSearch obj)
        {
            NotificationProcessingStatus objNotificationProcessingStatus = new NotificationProcessingStatus();
            DashboardDataManager         objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetNotificationCountProcessingStatus(obj);

            if (ds != null)
            {
                int tblIndex = -1;
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objProcessingStatusList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objProcessingStatusList.Add(objD);
                    }
                    objNotificationProcessingStatus.objPendingFullText = objProcessingStatusList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objProcessingStatusList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objProcessingStatusList.Add(objD);
                    }
                    objNotificationProcessingStatus.objPendingTranslation = objProcessingStatusList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objProcessingStatusList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objProcessingStatusList.Add(objD);
                    }
                    objNotificationProcessingStatus.objToSendtoStakeholder = objProcessingStatusList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objProcessingStatusList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objProcessingStatusList.Add(objD);
                    }
                    objNotificationProcessingStatus.objToDiscuss = objProcessingStatusList;
                }
            }
            return(objNotificationProcessingStatus);
        }
Пример #7
0
        public NotificationRequestResponse GetNotificationCountRequestResponse(DashboardSearch obj)
        {
            NotificationRequestResponse objNotificationRequestResponse = new NotificationRequestResponse();
            DashboardDataManager        objDDM = new DashboardDataManager();
            DataSet ds = objDDM.GetNotificationCountRequestResponse(obj);

            if (ds != null)
            {
                int tblIndex = -1;
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objRequestandResponseList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objRequestandResponseList.Add(objD);
                    }
                    objNotificationRequestResponse.objRequestForFullText = objRequestandResponseList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objRequestandResponseList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objRequestandResponseList.Add(objD);
                    }
                    objNotificationRequestResponse.objRequestForTranslation = objRequestandResponseList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    List <NotificationTextCount> objRequestandResponseList = new List <NotificationTextCount>();
                    foreach (DataRow dr in ds.Tables[tblIndex].Rows)
                    {
                        NotificationTextCount objD = new NotificationTextCount();
                        objD.Text  = Convert.ToString(dr["Text"]);
                        objD.Count = Convert.ToString(dr["NotificationCount"]);
                        objRequestandResponseList.Add(objD);
                    }
                    objNotificationRequestResponse.objRequestForStakeholderResponse = objRequestandResponseList;
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    objNotificationRequestResponse.ClosedCount = Convert.ToString(ds.Tables[tblIndex].Rows[0]["NotificationCount"]);
                }
                tblIndex++;
                if (ds.Tables.Count > tblIndex && ds.Tables[tblIndex].Rows.Count > 0)
                {
                    objNotificationRequestResponse.LapsedCount = Convert.ToString(ds.Tables[tblIndex].Rows[0]["NotificationCount"]);
                }
            }
            return(objNotificationRequestResponse);
        }