private void AssignMakesInfoList(IDataReader ZipCodeInfoDataReader, ZipcodeDistancesInfo objZipcodeDistancesInfo) { try { objZipcodeDistancesInfo.ZipCode = ZipCodeInfoDataReader["ZipCode"].ToString(); } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY); } }
public IList<ZipcodeDistancesInfo> GetZips(string zipcode) { //Decalaring MakesInfo division object collection IList<ZipcodeDistancesInfo> ZipCodeIList = new List<ZipcodeDistancesInfo>(); string spNameString = string.Empty; //Setting Connection //Global.INSTANCE_NAME = strCurrentConn; IDataReader ZipCodeInfoDataReader = null; //Connect to the database Database dbDatabase = DatabaseFactory.CreateDatabase(Global.INSTANCE_NAME); //Assign stored procedure name spNameString = "[GetAllZipCocde]"; DbCommand dbCommand = null; try { //Set stored procedure to the command object //if (System.Web.Caching.Cache["Zips"] == null) //{ dbCommand = dbDatabase.GetStoredProcCommand(spNameString); dbDatabase.AddInParameter(dbCommand, "@zipcode", DbType.String, zipcode); //Executing stored procedure ZipCodeInfoDataReader = dbDatabase.ExecuteReader(dbCommand); while (ZipCodeInfoDataReader.Read()) { //Assign values to the MakesInfo object list ZipcodeDistancesInfo ZipCodeInfo_Info = new ZipcodeDistancesInfo(); AssignMakesInfoList(ZipCodeInfoDataReader, ZipCodeInfo_Info); ZipCodeIList.Add(ZipCodeInfo_Info); } //} //else //{ //objZips = (List<CarsInfo.ZipcodeDistancesInfo>)System.Web.Caching.Cache["Zips"] ; //} } catch (Exception ex) { bool rethrow = ExceptionPolicy.HandleException(ex, Global.EXCEPTION_POLICY); if (rethrow) throw; } finally { ZipCodeInfoDataReader.Close(); } return ZipCodeIList; }