public ActionResult OrganizationDashboard(int?user, int?OrgId, int?CompanyID, int?SiteID, int?AccountID, int?AccountTypeID, decimal?Rating)
{
ViewBag.OrgID = new SelectList(wpsModel.GetAllOrganization(), "OrgID", "Description");
ViewBag.CompanyID = new SelectList(wpsModel.GetAllCompaniesByOrgId(OrgId.Value), "CompanyID", "CompanyName");
ViewBag.SiteID = new SelectList(wpsModel.GetAllReviewSites(), "SiteID", "SiteName");
ViewBag.AccountID = new SelectList(wpsModel.GetAllComAccounts(), "ID", "MiddleName");
ViewBag.AccountType = new SelectList(wpsModel.GetAllActType(), "ID", "Description");
var mDashboard = new mDashboard();
mDashboard.ComList = wpsModel.GetAllCompanies();
mDashboard.ComCount = mDashboard.ComList.Count();
mDashboard.ActList = wpsModel.GetAllComAccounts();
mDashboard.ActCount = mDashboard.ActList.Count();
var respGetReviews = wpsModel.Sp_ReviewsSitesList((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%", (Rating > 0 && Rating.HasValue) ? Rating.ToString() : "%");
mDashboard.RevCount = respGetReviews.Sum(x => x.TotalReview.Value);
var respGetAccount = wpsModel.SP_Get_Account_By_Company((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (OrgId > 0 && OrgId.HasValue) ? OrgId.ToString() : "%");
mDashboard.SP_Get_Account_By_Company = respGetAccount.ToList();
mDashboard.ReviewsSitesList = respGetReviews.ToList();
return(View(mDashboard));
}
public ActionResult Dashboard(int?user, int?OrgId, int?CompanyId, int?SiteID, int?AccountID, int?AccountTypeID, decimal?Rating)
{
ViewBag.SiteID = new SelectList(wpsModel.GetAllReviewSites(), "SiteID", "SiteName");
ViewBag.AccountID = new SelectList(wpsModel.GetAllComAccounts(), "ID", "MiddleName");
ViewBag.AccountType = new SelectList(wpsModel.GetAllActType(), "ID", "Description");
var mDashboard = new mDashboard();
#region Reviews Site List
mDashboard.ActList = wpsModel.GetAllComAccounts();
mDashboard.ActCount = mDashboard.ActList.Count();
var respGetReviews = wpsModel.Sp_ReviewsSitesList((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%", (Rating > 0 && Rating.HasValue) ? Rating.ToString() : "%");
mDashboard.RevCount = respGetReviews.Sum(x => x.TotalReview.Value);
var respReviewInfo = wpsModel.Sp_ReviewsSitesList((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%", (Rating > 0 && Rating.HasValue) ? Rating.ToString() : "%").ToList();
mDashboard.ReviewsSitesList = respReviewInfo.ToList();
var respBWordInfo = wpsModel.SP_Review_WordCount_Dashboard_HI(1);
mDashboard.BadCount = respBWordInfo.Select(x => x.WrdTypeCount).FirstOrDefault();
var respGWordInfo = wpsModel.SP_Review_WordCount_Dashboard_HI(2);
mDashboard.GoodCount = respGWordInfo.Select(x => x.WrdTypeCount).FirstOrDefault();
#endregion
return(View(mDashboard));
}
public ActionResult ReviewDashboard(int?user, int?OrgId, int?CompanyId, int?SiteID, int?AccountID, int?AccountTypeID, decimal?Rating)
{
ViewBag.SiteID = new SelectList(wpsModel.GetAllReviewSites(), "SiteID", "SiteName");
ViewBag.AccountID = new SelectList(wpsModel.GetAllComAccounts(), "ID", "MiddleName");
ViewBag.AccountType = new SelectList(wpsModel.GetAllActType(), "ID", "Description");
var mDashboard = new mDashboard();
#region Dashboard Pie Chart and Gridview
//var respChartInfo = wpsModel.SP_Reviews_Chart_Dashboard_TR((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%").ToList();
//cDashboard.ReviewsChartDashboardTR = respChartInfo.ToList();
#endregion
return(View(mDashboard));
}
public JsonResult ReviewList(int?SiteID, int?AccountID, int?AccountTypeID, decimal?Rating)
{
try
{
mDashboard mDash = new mDashboard();
var respReviewInfo = wpsModel.Sp_ReviewsSitesList((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%", (Rating > 0 && Rating.HasValue) ? Rating.ToString() : "%").ToList();
mDash.ReviewsSitesList = respReviewInfo.ToList();
return(Json(new { reviewSite = mDash }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review site list is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult GetwordDescBarChartList(int?user, int?OrgId, int?CompanyID, int?SiteID, int?AccountID, int?AccountTypeID, int?WrdTypeID)
{
try
{
mDashboard mDashboard = new mDashboard();
var respWordDescList = wpsModel.SP_WordDesc_MonthWise_BarChart_Dashboard_HI((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "0", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "0", (WrdTypeID > 0 && WrdTypeID.HasValue) ? WrdTypeID.ToString() : "0");
mDashboard.SP_WordDesc_MonthWise_BarChart_Dashboard_HI = respWordDescList.ToList();
return(Json(new { worddescbar = mDashboard }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review bar chart details is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult GetCompanyOrgdash(int?OrgId, int?CompanyID)
{
try
{
mDashboard mDashboard = new mDashboard();
var respGetOrgList = wpsModel.SP_Get_Account_By_Company((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (OrgId > 0 && OrgId.HasValue) ? OrgId.ToString() : "%");
mDashboard.SP_Get_Account_By_Company = respGetOrgList.ToList();
return(Json(new { organizationcompany = mDashboard }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review chart details is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult ReviewCompanyLineChartList(int?user, int?OrgId, int?CompanyID, int?SiteID, int?AccountID, int?AccountTypeID)
{
try
{
mDashboard eDash = new mDashboard();
var respCompanyInfo = wpsModel.SP_Reviews_Line_CompanyWise_Dashboard((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "0", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "0").ToList();
eDash.SP_Reviews_Line_CompanyWise_Dashboard = respCompanyInfo.ToList();
return(Json(new { reviewsCompanyLineChart = eDash }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review chart details is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult GetorgAdmindash(string OrgName)
{
try
{
mDashboard mDashboard = new mDashboard();
var respGetOrgList = wpsModel.SP_GetCompanies_By_Organization(String.IsNullOrEmpty(OrgName) ? "%" : "%" + OrgName + "%");
mDashboard.SP_GetCompanies_By_Organization = respGetOrgList.ToList();
return(Json(new { orgcompany = mDashboard }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review chart details is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult ReviewChartList(int?SiteID, int?AccountID, int?AccountTypeID)
{
try
{
mDashboard mDash = new mDashboard();
var respChartInfo = wpsModel.SP_Reviews_Chart_Dashboard_TR((SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "%", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "%").ToList();
mDash.ReviewsPieChartDashboardTR = respChartInfo.ToList();
return(Json(new { reviewsPieChart = mDash }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review chart details is failed. {0}", ex.Message));
throw e;
}
}
public JsonResult GetwordCountCloudCharts(int?user, int?OrgId, int?CompanyID, int?SiteID, int?AccountID, int?AccountTypeID)
{
try
{
mDashboard mDashboard = new mDashboard();
var respWordCountList = wpsModel.SP_WordCount_Desc_CloudChart_Dashboard_HI((CompanyID > 0 && CompanyID.HasValue) ? CompanyID.ToString() : "%", (SiteID > 0 && SiteID.HasValue) ? SiteID.ToString() : "%", (AccountID > 0 && AccountID.HasValue) ? AccountID.ToString() : "0", (AccountTypeID > 0 && AccountTypeID.HasValue) ? AccountTypeID.ToString() : "0");
mDashboard.wordCloudData = respWordCountList.Select(p => new wordCloud {
x = p.Word, value = p.WordCount, Category = p.WorType
}).ToList();
return(Json(new { wordcloudcount = mDashboard }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
var e = new Exception(string.Format("Review bar chart details is failed. {0}", ex.Message));
throw e;
}
}
public ActionResult AdminDashboard(int?user, int?OrgId, int?CompanyId, string OrgName)
{
var mDashboard = new mDashboard();
mDashboard.OrgList = wpsModel.GetAllOrganization();
mDashboard.OrgCount = mDashboard.OrgList.Count();
mDashboard.ComList = wpsModel.GetAllCompanies();
mDashboard.ComCount = mDashboard.ComList.Count();
mDashboard.ActList = wpsModel.GetAllComAccounts();
mDashboard.ActCount = mDashboard.ActList.Count();
mDashboard.SiteList = wpsModel.GetAllReviewSites();
mDashboard.SitCount = mDashboard.SiteList.Count();
var respGetOrgList = wpsModel.SP_GetCompanies_By_Organization(String.IsNullOrEmpty(OrgName) ? "%" : OrgName);
mDashboard.SP_GetCompanies_By_Organization = respGetOrgList.ToList();
mDashboard.SiteList = wpsModel.GetAllReviewSites();
return(View(mDashboard));
}
