public bool Update(ConferenceRegisterationsLanguage conferenceregisterationslanguage ,int old_conferenceRegistererId) { ConferenceRegisterationsLanguageDAC conferenceregisterationslanguageComponent = new ConferenceRegisterationsLanguageDAC(); return conferenceregisterationslanguageComponent.UpdateConferenceRegisterationsLanguage( conferenceregisterationslanguage.SponsorId, conferenceregisterationslanguage.PersonId, conferenceregisterationslanguage.ConferenceId, conferenceregisterationslanguage.DateRegistered, conferenceregisterationslanguage.DiscountAmount, conferenceregisterationslanguage.AmountPaid, conferenceregisterationslanguage.DiscountReason, conferenceregisterationslanguage.RegitrationCategory, conferenceregisterationslanguage.LicenseNumber, conferenceregisterationslanguage.Address, conferenceregisterationslanguage.POBox, conferenceregisterationslanguage.ZipCode, conferenceregisterationslanguage.City, conferenceregisterationslanguage.Country, conferenceregisterationslanguage.PhoneNumberCountryCode, conferenceregisterationslanguage.PhoneNumberAreaCode, conferenceregisterationslanguage.PhoneNumber, conferenceregisterationslanguage.FaxNumberCountryCode, conferenceregisterationslanguage.FaxNumberAreaCode, conferenceregisterationslanguage.FaxNumber, conferenceregisterationslanguage.MobileNumberCountryCode, conferenceregisterationslanguage.MobileNumberAreaCode, conferenceregisterationslanguage.MobileNumber, conferenceregisterationslanguage.Email, conferenceregisterationslanguage.AcademicInformationPosition, conferenceregisterationslanguage.AcademicInformationDegree, conferenceregisterationslanguage.AcademicInformationHealthCarePro, conferenceregisterationslanguage.AcademicInformationHealthCareProValue, conferenceregisterationslanguage.HospitalInstituteName, conferenceregisterationslanguage.HospitalInstituteDepartment, conferenceregisterationslanguage.HospitalInstituteAddress, conferenceregisterationslanguage.HospitalInstituteZipCode, conferenceregisterationslanguage.HospitalInstituteCity, conferenceregisterationslanguage.HospitalInstituteCountry, conferenceregisterationslanguage.HospitalInstitutePOBox, conferenceregisterationslanguage.ConferenceRegistrationTypeId, conferenceregisterationslanguage.PreConferenceWorkShopIncluded, conferenceregisterationslanguage.SubscribeToNewsLetter, conferenceregisterationslanguage.AOAAdministrator, conferenceregisterationslanguage.AOARetired, conferenceregisterationslanguage.AOAClinicalResearcher, conferenceregisterationslanguage.AOABasicResearcher, conferenceregisterationslanguage.AOATeacherEducator, conferenceregisterationslanguage.AOAIndustryRepresentative, conferenceregisterationslanguage.AOAClinicalPractitioner, conferenceregisterationslanguage.AOAAlliedHealthProfessional, conferenceregisterationslanguage.AOAStudent, conferenceregisterationslanguage.AOAOther, conferenceregisterationslanguage.AOAOtherText, conferenceregisterationslanguage.AOAMCNAcuteKidneyInjury, conferenceregisterationslanguage.AOAMCNChronicKidneyDisease, conferenceregisterationslanguage.AOAMCNHypertension, conferenceregisterationslanguage.AOAMCNGlomerulonephritis, conferenceregisterationslanguage.AOAMCNNephrolithiasis, conferenceregisterationslanguage.AOAMRRTHemodialysis, conferenceregisterationslanguage.AOAMRRTPertionealDialysis, conferenceregisterationslanguage.AOAMRRTCRRT, conferenceregisterationslanguage.AOAMPediatricNephrology, conferenceregisterationslanguage.AOAMGenetics, conferenceregisterationslanguage.AOAMUrology, conferenceregisterationslanguage.AOAMMineralMetabolism, conferenceregisterationslanguage.AOAMAnemia, conferenceregisterationslanguage.AOAMDiabetes, conferenceregisterationslanguage.AOAMImmunology, conferenceregisterationslanguage.AOAMPathology, conferenceregisterationslanguage.AOAMIterventionalCCN, conferenceregisterationslanguage.AOAMOther, conferenceregisterationslanguage.AOAMOtherText, conferenceregisterationslanguage.SponsorName, conferenceregisterationslanguage.DeductedAmount, conferenceregisterationslanguage.IsActive, conferenceregisterationslanguage.IsMember, conferenceregisterationslanguage.IsSelfSponsor, conferenceregisterationslanguage.ConferenceRegistererParentId, conferenceregisterationslanguage.LanguageID, old_conferenceRegistererId); }
public ConferenceRegisterationsLanguage GetByID(int _conferenceRegistererId) { ConferenceRegisterationsLanguageDAC _conferenceRegisterationsLanguageComponent = new ConferenceRegisterationsLanguageDAC(); IDataReader reader = _conferenceRegisterationsLanguageComponent.GetByIDConferenceRegisterationsLanguage(_conferenceRegistererId); ConferenceRegisterationsLanguage _conferenceRegisterationsLanguage = null; while(reader.Read()) { _conferenceRegisterationsLanguage = new ConferenceRegisterationsLanguage(); if(reader["ConferenceRegistererId"] != DBNull.Value) _conferenceRegisterationsLanguage.ConferenceRegistererId = Convert.ToInt32(reader["ConferenceRegistererId"]); if(reader["SponsorId"] != DBNull.Value) _conferenceRegisterationsLanguage.SponsorId = Convert.ToInt32(reader["SponsorId"]); if(reader["PersonId"] != DBNull.Value) _conferenceRegisterationsLanguage.PersonId = Convert.ToInt32(reader["PersonId"]); if(reader["ConferenceId"] != DBNull.Value) _conferenceRegisterationsLanguage.ConferenceId = Convert.ToInt32(reader["ConferenceId"]); if(reader["DateRegistered"] != DBNull.Value) _conferenceRegisterationsLanguage.DateRegistered = Convert.ToDateTime(reader["DateRegistered"]); if(reader["DiscountAmount"] != DBNull.Value) _conferenceRegisterationsLanguage.DiscountAmount = Convert.ToDecimal(reader["DiscountAmount"]); if(reader["AmountPaid"] != DBNull.Value) _conferenceRegisterationsLanguage.AmountPaid = Convert.ToDecimal(reader["AmountPaid"]); if(reader["DiscountReason"] != DBNull.Value) _conferenceRegisterationsLanguage.DiscountReason = Convert.ToString(reader["DiscountReason"]); if(reader["RegitrationCategory"] != DBNull.Value) _conferenceRegisterationsLanguage.RegitrationCategory = Convert.ToString(reader["RegitrationCategory"]); if(reader["LicenseNumber"] != DBNull.Value) _conferenceRegisterationsLanguage.LicenseNumber = Convert.ToString(reader["LicenseNumber"]); if(reader["Address"] != DBNull.Value) _conferenceRegisterationsLanguage.Address = Convert.ToString(reader["Address"]); if(reader["POBox"] != DBNull.Value) _conferenceRegisterationsLanguage.POBox = Convert.ToString(reader["POBox"]); if(reader["ZipCode"] != DBNull.Value) _conferenceRegisterationsLanguage.ZipCode = Convert.ToString(reader["ZipCode"]); if(reader["City"] != DBNull.Value) _conferenceRegisterationsLanguage.City = Convert.ToString(reader["City"]); if(reader["Country"] != DBNull.Value) _conferenceRegisterationsLanguage.Country = Convert.ToString(reader["Country"]); if(reader["PhoneNumberCountryCode"] != DBNull.Value) _conferenceRegisterationsLanguage.PhoneNumberCountryCode = Convert.ToString(reader["PhoneNumberCountryCode"]); if(reader["PhoneNumberAreaCode"] != DBNull.Value) _conferenceRegisterationsLanguage.PhoneNumberAreaCode = Convert.ToString(reader["PhoneNumberAreaCode"]); if(reader["PhoneNumber"] != DBNull.Value) _conferenceRegisterationsLanguage.PhoneNumber = Convert.ToString(reader["PhoneNumber"]); if(reader["FaxNumberCountryCode"] != DBNull.Value) _conferenceRegisterationsLanguage.FaxNumberCountryCode = Convert.ToString(reader["FaxNumberCountryCode"]); if(reader["FaxNumberAreaCode"] != DBNull.Value) _conferenceRegisterationsLanguage.FaxNumberAreaCode = Convert.ToString(reader["FaxNumberAreaCode"]); if(reader["FaxNumber"] != DBNull.Value) _conferenceRegisterationsLanguage.FaxNumber = Convert.ToString(reader["FaxNumber"]); if(reader["MobileNumberCountryCode"] != DBNull.Value) _conferenceRegisterationsLanguage.MobileNumberCountryCode = Convert.ToString(reader["MobileNumberCountryCode"]); if(reader["MobileNumberAreaCode"] != DBNull.Value) _conferenceRegisterationsLanguage.MobileNumberAreaCode = Convert.ToString(reader["MobileNumberAreaCode"]); if(reader["MobileNumber"] != DBNull.Value) _conferenceRegisterationsLanguage.MobileNumber = Convert.ToString(reader["MobileNumber"]); if(reader["Email"] != DBNull.Value) _conferenceRegisterationsLanguage.Email = Convert.ToString(reader["Email"]); if(reader["AcademicInformationPosition"] != DBNull.Value) _conferenceRegisterationsLanguage.AcademicInformationPosition = Convert.ToString(reader["AcademicInformationPosition"]); if(reader["AcademicInformationDegree"] != DBNull.Value) _conferenceRegisterationsLanguage.AcademicInformationDegree = Convert.ToString(reader["AcademicInformationDegree"]); if(reader["AcademicInformationHealthCarePro"] != DBNull.Value) _conferenceRegisterationsLanguage.AcademicInformationHealthCarePro = Convert.ToBoolean(reader["AcademicInformationHealthCarePro"]); if(reader["AcademicInformationHealthCareProValue"] != DBNull.Value) _conferenceRegisterationsLanguage.AcademicInformationHealthCareProValue = Convert.ToString(reader["AcademicInformationHealthCareProValue"]); if(reader["HospitalInstituteName"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteName = Convert.ToString(reader["HospitalInstituteName"]); if(reader["HospitalInstituteDepartment"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteDepartment = Convert.ToString(reader["HospitalInstituteDepartment"]); if(reader["HospitalInstituteAddress"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteAddress = Convert.ToString(reader["HospitalInstituteAddress"]); if(reader["HospitalInstituteZipCode"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteZipCode = Convert.ToString(reader["HospitalInstituteZipCode"]); if(reader["HospitalInstituteCity"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteCity = Convert.ToString(reader["HospitalInstituteCity"]); if(reader["HospitalInstituteCountry"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstituteCountry = Convert.ToString(reader["HospitalInstituteCountry"]); if(reader["HospitalInstitutePOBox"] != DBNull.Value) _conferenceRegisterationsLanguage.HospitalInstitutePOBox = Convert.ToString(reader["HospitalInstitutePOBox"]); if(reader["ConferenceRegistrationTypeId"] != DBNull.Value) _conferenceRegisterationsLanguage.ConferenceRegistrationTypeId = Convert.ToInt32(reader["ConferenceRegistrationTypeId"]); if(reader["PreConferenceWorkShopIncluded"] != DBNull.Value) _conferenceRegisterationsLanguage.PreConferenceWorkShopIncluded = Convert.ToBoolean(reader["PreConferenceWorkShopIncluded"]); if(reader["SubscribeToNewsLetter"] != DBNull.Value) _conferenceRegisterationsLanguage.SubscribeToNewsLetter = Convert.ToBoolean(reader["SubscribeToNewsLetter"]); if(reader["AOAAdministrator"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAAdministrator = Convert.ToBoolean(reader["AOAAdministrator"]); if(reader["AOARetired"] != DBNull.Value) _conferenceRegisterationsLanguage.AOARetired = Convert.ToBoolean(reader["AOARetired"]); if(reader["AOAClinicalResearcher"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAClinicalResearcher = Convert.ToBoolean(reader["AOAClinicalResearcher"]); if(reader["AOABasicResearcher"] != DBNull.Value) _conferenceRegisterationsLanguage.AOABasicResearcher = Convert.ToBoolean(reader["AOABasicResearcher"]); if(reader["AOATeacherEducator"] != DBNull.Value) _conferenceRegisterationsLanguage.AOATeacherEducator = Convert.ToBoolean(reader["AOATeacherEducator"]); if(reader["AOAIndustryRepresentative"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAIndustryRepresentative = Convert.ToBoolean(reader["AOAIndustryRepresentative"]); if(reader["AOAClinicalPractitioner"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAClinicalPractitioner = Convert.ToBoolean(reader["AOAClinicalPractitioner"]); if(reader["AOAAlliedHealthProfessional"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAAlliedHealthProfessional = Convert.ToBoolean(reader["AOAAlliedHealthProfessional"]); if(reader["AOAStudent"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAStudent = Convert.ToBoolean(reader["AOAStudent"]); if(reader["AOAOther"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAOther = Convert.ToBoolean(reader["AOAOther"]); if(reader["AOAOtherText"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAOtherText = Convert.ToString(reader["AOAOtherText"]); if(reader["AOAMCNAcuteKidneyInjury"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMCNAcuteKidneyInjury = Convert.ToBoolean(reader["AOAMCNAcuteKidneyInjury"]); if(reader["AOAMCNChronicKidneyDisease"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMCNChronicKidneyDisease = Convert.ToBoolean(reader["AOAMCNChronicKidneyDisease"]); if(reader["AOAMCNHypertension"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMCNHypertension = Convert.ToBoolean(reader["AOAMCNHypertension"]); if(reader["AOAMCNGlomerulonephritis"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMCNGlomerulonephritis = Convert.ToBoolean(reader["AOAMCNGlomerulonephritis"]); if(reader["AOAMCNNephrolithiasis"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMCNNephrolithiasis = Convert.ToBoolean(reader["AOAMCNNephrolithiasis"]); if(reader["AOAMRRTHemodialysis"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMRRTHemodialysis = Convert.ToBoolean(reader["AOAMRRTHemodialysis"]); if(reader["AOAMRRTPertionealDialysis"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMRRTPertionealDialysis = Convert.ToBoolean(reader["AOAMRRTPertionealDialysis"]); if(reader["AOAMRRTCRRT"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMRRTCRRT = Convert.ToBoolean(reader["AOAMRRTCRRT"]); if(reader["AOAMPediatricNephrology"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMPediatricNephrology = Convert.ToBoolean(reader["AOAMPediatricNephrology"]); if(reader["AOAMGenetics"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMGenetics = Convert.ToBoolean(reader["AOAMGenetics"]); if(reader["AOAMUrology"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMUrology = Convert.ToBoolean(reader["AOAMUrology"]); if(reader["AOAMMineralMetabolism"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMMineralMetabolism = Convert.ToBoolean(reader["AOAMMineralMetabolism"]); if(reader["AOAMAnemia"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMAnemia = Convert.ToBoolean(reader["AOAMAnemia"]); if(reader["AOAMDiabetes"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMDiabetes = Convert.ToBoolean(reader["AOAMDiabetes"]); if(reader["AOAMImmunology"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMImmunology = Convert.ToBoolean(reader["AOAMImmunology"]); if(reader["AOAMPathology"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMPathology = Convert.ToBoolean(reader["AOAMPathology"]); if(reader["AOAMIterventionalCCN"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMIterventionalCCN = Convert.ToBoolean(reader["AOAMIterventionalCCN"]); if(reader["AOAMOther"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMOther = Convert.ToBoolean(reader["AOAMOther"]); if(reader["AOAMOtherText"] != DBNull.Value) _conferenceRegisterationsLanguage.AOAMOtherText = Convert.ToString(reader["AOAMOtherText"]); if(reader["SponsorName"] != DBNull.Value) _conferenceRegisterationsLanguage.SponsorName = Convert.ToString(reader["SponsorName"]); if(reader["DeductedAmount"] != DBNull.Value) _conferenceRegisterationsLanguage.DeductedAmount = Convert.ToDecimal(reader["DeductedAmount"]); if(reader["IsActive"] != DBNull.Value) _conferenceRegisterationsLanguage.IsActive = Convert.ToBoolean(reader["IsActive"]); if(reader["IsMember"] != DBNull.Value) _conferenceRegisterationsLanguage.IsMember = Convert.ToBoolean(reader["IsMember"]); if(reader["IsSelfSponsor"] != DBNull.Value) _conferenceRegisterationsLanguage.IsSelfSponsor = Convert.ToBoolean(reader["IsSelfSponsor"]); if(reader["ConferenceRegistererParentId"] != DBNull.Value) _conferenceRegisterationsLanguage.ConferenceRegistererParentId = Convert.ToInt32(reader["ConferenceRegistererParentId"]); if(reader["LanguageID"] != DBNull.Value) _conferenceRegisterationsLanguage.LanguageID = Convert.ToInt32(reader["LanguageID"]); _conferenceRegisterationsLanguage.NewRecord = false; } reader.Close(); return _conferenceRegisterationsLanguage; }