public static Saspuserfields BuildSaspuserfieldsFromRow(DataRow row) { Saspuserfields entity = new Saspuserfields(); entity.printernm = row.IsNull("printernm") ? string.Empty : row.Field <string>("printernm"); entity.user11 = row.IsNull("user11") ? 0 : row.Field <int>("user11"); entity.user12 = row.IsNull("user12") ? 0 : row.Field <int>("user12"); entity.user13 = row.IsNull("user13") ? 0 : row.Field <int>("user13"); entity.user14 = row.IsNull("user14") ? 0 : row.Field <int>("user14"); entity.user15 = row.IsNull("user15") ? 0 : row.Field <int>("user15"); entity.user16 = row.IsNull("user16") ? 0 : row.Field <int>("user16"); entity.user17 = row.IsNull("user17") ? 0 : row.Field <int>("user17"); entity.user18 = row.IsNull("user18") ? 0 : row.Field <int>("user18"); entity.user19 = row.IsNull("user19") ? 0 : row.Field <int>("user19"); entity.user110 = row.IsNull("user110") ? 0 : row.Field <int>("user110"); entity.user21 = row.IsNull("user21") ? 0 : row.Field <int>("user21"); entity.user22 = row.IsNull("user22") ? 0 : row.Field <int>("user22"); entity.user23 = row.IsNull("user23") ? 0 : row.Field <int>("user23"); entity.user24 = row.IsNull("user24") ? 0 : row.Field <int>("user24"); entity.user25 = row.IsNull("user25") ? 0 : row.Field <int>("user25"); entity.user26 = row.IsNull("user26") ? 0 : row.Field <int>("user26"); entity.user27 = row.IsNull("user27") ? 0 : row.Field <int>("user27"); entity.user28 = row.IsNull("user28") ? 0 : row.Field <int>("user28"); entity.user29 = row.IsNull("user29") ? 0 : row.Field <int>("user29"); entity.user210 = row.IsNull("user210") ? 0 : row.Field <int>("user210"); entity.user31 = row.IsNull("user31") ? 0 : row.Field <int>("user31"); entity.user32 = row.IsNull("user32") ? 0 : row.Field <int>("user32"); entity.user33 = row.IsNull("user33") ? 0 : row.Field <int>("user33"); entity.user34 = row.IsNull("user34") ? 0 : row.Field <int>("user34"); entity.user35 = row.IsNull("user35") ? 0 : row.Field <int>("user35"); entity.user36 = row.IsNull("user36") ? 0 : row.Field <int>("user36"); entity.user37 = row.IsNull("user37") ? 0 : row.Field <int>("user37"); entity.user38 = row.IsNull("user38") ? 0 : row.Field <int>("user38"); entity.user39 = row.IsNull("user39") ? 0 : row.Field <int>("user39"); entity.user310 = row.IsNull("user310") ? 0 : row.Field <int>("user310"); entity.user41 = row.IsNull("user41") ? 0 : row.Field <int>("user41"); entity.user42 = row.IsNull("user42") ? 0 : row.Field <int>("user42"); entity.user43 = row.IsNull("user43") ? 0 : row.Field <int>("user43"); entity.user44 = row.IsNull("user44") ? 0 : row.Field <int>("user44"); entity.user45 = row.IsNull("user45") ? 0 : row.Field <int>("user45"); entity.user46 = row.IsNull("user46") ? 0 : row.Field <int>("user46"); entity.user47 = row.IsNull("user47") ? 0 : row.Field <int>("user47"); entity.user48 = row.IsNull("user48") ? 0 : row.Field <int>("user48"); entity.user49 = row.IsNull("user49") ? 0 : row.Field <int>("user49"); entity.user410 = row.IsNull("user410") ? 0 : row.Field <int>("user410"); entity.user51 = row.IsNull("user51") ? 0 : row.Field <int>("user51"); entity.user52 = row.IsNull("user52") ? 0 : row.Field <int>("user52"); entity.user53 = row.IsNull("user53") ? 0 : row.Field <int>("user53"); entity.user54 = row.IsNull("user54") ? 0 : row.Field <int>("user54"); entity.user55 = row.IsNull("user55") ? 0 : row.Field <int>("user55"); entity.user56 = row.IsNull("user56") ? 0 : row.Field <int>("user56"); entity.user57 = row.IsNull("user57") ? 0 : row.Field <int>("user57"); entity.user58 = row.IsNull("user58") ? 0 : row.Field <int>("user58"); entity.user59 = row.IsNull("user59") ? 0 : row.Field <int>("user59"); entity.user510 = row.IsNull("user510") ? 0 : row.Field <int>("user510"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }
/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSaspuserfields(ref DataRow row, Saspuserfields entity) { row.SetField("printernm", entity.printernm); row.SetField("user11", entity.user11); row.SetField("user12", entity.user12); row.SetField("user13", entity.user13); row.SetField("user14", entity.user14); row.SetField("user15", entity.user15); row.SetField("user16", entity.user16); row.SetField("user17", entity.user17); row.SetField("user18", entity.user18); row.SetField("user19", entity.user19); row.SetField("user110", entity.user110); row.SetField("user21", entity.user21); row.SetField("user22", entity.user22); row.SetField("user23", entity.user23); row.SetField("user24", entity.user24); row.SetField("user25", entity.user25); row.SetField("user26", entity.user26); row.SetField("user27", entity.user27); row.SetField("user28", entity.user28); row.SetField("user29", entity.user29); row.SetField("user210", entity.user210); row.SetField("user31", entity.user31); row.SetField("user32", entity.user32); row.SetField("user33", entity.user33); row.SetField("user34", entity.user34); row.SetField("user35", entity.user35); row.SetField("user36", entity.user36); row.SetField("user37", entity.user37); row.SetField("user38", entity.user38); row.SetField("user39", entity.user39); row.SetField("user310", entity.user310); row.SetField("user41", entity.user41); row.SetField("user42", entity.user42); row.SetField("user43", entity.user43); row.SetField("user44", entity.user44); row.SetField("user45", entity.user45); row.SetField("user46", entity.user46); row.SetField("user47", entity.user47); row.SetField("user48", entity.user48); row.SetField("user49", entity.user49); row.SetField("user410", entity.user410); row.SetField("user51", entity.user51); row.SetField("user52", entity.user52); row.SetField("user53", entity.user53); row.SetField("user54", entity.user54); row.SetField("user55", entity.user55); row.SetField("user56", entity.user56); row.SetField("user57", entity.user57); row.SetField("user58", entity.user58); row.SetField("user59", entity.user59); row.SetField("user510", entity.user510); row.SetField("userfield", entity.userfield); }