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