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