/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromIcspcdresults(ref DataRow row, Icspcdresults entity)
{
row.SetField("product", entity.product);
row.SetField("allowpullqtyfl", entity.allowpullqtyfl);
row.SetField("replenishfl", entity.replenishfl);
row.SetField("qtyrequired", entity.qtyrequired);
row.SetField("qtyreserved", entity.qtyreserved);
row.SetField("qtyexpected", entity.qtyexpected);
row.SetField("qtysold", entity.qtysold);
row.SetField("lastinvdt", entity.lastinvdt);
row.SetField("createdt", entity.createdt);
row.SetField("qtyavail", entity.qtyavail);
row.SetField("qtybo", entity.qtybo);
row.SetField("expectedratepct", entity.expectedratepct);
row.SetField("qtyforecast1", entity.qtyforecast1);
row.SetField("qtyforecast2", entity.qtyforecast2);
row.SetField("qtyforecast3", entity.qtyforecast3);
row.SetField("qtyforecast4", entity.qtyforecast4);
row.SetField("qtyforecast5", entity.qtyforecast5);
row.SetField("qtyforecast6", entity.qtyforecast6);
row.SetField("qtyforecast7", entity.qtyforecast7);
row.SetField("qtyforecast8", entity.qtyforecast8);
row.SetField("qtyforecast9", entity.qtyforecast9);
row.SetField("qtyforecast10", entity.qtyforecast10);
row.SetField("qtyforecast11", entity.qtyforecast11);
row.SetField("qtyforecast12", entity.qtyforecast12);
row.SetField("qtyactual1", entity.qtyactual1);
row.SetField("qtyactual2", entity.qtyactual2);
row.SetField("qtyactual3", entity.qtyactual3);
row.SetField("qtyactual4", entity.qtyactual4);
row.SetField("qtyactual5", entity.qtyactual5);
row.SetField("qtyactual6", entity.qtyactual6);
row.SetField("qtyactual7", entity.qtyactual7);
row.SetField("qtyactual8", entity.qtyactual8);
row.SetField("qtyactual9", entity.qtyactual9);
row.SetField("qtyactual10", entity.qtyactual10);
row.SetField("qtyactual11", entity.qtyactual11);
row.SetField("qtyactual12", entity.qtyactual12);
row.SetField("monthlabel1", entity.monthlabel1);
row.SetField("monthlabel2", entity.monthlabel2);
row.SetField("monthlabel3", entity.monthlabel3);
row.SetField("monthlabel4", entity.monthlabel4);
row.SetField("monthlabel5", entity.monthlabel5);
row.SetField("monthlabel6", entity.monthlabel6);
row.SetField("monthlabel7", entity.monthlabel7);
row.SetField("monthlabel8", entity.monthlabel8);
row.SetField("monthlabel9", entity.monthlabel9);
row.SetField("monthlabel10", entity.monthlabel10);
row.SetField("monthlabel11", entity.monthlabel11);
row.SetField("monthlabel12", entity.monthlabel12);
row.SetField("cono", entity.cono);
row.SetField("srcrowpointer", entity.srcrowpointer);
row.SetField("icsprowpointer", entity.icsprowpointer);
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("userfield", entity.userfield);
}
public static Icspcdresults BuildIcspcdresultsFromRow(DataRow row)
{
Icspcdresults entity = new Icspcdresults();
entity.product = row.IsNull("product") ? string.Empty : row.Field <string>("product");
entity.allowpullqtyfl = row.Field <bool>("allowpullqtyfl");
entity.replenishfl = row.Field <bool>("replenishfl");
entity.qtyrequired = row.IsNull("qtyrequired") ? decimal.Zero : row.Field <decimal>("qtyrequired");
entity.qtyreserved = row.IsNull("qtyreserved") ? decimal.Zero : row.Field <decimal>("qtyreserved");
entity.qtyexpected = row.IsNull("qtyexpected") ? decimal.Zero : row.Field <decimal>("qtyexpected");
entity.qtysold = row.IsNull("qtysold") ? decimal.Zero : row.Field <decimal>("qtysold");
entity.lastinvdt = row.Field <DateTime?>("lastinvdt");
entity.createdt = row.Field <DateTime?>("createdt");
entity.qtyavail = row.IsNull("qtyavail") ? decimal.Zero : row.Field <decimal>("qtyavail");
entity.qtybo = row.IsNull("qtybo") ? decimal.Zero : row.Field <decimal>("qtybo");
entity.expectedratepct = row.IsNull("expectedratepct") ? 0 : row.Field <int>("expectedratepct");
entity.qtyforecast1 = row.IsNull("qtyforecast1") ? decimal.Zero : row.Field <decimal>("qtyforecast1");
entity.qtyforecast2 = row.IsNull("qtyforecast2") ? decimal.Zero : row.Field <decimal>("qtyforecast2");
entity.qtyforecast3 = row.IsNull("qtyforecast3") ? decimal.Zero : row.Field <decimal>("qtyforecast3");
entity.qtyforecast4 = row.IsNull("qtyforecast4") ? decimal.Zero : row.Field <decimal>("qtyforecast4");
entity.qtyforecast5 = row.IsNull("qtyforecast5") ? decimal.Zero : row.Field <decimal>("qtyforecast5");
entity.qtyforecast6 = row.IsNull("qtyforecast6") ? decimal.Zero : row.Field <decimal>("qtyforecast6");
entity.qtyforecast7 = row.IsNull("qtyforecast7") ? decimal.Zero : row.Field <decimal>("qtyforecast7");
entity.qtyforecast8 = row.IsNull("qtyforecast8") ? decimal.Zero : row.Field <decimal>("qtyforecast8");
entity.qtyforecast9 = row.IsNull("qtyforecast9") ? decimal.Zero : row.Field <decimal>("qtyforecast9");
entity.qtyforecast10 = row.IsNull("qtyforecast10") ? decimal.Zero : row.Field <decimal>("qtyforecast10");
entity.qtyforecast11 = row.IsNull("qtyforecast11") ? decimal.Zero : row.Field <decimal>("qtyforecast11");
entity.qtyforecast12 = row.IsNull("qtyforecast12") ? decimal.Zero : row.Field <decimal>("qtyforecast12");
entity.qtyactual1 = row.IsNull("qtyactual1") ? decimal.Zero : row.Field <decimal>("qtyactual1");
entity.qtyactual2 = row.IsNull("qtyactual2") ? decimal.Zero : row.Field <decimal>("qtyactual2");
entity.qtyactual3 = row.IsNull("qtyactual3") ? decimal.Zero : row.Field <decimal>("qtyactual3");
entity.qtyactual4 = row.IsNull("qtyactual4") ? decimal.Zero : row.Field <decimal>("qtyactual4");
entity.qtyactual5 = row.IsNull("qtyactual5") ? decimal.Zero : row.Field <decimal>("qtyactual5");
entity.qtyactual6 = row.IsNull("qtyactual6") ? decimal.Zero : row.Field <decimal>("qtyactual6");
entity.qtyactual7 = row.IsNull("qtyactual7") ? decimal.Zero : row.Field <decimal>("qtyactual7");
entity.qtyactual8 = row.IsNull("qtyactual8") ? decimal.Zero : row.Field <decimal>("qtyactual8");
entity.qtyactual9 = row.IsNull("qtyactual9") ? decimal.Zero : row.Field <decimal>("qtyactual9");
entity.qtyactual10 = row.IsNull("qtyactual10") ? decimal.Zero : row.Field <decimal>("qtyactual10");
entity.qtyactual11 = row.IsNull("qtyactual11") ? decimal.Zero : row.Field <decimal>("qtyactual11");
entity.qtyactual12 = row.IsNull("qtyactual12") ? decimal.Zero : row.Field <decimal>("qtyactual12");
entity.monthlabel1 = row.IsNull("monthlabel1") ? string.Empty : row.Field <string>("monthlabel1");
entity.monthlabel2 = row.IsNull("monthlabel2") ? string.Empty : row.Field <string>("monthlabel2");
entity.monthlabel3 = row.IsNull("monthlabel3") ? string.Empty : row.Field <string>("monthlabel3");
entity.monthlabel4 = row.IsNull("monthlabel4") ? string.Empty : row.Field <string>("monthlabel4");
entity.monthlabel5 = row.IsNull("monthlabel5") ? string.Empty : row.Field <string>("monthlabel5");
entity.monthlabel6 = row.IsNull("monthlabel6") ? string.Empty : row.Field <string>("monthlabel6");
entity.monthlabel7 = row.IsNull("monthlabel7") ? string.Empty : row.Field <string>("monthlabel7");
entity.monthlabel8 = row.IsNull("monthlabel8") ? string.Empty : row.Field <string>("monthlabel8");
entity.monthlabel9 = row.IsNull("monthlabel9") ? string.Empty : row.Field <string>("monthlabel9");
entity.monthlabel10 = row.IsNull("monthlabel10") ? string.Empty : row.Field <string>("monthlabel10");
entity.monthlabel11 = row.IsNull("monthlabel11") ? string.Empty : row.Field <string>("monthlabel11");
entity.monthlabel12 = row.IsNull("monthlabel12") ? string.Empty : row.Field <string>("monthlabel12");
entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono");
entity.srcrowpointer = row.IsNull("srcrowpointer") ? string.Empty : row.Field <string>("srcrowpointer");
entity.icsprowpointer = row.IsNull("icsprowpointer") ? string.Empty : row.Field <string>("icsprowpointer");
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.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
