/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromValaborline(ref DataRow row, Valaborline entity)
{
row.SetField("whse", entity.whse);
row.SetField("vano", entity.vano);
row.SetField("vasuf", entity.vasuf);
row.SetField("seqno", entity.seqno);
row.SetField("lineno", entity.lineno);
row.SetField("sctntype", entity.sctntype);
row.SetField("sctncode", entity.sctncode);
row.SetField("stagecddesc", entity.stagecddesc);
row.SetField("shipprod", entity.shipprod);
row.SetField("nonstockty", entity.nonstockty);
row.SetField("unitconv", entity.unitconv);
row.SetField("proddesc", entity.proddesc);
row.SetField("timeslsrep", entity.timeslsrep);
row.SetField("timeslsrepnamedisp", entity.timeslsrepnamedisp);
row.SetField("hours", entity.hours);
row.SetField("minutes", entity.minutes);
row.SetField("timeworkdt", entity.timeworkdt);
row.SetField("timecomment", entity.timecomment);
row.SetField("vaehnotesfl", entity.vaehnotesfl);
row.SetField("icspnotesfl", entity.icspnotesfl);
row.SetField("prodcost", entity.prodcost);
row.SetField("prodcostdefault", entity.prodcostdefault);
row.SetField("netamt", entity.netamt);
row.SetField("seecostfl", entity.seecostfl);
row.SetField("prodcostdspl", entity.prodcostdspl);
row.SetField("netamtdspl", entity.netamtdspl);
row.SetField("getnewprodcostfl", entity.getnewprodcostfl);
row.SetField("vaeslrowid", entity.vaeslrowid.ToByteArray());
}
public static Valaborline BuildValaborlineFromRow(DataRow row)
{
Valaborline entity = new Valaborline();
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.vano = row.IsNull("vano") ? 0 : row.Field <int>("vano");
entity.vasuf = row.IsNull("vasuf") ? 0 : row.Field <int>("vasuf");
entity.seqno = row.IsNull("seqno") ? 0 : row.Field <int>("seqno");
entity.lineno = row.IsNull("lineno") ? 0 : row.Field <int>("lineno");
entity.sctntype = row.IsNull("sctntype") ? string.Empty : row.Field <string>("sctntype");
entity.sctncode = row.IsNull("sctncode") ? string.Empty : row.Field <string>("sctncode");
entity.stagecddesc = row.IsNull("stagecddesc") ? string.Empty : row.Field <string>("stagecddesc");
entity.shipprod = row.IsNull("shipprod") ? string.Empty : row.Field <string>("shipprod");
entity.nonstockty = row.IsNull("nonstockty") ? string.Empty : row.Field <string>("nonstockty");
entity.unitconv = row.IsNull("unitconv") ? decimal.Zero : row.Field <decimal>("unitconv");
entity.proddesc = row.IsNull("proddesc") ? string.Empty : row.Field <string>("proddesc");
entity.timeslsrep = row.IsNull("timeslsrep") ? string.Empty : row.Field <string>("timeslsrep");
entity.timeslsrepnamedisp = row.IsNull("timeslsrepnamedisp") ? string.Empty : row.Field <string>("timeslsrepnamedisp");
entity.hours = row.IsNull("hours") ? 0 : row.Field <int>("hours");
entity.minutes = row.IsNull("minutes") ? 0 : row.Field <int>("minutes");
entity.timeworkdt = row.Field <DateTime?>("timeworkdt");
entity.timecomment = row.IsNull("timecomment") ? string.Empty : row.Field <string>("timecomment");
entity.vaehnotesfl = row.IsNull("vaehnotesfl") ? string.Empty : row.Field <string>("vaehnotesfl");
entity.icspnotesfl = row.IsNull("icspnotesfl") ? string.Empty : row.Field <string>("icspnotesfl");
entity.prodcost = row.IsNull("prodcost") ? decimal.Zero : row.Field <decimal>("prodcost");
entity.prodcostdefault = row.IsNull("prodcostdefault") ? decimal.Zero : row.Field <decimal>("prodcostdefault");
entity.netamt = row.IsNull("netamt") ? decimal.Zero : row.Field <decimal>("netamt");
entity.seecostfl = row.Field <bool>("seecostfl");
entity.prodcostdspl = row.IsNull("prodcostdspl") ? string.Empty : row.Field <string>("prodcostdspl");
entity.netamtdspl = row.IsNull("netamtdspl") ? string.Empty : row.Field <string>("netamtdspl");
entity.getnewprodcostfl = row.Field <bool>("getnewprodcostfl");
entity.vaeslrowid = row.Field <byte[]>("vaeslrowid").ToStringEncoded();
return(entity);
}
