public StandingTeeTimeRequest GetStandingTeeTimeRequest(string dayOfWeek, DateTime startDate, DateTime endDate, DateTime time) { { var golferManager = new ClubBaistUsers(); var requestedStandingTeeTimeRequest = new StandingTeeTimeRequest(); using var connection = new SqlConnection(ConnectionString); using var command = new SqlCommand("FindStandingTeeTimeRequest", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@dayOfWeek", SqlDbType.VarChar).Value = dayOfWeek; command.Parameters.Add("@startDate", SqlDbType.VarChar).Value = startDate; command.Parameters.Add("@endDate", SqlDbType.VarChar).Value = endDate; command.Parameters.Add("@time", SqlDbType.VarChar).Value = time; //Open the connection and execute the reader connection.Open(); var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { // Mapping the program Object to Database requestedStandingTeeTimeRequest = new StandingTeeTimeRequest { Time = new DateTime(((TimeSpan)reader[0]).Ticks), DayOfWeek = (string)reader[1], Shareholder1 = !DBNull.Value.Equals(reader[2]) ? golferManager.GetUserFromId((string)reader[2]) : new Shareholder(), Shareholder2 = !DBNull.Value.Equals(reader[3]) ? golferManager.GetUserFromId((string)reader[3]) : new Shareholder(), Shareholder3 = !DBNull.Value.Equals(reader[4]) ? golferManager.GetUserFromId((string)reader[4]) : new Shareholder(), Shareholder4 = !DBNull.Value.Equals(reader[5]) ? golferManager.GetUserFromId((string)reader[5]) : new Shareholder() }; } } reader.Close(); return(requestedStandingTeeTimeRequest); } }
public List <StandingTeeTimeRequest> GetStandingTeeTimeRequests(string dayOfWeek) { { var golferManager = new ClubBaistUsers(); var requestedStandingTeeTimeRequests = new List <StandingTeeTimeRequest>(); using var connection = new SqlConnection(ConnectionString); using var command = new SqlCommand("GetAvailableStandingTeeTimeRequestsByDay", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@DayOfWeek", SqlDbType.VarChar).Value = dayOfWeek; //Open the connection and execute the reader connection.Open(); var reader = command.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { // Mapping the program Object to Database var standingTeeTimeRequestDbInstance = new StandingTeeTimeRequest { Time = new DateTime(((TimeSpan)reader[0]).Ticks), DayOfWeek = (string)reader[1], Shareholder1 = !DBNull.Value.Equals(reader[2]) ? golferManager.GetUserFromId((string)reader[2]) : new Shareholder(), Shareholder2 = !DBNull.Value.Equals(reader[3]) ? golferManager.GetUserFromId((string)reader[3]) : new Shareholder(), Shareholder3 = !DBNull.Value.Equals(reader[4]) ? golferManager.GetUserFromId((string)reader[4]) : new Shareholder(), Shareholder4 = !DBNull.Value.Equals(reader[5]) ? golferManager.GetUserFromId((string)reader[5]) : new Shareholder() }; requestedStandingTeeTimeRequests.Add(standingTeeTimeRequestDbInstance); } } reader.Close(); return(requestedStandingTeeTimeRequests); } }