public Exercise GetExerciseByID(int exerciseID) { Exercise exercise = new Exercise(); string query = "SELECT * FROM Exercise WHERE ExerciseID = @exerciseID"; helper.AddParameters(new List<SqlParameter>() { new SqlParameter("@exerciseID", exerciseID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); exercise.ExerciseID = exerciseID; exercise.ExerciseType = reader.GetString(1); reader.Close(); return exercise; }
public MyDictionary GetWordByID(int wordID) { string query = "SELECT * FROM Dictionary WHERE WordID = @wordID"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@wordID", wordID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); MyDictionary word = GetWord(reader); reader.Close(); return(word); }
public Payment GetPaymentByID(int paymentID) { string query = "SELECT * FROM Payment WHERE PaymentID = @paymentID"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@paymentID", paymentID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); Payment payment = GetPayment(reader); reader.Close(); return(payment); }
public PaymentType GetTypeByID(int typeID) { string query = "SELECT * FROM PaymentType WHERE TypeID = @typeID"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@typeID", typeID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); PaymentType type = GetPaymentType(reader); reader.Close(); return(type); }
public UserRole GetRoleByID(int RoleID) { UserRole role = new UserRole(); string query = "SELECT * FROM UserRole WHERE RoleID = @roleID"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@roleID", RoleID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); role.RoleID = RoleID; role.RoleName = reader["RoleName"].ToString(); reader.Close(); return(role); }
public Pool GetPoolByID(int poolID) { Pool deadpool = new Pool(); string query = "SELECT * FROM Pool WHERE PoolID = @poolID"; helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@poolID", poolID) }); SqlDataReader reader = helper.ExecuteReader(query); reader.Read(); deadpool.PoolID = poolID; deadpool.ExerciseID = reader.GetInt32(1); deadpool.UserID = reader.GetInt32(2); deadpool.PoolName = reader.GetString(3); deadpool.CreatedDate = reader.GetDateTime(4); deadpool.IsActive = reader.GetBoolean(5); reader.Close(); return(deadpool); }
public User GetUserByID(int userID) { string query = "SELECT * FROM [User] WHERE UserID = @userID"; User user = new User(); _helper.AddParameters(new List <SqlParameter>() { new SqlParameter("@userID", userID) }); SqlDataReader reader = _helper.ExecuteReader(query); reader.Read(); user = GetUser(reader); reader.Close(); return(user); }