private void SetReaderToObject(ref ModificationClass objModificationClass, ref SqlDataReader result) { if (result.HasRows) { objModificationClass.ModificationClassID = (int)result.GetValue(result.GetOrdinal("ModificationClassID")); objModificationClass.ModificationClassName = result.GetValue(result.GetOrdinal("ModificationClassName")).ToString(); objModificationClass.ModificationClassDescription = result.GetValue(result.GetOrdinal("ModificationClassDescription")).ToString(); } }
private List <ModificationClass> GetModificationClassList(string strSprocName, string strWhere, string strOrderBy) { List <ModificationClass> ModificationClasss = new List <ModificationClass>(); SqlDataReader result; DatabaseConnection dbconn = new DatabaseConnection(); SqlCommand command = new SqlCommand(); SqlConnection connection = new SqlConnection(dbconn.SQLSEVERConnString); try { connection.Open(); command.Connection = connection; command.CommandType = CommandType.StoredProcedure; command.CommandText = strSprocName; command.Parameters.Add(dbconn.GenerateParameterObj("@strWhere", SqlDbType.VarChar, strWhere, 1000)); command.Parameters.Add(dbconn.GenerateParameterObj("@strOrderBy", SqlDbType.VarChar, strOrderBy, 1000)); result = command.ExecuteReader(); while (result.Read()) { ModificationClass objModificationClass = new ModificationClass(); SetReaderToObject(ref objModificationClass, ref result); ModificationClasss.Add(objModificationClass); } } catch { Exception e = new Exception(); throw e; } finally { command.Dispose(); connection.Close(); } return(ModificationClasss); }