/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromBuildunavailttresults(ref DataRow row, Buildunavailttresults entity)
{
row.SetField("enterdt", entity.enterdt);
row.SetField("operinit", entity.operinit);
row.SetField("prod", entity.prod);
row.SetField("qtyunavail", entity.qtyunavail);
row.SetField("reasunavty", entity.reasunavty);
row.SetField("refer", entity.refer);
row.SetField("stkunit", entity.stkunit);
row.SetField("transdt", entity.transdt);
row.SetField("transtm", entity.transtm);
row.SetField("user1", entity.user1);
row.SetField("user2", entity.user2);
row.SetField("user3", entity.user3);
row.SetField("user4", entity.user4);
row.SetField("user5", entity.user5);
row.SetField("user6", entity.user6);
row.SetField("user7", entity.user7);
row.SetField("user8", entity.user8);
row.SetField("user9", entity.user9);
row.SetField("whse", entity.whse);
row.SetField("cDesc", entity.cDesc);
row.SetField("ICETNotesFl", entity.iCETNotesFl);
row.SetField("ICETNotesID", entity.iCETNotesID);
row.SetField("ICETRowID", entity.iCETRowID.ToByteArray());
row.SetField("reasunavtydesc", entity.reasunavtydesc);
row.SetField("brandcode", entity.brandcode);
row.SetField("mfgprod", entity.mfgprod);
row.SetField("vendprod", entity.vendprod);
row.SetField("userfield", entity.userfield);
}
public static Buildunavailttresults BuildBuildunavailttresultsFromRow(DataRow row)
{
Buildunavailttresults entity = new Buildunavailttresults();
entity.enterdt = row.Field <DateTime?>("enterdt");
entity.operinit = row.IsNull("operinit") ? string.Empty : row.Field <string>("operinit");
entity.prod = row.IsNull("prod") ? string.Empty : row.Field <string>("prod");
entity.qtyunavail = row.IsNull("qtyunavail") ? decimal.Zero : row.Field <decimal>("qtyunavail");
entity.reasunavty = row.IsNull("reasunavty") ? string.Empty : row.Field <string>("reasunavty");
entity.refer = row.IsNull("refer") ? string.Empty : row.Field <string>("refer");
entity.stkunit = row.IsNull("stkunit") ? string.Empty : row.Field <string>("stkunit");
entity.transdt = row.Field <DateTime?>("transdt");
entity.transtm = row.IsNull("transtm") ? string.Empty : row.Field <string>("transtm");
entity.user1 = row.IsNull("user1") ? string.Empty : row.Field <string>("user1");
entity.user2 = row.IsNull("user2") ? string.Empty : row.Field <string>("user2");
entity.user3 = row.IsNull("user3") ? string.Empty : row.Field <string>("user3");
entity.user4 = row.IsNull("user4") ? string.Empty : row.Field <string>("user4");
entity.user5 = row.IsNull("user5") ? string.Empty : row.Field <string>("user5");
entity.user6 = row.Field <decimal?>("user6");
entity.user7 = row.Field <decimal?>("user7");
entity.user8 = row.Field <DateTime?>("user8");
entity.user9 = row.Field <DateTime?>("user9");
entity.whse = row.IsNull("whse") ? string.Empty : row.Field <string>("whse");
entity.cDesc = row.IsNull("cDesc") ? string.Empty : row.Field <string>("cDesc");
entity.iCETNotesFl = row.IsNull("ICETNotesFl") ? string.Empty : row.Field <string>("ICETNotesFl");
entity.iCETNotesID = row.IsNull("ICETNotesID") ? 0 : row.Field <int>("ICETNotesID");
entity.iCETRowID = row.Field <byte[]>("ICETRowID").ToStringEncoded();
entity.reasunavtydesc = row.IsNull("reasunavtydesc") ? string.Empty : row.Field <string>("reasunavtydesc");
entity.brandcode = row.IsNull("brandcode") ? string.Empty : row.Field <string>("brandcode");
entity.mfgprod = row.IsNull("mfgprod") ? string.Empty : row.Field <string>("mfgprod");
entity.vendprod = row.IsNull("vendprod") ? string.Empty : row.Field <string>("vendprod");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}