/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromIceuloaddetailsresults(ref DataRow row, Iceuloaddetailsresults entity) { row.SetField("prod", entity.prod); row.SetField("whse", entity.whse); row.SetField("prodlookupnm", entity.prodlookupnm); row.SetField("proddesc", entity.proddesc); row.SetField("qtyonhand", entity.qtyonhand); row.SetField("qtyreservd", entity.qtyreservd); row.SetField("qtyunavail", entity.qtyunavail); row.SetField("qtyonorder", entity.qtyonorder); row.SetField("qtybo", entity.qtybo); row.SetField("netavail", entity.netavail); row.SetField("msg", entity.msg); row.SetField("reasunavty", entity.reasunavty); row.SetField("qtyunavailforreason", entity.qtyunavailforreason); row.SetField("stkqtyship", entity.stkqtyship); row.SetField("unit", entity.unit); row.SetField("orderno", entity.orderno); row.SetField("refer", entity.refer); row.SetField("ordernoenabled", entity.ordernoenabled); row.SetField("reasunavtyenabled", entity.reasunavtyenabled); row.SetField("stkqtyshiplabel", entity.stkqtyshiplabel); row.SetField("reasunavtylabel", entity.reasunavtylabel); row.SetField("userfield", entity.userfield); }
public static Iceuloaddetailsresults BuildIceuloaddetailsresultsFromRow(DataRow row) { Iceuloaddetailsresults entity = new Iceuloaddetailsresults(); entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod"); entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse"); entity.prodlookupnm = row.IsNull("prodlookupnm") ? string.Empty : row.Field <string>("prodlookupnm"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc"); entity.qtyonhand = row.IsNull("qtyonhand") ? decimal.Zero : row.Field <decimal>("qtyonhand"); entity.qtyreservd = row.IsNull("qtyreservd") ? decimal.Zero : row.Field <decimal>("qtyreservd"); entity.qtyunavail = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail"); entity.qtyonorder = row.IsNull("qtyonorder") ? decimal.Zero : row.Field <decimal>("qtyonorder"); entity.qtybo = row.IsNull("qtybo") ? decimal.Zero : row.Field <decimal>("qtybo"); entity.netavail = row.IsNull("netavail") ? decimal.Zero : row.Field <decimal>("netavail"); entity.msg = row.IsNull("msg") ? string.Empty : row.Field <string>("msg"); entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty"); entity.qtyunavailforreason = row.IsNull("qtyunavailforreason") ? decimal.Zero : row.Field <decimal>("qtyunavailforreason"); entity.stkqtyship = row.IsNull("stkqtyship") ? decimal.Zero : row.Field <decimal>("stkqtyship"); entity.unit = row.IsNull("unit") ? string.Empty : row.Field <string>("unit"); entity.orderno = row.IsNull("orderno") ? 0 : row.Field <int>("orderno"); entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer"); entity.ordernoenabled = row.Field <bool>("ordernoenabled"); entity.reasunavtyenabled = row.Field <bool>("reasunavtyenabled"); entity.stkqtyshiplabel = row.IsNull("stkqtyshiplabel") ? string.Empty : row.Field <string>("stkqtyshiplabel"); entity.reasunavtylabel = row.IsNull("reasunavtylabel") ? string.Empty : row.Field <string>("reasunavtylabel"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }