public ActionResult SaveGoalMetric(FormCollection collection) { var existingRecord = Boolean.Parse(collection["goal-metric-existing-record"].ToString()); var id = Guid.Parse(collection["goal-metric-id"].ToString()); var goalId = collection["goal-metric-goalid"].ToString(); var planId = collection["goal-metric-planid"].ToString(); var industry = collection["goal-metric-industry"].ToString(); var value = collection["goal-metric-value"].ToString(); var valueAsOf = collection["goal-metric-value-as-of"].ToString(); PlanPerformance.Business.Entities.GoalMetric goalMetric; if (existingRecord == false) { goalMetric = new PlanPerformance.Business.Entities.GoalMetric(); } else { goalMetric = new PlanPerformance.Business.Entities.GoalMetric(id); } goalMetric.GoalId = Guid.Parse(goalId); goalMetric.PlanId = Guid.Parse(planId); goalMetric.Industry = industry; goalMetric.Value = Decimal.Parse(value); goalMetric.ValueAsOf = DateTime.Parse(valueAsOf); var userDih = DataIntegrationHub.Business.Entities.User.AllUsers().Find(x => x.EmailAddress.ToUpper() == User.Identity.Name.ToUpper()); goalMetric.SaveRecordToDatabase(userDih.UserId); return(View()); }
public static List <GoalMetric> Get() { var result = new List <GoalMetric>(); var dataTable = Access.DbAccess.ExecuteSqlQuery("SELECT " + _tableName + "Id FROM " + _tableName); foreach (DataRow row in dataTable.Rows) { var id = Guid.Parse(row[_tableName + "Id"].ToString()); var goal = new GoalMetric(id); result.Add(goal); } return(result); }
public GoalMetric GetGoalMetric() { var goal = new Goal(this.GoalId); var goalMetrics = GoalMetric.Get().FindAll(x => x.GoalId == goal.Id && x.ValueAsOf <= this.ValueAsOf); if (goal.Team == "RetireAdvisers") { //return goalMetrics.Find(x => x.Industry == this.GetPlan().Industry); return(goalMetrics.Find(x => x.PlanId == this.PlanId)); } else if (goal.Team == "Vendor Services") { return(goalMetrics.Find(x => x.PlanId == this.PlanId)); } else { return(goalMetrics.FirstOrDefault()); } }
public ActionResult DeleteGoalMetric(FormCollection collection) { var id = collection["goal-metric-id"].ToString(); var goalMetric = new PlanPerformance.Business.Entities.GoalMetric(); if (String.IsNullOrWhiteSpace(id)) { return(View()); } else { goalMetric = new PlanPerformance.Business.Entities.GoalMetric(Guid.Parse(id)); var userDih = DataIntegrationHub.Business.Entities.User.AllUsers().Find(x => x.EmailAddress.ToUpper() == User.Identity.Name.ToUpper()); goalMetric.DeleteRecordFromDatabase(userDih.UserId); } return(View()); }
public ActionResult GoalMetric() { var id = Request.QueryString["id"]; var goalId = Request.QueryString["goalId"]; var goalMetric = new PlanPerformance.Business.Entities.GoalMetric(); if (!String.IsNullOrWhiteSpace(goalId)) { goalMetric.GoalId = Guid.Parse(goalId); } if (String.IsNullOrWhiteSpace(id)) { ViewBag.Title = "New Plan Metric"; goalMetric.ValueAsOf = DateTime.Now; } else { goalMetric = new PlanPerformance.Business.Entities.GoalMetric(Guid.Parse(id)); //ViewBag.Title = planMetric.Name; } return(View(goalMetric)); }