/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromAricgrpdispresults(ref DataRow row, Aricgrpdispresults entity)
{
row.SetField("groupid", entity.groupid);
row.SetField("period1", entity.period1);
row.SetField("period2", entity.period2);
row.SetField("period3", entity.period3);
row.SetField("period4", entity.period4);
row.SetField("period5", entity.period5);
row.SetField("period1label", entity.period1label);
row.SetField("period2label", entity.period2label);
row.SetField("period3label", entity.period3label);
row.SetField("period4label", entity.period4label);
row.SetField("period5label", entity.period5label);
row.SetField("futbal", entity.futbal);
row.SetField("futballabel", entity.futballabel);
row.SetField("totbal1", entity.totbal1);
row.SetField("totbal2", entity.totbal2);
row.SetField("totbal3", entity.totbal3);
row.SetField("totbal4", entity.totbal4);
row.SetField("totbal5", entity.totbal5);
row.SetField("totbal1label", entity.totbal1label);
row.SetField("totbal2label", entity.totbal2label);
row.SetField("totbal3label", entity.totbal3label);
row.SetField("totbal4label", entity.totbal4label);
row.SetField("totbal5label", entity.totbal5label);
row.SetField("Ordbal", entity.ordbal);
row.SetField("crdlimit", entity.crdlimit);
row.SetField("crdremaining", entity.crdremaining);
row.SetField("futOrder", entity.futOrder);
row.SetField("laststmtbal", entity.laststmtbal);
row.SetField("priorstmtbal", entity.priorstmtbal);
row.SetField("lastpayment", entity.lastpayment);
row.SetField("lastpaymentdt", entity.lastpaymentdt);
row.SetField("lastsaleamt", entity.lastsaleamt);
row.SetField("lastsaledt", entity.lastsaledt);
row.SetField("downpayamt", entity.downpayamt);
row.SetField("rebatesdue", entity.rebatesdue);
row.SetField("servchgytd", entity.servchgytd);
row.SetField("discytd", entity.discytd);
row.SetField("unearnedytd", entity.unearnedytd);
row.SetField("salesytd", entity.salesytd);
row.SetField("costytd", entity.costytd);
row.SetField("returnsytd", entity.returnsytd);
row.SetField("rebatesytd", entity.rebatesytd);
row.SetField("grossmarginval", entity.grossmarginval);
row.SetField("grossmarginper", entity.grossmarginper);
row.SetField("holdpercd-CR", entity.holdpercdCR);
row.SetField("credlimappty-CR", entity.credlimapptyCR);
row.SetField("credlimit-CR", entity.credlimitCR);
row.SetField("credremaining-CR", entity.credremainingCR);
row.SetField("lastpayamt-CR", entity.lastpayamtCR);
row.SetField("lastSaleAmt-CR", entity.lastSaleAmtCR);
row.SetField("lastPayDt-CR", entity.lastPayDtCR);
row.SetField("lastSaleDt-CR", entity.lastSaleDtCR);
row.SetField("highbal-CR", entity.highbalCR);
row.SetField("pastDueDt-CR", entity.pastDueDtCR);
row.SetField("noPastDue-CR", entity.noPastDueCR);
row.SetField("noPay-CR", entity.noPayCR);
row.SetField("noInv-CR", entity.noInvCR);
row.SetField("userfield", entity.userfield);
}
public static Aricgrpdispresults BuildAricgrpdispresultsFromRow(DataRow row)
{
Aricgrpdispresults entity = new Aricgrpdispresults();
entity.groupid = row.IsNull("groupid") ? string.Empty : row.Field <string>("groupid");
entity.period1 = row.IsNull("period1") ? decimal.Zero : row.Field <decimal>("period1");
entity.period2 = row.IsNull("period2") ? decimal.Zero : row.Field <decimal>("period2");
entity.period3 = row.IsNull("period3") ? decimal.Zero : row.Field <decimal>("period3");
entity.period4 = row.IsNull("period4") ? decimal.Zero : row.Field <decimal>("period4");
entity.period5 = row.IsNull("period5") ? decimal.Zero : row.Field <decimal>("period5");
entity.period1label = row.IsNull("period1label") ? string.Empty : row.Field <string>("period1label");
entity.period2label = row.IsNull("period2label") ? string.Empty : row.Field <string>("period2label");
entity.period3label = row.IsNull("period3label") ? string.Empty : row.Field <string>("period3label");
entity.period4label = row.IsNull("period4label") ? string.Empty : row.Field <string>("period4label");
entity.period5label = row.IsNull("period5label") ? string.Empty : row.Field <string>("period5label");
entity.futbal = row.IsNull("futbal") ? decimal.Zero : row.Field <decimal>("futbal");
entity.futballabel = row.IsNull("futballabel") ? string.Empty : row.Field <string>("futballabel");
entity.totbal1 = row.IsNull("totbal1") ? decimal.Zero : row.Field <decimal>("totbal1");
entity.totbal2 = row.IsNull("totbal2") ? decimal.Zero : row.Field <decimal>("totbal2");
entity.totbal3 = row.IsNull("totbal3") ? decimal.Zero : row.Field <decimal>("totbal3");
entity.totbal4 = row.IsNull("totbal4") ? decimal.Zero : row.Field <decimal>("totbal4");
entity.totbal5 = row.IsNull("totbal5") ? decimal.Zero : row.Field <decimal>("totbal5");
entity.totbal1label = row.IsNull("totbal1label") ? string.Empty : row.Field <string>("totbal1label");
entity.totbal2label = row.IsNull("totbal2label") ? string.Empty : row.Field <string>("totbal2label");
entity.totbal3label = row.IsNull("totbal3label") ? string.Empty : row.Field <string>("totbal3label");
entity.totbal4label = row.IsNull("totbal4label") ? string.Empty : row.Field <string>("totbal4label");
entity.totbal5label = row.IsNull("totbal5label") ? string.Empty : row.Field <string>("totbal5label");
entity.ordbal = row.IsNull("Ordbal") ? decimal.Zero : row.Field <decimal>("Ordbal");
entity.crdlimit = row.IsNull("crdlimit") ? decimal.Zero : row.Field <decimal>("crdlimit");
entity.crdremaining = row.IsNull("crdremaining") ? decimal.Zero : row.Field <decimal>("crdremaining");
entity.futOrder = row.IsNull("futOrder") ? decimal.Zero : row.Field <decimal>("futOrder");
entity.laststmtbal = row.IsNull("laststmtbal") ? decimal.Zero : row.Field <decimal>("laststmtbal");
entity.priorstmtbal = row.IsNull("priorstmtbal") ? decimal.Zero : row.Field <decimal>("priorstmtbal");
entity.lastpayment = row.IsNull("lastpayment") ? decimal.Zero : row.Field <decimal>("lastpayment");
entity.lastpaymentdt = row.Field <DateTime?>("lastpaymentdt");
entity.lastsaleamt = row.IsNull("lastsaleamt") ? decimal.Zero : row.Field <decimal>("lastsaleamt");
entity.lastsaledt = row.Field <DateTime?>("lastsaledt");
entity.downpayamt = row.IsNull("downpayamt") ? decimal.Zero : row.Field <decimal>("downpayamt");
entity.rebatesdue = row.IsNull("rebatesdue") ? decimal.Zero : row.Field <decimal>("rebatesdue");
entity.servchgytd = row.IsNull("servchgytd") ? decimal.Zero : row.Field <decimal>("servchgytd");
entity.discytd = row.IsNull("discytd") ? decimal.Zero : row.Field <decimal>("discytd");
entity.unearnedytd = row.IsNull("unearnedytd") ? decimal.Zero : row.Field <decimal>("unearnedytd");
entity.salesytd = row.IsNull("salesytd") ? decimal.Zero : row.Field <decimal>("salesytd");
entity.costytd = row.IsNull("costytd") ? decimal.Zero : row.Field <decimal>("costytd");
entity.returnsytd = row.IsNull("returnsytd") ? decimal.Zero : row.Field <decimal>("returnsytd");
entity.rebatesytd = row.IsNull("rebatesytd") ? decimal.Zero : row.Field <decimal>("rebatesytd");
entity.grossmarginval = row.IsNull("grossmarginval") ? decimal.Zero : row.Field <decimal>("grossmarginval");
entity.grossmarginper = row.IsNull("grossmarginper") ? decimal.Zero : row.Field <decimal>("grossmarginper");
entity.holdpercdCR = row.IsNull("holdpercd-CR") ? 0 : row.Field <int>("holdpercd-CR");
entity.credlimapptyCR = row.IsNull("credlimappty-CR") ? string.Empty : row.Field <string>("credlimappty-CR");
entity.credlimitCR = row.IsNull("credlimit-CR") ? decimal.Zero : row.Field <decimal>("credlimit-CR");
entity.credremainingCR = row.IsNull("credremaining-CR") ? decimal.Zero : row.Field <decimal>("credremaining-CR");
entity.lastpayamtCR = row.IsNull("lastpayamt-CR") ? decimal.Zero : row.Field <decimal>("lastpayamt-CR");
entity.lastSaleAmtCR = row.IsNull("lastSaleAmt-CR") ? decimal.Zero : row.Field <decimal>("lastSaleAmt-CR");
entity.lastPayDtCR = row.Field <DateTime?>("lastPayDt-CR");
entity.lastSaleDtCR = row.Field <DateTime?>("lastSaleDt-CR");
entity.highbalCR = row.IsNull("highbal-CR") ? decimal.Zero : row.Field <decimal>("highbal-CR");
entity.pastDueDtCR = row.Field <DateTime?>("pastDueDt-CR");
entity.noPastDueCR = row.IsNull("noPastDue-CR") ? 0 : row.Field <int>("noPastDue-CR");
entity.noPayCR = row.IsNull("noPay-CR") ? 0 : row.Field <int>("noPay-CR");
entity.noInvCR = row.IsNull("noInv-CR") ? 0 : row.Field <int>("noInv-CR");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
