/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromLoadwtlinenonstockresults(ref DataRow row, Loadwtlinenonstockresults entity)
{
row.SetField("prod", entity.prod);
row.SetField("proddesc1", entity.proddesc1);
row.SetField("proddesc2", entity.proddesc2);
row.SetField("prodcost", entity.prodcost);
row.SetField("vendno", entity.vendno);
row.SetField("vendname", entity.vendname);
row.SetField("prodline", entity.prodline);
row.SetField("prodlinedesc", entity.prodlinedesc);
row.SetField("arpwhse", entity.arpwhse);
row.SetField("arpwhsename", entity.arpwhsename);
row.SetField("foreigncost", entity.foreigncost);
row.SetField("exchgrate", entity.exchgrate);
row.SetField("currencyty", entity.currencyty);
row.SetField("shortdesc", entity.shortdesc);
row.SetField("prodcato", entity.prodcato);
row.SetField("prodcatodesc", entity.prodcatodesc);
row.SetField("prodcati", entity.prodcati);
row.SetField("prodcatidesc", entity.prodcatidesc);
}
public static Loadwtlinenonstockresults BuildLoadwtlinenonstockresultsFromRow(DataRow row)
{
Loadwtlinenonstockresults entity = new Loadwtlinenonstockresults();
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.proddesc1 = row.IsNull("proddesc1") ? string.Empty : row.Field <string>("proddesc1");
entity.proddesc2 = row.IsNull("proddesc2") ? string.Empty : row.Field <string>("proddesc2");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.vendno = row.IsNull("vendno") ? decimal.Zero : row.Field <decimal>("vendno");
entity.vendname = row.IsNull("vendname") ? string.Empty : row.Field <string>("vendname");
entity.prodline = row.IsNull("prodline") ? string.Empty : row.Field <string>("prodline");
entity.prodlinedesc = row.IsNull("prodlinedesc") ? string.Empty : row.Field <string>("prodlinedesc");
entity.arpwhse = row.IsNull("arpwhse") ? string.Empty : row.Field <string>("arpwhse");
entity.arpwhsename = row.IsNull("arpwhsename") ? string.Empty : row.Field <string>("arpwhsename");
entity.foreigncost = row.IsNull("foreigncost") ? decimal.Zero : row.Field <decimal>("foreigncost");
entity.exchgrate = row.IsNull("exchgrate") ? decimal.Zero : row.Field <decimal>("exchgrate");
entity.currencyty = row.IsNull("currencyty") ? string.Empty : row.Field <string>("currencyty");
entity.shortdesc = row.IsNull("shortdesc") ? string.Empty : row.Field <string>("shortdesc");
entity.prodcato = row.IsNull("prodcato") ? string.Empty : row.Field <string>("prodcato");
entity.prodcatodesc = row.IsNull("prodcatodesc") ? string.Empty : row.Field <string>("prodcatodesc");
entity.prodcati = row.IsNull("prodcati") ? string.Empty : row.Field <string>("prodcati");
entity.prodcatidesc = row.IsNull("prodcatidesc") ? string.Empty : row.Field <string>("prodcatidesc");
return(entity);
}
