/// <summary> /// Selects the column names and information about each column for the products table. /// </summary> /// <returns>A list of type ProdColumnInfoList.</returns> public static ProdColumnInfoList getProdColumnInfo() { ProdColumnInfoModel myProdColumnInfo = new ProdColumnInfoModel(); ProdColumnInfoList myProdColumnInfoList = null; using (SqlConnection myConn = dac.getConnection()) { SqlCommand myCommand = new SqlCommand("getProductColumnInfo", myConn); myCommand.CommandType = CommandType.StoredProcedure; myConn.Open(); try { myProdColumnInfoList = new ProdColumnInfoList(); SqlDataReader sqlReader = myCommand.ExecuteReader(); while (sqlReader.Read()) { myProdColumnInfoList.Add(FillList(sqlReader)); } } catch (Exception ex) { } finally { myConn.Close(); } return(myProdColumnInfoList); } }
/// <summary> /// Fills a ProdColumnInfoModel object with data from the database. /// </summary> /// <param name="rec">An IDataRecord from an IDataReader</param> /// <returns>The filled out Product Column Info Model.</returns> protected static ProdColumnInfoModel FillList(IDataRecord rec) { ProdColumnInfoModel tempProdColumnInfoModel = new ProdColumnInfoModel(); string tempColumnName = ""; if (!rec.IsDBNull(rec.GetOrdinal("Column Name"))) { tempColumnName = rec.GetString(rec.GetOrdinal("Column Name")); tempProdColumnInfoModel.column_name = tempColumnName.Replace("_", " "); } if (!rec.IsDBNull(rec.GetOrdinal("Data Type"))) { tempProdColumnInfoModel.data_type = rec.GetString(rec.GetOrdinal("Data Type")); } if (!rec.IsDBNull(rec.GetOrdinal("Max Length"))) { tempProdColumnInfoModel.max_length = Convert.ToInt32(rec.GetValue(rec.GetOrdinal("Max Length"))); } return(tempProdColumnInfoModel); }