public MovieUserDAL FindMovieUserByID(int MovieUserID) { MovieUserDAL rv = null; try { EnsureConnected(); using (SqlCommand command = new SqlCommand("FindMovieUserByID", Con)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@MovieUserID", MovieUserID); using (SqlDataReader reader = command.ExecuteReader()) { MovieUserMapper mapper = new MovieUserMapper(reader); if (reader.Read()) { rv = mapper.ToMovieUser(reader); } } } } catch (Exception ex) { Log(ex); throw; } return(rv); }
public List <MovieUserDAL> GetMovieUsers(int skip, int take) { List <MovieUserDAL> rv = new List <MovieUserDAL>(); try { EnsureConnected(); using (SqlCommand command = new SqlCommand("GetMovieUsers", Con)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@skip", skip); command.Parameters.AddWithValue("@take", take); using (SqlDataReader reader = command.ExecuteReader()) { MovieUserMapper mapper = new MovieUserMapper(reader); while (reader.Read()) { MovieUserDAL c = mapper.ToMovieUser(reader); rv.Add(c); } } } } catch (Exception ex) { Log(ex); throw; } return(rv); }
public MovieUserDAL ToMovieUser(SqlDataReader r) //different from ctor used many times in loops { MovieUserDAL rv = new MovieUserDAL(); rv.MovieUserID = GetInt32OrZero(r, MovieUserIDOrdinal); rv.MovieID = GetInt32OrZero(r, MovieIDOrdinal); rv.UserID = GetInt32OrZero(r, UserIDOrdinal); rv.Date = GetDateTimeOrMinValue(r, DateOrdinal); rv.UserName = GetStringOrNull(r, UserNameOrdinal); rv.Title = GetStringOrNull(r, TitleOrdinal); rv.Length = GetInt32OrZero(r, LengthOrdinal); return(rv); }
public MovieUserDAL ToMovieUser(SqlDataReader r) { MovieUserDAL rv = new MovieUserDAL(); rv.MovieUserID = GetInt32OrZero(r, MovieUserIDOrdinal); rv.MovieID = GetInt32OrZero(r, MovieIDOrdinal); rv.UserID = GetInt32OrZero(r, UserIDOrdinal); rv.Date = GetDateTimeOrMinValue(r, DateOrdinal); rv.UserName = GetStringOrNull(r, UserNameOrdinal); rv.Title = GetStringOrNull(r, TitleOrdinal); rv.Length = GetInt32OrZero(r, LengthOrdinal); return(rv); }