public ActionResult GoToFinish(int UserID, int PlanID, int Flag, string AlertDate)
{
SqlFunctionalOperation GoToFinish = new SqlFunctionalOperation();
int i = GoToFinish.UpdateCompletion(UserID, PlanID, Flag, AlertDate);
return(Json(i));
}
public ActionResult DisplayTA(int UserID)
{
SqlFunctionalOperation DisplayTodayAlert = new SqlFunctionalOperation();
string[][] TodayAlert = DisplayTodayAlert.SearchTA(UserID);
return(Json(TodayAlert));
}
public ActionResult UpdateTimeFromTA(int UserID, int PlanID, int TodayAlertID, string NewTimeFromTA)
{
SqlFunctionalOperation UpdateTimeFromTodayAlert = new SqlFunctionalOperation();
int i = UpdateTimeFromTodayAlert.UpdateTimeFromTA(UserID, PlanID, TodayAlertID, NewTimeFromTA);
return(Json(i));
}
public ActionResult UpdatePlan(int UserID, int PlanID, string Project, string NewValue)
{
SqlFunctionalOperation updateplan = new SqlFunctionalOperation();
int i = updateplan.UpdatePlan(UserID, PlanID, Project, NewValue);
return(Json(i));
}
public ActionResult SearchBSPlan(int UserID)
{
SqlFunctionalOperation searchBSplan = new SqlFunctionalOperation();
string[][] BSPlan = searchBSplan.SearchBSPlan(UserID);
return(Json(BSPlan));
}
public ActionResult InsertBSPlan(int UserID, string Project, string Frequency, string Time, string Date, int Type)
{
SqlFunctionalOperation insertBSplan = new SqlFunctionalOperation();
string[][] i = insertBSplan.InsertBSPlan(UserID, Project, Frequency, Time, Date, Type);
return(Json(i));
}
public ActionResult SearchGoals(int UserID)
{
SqlFunctionalOperation searchgoals = new SqlFunctionalOperation();
ControlGoals controlgoalsresults = new ControlGoals();
controlgoalsresults = searchgoals.SearchControlGoals(UserID);
return(Json(controlgoalsresults));
}
public ActionResult UpateGoals(int UserID, float HbA1c, float FPG, bool FPGflag, float PPG, bool PPGflag, float BPH, float BPL, float Tch, bool Tchflag, float LDLch, bool LDLchflag, float HDLch, bool HDLchflag, float TG, bool TGflag, float Ua, bool Uaflag, float AlbCr, bool AlbCrflag, float Athlete, float Weight)
{
ControlGoalsResults newcontrolgoals = new ControlGoalsResults();
newcontrolgoals.UserID = UserID;
newcontrolgoals.HbA1c = HbA1c;
newcontrolgoals.FPG = FPG;
newcontrolgoals.FPGflag = FPGflag;
newcontrolgoals.PPG = PPG;
newcontrolgoals.PPGflag = PPGflag;
newcontrolgoals.BPH = BPH;
newcontrolgoals.BPL = BPL;
newcontrolgoals.Tch = Tch;
newcontrolgoals.Tchflag = Tchflag;
newcontrolgoals.LDLch = LDLch;
newcontrolgoals.LDLchflag = LDLchflag;
newcontrolgoals.HDLch = HDLch;
newcontrolgoals.HDLchflag = HDLchflag;
newcontrolgoals.TG = TG;
newcontrolgoals.TGflag = TGflag;
newcontrolgoals.Ua = Ua;
newcontrolgoals.Uaflag = Uaflag;
newcontrolgoals.AlbCr = AlbCr;
newcontrolgoals.AlbCrflag = AlbCrflag;
newcontrolgoals.Athlete = Athlete;
newcontrolgoals.Weight = Weight;
SqlFunctionalOperation updategoals = new SqlFunctionalOperation();
int i = updategoals.UpdateControlGoals(newcontrolgoals);
SqlFunctionalOperation searchgoals = new SqlFunctionalOperation();
ControlGoals controlgoalsresults = new ControlGoals();
controlgoalsresults = searchgoals.SearchControlGoals(UserID);
return(Json(controlgoalsresults));
}
