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 <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 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 DataSet GetNotificationGraphDataWeekly(DashboardSearch obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.Dashboards_NotificationGraphDataWeekly; sqlCommand.Parameters.AddWithValue("@StartDate", obj.DateFrom); return(DAL.GetDataSet(ConfigurationHelper.connectionString, sqlCommand)); } }
public DataSet GetNotificationCountProcessingStatus(DashboardSearch obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.Dashboards_PendingCounts_Discussion; sqlCommand.Parameters.AddWithValue("@FromDate", obj.DateFrom); sqlCommand.Parameters.AddWithValue("@ToDate", obj.DateTo); return(DAL.GetDataSet(ConfigurationHelper.connectionString, sqlCommand)); } }
public DataSet GetHsCodeGraphDataCountryWise(DashboardSearch obj) { using (SqlCommand sqlCommand = new SqlCommand()) { sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.CommandText = Procedures.Dashboards_NotificationCountByCountry; sqlCommand.Parameters.AddWithValue("@DateFrom", obj.DateFrom); sqlCommand.Parameters.AddWithValue("@DateTo", obj.DateTo); sqlCommand.Parameters.AddWithValue("@HSCodes", obj.HSCode); return(DAL.GetDataSet(ConfigurationHelper.connectionString, sqlCommand)); } }
public ActionResult WTOGetHSCodeDataByCountry() { if (Convert.ToString(Session["UserId"]).Trim().Length > 0) { DashboardBusinessService obj = new DashboardBusinessService(); DashboardSearch obj1 = new DashboardSearch(); return(View("~/Views/Partial/Dashboard/DashboardHSCodeByCountry.cshtml", obj.GetHsCodeGraphDataCountryWise(obj1))); } else { return(PartialView("RedirectToLogin")); } }
public ActionResult GetNotificationGraphData(DashboardSearch obj1) { if (Convert.ToString(Session["UserId"]).Trim().Length > 0) { DashboardBusinessService obj = new DashboardBusinessService(); DateTime d = DateTime.Now; d = d.AddMonths(-1); obj1.DateFrom = d.ToString("dd MMM yyyy"); return(View("~/Views/Partial/Dashboard/DashboardNotificationHistory.cshtml", obj.GetNotificationGraphDataMonthly(obj1))); } else { return(PartialView("RedirectToLogin")); } }
public ActionResult GetDashboardAction(DashboardSearch obj) { if (Convert.ToString(Session["UserId"]).Trim().Length > 0) { if (obj.DateFrom == null) { obj.DateFrom = ""; } if (obj.DateTo == null) { obj.DateTo = ""; } ViewBag.FromDate = obj.DateFrom; ViewBag.ToDate = obj.DateTo; DashboardBusinessService objDBS = new DashboardBusinessService(); return(View("~/Views/Partial/Dashboard/DashboardAction.cshtml", objDBS.GetDashboardAction(obj))); } else { return(PartialView("RedirectToLogin")); } }
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); }
public IHttpActionResult WTOGetNotificationGraphDataMonthly(DashboardSearch obj1) { DashboardBusinessService obj = new DashboardBusinessService(); return(Ok(obj.GetNotificationGraphDataMonthly(obj1))); }
public IHttpActionResult WTOGetHSCodeDataByCountry(DashboardSearch obj1) { DashboardBusinessService obj = new DashboardBusinessService(); return(Ok(obj.GetHsCodeGraphDataCountryWise(obj1))); }