public static ObservableCollection <Modality> GetModalities() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var modalities = new ObservableCollection <Modality>(); using (var cmd = new SqlCommand("SELECT * FROM CluSys.F_GetModalities ()", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { modalities.Add(new Modality { Name = reader["Name"].ToString(), RecognitionYear = int.Parse(reader["RecognitionYear"].ToString()), }); } } } return(modalities); } }
public MedicalEvaluation GetMedicalEvaluation() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); MedicalEvaluation evaluation; using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetEvaluation ({EvalId});", cn)) { using (var reader = cmd.ExecuteReader()) { if (!reader.Read()) { return(null); } evaluation = new MedicalEvaluation { Id = int.Parse(reader["Id"].ToString()), Weight = double.TryParse(reader["Weight"].ToString(), out double weight) ? (double?)weight : null, Height = double.TryParse(reader["Height"].ToString(), out double height) ? (double?)height : null, Story = reader["Story"].ToString(), OpeningDate = DateTime.Parse(reader["OpeningDate"].ToString()), ClosingDate = DateTime.TryParse(reader["ClosingDate"].ToString(), out DateTime closingDate) ? (DateTime?)closingDate : null, ExpectedRecovery = DateTime.TryParse(reader["ExpectedRecovery"].ToString(), out DateTime expectedRecovery) ? (DateTime?)expectedRecovery : null, AthleteCC = reader["AthleteCC"].ToString(), PhysiotherapistCC = reader["PhysiotherapistCC"].ToString() }; } } return(evaluation); } }
/* This function is used! It is called using reflection. */ public ObservableCollection <Athlete> GetAthletes() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var athletes = new ObservableCollection <Athlete>(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetAthletes ('{Name}');", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { athletes.Add(new Athlete { CC = reader["CC"].ToString(), FirstName = reader["FirstName"].ToString(), MiddleName = reader["MiddleName"].ToString(), LastName = reader["LastName"].ToString(), Birthdate = DateTime.Parse(reader["Birthdate"].ToString()), Photo = reader["Photo"].ToString(), Phone = reader["Phone"].ToString(), Email = reader["Email"].ToString(), Password = reader["Password"] as byte[], Job = reader["Job"].ToString(), DominantSide = reader["DominantSide"].ToString(), ModalityId = reader["ModalityId"].ToString(), }); } } } return(athletes); } }
public ObservableCollection <MajorProblem> GetProblems() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var problems = new ObservableCollection <MajorProblem>(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetProblems ({EvalId}, {Id});", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { problems.Add(new MajorProblem { Id = int.Parse(reader["Id"].ToString()), Description = reader["Description"].ToString(), EvalId = int.Parse(reader["EvalId"].ToString()), SessionId = int.Parse(reader["SessionId"].ToString()), }); } } } return(problems); } }
public ObservableCollection <BodyChartMark> GetMarks() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var bodyMarks = new ObservableCollection <BodyChartMark>(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetBodyChartMarks ({EvalId}, {Id})", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { bodyMarks.Add(new BodyChartMark(int.Parse(reader["Id"].ToString())) { X = double.Parse(reader["X"].ToString()), Y = double.Parse(reader["Y"].ToString()), PainLevel = int.Parse(reader["PainLevel"].ToString()), Description = reader["Description"].ToString(), EvalId = int.Parse(reader["EvalId"].ToString()), SessionId = int.Parse(reader["SessionId"].ToString()), ViewId = int.Parse(reader["ViewId"].ToString()), }); } } } return(bodyMarks); } }
public static ObservableCollection <BodyChartView> GetViews() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var bodyViews = new ObservableCollection <BodyChartView>(); using (var cmd = new SqlCommand("SELECT * FROM CluSys.F_GetBodyViews();", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { bodyViews.Add(new BodyChartView { Id = int.Parse(reader["Id"].ToString()), Image = reader["Image"].ToString(), Order = int.Parse(reader["Order"].ToString()), }); } } } return(bodyViews); } }
public static ObservableCollection <Annotation> GetAnnotations() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var annotations = new ObservableCollection <Annotation>(); using (var cmd = new SqlCommand("SELECT * FROM CluSys.F_GetAnnotations();", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { annotations.Add(new Annotation { Symbol = reader["Symbol"].ToString(), Meaning = reader["Meaning"].ToString(), }); } } } return(annotations); } }
public ObservableCollection <SessionObservation> GetObservations() { var obs = new ObservableCollection <SessionObservation>(); using (var conn = ClusysUtils.GetConnection()) { conn.Open(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetOpenObservations ({Id});", conn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { obs.Add(new SessionObservation { Id = int.Parse(reader["Id"].ToString()), Obs = reader["Obs"].ToString(), DateClosed = string.IsNullOrEmpty(reader["DateClosed"].ToString()) ? null : (DateTime?)DateTime.Parse(reader["DateClosed"].ToString()), EvalId = int.Parse(reader["EvalId"].ToString()), SessionId = int.Parse(reader["SessionId"].ToString()) }); } } } } return(obs); }
public ObservableCollection <MedicalEvaluation> GetEvaluations() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var evaluations = new ObservableCollection <MedicalEvaluation>(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetEvaluations ('{CC}');", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { evaluations.Add(new MedicalEvaluation(evaluations) { Id = int.Parse(reader["Id"].ToString()), Weight = double.TryParse(reader["Weight"].ToString(), out double weight) ? (double?)weight : null, Height = double.TryParse(reader["Height"].ToString(), out double height) ? (double?)height : null, Story = reader["Story"].ToString(), OpeningDate = DateTime.Parse(reader["OpeningDate"].ToString()), ClosingDate = DateTime.TryParse(reader["ClosingDate"].ToString(), out DateTime closingDate) ? (DateTime?)closingDate : null, ExpectedRecovery = DateTime.TryParse(reader["ExpectedRecovery"].ToString(), out DateTime expectedRecovery) ? (DateTime?)expectedRecovery : null, AthleteCC = reader["AthleteCC"].ToString(), PhysiotherapistCC = reader["PhysiotherapistCC"].ToString(), });
public ObservableCollection <TreatmentPlan> GetTreatments() { using (var cn = ClusysUtils.GetConnection()) { cn.Open(); var treatments = new ObservableCollection <TreatmentPlan>(); using (var cmd = new SqlCommand($"SELECT * FROM CluSys.F_GetTreatments ({EvalId}, {Id});", cn)) { using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { treatments.Add(new TreatmentPlan { Id = int.Parse(reader["Id"].ToString()), Description = reader["Description"].ToString(), Objective = reader["Objective"].ToString(), EvalId = int.Parse(reader["EvalId"].ToString()), SessionId = int.Parse(reader["SessionId"].ToString()), ProbId = int.TryParse(reader["ProbId"].ToString(), out int probId) ? (int?)probId : null, });