public Star2Details ObjGetStar2Details(string level1, string level2, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbCommand = db.GetStoredProcCommand(Resources.GetStar2DetailsResources.SP_GetStar2Details); db.AddInParameter(dbCommand, Resources.GetStar2DetailsResources.PARAM_Level1, DbType.String, level1); db.AddInParameter(dbCommand, Resources.GetStar2DetailsResources.PARAM_Level2, DbType.String, level2); var item = new Star2Details(); using (IDataReader dr = db.ExecuteReader(dbCommand)) { int _id = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Id); int _level1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Level1); int _level2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Level2); int _name = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Name); int _lastName = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_LastName); int _officePhone = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_OfficePhone); int _ext = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Ext); int _officePhoneCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_OfficePhoneCode); int _directPhone = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_DirectPhone); int _directPhoneCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_DirectPhoneCode); int _email = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Email); int _frequentFlyer1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer1); int _frequentFlyer2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer2); int _frequentFlyer3 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer3); int _frequentFlyer4 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer4); int _frequentFlyer5 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_FrequentFlyer5); int _passport = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Passport); int _birthday = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Birthday); int _visa = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Visa); int _immigrationForm = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_ImmigrationForm); int _rfc = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_RFC); int _creditCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CreditCar); int _personalCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_PersonalCar); int _streetAndNumber = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_StreetAndNumber); int _colony = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Colony); int _postalCode = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_PostalCode); int _estate = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Estate); int _city = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_City); int _name2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Name2); int _lastName2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_LastName2); int _paternal = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Paternal); int _maternal = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Maternal); int _occupation = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Occupation); int _seat = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Seat); int _family1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family1); int _family2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family2); int _family3 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family3); int _family4 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family4); int _family5 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family5); int _family6 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Family6); int _comments = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_Comments); int _hotelCreditCar = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_HotelCreditCar); int _cadHotel1 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CadHotel1); int _cadHotel2 = dr.GetOrdinal(Resources.GetStar2DetailsResources.PARAM_CadHotel2); while (dr.Read()) { item.Id = (dr[_id] == DBNull.Value) ? Types.StringNullValue : dr.GetInt32(_id).ToString(); item.Level1 = MyCTSConvert.ToString(dr.GetString(_level1)); item.Level2 = MyCTSConvert.ToString(dr.GetString(_level2)); item.Name = MyCTSConvert.ToString(dr.GetString(_name)); item.LastName = MyCTSConvert.ToString(dr.GetString(_lastName)); item.OfficePhone = MyCTSConvert.ToString(dr.GetString(_officePhone)); item.Ext = MyCTSConvert.ToString(dr.GetString(_ext)); item.OfficePhoneCode = MyCTSConvert.ToString(dr.GetString(_officePhoneCode)); item.DirectPhone = MyCTSConvert.ToString(dr.GetString(_directPhone)); item.DirectPhoneCode = MyCTSConvert.ToString(dr.GetString(_directPhoneCode)); item.Email = MyCTSConvert.ToString(dr.GetString(_email)); item.FrequentFlyer1 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer1)); item.FrequentFlyer2 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer2)); item.FrequentFlyer3 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer3)); item.FrequentFlyer4 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer4)); item.FrequentFlyer5 = MyCTSConvert.ToString(dr.GetString(_frequentFlyer5)); item.Passport = MyCTSConvert.ToString(dr.GetString(_passport)); item.Birthday = MyCTSConvert.ToString(dr.GetString(_birthday)); item.Visa = MyCTSConvert.ToString(dr.GetString(_visa)); item.ImmigrationForm = MyCTSConvert.ToString(dr.GetString(_immigrationForm)); item.Rfc = MyCTSConvert.ToString(dr.GetString(_rfc)); item.CreditCar = MyCTSConvert.ToString(dr.GetString(_creditCar)); item.PersonalCar = MyCTSConvert.ToString(dr.GetString(_personalCar)); item.StreetAndNumber = MyCTSConvert.ToString(dr.GetString(_streetAndNumber)); item.Colony = MyCTSConvert.ToString(dr.GetString(_colony)); item.PostalCode = MyCTSConvert.ToString(dr.GetString(_postalCode)); item.Estate = MyCTSConvert.ToString(dr.GetString(_estate)); item.City = MyCTSConvert.ToString(dr.GetString(_city)); item.Name2 = MyCTSConvert.ToString(dr.GetString(_name2)); item.LastName2 = MyCTSConvert.ToString(dr.GetString(_lastName2)); item.Paternal = MyCTSConvert.ToString(dr.GetString(_paternal)); item.Maternal = MyCTSConvert.ToString(dr.GetString(_maternal)); item.Occupation = MyCTSConvert.ToString(dr.GetString(_occupation)); item.Seat = MyCTSConvert.ToString(dr.GetString(_seat)); item.Family1 = MyCTSConvert.ToString(dr.GetString(_family1)); item.Family2 = MyCTSConvert.ToString(dr.GetString(_family2)); item.Family3 = MyCTSConvert.ToString(dr.GetString(_family3)); item.Family4 = MyCTSConvert.ToString(dr.GetString(_family4)); item.Family5 = MyCTSConvert.ToString(dr.GetString(_family5)); item.Family6 = MyCTSConvert.ToString(dr.GetString(_family6)); item.Comments = MyCTSConvert.ToString(dr.GetString(_comments)); item.HotelCreditCar = MyCTSConvert.ToString(dr.GetString(_hotelCreditCar)); item.CadHotel1 = MyCTSConvert.ToString(dr.GetString(_cadHotel1)); item.CadHotel2 = MyCTSConvert.ToString(dr.GetString(_cadHotel2)); } } return(item); }