public List <CivilizationDAL> CivilizationsGetAll(int Skip, int Take) { List <CivilizationDAL> proposedReturnValue = new List <CivilizationDAL>(); try { EnsureConnected(); using (SqlCommand command = new SqlCommand("CivilizationsGetAll", _con)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@skip", Skip); command.Parameters.AddWithValue("@take", Take); using (SqlDataReader reader = command.ExecuteReader()) { CivilizationMapper cm = new CivilizationMapper(reader); while (reader.Read()) { CivilizationDAL item = cm.ToCivilization(reader); proposedReturnValue.Add(item); } } } } catch (Exception ex) when(Log(ex)) { // stays empty } return(proposedReturnValue); }
public CivilizationDAL CivilizationFindByID(int CivID) { CivilizationDAL proposedreturnValue = null; try { EnsureConnected(); using (SqlCommand command = new SqlCommand("CivilizationFindByID", _con)) { command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.AddWithValue("@CivID", CivID); //QuotesQuotesQuotes using (SqlDataReader reader = command.ExecuteReader()) { CivilizationMapper cm = new CivilizationMapper(reader); int count = 0; while (reader.Read()) { proposedreturnValue = cm.ToCivilization(reader); count++; } if (count > 1) { throw new Exception($"Multiple Civilizations found for ID {CivID}"); } } } } catch (Exception ex) when(Log(ex)) { // stays empty } return(proposedreturnValue); }
public CivilizationDAL ToCivilization(SqlDataReader reader) { CivilizationDAL proposedReturnValue = new CivilizationDAL(); proposedReturnValue.CivID = reader.GetInt32(OffsetToCivID); proposedReturnValue.CivName = reader.GetString(OffsetToCivName); proposedReturnValue.CivStart = reader.GetDateTime(OffsetToCivStart); proposedReturnValue.CivEnd = reader.GetDateTime(OffsetToCivEnd); return(proposedReturnValue); }