Example #1
0
 /// <summary>
 /// Update a database row from a class
 /// </summary>
 public static void UpdateRowFromAointegrations(ref DataRow row, Aointegrations entity)
 {
     row.SetField("ServiceURL", entity.serviceURL);
     row.SetField("ApplicationID", entity.applicationID);
     row.SetField("InstanceID", entity.instanceID);
     row.SetField("NamespaceID", entity.namespaceID);
     row.SetField("ProfileID", entity.profileID);
     row.SetField("ApiKey", entity.apiKey);
     row.SetField("TaxApplicationID", entity.taxApplicationID);
     row.SetField("TaxServiceURL", entity.taxServiceURL);
     row.SetField("TaxAdminName", entity.taxAdminName);
     row.SetField("TaxAdminPassword", entity.taxAdminPassword);
     row.SetField("TaxAppVersion", entity.taxAppVersion);
     row.SetField("CertApplicationID", entity.certApplicationID);
     row.SetField("CertAdminName", entity.certAdminName);
     row.SetField("CertAdminPassword", entity.certAdminPassword);
     row.SetField("CertConnection", entity.certConnection);
     row.SetField("CertService", entity.certService);
     row.SetField("CertContent", entity.certContent);
     row.SetField("AddrServiceURL", entity.addrServiceURL);
     row.SetField("AddrAcctId", entity.addrAcctId);
     row.SetField("AddrAcctPswrd", entity.addrAcctPswrd);
     row.SetField("FinIntegrationTy", entity.finIntegrationTy);
     row.SetField("FinIntTyWarning1", entity.finIntTyWarning1);
     row.SetField("FinIntTyWarning2", entity.finIntTyWarning2);
     row.SetField("FinIntTyWarning3", entity.finIntTyWarning3);
     row.SetField("FinIntTyWarning4", entity.finIntTyWarning4);
     row.SetField("FinIntTyWarning5", entity.finIntTyWarning5);
     row.SetField("FinIntTyWarning6", entity.finIntTyWarning6);
     row.SetField("FinIntTyWarning7", entity.finIntTyWarning7);
     row.SetField("FinIntTyWarning8", entity.finIntTyWarning8);
     row.SetField("FinIntTyWarning9", entity.finIntTyWarning9);
     row.SetField("ionactivateshipto", entity.ionactivateshipto);
     row.SetField("currproc", entity.currproc);
     row.SetField("FTPProcess", entity.fTPProcess);
     row.SetField("SIGProcess", entity.sIGProcess);
     row.SetField("Printer", entity.printer);
     row.SetField("FAXPrinter", entity.fAXPrinter);
     row.SetField("FTPAddress", entity.fTPAddress);
     row.SetField("FTPUser", entity.fTPUser);
     row.SetField("FTPPassword", entity.fTPPassword);
     row.SetField("FTPEmail", entity.fTPEmail);
     row.SetField("FTPRemDir", entity.fTPRemDir);
     row.SetField("FTPLogFile", entity.fTPLogFile);
     row.SetField("FilePrefix", entity.filePrefix);
     row.SetField("LockBox", entity.lockBox);
     row.SetField("PayDir", entity.payDir);
     row.SetField("EDIfl", entity.eDIfl);
     row.SetField("dnbiinterfacefl", entity.dnbiinterfacefl);
     row.SetField("dnbihostname", entity.dnbihostname);
     row.SetField("dnbiportnumber", entity.dnbiportnumber);
     row.SetField("dnbiresourcename", entity.dnbiresourcename);
     row.SetField("dnbidefaultcredlim", entity.dnbidefaultcredlim);
     row.SetField("dnbimaxcredlim", entity.dnbimaxcredlim);
     row.SetField("dnbiincreasecredlim", entity.dnbiincreasecredlim);
     row.SetField("dnbireviewperiod", entity.dnbireviewperiod);
     row.SetField("dnbioecreditcheckfl", entity.dnbioecreditcheckfl);
     row.SetField("userfield", entity.userfield);
     row.SetField("multitenantfl", entity.multitenantfl);
     row.SetField("cloudedition", entity.cloudedition);
     row.SetField("TaxHostedInterface", entity.taxHostedInterface);
     row.SetField("TaxHostedSecurityKey", entity.taxHostedSecurityKey);
     row.SetField("ISMPrint", entity.iSMPrint);
     row.SetField("ISMNonImpactProduct", entity.iSMNonImpactProduct);
     row.SetField("ISMLive", entity.iSMLive);
     row.SetField("ISMApiUrl", entity.iSMApiUrl);
     row.SetField("ISMApiUserName", entity.iSMApiUserName);
     row.SetField("ISMApiPassWord", entity.iSMApiPassWord);
     row.SetField("ISMApiConfigName", entity.iSMApiConfigName);
     row.SetField("AllowRental", entity.allowRental);
     row.SetField("AutomaticallyPurgeIORecord", entity.automaticallyPurgeIORecord);
     row.SetField("OutboundProcessing", entity.outboundProcessing);
     row.SetField("OutboundProcessingThreads", entity.outboundProcessingThreads);
     row.SetField("InboundOperator", entity.inboundOperator);
     row.SetField("SurchargeAddon", entity.surchargeAddon);
     row.SetField("DiscountAddon", entity.discountAddon);
     row.SetField("WaiverAddon", entity.waiverAddon);
     row.SetField("LostBusiness", entity.lostBusiness);
     row.SetField("IONEDI810InLive", entity.iONEDI810InLive);
     row.SetField("IONEDI849InLive", entity.iONEDI849InLive);
     row.SetField("IONEDI855InLive", entity.iONEDI855InLive);
     row.SetField("IONEDI856InLive", entity.iONEDI856InLive);
     row.SetField("LaborReturnReason", entity.laborReturnReason);
     row.SetField("MiscReturnReason", entity.miscReturnReason);
     row.SetField("ISMLogicalID", entity.iSMLogicalID);
     row.SetField("FreightAddon", entity.freightAddon);
     row.SetField("MiscAddon", entity.miscAddon);
     row.SetField("LogicalID", entity.logicalID);
     row.SetField("locallyMexicoFl", entity.locallyMexicoFl);
 }
