/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromManifestcriteria(ref DataRow row, Manifestcriteria entity) { row.SetField("co_num", entity.coNum); row.SetField("wh_num", entity.whNum); row.SetField("carrier_id", entity.carrierId); row.SetField("manifest_id", entity.manifestId); row.SetField("dock_id", entity.dockId); row.SetField("trailer_num", entity.trailerNum); row.SetField("from_date_time", entity.fromDateTime); row.SetField("to_date_time", entity.toDateTime); row.SetField("manifestRowID", entity.manifestRowID.ToByteArray()); row.SetField("recordlimit", entity.recordlimit); row.SetField("manifestcriteriauserfield", entity.manifestcriteriauserfield); row.SetField("userfield", entity.userfield); }
public static Manifestcriteria BuildManifestcriteriaFromRow(DataRow row) { Manifestcriteria entity = new Manifestcriteria(); entity.coNum = row.IsNull("co_num") ? string.Empty : row.Field <string>("co_num"); entity.whNum = row.IsNull("wh_num") ? string.Empty : row.Field <string>("wh_num"); entity.carrierId = row.IsNull("carrier_id") ? string.Empty : row.Field <string>("carrier_id"); entity.manifestId = row.IsNull("manifest_id") ? 0 : row.Field <int>("manifest_id"); entity.dockId = row.IsNull("dock_id") ? string.Empty : row.Field <string>("dock_id"); entity.trailerNum = row.IsNull("trailer_num") ? string.Empty : row.Field <string>("trailer_num"); entity.fromDateTime = row.IsNull("from_date_time") ? string.Empty : row.Field <string>("from_date_time"); entity.toDateTime = row.IsNull("to_date_time") ? string.Empty : row.Field <string>("to_date_time"); entity.manifestRowID = row.Field <byte[]>("manifestRowID").ToStringEncoded(); entity.recordlimit = row.IsNull("recordlimit") ? 0 : row.Field <int>("recordlimit"); entity.manifestcriteriauserfield = row.IsNull("manifestcriteriauserfield") ? string.Empty : row.Field <string>("manifestcriteriauserfield"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }