/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSasaresults(ref DataRow row, Sasaresults entity) { row.SetField("forcelogin", entity.forcelogin); row.SetField("monitorfl", entity.monitorfl); row.SetField("docdir", entity.docdir); row.SetField("sysdir", entity.sysdir); row.SetField("timeout", entity.timeout); row.SetField("begwtno", entity.begwtno); row.SetField("nextwtno", entity.nextwtno); row.SetField("endwtno", entity.endwtno); row.SetField("licenseno", entity.licenseno); row.SetField("licenseto", entity.licenseto); row.SetField("nousers", entity.nousers); row.SetField("rdcustno", entity.rdcustno); row.SetField("licensedt", entity.licensedt); row.SetField("modapfl", entity.modapfl); row.SetField("modarfl", entity.modarfl); row.SetField("modbpfl", entity.modbpfl); row.SetField("modcmfl", entity.modcmfl); row.SetField("modedfl", entity.modedfl); row.SetField("modglfl", entity.modglfl); row.SetField("modibfl", entity.modibfl); row.SetField("modicfl", entity.modicfl); row.SetField("modisfl", entity.modisfl); row.SetField("modjmfl", entity.modjmfl); row.SetField("modkpfl", entity.modkpfl); row.SetField("modoefl", entity.modoefl); row.SetField("modogfl", entity.modogfl); row.SetField("modoifl", entity.modoifl); row.SetField("modotfl", entity.modotfl); row.SetField("modpmfl", entity.modpmfl); row.SetField("modpofl", entity.modpofl); row.SetField("modrsfl", entity.modrsfl); row.SetField("modslfl", entity.modslfl); row.SetField("modsvfl", entity.modsvfl); row.SetField("modswfl", entity.modswfl); row.SetField("modtqfl", entity.modtqfl); row.SetField("modvafl", entity.modvafl); row.SetField("modvtfl", entity.modvtfl); row.SetField("modwlfl", entity.modwlfl); row.SetField("modwmfl", entity.modwmfl); row.SetField("modwtfl", entity.modwtfl); row.SetField("operinit", entity.operinit); row.SetField("transdt", entity.transdt); row.SetField("transproc", entity.transproc); row.SetField("transtm", entity.transtm); row.SetField("user1", entity.user1); row.SetField("user2", entity.user2); row.SetField("user3", entity.user3); row.SetField("user4", entity.user4); row.SetField("user5", entity.user5); row.SetField("user6", entity.user6); row.SetField("user7", entity.user7); row.SetField("user8", entity.user8); row.SetField("user9", entity.user9); row.SetField("ptxsensitive", entity.ptxsensitive); row.SetField("ptxcono", entity.ptxcono); row.SetField("ptxfeewhse", entity.ptxfeewhse); row.SetField("ptxwhse", entity.ptxwhse); row.SetField("multitenantfl", entity.multitenantfl); row.SetField("userfield", entity.userfield); row.SetField("sasaRowID", entity.sasaRowID.ToByteArray()); }
public static Sasaresults BuildSasaresultsFromRow(DataRow row) { Sasaresults entity = new Sasaresults(); entity.forcelogin = row.Field <bool>("forcelogin"); entity.monitorfl = row.Field <bool>("monitorfl"); entity.docdir = row.IsNull("docdir") ? string.Empty : row.Field <string>("docdir"); entity.sysdir = row.IsNull("sysdir") ? string.Empty : row.Field <string>("sysdir"); entity.timeout = row.IsNull("timeout") ? 0 : row.Field <int>("timeout"); entity.begwtno = row.IsNull("begwtno") ? 0 : row.Field <int>("begwtno"); entity.nextwtno = row.IsNull("nextwtno") ? 0 : row.Field <int>("nextwtno"); entity.endwtno = row.IsNull("endwtno") ? 0 : row.Field <int>("endwtno"); entity.licenseno = row.IsNull("licenseno") ? string.Empty : row.Field <string>("licenseno"); entity.licenseto = row.IsNull("licenseto") ? string.Empty : row.Field <string>("licenseto"); entity.nousers = row.IsNull("nousers") ? 0 : row.Field <int>("nousers"); entity.rdcustno = row.IsNull("rdcustno") ? decimal.Zero : row.Field <decimal>("rdcustno"); entity.licensedt = row.Field <DateTime?>("licensedt"); entity.modapfl = row.Field <bool>("modapfl"); entity.modarfl = row.Field <bool>("modarfl"); entity.modbpfl = row.Field <bool>("modbpfl"); entity.modcmfl = row.Field <bool>("modcmfl"); entity.modedfl = row.Field <bool>("modedfl"); entity.modglfl = row.Field <bool>("modglfl"); entity.modibfl = row.Field <bool>("modibfl"); entity.modicfl = row.Field <bool>("modicfl"); entity.modisfl = row.Field <bool>("modisfl"); entity.modjmfl = row.Field <bool>("modjmfl"); entity.modkpfl = row.Field <bool>("modkpfl"); entity.modoefl = row.Field <bool>("modoefl"); entity.modogfl = row.Field <bool>("modogfl"); entity.modoifl = row.Field <bool>("modoifl"); entity.modotfl = row.Field <bool>("modotfl"); entity.modpmfl = row.Field <bool>("modpmfl"); entity.modpofl = row.Field <bool>("modpofl"); entity.modrsfl = row.Field <bool>("modrsfl"); entity.modslfl = row.Field <bool>("modslfl"); entity.modsvfl = row.Field <bool>("modsvfl"); entity.modswfl = row.Field <bool>("modswfl"); entity.modtqfl = row.Field <bool>("modtqfl"); entity.modvafl = row.Field <bool>("modvafl"); entity.modvtfl = row.Field <bool>("modvtfl"); entity.modwlfl = row.Field <bool>("modwlfl"); entity.modwmfl = row.Field <bool>("modwmfl"); entity.modwtfl = row.Field <bool>("modwtfl"); entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit"); entity.transdt = row.Field <DateTime?>("transdt"); entity.transproc = row.IsNull("transproc") ? string.Empty : row.Field <string>("transproc"); entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm"); entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1"); entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2"); entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3"); entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4"); entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5"); entity.user6 = row.Field <decimal?>("user6"); entity.user7 = row.Field <decimal?>("user7"); entity.user8 = row.Field <DateTime?>("user8"); entity.user9 = row.Field <DateTime?>("user9"); entity.ptxsensitive = row.Field <bool>("ptxsensitive"); entity.ptxcono = row.IsNull("ptxcono") ? 0 : row.Field <int>("ptxcono"); entity.ptxfeewhse = row.IsNull("ptxfeewhse") ? string.Empty : row.Field <string>("ptxfeewhse"); entity.ptxwhse = row.IsNull("ptxwhse") ? string.Empty : row.Field <string>("ptxwhse"); entity.multitenantfl = row.Field <bool>("multitenantfl"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); entity.sasaRowID = row.Field <byte[]>("sasaRowID").ToStringEncoded(); return(entity); }