/// <summary> /// Creates a new instance of the Sol_WS_ItemTypes class and populates it with data from the specified SqlDataReader. /// </summary> protected virtual Sol_WS_ItemType MakeSol_WS_ItemType(SqlDataReader dataReader) { Sol_WS_ItemType sol_WS_ItemType = new Sol_WS_ItemType(); sol_WS_ItemType.ItemTypeID = SqlClientUtility.GetInt32(dataReader, "ItemTypeID", 0); sol_WS_ItemType.ItemType = SqlClientUtility.GetString(dataReader, "ItemType", String.Empty); return(sol_WS_ItemType); }
/// <summary> /// Updates a record in the Sol_WS_ItemTypes table. /// </summary> public virtual void Update(Sol_WS_ItemType sol_WS_ItemType) { ValidationUtility.ValidateArgument("sol_WS_ItemType", sol_WS_ItemType); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ItemTypeID", sol_WS_ItemType.ItemTypeID), new SqlParameter("@ItemType", sol_WS_ItemType.ItemType) }; SqlClientUtility.ExecuteNonQuery(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ItemTypes_Update", parameters); }
/// <summary> /// Selects all records from the Sol_WS_ItemTypes table. /// </summary> public virtual List <Sol_WS_ItemType> SelectAll() { using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader(connectionStringName, CommandType.StoredProcedure, "Sol_WS_ItemTypes_SelectAll")) { List <Sol_WS_ItemType> sol_WS_ItemTypeList = new List <Sol_WS_ItemType>(); while (dataReader.Read()) { Sol_WS_ItemType sol_WS_ItemType = MakeSol_WS_ItemType(dataReader); sol_WS_ItemTypeList.Add(sol_WS_ItemType); } return(sol_WS_ItemTypeList); } }