コード例 #1
0
		/// <summary>
		/// The object factory for a particular data collection instance.
		/// </summary>
		public virtual void CreateObjectsFromData(CitizenshipResidencyTypes citizenshipresidencytypes, System.Data.DataSet data)
		{
			// Do nothing if we have nothing
			if (data == null || data.Tables.Count == 0 || data.Tables[0].Rows.Count == 0) return;


			// Create a local variable for the new instance.
			CitizenshipResidencyType newobj = null;
			// Create a local variable for the data row instance.
			System.Data.DataRow dr = null;


			// Iterate through the table rows
			for (int i = 0; i<data.Tables[0].Rows.Count; i++)
			{
				// Get a reference to the data row
				dr = data.Tables[0].Rows[i];
				// Create a new object instance
				newobj = System.Activator.CreateInstance(citizenshipresidencytypes.ContainsType[0]) as CitizenshipResidencyType;
				// Let the instance set its own members
				newobj.SetMembers(ref dr);
				// Add the new object to the collection instance
				citizenshipresidencytypes.Add(newobj);
			}
		}
コード例 #2
0
		/// <summary>
		/// Fill method for populating an entire collection of CitizenshipResidencyTypes
		/// </summary>
		public virtual void Fill(CitizenshipResidencyTypes citizenshipResidencyTypes)
		{
			// create the connection to use
			SqlConnection cnn = new SqlConnection(CitizenshipResidencyType.GetConnectionString());


			try
			{
				using (cnn)
				{
					// open the connection
					cnn.Open();


					// create an instance of the reader to fill.
					SqlDataReader datareader = SqlHelper.ExecuteReader(cnn, "gsp_SelectCitizenshipResidencyTypes");


					// Send the collection and data to the object factory
					CreateObjectsFromData(citizenshipResidencyTypes, datareader);


					// close the connection
					cnn.Close();
				}


				// nullify the connection
				cnn = null;
			}
			catch (SqlException sqlex)
			{
				throw sqlex;
			}
		}
コード例 #3
0
		/// <summary>
		/// Gets all the available objects.
		/// </summary>
		public virtual CitizenshipResidencyTypes GetAll()
		{
			// create a new instance of the return object
			CitizenshipResidencyTypes objects = new CitizenshipResidencyTypes();


			// fill the objects
			this.Fill(objects);


			// return the filled object from the service
			return objects;
		}
コード例 #4
0
		/// <summary>
		/// The object factory for a particular data collection instance.
		/// </summary>
		public virtual void CreateObjectsFromData(CitizenshipResidencyTypes citizenshipresidencytypes, System.Data.SqlClient.SqlDataReader data)
		{
			// Do nothing if we have nothing
			if (data == null) return;


			// Create a local variable for the new instance.
			CitizenshipResidencyType newobj = null;
			// Iterate through the data reader
			while (data.Read())
			{
				// Create a new object instance
				newobj = System.Activator.CreateInstance(citizenshipresidencytypes.ContainsType[0]) as CitizenshipResidencyType;
				// Let the instance set its own members
				newobj.SetMembers(ref data);
				// Add the new object to the collection instance
				citizenshipresidencytypes.Add(newobj);
			}
		}