protected override void LoadFromRow(DataRow _dataRow) { SummitDS.BodyShopRow _thisRow = _dataRow as SummitDS.BodyShopRow; if (_thisRow != null) { this._ID = _thisRow.shop_id; this.m_strShopName = _thisRow.Isshop_nameNull() ? String.Empty : _thisRow.shop_name; this.m_strAddress1 = _thisRow.Isaddress1Null() ? String.Empty : _thisRow.address1; this.m_strAddress2 = _thisRow.Isaddress2Null() ? String.Empty : _thisRow.address2; this.m_strCity = _thisRow.IscityNull() ? String.Empty : _thisRow.city; this.m_strState = _thisRow.IsstateNull() ? String.Empty : _thisRow.state; this.m_strZip = _thisRow.IszipNull() ? String.Empty : _thisRow.zip; this.m_strPhone = _thisRow.IsphoneNull() ? String.Empty : _thisRow.phone; this.m_strFax = _thisRow.IsfaxNull() ? String.Empty : _thisRow.fax; this.m_strEmail = _thisRow.IsemailNull() ? String.Empty : _thisRow.email; this.m_strWebsite = _thisRow.IswebsiteNull() ? String.Empty : _thisRow.website; this.m_strBusinessLicence = _thisRow.Isbusiness_licenseNull() ? String.Empty : _thisRow.business_license; this.m_strEpsLicence = _thisRow.Isepa_licenseNull() ? String.Empty : _thisRow.epa_license; this.m_strBarLicence = _thisRow.Isbar_licenseNull() ? String.Empty : _thisRow.bar_license; this.m_strNetWorkName = _thisRow.Isnetwork_nameNull() ? String.Empty : _thisRow.network_name; this.m_strCertificationVehicles = _thisRow.Iscertification_vehiclesNull() ? String.Empty : _thisRow.certification_vehicles; this.m_strThirdPartyProviders = _thisRow.Isthird_party_providersNull() ? String.Empty : _thisRow.third_party_providers; this.m_iRating = _thisRow.IsratingsNull() ? (Nullable <Int32>)null : _thisRow.ratings; this.m_fLatitude = _thisRow.IslatitudeNull() ? (Nullable <double>)null : _thisRow.latitude; this.m_fLongitude = _thisRow.IslongitudeNull() ? (Nullable <double>)null : _thisRow.longitude; this.m_strManager = _thisRow.IsmanagerNull() ? String.Empty : _thisRow.manager; this.m_strSystemAdmin = _thisRow.Issystem_adminNull() ? String.Empty : _thisRow.system_admin; this.m_strPortalAdminPassword = _thisRow.Isportal_admin_passwordNull() ? String.Empty : _thisRow.portal_admin_password; this.m_strTagLine = _thisRow.Iscompany_tag_lineNull() ? String.Empty : _thisRow.company_tag_line; this.m_strOwner = _thisRow.IsownerNull() ? String.Empty : _thisRow.owner; this.m_iNoPremierShop = _thisRow.IsnoPremierShopNull() ? (Nullable <Int32>)null : _thisRow.noPremierShop; this.m_iNoHelpSelection = _thisRow.IsnoHelpSelectionNull() ? (Nullable <Int32>)null : _thisRow.noHelpSelection; this.m_bIsPremierShop = _thisRow.IsisPremierShopNull() ? (Nullable <Boolean>)null : _thisRow.isPremierShop; this.m_strContent = _thisRow.IscontentNull() ? String.Empty : _thisRow.content; this.m_strImagePath = _thisRow.Isimage_pathNull() ? String.Empty : _thisRow.image_path; this.m_iMessageCount = _thisRow.IsmessageCountNull() ? (Nullable <Int32>)null : _thisRow.messageCount; this.m_iAvailableMessages = _thisRow.IsavailableMessagesNull() ? (Nullable <Int32>)null : _thisRow.availableMessages; this.m_dtExpirationDate = _thisRow.IsexpirationDateNull() ? (Nullable <DateTime>)null : _thisRow.expirationDate; // this.m_dt_ts = _thisRow.Is_tsNull() ? (Nullable<DateTime>) null : _thisRow._ts ; _rowToSave = _thisRow; } }
protected override void SaveToRow() { SummitDS.BodyShopDataTable _thisTable = new SummitDS.BodyShopDataTable(); if (_rowToSave == null) { _rowToSave = _thisTable.NewBodyShopRow(); } SummitDS.BodyShopRow _dataRow = _rowToSave as SummitDS.BodyShopRow; if (_dataRow != null) { if (IsExisting()) { if (String.IsNullOrEmpty(m_strShopName)) { if (!_dataRow.Isshop_nameNull()) { _dataRow.Setshop_nameNull(); } } else if (_dataRow.Isshop_nameNull() ? true : _dataRow.shop_name != m_strShopName) { _dataRow.shop_name = m_strShopName; } if (String.IsNullOrEmpty(m_strAddress1)) { if (!_dataRow.Isaddress1Null()) { _dataRow.Setaddress1Null(); } } else if (_dataRow.Isaddress1Null() ? true : _dataRow.address1 != m_strAddress1) { _dataRow.address1 = m_strAddress1; } if (String.IsNullOrEmpty(m_strAddress2)) { if (!_dataRow.Isaddress2Null()) { _dataRow.Setaddress2Null(); } } else if (_dataRow.Isaddress2Null() ? true : _dataRow.address2 != m_strAddress2) { _dataRow.address2 = m_strAddress2; } if (String.IsNullOrEmpty(m_strCity)) { if (!_dataRow.IscityNull()) { _dataRow.SetcityNull(); } } else if (_dataRow.IscityNull() ? true : _dataRow.city != m_strCity) { _dataRow.city = m_strCity; } if (String.IsNullOrEmpty(m_strState)) { if (!_dataRow.IsstateNull()) { _dataRow.SetstateNull(); } } else if (_dataRow.IsstateNull() ? true : _dataRow.state != m_strState) { _dataRow.state = m_strState; } if (String.IsNullOrEmpty(m_strZip)) { if (!_dataRow.IszipNull()) { _dataRow.SetzipNull(); } } else if (_dataRow.IszipNull() ? true : _dataRow.zip != m_strZip) { _dataRow.zip = m_strZip; } if (String.IsNullOrEmpty(m_strPhone)) { if (!_dataRow.IsphoneNull()) { _dataRow.SetphoneNull(); } } else if (_dataRow.IsphoneNull() ? true : _dataRow.phone != m_strPhone) { _dataRow.phone = m_strPhone; } if (String.IsNullOrEmpty(m_strFax)) { if (!_dataRow.IsfaxNull()) { _dataRow.SetfaxNull(); } } else if (_dataRow.IsfaxNull() ? true : _dataRow.fax != m_strFax) { _dataRow.fax = m_strFax; } if (String.IsNullOrEmpty(m_strEmail)) { if (!_dataRow.IsemailNull()) { _dataRow.SetemailNull(); } } else if (_dataRow.IsemailNull() ? true : _dataRow.email != m_strEmail) { _dataRow.email = m_strEmail; } if (String.IsNullOrEmpty(m_strWebsite)) { if (!_dataRow.IswebsiteNull()) { _dataRow.SetwebsiteNull(); } } else if (_dataRow.IswebsiteNull() ? true : _dataRow.website != m_strWebsite) { _dataRow.website = m_strWebsite; } if (String.IsNullOrEmpty(m_strBusinessLicence)) { if (!_dataRow.Isbusiness_licenseNull()) { _dataRow.Setbusiness_licenseNull(); } } else if (_dataRow.Isbusiness_licenseNull() ? true : _dataRow.business_license != m_strBusinessLicence) { _dataRow.business_license = m_strBusinessLicence; } if (String.IsNullOrEmpty(m_strEpsLicence)) { if (!_dataRow.Isepa_licenseNull()) { _dataRow.Setepa_licenseNull(); } } else if (_dataRow.Isepa_licenseNull() ? true : _dataRow.epa_license != m_strEpsLicence) { _dataRow.epa_license = m_strEpsLicence; } if (String.IsNullOrEmpty(m_strBarLicence)) { if (!_dataRow.Isbar_licenseNull()) { _dataRow.Setbar_licenseNull(); } } else if (_dataRow.Isbar_licenseNull() ? true : _dataRow.bar_license != m_strBarLicence) { _dataRow.bar_license = m_strBarLicence; } if (String.IsNullOrEmpty(m_strNetWorkName)) { if (!_dataRow.Isnetwork_nameNull()) { _dataRow.Setnetwork_nameNull(); } } else if (_dataRow.Isnetwork_nameNull() ? true : _dataRow.network_name != m_strNetWorkName) { _dataRow.network_name = m_strNetWorkName; } if (String.IsNullOrEmpty(m_strCertificationVehicles)) { if (!_dataRow.Iscertification_vehiclesNull()) { _dataRow.Setcertification_vehiclesNull(); } } else if (_dataRow.Iscertification_vehiclesNull() ? true : _dataRow.certification_vehicles != m_strCertificationVehicles) { _dataRow.certification_vehicles = m_strCertificationVehicles; } if (String.IsNullOrEmpty(m_strThirdPartyProviders)) { if (!_dataRow.Isthird_party_providersNull()) { _dataRow.Setthird_party_providersNull(); } } else if (_dataRow.Isthird_party_providersNull() ? true : _dataRow.third_party_providers != m_strThirdPartyProviders) { _dataRow.third_party_providers = m_strThirdPartyProviders; } if (String.IsNullOrEmpty(m_strManager)) { if (!_dataRow.IsmanagerNull()) { _dataRow.SetmanagerNull(); } } else if (_dataRow.IsmanagerNull() ? true : _dataRow.manager != m_strManager) { _dataRow.manager = m_strManager; } if (String.IsNullOrEmpty(m_strSystemAdmin)) { if (!_dataRow.Issystem_adminNull()) { _dataRow.Setsystem_adminNull(); } } else if (_dataRow.Issystem_adminNull() ? true : _dataRow.system_admin != m_strSystemAdmin) { _dataRow.system_admin = m_strSystemAdmin; } if (String.IsNullOrEmpty(m_strPortalAdminPassword)) { if (!_dataRow.Isportal_admin_passwordNull()) { _dataRow.Setportal_admin_passwordNull(); } } else if (_dataRow.Isportal_admin_passwordNull() ? true : _dataRow.portal_admin_password != m_strPortalAdminPassword) { _dataRow.portal_admin_password = m_strPortalAdminPassword; } if (String.IsNullOrEmpty(m_strTagLine)) { if (!_dataRow.Iscompany_tag_lineNull()) { _dataRow.Setcompany_tag_lineNull(); } } else if (_dataRow.Iscompany_tag_lineNull() ? true : _dataRow.company_tag_line != m_strTagLine) { _dataRow.company_tag_line = m_strTagLine; } if (String.IsNullOrEmpty(m_strOwner)) { if (!_dataRow.IsownerNull()) { _dataRow.SetownerNull(); } } else if (_dataRow.IsownerNull() ? true : _dataRow.owner != m_strOwner) { _dataRow.owner = m_strOwner; } if (iRating.HasValue) { _dataRow.ratings = iRating.Value; } else { _dataRow.SetratingsNull(); } if (fLatitude.HasValue) { _dataRow.latitude = fLatitude.Value; } else { _dataRow.SetlatitudeNull(); } if (fLongitude.HasValue) { _dataRow.longitude = fLongitude.Value; } else { _dataRow.SetlongitudeNull(); } if (iNoHelpSelection.HasValue) { _dataRow.noHelpSelection = iNoHelpSelection.Value; } else { _dataRow.SetnoHelpSelectionNull(); } if (iNoPremierShop.HasValue) { _dataRow.noPremierShop = iNoPremierShop.Value; } else { _dataRow.SetnoPremierShopNull(); } if (bIsPremierShop.HasValue) { _dataRow.isPremierShop = bIsPremierShop.Value; } else { _dataRow.SetisPremierShopNull(); } if (String.IsNullOrEmpty(m_strContent)) { if (!_dataRow.IscontentNull()) { _dataRow.SetcontentNull(); } } else if (_dataRow.IscontentNull() ? true : _dataRow.content != m_strContent) { _dataRow.content = m_strContent; } if (String.IsNullOrEmpty(m_strImagePath)) { if (!_dataRow.Isimage_pathNull()) { _dataRow.Setimage_pathNull(); } } else if (_dataRow.Isimage_pathNull() ? true : _dataRow.image_path != m_strImagePath) { _dataRow.image_path = m_strImagePath; } if (iMessageCount.HasValue) { _dataRow.messageCount = iMessageCount.Value; } else { _dataRow.SetmessageCountNull(); } if (iAvailableMessages.HasValue) { _dataRow.availableMessages = iAvailableMessages.Value; } else { _dataRow.SetavailableMessagesNull(); } if (dtExpirationDate.HasValue) { _dataRow.expirationDate = dtExpirationDate.Value; } else { _dataRow.SetexpirationDateNull(); } } else { if (String.IsNullOrEmpty(m_strShopName)) { if (!_dataRow.Isshop_nameNull()) { _dataRow.Setshop_nameNull(); } } else if (_dataRow.Isshop_nameNull() ? true : _dataRow.shop_name != m_strShopName) { _dataRow.shop_name = m_strShopName; } if (String.IsNullOrEmpty(m_strAddress1)) { if (!_dataRow.Isaddress1Null()) { _dataRow.Setaddress1Null(); } } else if (_dataRow.Isaddress1Null() ? true : _dataRow.address1 != m_strAddress1) { _dataRow.address1 = m_strAddress1; } if (String.IsNullOrEmpty(m_strAddress2)) { if (!_dataRow.Isaddress2Null()) { _dataRow.Setaddress2Null(); } } else if (_dataRow.Isaddress2Null() ? true : _dataRow.address2 != m_strAddress2) { _dataRow.address2 = m_strAddress2; } if (String.IsNullOrEmpty(m_strCity)) { if (!_dataRow.IscityNull()) { _dataRow.SetcityNull(); } } else if (_dataRow.IscityNull() ? true : _dataRow.city != m_strCity) { _dataRow.city = m_strCity; } if (String.IsNullOrEmpty(m_strState)) { if (!_dataRow.IsstateNull()) { _dataRow.SetstateNull(); } } else if (_dataRow.IsstateNull() ? true : _dataRow.state != m_strState) { _dataRow.state = m_strState; } if (String.IsNullOrEmpty(m_strZip)) { if (!_dataRow.IszipNull()) { _dataRow.SetzipNull(); } } else if (_dataRow.IszipNull() ? true : _dataRow.zip != m_strZip) { _dataRow.zip = m_strZip; } if (String.IsNullOrEmpty(m_strPhone)) { if (!_dataRow.IsphoneNull()) { _dataRow.SetphoneNull(); } } else if (_dataRow.IsphoneNull() ? true : _dataRow.phone != m_strPhone) { _dataRow.phone = m_strPhone; } if (String.IsNullOrEmpty(m_strFax)) { if (!_dataRow.IsfaxNull()) { _dataRow.SetfaxNull(); } } else if (_dataRow.IsfaxNull() ? true : _dataRow.fax != m_strFax) { _dataRow.fax = m_strFax; } if (String.IsNullOrEmpty(m_strEmail)) { if (!_dataRow.IsemailNull()) { _dataRow.SetemailNull(); } } else if (_dataRow.IsemailNull() ? true : _dataRow.email != m_strEmail) { _dataRow.email = m_strEmail; } if (String.IsNullOrEmpty(m_strWebsite)) { if (!_dataRow.IswebsiteNull()) { _dataRow.SetwebsiteNull(); } } else if (_dataRow.IswebsiteNull() ? true : _dataRow.website != m_strWebsite) { _dataRow.website = m_strWebsite; } if (String.IsNullOrEmpty(m_strBusinessLicence)) { if (!_dataRow.Isbusiness_licenseNull()) { _dataRow.Setbusiness_licenseNull(); } } else if (_dataRow.Isbusiness_licenseNull() ? true : _dataRow.business_license != m_strBusinessLicence) { _dataRow.business_license = m_strBusinessLicence; } if (String.IsNullOrEmpty(m_strEpsLicence)) { if (!_dataRow.Isepa_licenseNull()) { _dataRow.Setepa_licenseNull(); } } else if (_dataRow.Isepa_licenseNull() ? true : _dataRow.epa_license != m_strEpsLicence) { _dataRow.epa_license = m_strEpsLicence; } if (String.IsNullOrEmpty(m_strBarLicence)) { if (!_dataRow.Isbar_licenseNull()) { _dataRow.Setbar_licenseNull(); } } else if (_dataRow.Isbar_licenseNull() ? true : _dataRow.bar_license != m_strBarLicence) { _dataRow.bar_license = m_strBarLicence; } if (String.IsNullOrEmpty(m_strNetWorkName)) { if (!_dataRow.Isnetwork_nameNull()) { _dataRow.Setnetwork_nameNull(); } } else if (_dataRow.Isnetwork_nameNull() ? true : _dataRow.network_name != m_strNetWorkName) { _dataRow.network_name = m_strNetWorkName; } if (String.IsNullOrEmpty(m_strCertificationVehicles)) { if (!_dataRow.Iscertification_vehiclesNull()) { _dataRow.Setcertification_vehiclesNull(); } } else if (_dataRow.Iscertification_vehiclesNull() ? true : _dataRow.certification_vehicles != m_strCertificationVehicles) { _dataRow.certification_vehicles = m_strCertificationVehicles; } if (String.IsNullOrEmpty(m_strThirdPartyProviders)) { if (!_dataRow.Isthird_party_providersNull()) { _dataRow.Setthird_party_providersNull(); } } else if (_dataRow.Isthird_party_providersNull() ? true : _dataRow.third_party_providers != m_strThirdPartyProviders) { _dataRow.third_party_providers = m_strThirdPartyProviders; } if (String.IsNullOrEmpty(m_strManager)) { if (!_dataRow.IsmanagerNull()) { _dataRow.SetmanagerNull(); } } else if (_dataRow.IsmanagerNull() ? true : _dataRow.manager != m_strManager) { _dataRow.manager = m_strManager; } if (String.IsNullOrEmpty(m_strSystemAdmin)) { if (!_dataRow.Issystem_adminNull()) { _dataRow.Setsystem_adminNull(); } } else if (_dataRow.Issystem_adminNull() ? true : _dataRow.system_admin != m_strSystemAdmin) { _dataRow.system_admin = m_strSystemAdmin; } if (String.IsNullOrEmpty(m_strPortalAdminPassword)) { if (!_dataRow.Isportal_admin_passwordNull()) { _dataRow.Setportal_admin_passwordNull(); } } else if (_dataRow.Isportal_admin_passwordNull() ? true : _dataRow.portal_admin_password != m_strPortalAdminPassword) { _dataRow.portal_admin_password = m_strPortalAdminPassword; } if (String.IsNullOrEmpty(m_strTagLine)) { if (!_dataRow.Iscompany_tag_lineNull()) { _dataRow.Setcompany_tag_lineNull(); } } else if (_dataRow.Iscompany_tag_lineNull() ? true : _dataRow.company_tag_line != m_strTagLine) { _dataRow.company_tag_line = m_strTagLine; } if (String.IsNullOrEmpty(m_strOwner)) { if (!_dataRow.IsownerNull()) { _dataRow.SetownerNull(); } } else if (_dataRow.IsownerNull() ? true : _dataRow.owner != m_strOwner) { _dataRow.owner = m_strOwner; } if (iRating.HasValue) { _dataRow.ratings = iRating.Value; } else { _dataRow.SetratingsNull(); } if (fLatitude.HasValue) { _dataRow.latitude = fLatitude.Value; } else { _dataRow.SetlatitudeNull(); } if (fLongitude.HasValue) { _dataRow.longitude = fLongitude.Value; } else { _dataRow.SetlongitudeNull(); } if (iNoHelpSelection.HasValue) { _dataRow.noHelpSelection = iNoHelpSelection.Value; } else { _dataRow.SetnoHelpSelectionNull(); } if (iNoPremierShop.HasValue) { _dataRow.noPremierShop = iNoPremierShop.Value; } else { _dataRow.SetnoPremierShopNull(); } if (bIsPremierShop.HasValue) { _dataRow.isPremierShop = bIsPremierShop.Value; } else { _dataRow.SetisPremierShopNull(); } if (String.IsNullOrEmpty(m_strContent)) { if (!_dataRow.IscontentNull()) { _dataRow.SetcontentNull(); } } else if (_dataRow.IscontentNull() ? true : _dataRow.content != m_strContent) { _dataRow.content = m_strContent; } if (String.IsNullOrEmpty(m_strImagePath)) { if (!_dataRow.Isimage_pathNull()) { _dataRow.Setimage_pathNull(); } } else if (_dataRow.Isimage_pathNull() ? true : _dataRow.image_path != m_strImagePath) { _dataRow.image_path = m_strImagePath; } if (iMessageCount.HasValue) { _dataRow.messageCount = iMessageCount.Value; } else { _dataRow.SetmessageCountNull(); } if (iAvailableMessages.HasValue) { _dataRow.availableMessages = iAvailableMessages.Value; } else { _dataRow.SetavailableMessagesNull(); } if (dtExpirationDate.HasValue) { _dataRow.expirationDate = dtExpirationDate.Value; } else { _dataRow.SetexpirationDateNull(); } _thisTable.AddBodyShopRow(_dataRow); } } }