public string SelectIdNeedCoach(string firstName, string lastName) { var result = _coachDao.SelectIdNeedCoach(firstName, lastName).ToList(); if (result.Any()) { return(result.FirstOrDefault().ToString()); } else { return(null); } }
public void AddClient(Client client) { using (SqlConnection connection = new SqlConnection(connectionstring)) { SqlCommand cmd = new SqlCommand("AddClient", connection); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@firstName", client.FirstName); cmd.Parameters.AddWithValue("@lastName", client.LastName); cmd.Parameters.AddWithValue("@telephoneNumber", client.TelephoneNumber); if (client.FirstNameOfFavoriteCoach != null && client.LastNameOfFavoriteCoach != null) { cmd.Parameters.AddWithValue("@idFavoriteCoach", coachDao.SelectIdNeedCoach(client.FirstNameOfFavoriteCoach, client.LastNameOfFavoriteCoach)); } connection.Open(); cmd.ExecuteNonQuery(); } }