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);
        }
        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);
        }