/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromAovendor(ref DataRow row, Aovendor entity) { row.SetField("cono", entity.cono); row.SetField("apChkfrmt", entity.apChkfrmt); row.SetField("apchkheadfl", entity.apchkheadfl); row.SetField("ap1099Frmt", entity.ap1099Frmt); row.SetField("APImmedFl", entity.aPImmedFl); row.SetField("APHoldFl", entity.aPHoldFl); row.SetField("APmcDiscFl", entity.aPmcDiscFl); row.SetField("APDupInvFl", entity.aPDupInvFl); row.SetField("AllocationTy", entity.allocationTy); row.SetField("apMinBuy", entity.apMinBuy); row.SetField("apOrdCost", entity.apOrdCost); row.SetField("apClsPct1", entity.apClsPct1); row.SetField("apClsPct2", entity.apClsPct2); row.SetField("apClsPct3", entity.apClsPct3); row.SetField("apClsPct4", entity.apClsPct4); row.SetField("apClsPct5", entity.apClsPct5); row.SetField("apClsPct6", entity.apClsPct6); row.SetField("apClsPct7", entity.apClsPct7); row.SetField("apClsPct8", entity.apClsPct8); row.SetField("apClsPct9", entity.apClsPct9); row.SetField("apClsPct10", entity.apClsPct10); row.SetField("apClsPct11", entity.apClsPct11); row.SetField("apClsPct12", entity.apClsPct12); row.SetField("APPerDays1", entity.aPPerDays1); row.SetField("APPerDays2", entity.aPPerDays2); row.SetField("APPerDays3", entity.aPPerDays3); row.SetField("APPerDays4", entity.aPPerDays4); row.SetField("POCommMethod-VMI", entity.pOCommMethodVMI); row.SetField("POCommMethod-EMail", entity.pOCommMethodEMail); row.SetField("POCommMethod-Print", entity.pOCommMethodPrint); row.SetField("POCommMethod-EDI", entity.pOCommMethodEDI); row.SetField("POCommMethod-Fax", entity.pOCommMethodFax); row.SetField("POCommMethod-ION", entity.pOCommMethodION); row.SetField("APBatchDel", entity.aPBatchDel); row.SetField("APDisputeFl", entity.aPDisputeFl); row.SetField("APQtyTolAmt", entity.aPQtyTolAmt); row.SetField("APQtyTolPct", entity.aPQtyTolPct); row.SetField("APLnTolAmt", entity.aPLnTolAmt); row.SetField("APLnTolPct", entity.aPLnTolPct); row.SetField("APInvTolAmt", entity.aPInvTolAmt); row.SetField("APInvTolPct", entity.aPInvTolPct); row.SetField("apinvtolminamt", entity.apinvtolminamt); row.SetField("APUser1Amt", entity.aPUser1Amt); row.SetField("APUser1Pct", entity.aPUser1Pct); row.SetField("APUser2Amt", entity.aPUser2Amt); row.SetField("APUser2Pct", entity.aPUser2Pct); row.SetField("APRcvTolType", entity.aPRcvTolType); row.SetField("APRcvQtyTolAmt", entity.aPRcvQtyTolAmt); row.SetField("APRcvQtyTolPct", entity.aPRcvQtyTolPct); row.SetField("APRcvLnTolAmt", entity.aPRcvLnTolAmt); row.SetField("APRcvLnTolPct", entity.aPRcvLnTolPct); row.SetField("APRcvPOTolAmt", entity.aPRcvPOTolAmt); row.SetField("APRcvPOTolPct", entity.aPRcvPOTolPct); row.SetField("sasc-rowid", entity.sascRowid.ToByteArray()); row.SetField("userfield", entity.userfield); row.SetField("CheckOutputType", entity.checkOutputType); row.SetField("CheckExtraDataLevel1", entity.checkExtraDataLevel1); row.SetField("CheckExtraDataLevel2", entity.checkExtraDataLevel2); row.SetField("AllowAPCreditACH", entity.allowAPCreditACH); row.SetField("aprmtadvedifmt", entity.aprmtadvedifmt); row.SetField("apictransadjedifmt", entity.apictransadjedifmt); row.SetField("apictransedifmt", entity.apictransedifmt); row.SetField("apinvadvedifmt", entity.apinvadvedifmt); row.SetField("CheckIDMDocTypeID", entity.checkIDMDocTypeID); row.SetField("CheckIDMTemplateName", entity.checkIDMTemplateName); row.SetField("CheckIDMFromEmailAddr", entity.checkIDMFromEmailAddr); row.SetField("CheckIDMFromEmailName", entity.checkIDMFromEmailName); row.SetField("CheckRemitIDMDocTypeID", entity.checkRemitIDMDocTypeID); row.SetField("CheckRemitIDMTemplateName", entity.checkRemitIDMTemplateName); row.SetField("CheckLines", entity.checkLines); }
public static Aovendor BuildAovendorFromRow(DataRow row) { Aovendor entity = new Aovendor(); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.apChkfrmt = row.IsNull("apChkfrmt") ? 0 : row.Field <int>("apChkfrmt"); entity.apchkheadfl = row.Field <bool>("apchkheadfl"); entity.ap1099Frmt = row.IsNull("ap1099Frmt") ? 0 : row.Field <int>("ap1099Frmt"); entity.aPImmedFl = row.Field <bool>("APImmedFl"); entity.aPHoldFl = row.Field <bool>("APHoldFl"); entity.aPmcDiscFl = row.Field <bool>("APmcDiscFl"); entity.aPDupInvFl = row.IsNull("APDupInvFl") ? string.Empty : row.Field <string>("APDupInvFl"); entity.allocationTy = row.IsNull("AllocationTy") ? string.Empty : row.Field <string>("AllocationTy"); entity.apMinBuy = row.IsNull("apMinBuy") ? 0 : row.Field <int>("apMinBuy"); entity.apOrdCost = row.IsNull("apOrdCost") ? decimal.Zero : row.Field <decimal>("apOrdCost"); entity.apClsPct1 = row.IsNull("apClsPct1") ? decimal.Zero : row.Field <decimal>("apClsPct1"); entity.apClsPct2 = row.IsNull("apClsPct2") ? decimal.Zero : row.Field <decimal>("apClsPct2"); entity.apClsPct3 = row.IsNull("apClsPct3") ? decimal.Zero : row.Field <decimal>("apClsPct3"); entity.apClsPct4 = row.IsNull("apClsPct4") ? decimal.Zero : row.Field <decimal>("apClsPct4"); entity.apClsPct5 = row.IsNull("apClsPct5") ? decimal.Zero : row.Field <decimal>("apClsPct5"); entity.apClsPct6 = row.IsNull("apClsPct6") ? decimal.Zero : row.Field <decimal>("apClsPct6"); entity.apClsPct7 = row.IsNull("apClsPct7") ? decimal.Zero : row.Field <decimal>("apClsPct7"); entity.apClsPct8 = row.IsNull("apClsPct8") ? decimal.Zero : row.Field <decimal>("apClsPct8"); entity.apClsPct9 = row.IsNull("apClsPct9") ? decimal.Zero : row.Field <decimal>("apClsPct9"); entity.apClsPct10 = row.IsNull("apClsPct10") ? decimal.Zero : row.Field <decimal>("apClsPct10"); entity.apClsPct11 = row.IsNull("apClsPct11") ? decimal.Zero : row.Field <decimal>("apClsPct11"); entity.apClsPct12 = row.IsNull("apClsPct12") ? decimal.Zero : row.Field <decimal>("apClsPct12"); entity.aPPerDays1 = row.IsNull("APPerDays1") ? 0 : row.Field <int>("APPerDays1"); entity.aPPerDays2 = row.IsNull("APPerDays2") ? 0 : row.Field <int>("APPerDays2"); entity.aPPerDays3 = row.IsNull("APPerDays3") ? 0 : row.Field <int>("APPerDays3"); entity.aPPerDays4 = row.IsNull("APPerDays4") ? 0 : row.Field <int>("APPerDays4"); entity.pOCommMethodVMI = row.IsNull("POCommMethod-VMI") ? string.Empty : row.Field <string>("POCommMethod-VMI"); entity.pOCommMethodEMail = row.IsNull("POCommMethod-EMail") ? string.Empty : row.Field <string>("POCommMethod-EMail"); entity.pOCommMethodPrint = row.IsNull("POCommMethod-Print") ? string.Empty : row.Field <string>("POCommMethod-Print"); entity.pOCommMethodEDI = row.IsNull("POCommMethod-EDI") ? string.Empty : row.Field <string>("POCommMethod-EDI"); entity.pOCommMethodFax = row.IsNull("POCommMethod-Fax") ? string.Empty : row.Field <string>("POCommMethod-Fax"); entity.pOCommMethodION = row.IsNull("POCommMethod-ION") ? string.Empty : row.Field <string>("POCommMethod-ION"); entity.aPBatchDel = row.Field <bool>("APBatchDel"); entity.aPDisputeFl = row.Field <bool>("APDisputeFl"); entity.aPQtyTolAmt = row.IsNull("APQtyTolAmt") ? decimal.Zero : row.Field <decimal>("APQtyTolAmt"); entity.aPQtyTolPct = row.IsNull("APQtyTolPct") ? decimal.Zero : row.Field <decimal>("APQtyTolPct"); entity.aPLnTolAmt = row.IsNull("APLnTolAmt") ? decimal.Zero : row.Field <decimal>("APLnTolAmt"); entity.aPLnTolPct = row.IsNull("APLnTolPct") ? decimal.Zero : row.Field <decimal>("APLnTolPct"); entity.aPInvTolAmt = row.IsNull("APInvTolAmt") ? decimal.Zero : row.Field <decimal>("APInvTolAmt"); entity.aPInvTolPct = row.IsNull("APInvTolPct") ? decimal.Zero : row.Field <decimal>("APInvTolPct"); entity.apinvtolminamt = row.IsNull("apinvtolminamt") ? decimal.Zero : row.Field <decimal>("apinvtolminamt"); entity.aPUser1Amt = row.IsNull("APUser1Amt") ? decimal.Zero : row.Field <decimal>("APUser1Amt"); entity.aPUser1Pct = row.IsNull("APUser1Pct") ? decimal.Zero : row.Field <decimal>("APUser1Pct"); entity.aPUser2Amt = row.IsNull("APUser2Amt") ? decimal.Zero : row.Field <decimal>("APUser2Amt"); entity.aPUser2Pct = row.IsNull("APUser2Pct") ? decimal.Zero : row.Field <decimal>("APUser2Pct"); entity.aPRcvTolType = row.IsNull("APRcvTolType") ? string.Empty : row.Field <string>("APRcvTolType"); entity.aPRcvQtyTolAmt = row.IsNull("APRcvQtyTolAmt") ? decimal.Zero : row.Field <decimal>("APRcvQtyTolAmt"); entity.aPRcvQtyTolPct = row.IsNull("APRcvQtyTolPct") ? decimal.Zero : row.Field <decimal>("APRcvQtyTolPct"); entity.aPRcvLnTolAmt = row.IsNull("APRcvLnTolAmt") ? decimal.Zero : row.Field <decimal>("APRcvLnTolAmt"); entity.aPRcvLnTolPct = row.IsNull("APRcvLnTolPct") ? decimal.Zero : row.Field <decimal>("APRcvLnTolPct"); entity.aPRcvPOTolAmt = row.IsNull("APRcvPOTolAmt") ? decimal.Zero : row.Field <decimal>("APRcvPOTolAmt"); entity.aPRcvPOTolPct = row.IsNull("APRcvPOTolPct") ? decimal.Zero : row.Field <decimal>("APRcvPOTolPct"); entity.sascRowid = row.Field <byte[]>("sasc-rowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); entity.checkOutputType = row.IsNull("CheckOutputType") ? string.Empty : row.Field <string>("CheckOutputType"); entity.checkExtraDataLevel1 = row.IsNull("CheckExtraDataLevel1") ? string.Empty : row.Field <string>("CheckExtraDataLevel1"); entity.checkExtraDataLevel2 = row.IsNull("CheckExtraDataLevel2") ? string.Empty : row.Field <string>("CheckExtraDataLevel2"); entity.allowAPCreditACH = row.Field <bool>("AllowAPCreditACH"); entity.aprmtadvedifmt = row.IsNull("aprmtadvedifmt") ? 0 : row.Field <int>("aprmtadvedifmt"); entity.apictransadjedifmt = row.IsNull("apictransadjedifmt") ? 0 : row.Field <int>("apictransadjedifmt"); entity.apictransedifmt = row.IsNull("apictransedifmt") ? 0 : row.Field <int>("apictransedifmt"); entity.apinvadvedifmt = row.IsNull("apinvadvedifmt") ? string.Empty : row.Field <string>("apinvadvedifmt"); entity.checkIDMDocTypeID = row.IsNull("CheckIDMDocTypeID") ? string.Empty : row.Field <string>("CheckIDMDocTypeID"); entity.checkIDMTemplateName = row.IsNull("CheckIDMTemplateName") ? string.Empty : row.Field <string>("CheckIDMTemplateName"); entity.checkIDMFromEmailAddr = row.IsNull("CheckIDMFromEmailAddr") ? string.Empty : row.Field <string>("CheckIDMFromEmailAddr"); entity.checkIDMFromEmailName = row.IsNull("CheckIDMFromEmailName") ? string.Empty : row.Field <string>("CheckIDMFromEmailName"); entity.checkRemitIDMDocTypeID = row.IsNull("CheckRemitIDMDocTypeID") ? string.Empty : row.Field <string>("CheckRemitIDMDocTypeID"); entity.checkRemitIDMTemplateName = row.IsNull("CheckRemitIDMTemplateName") ? string.Empty : row.Field <string>("CheckRemitIDMTemplateName"); entity.checkLines = row.IsNull("CheckLines") ? 0 : row.Field <int>("CheckLines"); return(entity); }