public ActionResult DeleteConfirmed(int id) { using (Nutrition db = new Nutrition()) { G3_Nutrition_Nutrition table = db.G3_Nutrition_Nutrition.Find(id); db.G3_Nutrition_Nutrition.Remove(table); db.SaveChanges(); return(RedirectToAction("View", "Nutrition", new { id = table.UserId })); } }
public ActionResult Edit(int id = 0) { using (Nutrition db = new Nutrition()) { G3_Nutrition_Nutrition table = db.G3_Nutrition_Nutrition.Find(id); if (table == null) { return(HttpNotFound()); } ViewBag.Message = "編輯建議"; return(View(table)); } }
public ActionResult Edit(G3_Nutrition_Nutrition table) { using (Nutrition db = new Nutrition()) { if (ModelState.IsValid) { table.Date = DateTime.Now; db.Entry(table).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "Nutrition")); } } return(RedirectToAction("View", "Nutrition", new { id = table.UserId })); }
public ActionResult Create(SystemNutrition A) { G3_Nutrition_Nutrition B = new G3_Nutrition_Nutrition(); B.UserId = A.Nutrition.UserId; B.Title = A.Nutrition.Title; B.Content = A.Nutrition.Content; B.Doctor = User.Identity.Name; B.Date = DateTime.Now; using (Nutrition db = new Nutrition()) { db.G3_Nutrition_Nutrition.Add(B); db.SaveChanges(); } return(RedirectToAction("Index", "Nutrition")); }
public ActionResult UserView(int WhereKey = 0, string Name = null) { SystemNutrition C = new SystemNutrition(); List <G3_Nutrition_Nutrition> list = new List <G3_Nutrition_Nutrition>(); C.WhereKey = WhereKey; using (AIPEntities18 db = new AIPEntities18()) { var reuslt = db.G1_User_Account.ToList(); foreach (var item in reuslt) { if (Name == item.email) { C.NutritionId = item.id; C.UserName = item.email; } } } using (Nutrition db = new Nutrition()) { var reuslt = db.G3_Nutrition_Nutrition.ToList(); foreach (var item in reuslt) { if (C.NutritionId == item.UserId) { G3_Nutrition_Nutrition Data = new G3_Nutrition_Nutrition(); Data.Id = item.Id; Data.UserId = item.UserId; Data.Title = item.Title; Data.Content = item.Content; Data.Doctor = item.Doctor; Data.Date = item.Date; list.Add(Data); } } } C.NutritionList = list; ViewBag.Message = "建議檢視"; return(View(C)); }
public ActionResult Details(int id = 0, string name = null) { SystemNutrition C = new SystemNutrition(); C.UserName = name; using (Nutrition db = new Nutrition()) { G3_Nutrition_Nutrition table = db.G3_Nutrition_Nutrition.Find(id); if (table == null) { return(HttpNotFound()); } else { C.Nutrition = table; } } return(View(C)); }
public ActionResult Create(string Name = null) { SystemNutrition D = new SystemNutrition(); G3_Nutrition_Nutrition B = new G3_Nutrition_Nutrition(); HealthyScore Healthy = new HealthyScore(); UserHealthyInformation C = new UserHealthyInformation(); using (AIPEntities18 db = new AIPEntities18()) { var reuslt = db.G1_User_Account.ToList(); foreach (var item in reuslt) { if (Name == item.email) { B.UserId = item.id; } } } D.UserName = Name; D.Nutrition = B; using (AIPEntities7 db = new AIPEntities7()) { int number = 1; var reuslt = db.G3_Measure_BloodPressure.ToList(); G3_Measure_BloodPressure History = new G3_Measure_BloodPressure(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.SBP = item.SBP; History.DBP = item.DBP; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.SBP = item.SBP; History.DBP = item.DBP; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.BloodPressure = History; } } using (AIPEntities9 db = new AIPEntities9()) { int number = 1; var reuslt = db.G3_Measure_ABG.ToList(); G3_Measure_ABG History = new G3_Measure_ABG(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.SpO2 = item.SpO2; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.SpO2 = item.SpO2; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.ABG = History; } } using (AIPEntities8 db = new AIPEntities8()) { int number = 1; var reuslt = db.G3_Measure_BloodGlucose.ToList(); G3_Measure_BloodGlucose History = new G3_Measure_BloodGlucose(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.GLU_AC = item.GLU_AC; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.GLU_AC = item.GLU_AC; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.BloodGlucose = History; } } using (AIPEntities11 db = new AIPEntities11()) { int number = 1; var reuslt = db.G3_Measure_BMI.ToList(); G3_Measure_BMI History = new G3_Measure_BMI(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.BMI = item.BMI; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.BMI = item.BMI; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.BMI = History; } } using (AIPEntities25 db = new AIPEntities25()) { int number = 1; var reuslt = db.G3_Measure_Air.ToList(); G3_Measure_Air History = new G3_Measure_Air(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.Air = item.Air; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.Air = item.Air; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.Air = History; } } using (GSR db = new GSR()) { int number = 1; var reuslt = db.G3_Measure_GSR.ToList(); G3_Measure_GSR History = new G3_Measure_GSR(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.SkinConductance = item.SkinConductance; History.SkinResistance = item.SkinResistance; History.SkinConductanceVoltage = item.SkinConductanceVoltage; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.SkinConductance = item.SkinConductance; History.SkinResistance = item.SkinResistance; History.SkinConductanceVoltage = item.SkinConductanceVoltage; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.GSR = History; } } using (GyroValues db = new GyroValues()) { int number = 1; var reuslt = db.G3_Measure_GyroValues.ToList(); G3_Measure_GyroValues History = new G3_Measure_GyroValues(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.RawX = item.RawX; History.RawY = item.RawY; History.RawZ = item.RawZ; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.RawX = item.RawX; History.RawY = item.RawY; History.RawZ = item.RawZ; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.GyroValues = History; } } using (bodyTemperature db = new bodyTemperature()) { int number = 1; var reuslt = db.G3_Measure_Temperature.ToList(); G3_Measure_Temperature History = new G3_Measure_Temperature(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.Temperature = item.Temperature; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.Temperature = item.Temperature; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.Temperature = History; } } using (Pulse db = new Pulse()) { int number = 1; var reuslt = db.G3_Measure_Pulse.ToList(); G3_Measure_Pulse History = new G3_Measure_Pulse(); foreach (var item in reuslt) { if (B.UserId == item.Userid && number == 1) { History.Userid = item.Userid; History.Pulse = item.Pulse; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; number = number + 1; } else if (B.UserId == item.Userid && number != 1) { if (DateTime.Compare(item.MeasurementDate, History.MeasurementDate) > 0) { History.Pulse = item.Pulse; History.MeasurementDate = item.MeasurementDate; History.Status = item.Status; History.Score = item.Score; } } C.Pulse = History; } } Healthy.HealthyInformation = C; Healthy.Total = C.ABG.Score + C.BloodGlucose.Score + C.BloodPressure.Score + C.BMI.Score + C.Air.Score + C.GSR.Score + C.GyroValues.Score + C.Pulse.Score + C.Temperature.Score; D.UserHealthy = Healthy; ViewBag.Message = "新增建議"; return(View(D)); }