public void GetPracticesInObjective(string userId) { //Get Connection from config file string connString = System.Configuration.ConfigurationManager. ConnectionStrings["killthetest"].ConnectionString; using (SqlConnection connection = new SqlConnection(connString)) { connection.Open(); using (SqlCommand command = new SqlCommand()) { command.Connection = connection; command.CommandTimeout = 0; command.CommandType = System.Data.CommandType.StoredProcedure; command.CommandText = "dbo.get_objective_Practices"; command.Parameters.AddWithValue("objective_id", ObjectiveId); SqlDataReader dr = command.ExecuteReader(); int PracticeId = 0; while (dr.Read()) { PracticeId = int.Parse(dr["Practice_id"].ToString()); Practice l = new Practice(); l.PracticeId = PracticeId; l.GetPractice(userId); PracticesInObjective.Add(l); } connection.Close(); } } }
public Practice PreviousPractice() { Practice previousId = null; foreach (Practice l in PracticesInObjective)//assume sortted by order { if (l.PracticeId == PracticeId) { return(previousId); } else { previousId = l; } } return(null); //First Practice? }