/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSaiclistresults(ref DataRow row, Saiclistresults entity) { row.SetField("_connect-usr", entity.connectUsr); row.SetField("_connect-type", entity.connectType); row.SetField("_connect-name", entity.connectName); row.SetField("_connect-device", entity.connectDevice); row.SetField("_connect-time", entity.connectTime); row.SetField("_connect-pid", entity.connectPid); row.SetField("_connect-server", entity.connectServer); row.SetField("_connect-transid", entity.connectTransid); row.SetField("_connect-batch", entity.connectBatch); row.SetField("_connect-ipaddress", entity.connectIpaddress); row.SetField("cGUID", entity.cGUID); row.SetField("cUserGroup", entity.cUserGroup); row.SetField("userfield", entity.userfield); }
public static Saiclistresults BuildSaiclistresultsFromRow(DataRow row) { Saiclistresults entity = new Saiclistresults(); entity.connectUsr = row.IsNull("_connect-usr") ? 0 : row.Field <int>("_connect-usr"); entity.connectType = row.IsNull("_connect-type") ? string.Empty : row.Field <string>("_connect-type"); entity.connectName = row.IsNull("_connect-name") ? string.Empty : row.Field <string>("_connect-name"); entity.connectDevice = row.IsNull("_connect-device") ? string.Empty : row.Field <string>("_connect-device"); entity.connectTime = row.IsNull("_connect-time") ? string.Empty : row.Field <string>("_connect-time"); entity.connectPid = row.IsNull("_connect-pid") ? 0 : row.Field <int>("_connect-pid"); entity.connectServer = row.IsNull("_connect-server") ? 0 : row.Field <int>("_connect-server"); entity.connectTransid = row.IsNull("_connect-transid") ? 0 : row.Field <int>("_connect-transid"); entity.connectBatch = row.IsNull("_connect-batch") ? string.Empty : row.Field <string>("_connect-batch"); entity.connectIpaddress = row.IsNull("_connect-ipaddress") ? string.Empty : row.Field <string>("_connect-ipaddress"); entity.cGUID = row.IsNull("cGUID") ? string.Empty : row.Field <string>("cGUID"); entity.cUserGroup = row.IsNull("cUserGroup") ? string.Empty : row.Field <string>("cUserGroup"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }