public ActionResult showdailyCharts(FilterAndPagerInfo filterInfo) { repository objRep = new repository(); List <FinTracker.Models.Filter> f = filterInfo.Filters != null?filterInfo.Filters.ToList() : new List <FinTracker.Models.Filter>(); User loginUser = Common.GetUser; f.Add(new Models.Filter() { Key = "rcid", Value = loginUser.UserId }); if (Common.GetUser.IsAdmin) { // f.Clear();//he should get all the users of that team. //f.Add(new Models.Filter() { Key = "team", Value = loginUser.AssignedTeam }); filterInfo.Filters = f.ToArray(); } JavaScriptSerializer serializer = new JavaScriptSerializer(); WMDashboardInfoList data = objRep.GetChartData(filterInfo); //build a string to pass on to the UI layer. StringBuilder sb = new StringBuilder(); foreach (WMDashboardInfo info in data.LstByProc) { sb.AppendFormat("['{0}', {1}, {2}]", info.User, info.Target.ToString(), info.TotalTime.ToString()); } ViewBag.Processor = sb.ToString(); ViewBag.ProcessorByAct = serializer.Serialize(data.LstByProcAct); ViewBag.Reviewer = serializer.Serialize(data.LstByRev); ViewBag.ReviewerByAct = serializer.Serialize(data.LstByRevAct); return(PartialView()); }
public JsonResult getPending(FilterAndPagerInfo objFilterInfo) { WMViewModel wms = new WMViewModel("", false); repository getdata = new repository(); wms = getdata.getPendingList(objFilterInfo); return(Json(wms, JsonRequestBehavior.AllowGet)); }
public ActionResult getChartsData(FilterAndPagerInfo filterInfo) { repository objRep = new repository(); //FilterAndPagerInfo filterInfo = new FilterAndPagerInfo(); List <FinTracker.Models.Filter> f = filterInfo.Filters != null?filterInfo.Filters.ToList() : new List <FinTracker.Models.Filter>(); User loginUser = Common.GetUser; Dictionary <String, procActivityData> procActivities = new Dictionary <String, procActivityData>(); //For testing f.Add(new Models.Filter() { Key = "startdate", Value = "2017-12-29" }); if (!Common.GetUser.IsAdmin) { f.Clear();//he should get all the users of that team. f.Add(new Models.Filter() { Key = "rcid", Value = loginUser.UserId }); filterInfo.Filters = f.ToArray(); } JavaScriptSerializer serializer = new JavaScriptSerializer(); WMDashboardInfoList data = objRep.GetChartData(filterInfo); List <String> activities = new List <String>(); int cnt = 0; //build a string to pass on to the UI layer. StringBuilder sb = new StringBuilder(); foreach (WMDashboardInfo info in data.LstByProc) { if (cnt > 0) { sb.Append(","); } sb.AppendFormat("['{0}', {1}, {2}]", info.User, info.Target.ToString(), info.TotalTime.ToString()); cnt++; } sb.Append("|"); //Activites only cnt = 0; if (data.LstByProcAct.Count > 0) { sb.Append("['Name',"); sb.Append("'Target Hrs',"); //from db if we get pivot table also we can't guarantee that columns will always be same. //So writing a code that seggregates the values based on the activities foreach (WMDashboardInfo info in data.LstByProcAct) { if (!activities.Exists(p => p == info.Activity)) { if (cnt > 0) { sb.Append(","); } activities.Add(info.Activity); sb.AppendFormat("'{0}'", info.Activity); } cnt++; } sb.Append("]"); } //We have the activities that are not duplicated so for every user initialize the activities. foreach (WMDashboardInfo info in data.LstByProcAct) { Dictionary <String, String> objActs = new Dictionary <String, String>(); foreach (String act in activities) { objActs.Add(act, "0.0"); } if (!procActivities.ContainsKey(info.User)) { procActivities.Add(info.User, new procActivityData() { actList = objActs, totTime = info.Target }); } } sb.Append("|"); //Processor by Activity cnt = 0; foreach (String act in activities) //This need to be changed to accommodate user grouping and summation { //For all the available activities we should have an entry foreach (WMDashboardInfo info in data.LstByProcAct) // check this activity exists for this processor then assign the total time otherwise 0 { if (act == info.Activity) { procActivities[info.User].actList[act] = info.TotalTime.ToString(); } } } foreach (KeyValuePair <String, procActivityData> info in procActivities) //This need to be changed to accommodate user grouping and summation { if (cnt > 0) { sb.Append(","); } sb.AppendFormat("['{0}', {1}", info.Key, info.Value.totTime); info.Value.actList.ToList().ForEach(p => sb.AppendFormat(",{0}", p.Value)); sb.Append("]"); cnt++; } sb.Append("|"); //Review information cnt = 0; foreach (WMDashboardInfo info in data.LstByRev) { if (cnt > 0) { sb.Append(","); } sb.AppendFormat("['{0}', {1}, {2}]", info.User, info.Target.ToString(), info.TotalTime.ToString()); cnt++; } sb.Append("|"); //Reviewer Activites only activities.Clear(); procActivities.Clear(); if (data.LstByRevAct.Count > 0) { sb.Append("['Name',"); sb.Append("'Target Hrs',"); cnt = 0; foreach (WMDashboardInfo info in data.LstByRevAct) { if (!activities.Exists(p => p == info.Activity)) { if (cnt > 0) { sb.Append(","); } activities.Add(info.Activity); sb.AppendFormat("'{0}'", info.Activity); } cnt++; } sb.Append("]"); } foreach (WMDashboardInfo info in data.LstByRevAct) { Dictionary <String, String> objActs = new Dictionary <String, String>(); foreach (String act in activities) { objActs.Add(act, "0.0"); } if (!procActivities.ContainsKey(info.User)) { procActivities.Add(info.User, new procActivityData() { actList = objActs, totTime = info.Target }); } } sb.Append("|"); //Reviewer by Activity cnt = 0; foreach (WMDashboardInfo info in data.LstByRevAct) //This need to be changed to accommodate user grouping and summation { //For all the available activities we should have an entry foreach (String act in activities) // check this activity exists for this processor then assign the total time otherwise 0 { if (act == info.Activity) { procActivities[info.User].actList[act] = info.TotalTime.ToString(); } } } foreach (KeyValuePair <String, procActivityData> info in procActivities) //This need to be changed to accommodate user grouping and summation { if (cnt > 0) { sb.Append(","); } sb.AppendFormat("['{0}', {1}", info.Key, info.Value.totTime); info.Value.actList.ToList().ForEach(p => sb.AppendFormat(",{0}", p.Value)); sb.Append("]"); cnt++; } TempData["Processor"] = sb.ToString(); //Wanted to use this information in another action method when exporting to excel sheet. return(Json(TempData["Processor"], JsonRequestBehavior.AllowGet)); }