need help creating a DB connection in my DAL class file.

Question

User-2015678876 posted

Below is my class file.

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;

namespace AutoPilot {
	public sealed class TblZipCode {
		#region Fields
		private string zIP_CODE;
		private string pREF_CITY_STATE_NAME;
		private string sTATE_ABBREV;
		private string sTATE;
		private string sTATE_FIPS;
		private string cOUNTY_NAME;
		private string cOUNTY_FIPS;
		private string zIP_CLASS_CODE;
		private string cARRIER_ROUTE_RATE;
		#endregion
		
		#region Constructors
		/// <summary>
		/// Initializes a new instance of the TblZipCode class.
		/// </summary>
		public TblZipCode() {
		}
		
		/// <summary>
		/// Initializes a new instance of the TblZipCode class.
		/// </summary>
		public TblZipCode(string zIP_CODE, string pREF_CITY_STATE_NAME, string sTATE_ABBREV, string sTATE, string sTATE_FIPS, string cOUNTY_NAME, string cOUNTY_FIPS, string zIP_CLASS_CODE, string cARRIER_ROUTE_RATE) {
			this.zIP_CODE = zIP_CODE;
			this.pREF_CITY_STATE_NAME = pREF_CITY_STATE_NAME;
			this.sTATE_ABBREV = sTATE_ABBREV;
			this.sTATE = sTATE;
			this.sTATE_FIPS = sTATE_FIPS;
			this.cOUNTY_NAME = cOUNTY_NAME;
			this.cOUNTY_FIPS = cOUNTY_FIPS;
			this.zIP_CLASS_CODE = zIP_CLASS_CODE;
			this.cARRIER_ROUTE_RATE = cARRIER_ROUTE_RATE;
		}
		#endregion
		
		#region Properties
		/// <summary>
		/// Gets or sets the ZIP_CODE value.
		/// </summary>
		public string ZIP_CODE {
			get { return zIP_CODE; }
			set { zIP_CODE = value; }
		}
		
		/// <summary>
		/// Gets or sets the PREF_CITY_STATE_NAME value.
		/// </summary>
		public string PREF_CITY_STATE_NAME {
			get { return pREF_CITY_STATE_NAME; }
			set { pREF_CITY_STATE_NAME = value; }
		}
		
		/// <summary>
		/// Gets or sets the STATE_ABBREV value.
		/// </summary>
		public string STATE_ABBREV {
			get { return sTATE_ABBREV; }
			set { sTATE_ABBREV = value; }
		}
		
		/// <summary>
		/// Gets or sets the STATE value.
		/// </summary>
		public string STATE {
			get { return sTATE; }
			set { sTATE = value; }
		}
		
		/// <summary>
		/// Gets or sets the STATE_FIPS value.
		/// </summary>
		public string STATE_FIPS {
			get { return sTATE_FIPS; }
			set { sTATE_FIPS = value; }
		}
		
		/// <summary>
		/// Gets or sets the COUNTY_NAME value.
		/// </summary>
		public string COUNTY_NAME {
			get { return cOUNTY_NAME; }
			set { cOUNTY_NAME = value; }
		}
		
		/// <summary>
		/// Gets or sets the COUNTY_FIPS value.
		/// </summary>
		public string COUNTY_FIPS {
			get { return cOUNTY_FIPS; }
			set { cOUNTY_FIPS = value; }
		}
		
		/// <summary>
		/// Gets or sets the ZIP_CLASS_CODE value.
		/// </summary>
		public string ZIP_CLASS_CODE {
			get { return zIP_CLASS_CODE; }
			set { zIP_CLASS_CODE = value; }
		}
		
		/// <summary>
		/// Gets or sets the CARRIER_ROUTE_RATE value.
		/// </summary>
		public string CARRIER_ROUTE_RATE {
			get { return cARRIER_ROUTE_RATE; }
			set { cARRIER_ROUTE_RATE = value; }
		}
		#endregion
		
		#region Methods
		/// <summary>
		/// Saves a record to the tblZipCode table.
		/// </summary>
		public void Insert() {
			
		}
		
		/// <summary>
		/// Selects all records from the tblZipCode table.
		/// </summary>
		public static List<TblZipCode> SelectAll() {
			
				return tblZipCodeList;
			}
		}
		
		/// <summary>
		/// Creates a new instance of the tblZipCode class and populates it with data from the specified SqlDataReader.
		/// </summary>
		private static TblZipCode MakeTblZipCode(SqlDataReader dataReader) {
			TblZipCode tblZipCode = new TblZipCode();
			
			if (dataReader.IsDBNull(0) == false) {
				tblZipCode.ZIP_CODE = dataReader.GetString(0);
			}
			if (dataReader.IsDBNull(1) == false) {
				tblZipCode.PREF_CITY_STATE_NAME = dataReader.GetString(1);
			}
			if (dataReader.IsDBNull(2) == false) {
				tblZipCode.STATE_ABBREV = dataReader.GetString(2);
			}
			if (dataReader.IsDBNull(3) == false) {
				tblZipCode.STATE = dataReader.GetString(3);
			}
			if (dataReader.IsDBNull(4) == false) {
				tblZipCode.STATE_FIPS = dataReader.GetString(4);
			}
			if (dataReader.IsDBNull(5) == false) {
				tblZipCode.COUNTY_NAME = dataReader.GetString(5);
			}
			if (dataReader.IsDBNull(6) == false) {
				tblZipCode.COUNTY_FIPS = dataReader.GetString(6);
			}
			if (dataReader.IsDBNull(7) == false) {
				tblZipCode.ZIP_CLASS_CODE = dataReader.GetString(7);
			}
			if (dataReader.IsDBNull(8) == false) {
				tblZipCode.CARRIER_ROUTE_RATE = dataReader.GetString(8);
			}

			return tblZipCode;
		}
		#endregion
	}
}