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