Example #2
0
        public static Aointegrations BuildAointegrationsFromRow(DataRow row)
        {
            Aointegrations entity = new Aointegrations();

            entity.serviceURL                 = row.IsNull("ServiceURL") ? string.Empty : row.Field <string>("ServiceURL");
            entity.applicationID              = row.IsNull("ApplicationID") ? string.Empty : row.Field <string>("ApplicationID");
            entity.instanceID                 = row.IsNull("InstanceID") ? string.Empty : row.Field <string>("InstanceID");
            entity.namespaceID                = row.IsNull("NamespaceID") ? string.Empty : row.Field <string>("NamespaceID");
            entity.profileID                  = row.IsNull("ProfileID") ? string.Empty : row.Field <string>("ProfileID");
            entity.apiKey                     = row.IsNull("ApiKey") ? string.Empty : row.Field <string>("ApiKey");
            entity.taxApplicationID           = row.IsNull("TaxApplicationID") ? string.Empty : row.Field <string>("TaxApplicationID");
            entity.taxServiceURL              = row.IsNull("TaxServiceURL") ? string.Empty : row.Field <string>("TaxServiceURL");
            entity.taxAdminName               = row.IsNull("TaxAdminName") ? string.Empty : row.Field <string>("TaxAdminName");
            entity.taxAdminPassword           = row.IsNull("TaxAdminPassword") ? string.Empty : row.Field <string>("TaxAdminPassword");
            entity.taxAppVersion              = row.IsNull("TaxAppVersion") ? string.Empty : row.Field <string>("TaxAppVersion");
            entity.certApplicationID          = row.IsNull("CertApplicationID") ? string.Empty : row.Field <string>("CertApplicationID");
            entity.certAdminName              = row.IsNull("CertAdminName") ? string.Empty : row.Field <string>("CertAdminName");
            entity.certAdminPassword          = row.IsNull("CertAdminPassword") ? string.Empty : row.Field <string>("CertAdminPassword");
            entity.certConnection             = row.IsNull("CertConnection") ? string.Empty : row.Field <string>("CertConnection");
            entity.certService                = row.IsNull("CertService") ? string.Empty : row.Field <string>("CertService");
            entity.certContent                = row.IsNull("CertContent") ? string.Empty : row.Field <string>("CertContent");
            entity.addrServiceURL             = row.IsNull("AddrServiceURL") ? string.Empty : row.Field <string>("AddrServiceURL");
            entity.addrAcctId                 = row.IsNull("AddrAcctId") ? string.Empty : row.Field <string>("AddrAcctId");
            entity.addrAcctPswrd              = row.IsNull("AddrAcctPswrd") ? string.Empty : row.Field <string>("AddrAcctPswrd");
            entity.finIntegrationTy           = row.IsNull("FinIntegrationTy") ? string.Empty : row.Field <string>("FinIntegrationTy");
            entity.finIntTyWarning1           = row.IsNull("FinIntTyWarning1") ? string.Empty : row.Field <string>("FinIntTyWarning1");
            entity.finIntTyWarning2           = row.IsNull("FinIntTyWarning2") ? string.Empty : row.Field <string>("FinIntTyWarning2");
            entity.finIntTyWarning3           = row.IsNull("FinIntTyWarning3") ? string.Empty : row.Field <string>("FinIntTyWarning3");
            entity.finIntTyWarning4           = row.IsNull("FinIntTyWarning4") ? string.Empty : row.Field <string>("FinIntTyWarning4");
            entity.finIntTyWarning5           = row.IsNull("FinIntTyWarning5") ? string.Empty : row.Field <string>("FinIntTyWarning5");
            entity.finIntTyWarning6           = row.IsNull("FinIntTyWarning6") ? string.Empty : row.Field <string>("FinIntTyWarning6");
            entity.finIntTyWarning7           = row.IsNull("FinIntTyWarning7") ? string.Empty : row.Field <string>("FinIntTyWarning7");
            entity.finIntTyWarning8           = row.IsNull("FinIntTyWarning8") ? string.Empty : row.Field <string>("FinIntTyWarning8");
            entity.finIntTyWarning9           = row.IsNull("FinIntTyWarning9") ? string.Empty : row.Field <string>("FinIntTyWarning9");
            entity.ionactivateshipto          = row.Field <bool>("ionactivateshipto");
            entity.currproc                   = row.IsNull("currproc") ? string.Empty : row.Field <string>("currproc");
            entity.fTPProcess                 = row.IsNull("FTPProcess") ? string.Empty : row.Field <string>("FTPProcess");
            entity.sIGProcess                 = row.IsNull("SIGProcess") ? string.Empty : row.Field <string>("SIGProcess");
            entity.printer                    = row.IsNull("Printer") ? string.Empty : row.Field <string>("Printer");
            entity.fAXPrinter                 = row.IsNull("FAXPrinter") ? string.Empty : row.Field <string>("FAXPrinter");
            entity.fTPAddress                 = row.IsNull("FTPAddress") ? string.Empty : row.Field <string>("FTPAddress");
            entity.fTPUser                    = row.IsNull("FTPUser") ? string.Empty : row.Field <string>("FTPUser");
            entity.fTPPassword                = row.IsNull("FTPPassword") ? string.Empty : row.Field <string>("FTPPassword");
            entity.fTPEmail                   = row.IsNull("FTPEmail") ? string.Empty : row.Field <string>("FTPEmail");
            entity.fTPRemDir                  = row.IsNull("FTPRemDir") ? string.Empty : row.Field <string>("FTPRemDir");
            entity.fTPLogFile                 = row.IsNull("FTPLogFile") ? string.Empty : row.Field <string>("FTPLogFile");
            entity.filePrefix                 = row.IsNull("FilePrefix") ? string.Empty : row.Field <string>("FilePrefix");
            entity.lockBox                    = row.IsNull("LockBox") ? string.Empty : row.Field <string>("LockBox");
            entity.payDir                     = row.IsNull("PayDir") ? string.Empty : row.Field <string>("PayDir");
            entity.eDIfl                      = row.Field <bool>("EDIfl");
            entity.dnbiinterfacefl            = row.Field <bool>("dnbiinterfacefl");
            entity.dnbihostname               = row.IsNull("dnbihostname") ? string.Empty : row.Field <string>("dnbihostname");
            entity.dnbiportnumber             = row.IsNull("dnbiportnumber") ? 0 : row.Field <int>("dnbiportnumber");
            entity.dnbiresourcename           = row.IsNull("dnbiresourcename") ? string.Empty : row.Field <string>("dnbiresourcename");
            entity.dnbidefaultcredlim         = row.IsNull("dnbidefaultcredlim") ? decimal.Zero : row.Field <decimal>("dnbidefaultcredlim");
            entity.dnbimaxcredlim             = row.IsNull("dnbimaxcredlim") ? decimal.Zero : row.Field <decimal>("dnbimaxcredlim");
            entity.dnbiincreasecredlim        = row.IsNull("dnbiincreasecredlim") ? decimal.Zero : row.Field <decimal>("dnbiincreasecredlim");
            entity.dnbireviewperiod           = row.IsNull("dnbireviewperiod") ? 0 : row.Field <int>("dnbireviewperiod");
            entity.dnbioecreditcheckfl        = row.Field <bool>("dnbioecreditcheckfl");
            entity.userfield                  = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
            entity.multitenantfl              = row.Field <bool>("multitenantfl");
            entity.cloudedition               = row.Field <bool>("cloudedition");
            entity.taxHostedInterface         = row.Field <bool>("TaxHostedInterface");
            entity.taxHostedSecurityKey       = row.IsNull("TaxHostedSecurityKey") ? string.Empty : row.Field <string>("TaxHostedSecurityKey");
            entity.iSMPrint                   = row.Field <bool>("ISMPrint");
            entity.iSMNonImpactProduct        = row.IsNull("ISMNonImpactProduct") ? string.Empty : row.Field <string>("ISMNonImpactProduct");
            entity.iSMLive                    = row.Field <bool>("ISMLive");
            entity.iSMApiUrl                  = row.IsNull("ISMApiUrl") ? string.Empty : row.Field <string>("ISMApiUrl");
            entity.iSMApiUserName             = row.IsNull("ISMApiUserName") ? string.Empty : row.Field <string>("ISMApiUserName");
            entity.iSMApiPassWord             = row.IsNull("ISMApiPassWord") ? string.Empty : row.Field <string>("ISMApiPassWord");
            entity.iSMApiConfigName           = row.IsNull("ISMApiConfigName") ? string.Empty : row.Field <string>("ISMApiConfigName");
            entity.allowRental                = row.Field <bool>("AllowRental");
            entity.automaticallyPurgeIORecord = row.Field <bool>("AutomaticallyPurgeIORecord");
            entity.outboundProcessing         = row.Field <bool>("OutboundProcessing");
            entity.outboundProcessingThreads  = row.IsNull("OutboundProcessingThreads") ? 0 : row.Field <int>("OutboundProcessingThreads");
            entity.inboundOperator            = row.IsNull("InboundOperator") ? string.Empty : row.Field <string>("InboundOperator");
            entity.surchargeAddon             = row.IsNull("SurchargeAddon") ? 0 : row.Field <int>("SurchargeAddon");
            entity.discountAddon              = row.IsNull("DiscountAddon") ? 0 : row.Field <int>("DiscountAddon");
            entity.waiverAddon                = row.IsNull("WaiverAddon") ? 0 : row.Field <int>("WaiverAddon");
            entity.lostBusiness               = row.IsNull("LostBusiness") ? string.Empty : row.Field <string>("LostBusiness");
            entity.iONEDI810InLive            = row.Field <bool>("IONEDI810InLive");
            entity.iONEDI849InLive            = row.Field <bool>("IONEDI849InLive");
            entity.iONEDI855InLive            = row.Field <bool>("IONEDI855InLive");
            entity.iONEDI856InLive            = row.Field <bool>("IONEDI856InLive");
            entity.laborReturnReason          = row.IsNull("LaborReturnReason") ? string.Empty : row.Field <string>("LaborReturnReason");
            entity.miscReturnReason           = row.IsNull("MiscReturnReason") ? string.Empty : row.Field <string>("MiscReturnReason");
            entity.iSMLogicalID               = row.IsNull("ISMLogicalID") ? string.Empty : row.Field <string>("ISMLogicalID");
            entity.freightAddon               = row.IsNull("FreightAddon") ? 0 : row.Field <int>("FreightAddon");
            entity.miscAddon                  = row.IsNull("MiscAddon") ? 0 : row.Field <int>("MiscAddon");
            entity.logicalID                  = row.IsNull("LogicalID") ? string.Empty : row.Field <string>("LogicalID");
            entity.locallyMexicoFl            = row.Field <bool>("locallyMexicoFl");
            return(entity);
        }