/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromSaeaactionsummary(ref DataRow row, Saeaactionsummary entity) { row.SetField("actionseqno", entity.actionseqno); row.SetField("cActionType", entity.cActionType); row.SetField("cSubjectType", entity.cSubjectType); row.SetField("cWhseRange", entity.cWhseRange); row.SetField("cRegionRange", entity.cRegionRange); row.SetField("cCustomerRange", entity.cCustomerRange); row.SetField("cVendorRange", entity.cVendorRange); row.SetField("cProductRange", entity.cProductRange); row.SetField("cProdCatRange", entity.cProdCatRange); row.SetField("cAmountSelection", entity.cAmountSelection); row.SetField("cCharSelection", entity.cCharSelection); row.SetField("cPriceSelection", entity.cPriceSelection); row.SetField("cDateSelection", entity.cDateSelection); row.SetField("lActive", entity.lActive); row.SetField("expiredt", entity.expiredt); row.SetField("eventname", entity.eventname); row.SetField("actionrowid", entity.actionrowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Saeaactionsummary BuildSaeaactionsummaryFromRow(DataRow row) { Saeaactionsummary entity = new Saeaactionsummary(); entity.actionseqno = row.IsNull("actionseqno") ? 0 : row.Field <int>("actionseqno"); entity.cActionType = row.IsNull("cActionType") ? string.Empty : row.Field <string>("cActionType"); entity.cSubjectType = row.IsNull("cSubjectType") ? string.Empty : row.Field <string>("cSubjectType"); entity.cWhseRange = row.IsNull("cWhseRange") ? string.Empty : row.Field <string>("cWhseRange"); entity.cRegionRange = row.IsNull("cRegionRange") ? string.Empty : row.Field <string>("cRegionRange"); entity.cCustomerRange = row.IsNull("cCustomerRange") ? string.Empty : row.Field <string>("cCustomerRange"); entity.cVendorRange = row.IsNull("cVendorRange") ? string.Empty : row.Field <string>("cVendorRange"); entity.cProductRange = row.IsNull("cProductRange") ? string.Empty : row.Field <string>("cProductRange"); entity.cProdCatRange = row.IsNull("cProdCatRange") ? string.Empty : row.Field <string>("cProdCatRange"); entity.cAmountSelection = row.IsNull("cAmountSelection") ? string.Empty : row.Field <string>("cAmountSelection"); entity.cCharSelection = row.IsNull("cCharSelection") ? string.Empty : row.Field <string>("cCharSelection"); entity.cPriceSelection = row.IsNull("cPriceSelection") ? string.Empty : row.Field <string>("cPriceSelection"); entity.cDateSelection = row.IsNull("cDateSelection") ? string.Empty : row.Field <string>("cDateSelection"); entity.lActive = row.Field <bool>("lActive"); entity.expiredt = row.Field <DateTime?>("expiredt"); entity.eventname = row.IsNull("eventname") ? string.Empty : row.Field <string>("eventname"); entity.actionrowid = row.Field <byte[]>("actionrowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }