public DogDAL DogFindByID(int DogID) { DogDAL proposedReturnValue = null; EnsureConnected(); using (SqlCommand command = new SqlCommand("DogFindByID", sec)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@DogID", DogID); using (SqlDataReader reader = command.ExecuteReader()) { DogMapper dm = new DogMapper(reader); int count = 0; while (reader.Read()) { proposedReturnValue = dm.ToDog(reader); count++; } if (count > 1) { throw new Exception($"{count} many users found for ID {DogID}"); } } } return(proposedReturnValue); }
public DogDAL DogFindByBreed(int BreedID) { DogDAL proposedReturnValue = null; try { EnsureConnected(); using (SqlCommand command = new SqlCommand("DogFindByBreed", sec)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@BreedID", BreedID); using (SqlDataReader reader = command.ExecuteReader()) { DogMapper dm = new DogMapper(reader); while (reader.Read()) { proposedReturnValue = dm.ToDog(reader); } } } } catch (Exception ex) { Logger.Logger.Log(ex); } return(proposedReturnValue); }
public List <DogDAL> DogsGetAll(int Skip, int Take) { List <DogDAL> proposedReturnValue = new List <DogDAL>(); try { EnsureConnected(); using (SqlCommand command = new SqlCommand("DogsGetAll", sec)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@Skip", Skip); command.Parameters.AddWithValue("@Take", Take); using (SqlDataReader reader = command.ExecuteReader()) { DogMapper dm = new DogMapper(reader); while (reader.Read()) { DogDAL item = dm.ToDog(reader); proposedReturnValue.Add(item); } } } } catch (Exception ex) { Logger.Logger.Log(ex); } return(proposedReturnValue); }
public DogDAL GetDogsByUserID(int UserID) { DogDAL proposedReturnValue = null; EnsureConnected(); using (SqlCommand command = new SqlCommand("GetDogsByUserID", sec)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@UserID", UserID); using (SqlDataReader reader = command.ExecuteReader()) { DogMapper dm = new DogMapper(reader); while (reader.Read()) { proposedReturnValue = dm.ToDog(reader); } } return(proposedReturnValue); } }