/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromPononstockresults(ref DataRow row, Pononstockresults entity) { row.SetField("shipprod", entity.shipprod); row.SetField("arpprodline", entity.arpprodline); row.SetField("arpvendno", entity.arpvendno); row.SetField("arpwhse", entity.arpwhse); row.SetField("cproddesc", entity.cproddesc); row.SetField("cprodnotes", entity.cprodnotes); row.SetField("cubes", entity.cubes); row.SetField("prodcat", entity.prodcat); row.SetField("prodcost", entity.prodcost); row.SetField("prodcostdspl", entity.prodcostdspl); row.SetField("proddesc", entity.proddesc); row.SetField("proddesc2", entity.proddesc2); row.SetField("rushfl", entity.rushfl); row.SetField("weight", entity.weight); row.SetField("usesettingsfl", entity.usesettingsfl); row.SetField("nonstkmessage", entity.nonstkmessage); row.SetField("prcavlmessage", entity.prcavlmessage); row.SetField("warningmessage", entity.warningmessage); row.SetField("userfield", entity.userfield); }
public static Pononstockresults BuildPononstockresultsFromRow(DataRow row) { Pononstockresults entity = new Pononstockresults(); entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field<string>("shipprod"); entity.arpprodline = row.IsNull("arpprodline") ? string.Empty : row.Field<string>("arpprodline"); entity.arpvendno = row.IsNull("arpvendno") ? decimal.Zero : row.Field<decimal>("arpvendno"); entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field<string>("arpwhse"); entity.cproddesc = row.IsNull("cproddesc") ? string.Empty : row.Field<string>("cproddesc"); entity.cprodnotes = row.IsNull("cprodnotes") ? string.Empty : row.Field<string>("cprodnotes"); entity.cubes = row.IsNull("cubes") ? decimal.Zero : row.Field<decimal>("cubes"); entity.prodcat = row.IsNull("prodcat") ? string.Empty : row.Field<string>("prodcat"); entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field<decimal>("prodcost"); entity.prodcostdspl = row.IsNull("prodcostdspl") ? string.Empty : row.Field<string>("prodcostdspl"); entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field<string>("proddesc"); entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field<string>("proddesc2"); entity.rushfl = row.Field<bool>("rushfl"); entity.weight = row.IsNull("weight") ? decimal.Zero : row.Field<decimal>("weight"); entity.usesettingsfl = row.Field<bool>("usesettingsfl"); entity.nonstkmessage = row.IsNull("nonstkmessage") ? string.Empty : row.Field<string>("nonstkmessage"); entity.prcavlmessage = row.IsNull("prcavlmessage") ? string.Empty : row.Field<string>("prcavlmessage"); entity.warningmessage = row.IsNull("warningmessage") ? string.Empty : row.Field<string>("warningmessage"); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field<string>("userfield"); return entity; }