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