public ActionResult SavePlanMetric(FormCollection collection) { var existingRecord = Boolean.Parse(collection["plan-metric-existing-record"].ToString()); var id = Guid.Parse(collection["plan-metric-id"].ToString()); var goalId = collection["plan-metric-goalid"].ToString(); var planId = collection["plan-metric-planid"].ToString(); var value = collection["plan-metric-value"].ToString(); var valueAsOf = collection["plan-metric-value-as-of"].ToString(); var isBaseline = collection["plan-metric-is-baseline"].ToString().Replace(",false", ""); PlanPerformance.Business.Entities.PlanMetric planMetric; if (existingRecord == false) { planMetric = new PlanPerformance.Business.Entities.PlanMetric(); } else { planMetric = new PlanPerformance.Business.Entities.PlanMetric(id); } planMetric.GoalId = Guid.Parse(goalId); planMetric.PlanId = Guid.Parse(planId); planMetric.Value = Decimal.Parse(value); planMetric.ValueAsOf = DateTime.Parse(valueAsOf); planMetric.IsBaseline = bool.Parse(isBaseline); var userDih = DataIntegrationHub.Business.Entities.User.AllUsers().Find(x => x.EmailAddress.ToUpper() == User.Identity.Name.ToUpper()); planMetric.SaveRecordToDatabase(userDih.UserId); return(View()); }
public static List <PlanMetric> Get() { var result = new List <PlanMetric>(); 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 PlanMetric(id); result.Add(goal); } return(result); }
public ActionResult DeletePlanMetric(FormCollection collection) { var id = collection["plan-metric-id"].ToString(); var planMetric = new PlanPerformance.Business.Entities.PlanMetric(); if (String.IsNullOrWhiteSpace(id)) { return(View()); } else { planMetric = new PlanPerformance.Business.Entities.PlanMetric(Guid.Parse(id)); var userDih = DataIntegrationHub.Business.Entities.User.AllUsers().Find(x => x.EmailAddress.ToUpper() == User.Identity.Name.ToUpper()); planMetric.DeleteRecordFromDatabase(userDih.UserId); } return(View()); }
public ActionResult PlanMetric() { var id = Request.QueryString["id"]; var planId = Request.QueryString["planId"]; var planMetric = new PlanPerformance.Business.Entities.PlanMetric(); if (!String.IsNullOrWhiteSpace(planId)) { planMetric.PlanId = Guid.Parse(planId); } if (String.IsNullOrWhiteSpace(id)) { ViewBag.Title = "New Plan Metric"; planMetric.ValueAsOf = DateTime.Now; } else { planMetric = new PlanPerformance.Business.Entities.PlanMetric(Guid.Parse(id)); //ViewBag.Title = planMetric.Name; } return(View(planMetric)); }