/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromGlsbreqcalcresults(ref DataRow row, Glsbreqcalcresults entity)
{
row.SetField("budgettype", entity.budgettype);
row.SetField("annbud", entity.annbud);
row.SetField("periodlbl1", entity.periodlbl1);
row.SetField("periodlbl2", entity.periodlbl2);
row.SetField("periodlbl3", entity.periodlbl3);
row.SetField("periodlbl4", entity.periodlbl4);
row.SetField("periodlbl5", entity.periodlbl5);
row.SetField("periodlbl6", entity.periodlbl6);
row.SetField("periodlbl7", entity.periodlbl7);
row.SetField("periodlbl8", entity.periodlbl8);
row.SetField("periodlbl9", entity.periodlbl9);
row.SetField("periodlbl10", entity.periodlbl10);
row.SetField("periodlbl11", entity.periodlbl11);
row.SetField("periodlbl12", entity.periodlbl12);
row.SetField("periodlbl13", entity.periodlbl13);
row.SetField("peramt1", entity.peramt1);
row.SetField("peramt2", entity.peramt2);
row.SetField("peramt3", entity.peramt3);
row.SetField("peramt4", entity.peramt4);
row.SetField("peramt5", entity.peramt5);
row.SetField("peramt6", entity.peramt6);
row.SetField("peramt7", entity.peramt7);
row.SetField("peramt8", entity.peramt8);
row.SetField("peramt9", entity.peramt9);
row.SetField("peramt10", entity.peramt10);
row.SetField("peramt11", entity.peramt11);
row.SetField("peramt12", entity.peramt12);
row.SetField("peramt13", entity.peramt13);
row.SetField("budpct1", entity.budpct1);
row.SetField("budpct2", entity.budpct2);
row.SetField("budpct3", entity.budpct3);
row.SetField("budpct4", entity.budpct4);
row.SetField("budpct5", entity.budpct5);
row.SetField("budpct6", entity.budpct6);
row.SetField("budpct7", entity.budpct7);
row.SetField("budpct8", entity.budpct8);
row.SetField("budpct9", entity.budpct9);
row.SetField("budpct10", entity.budpct10);
row.SetField("budpct11", entity.budpct11);
row.SetField("budpct12", entity.budpct12);
row.SetField("budpct13", entity.budpct13);
row.SetField("budytd1", entity.budytd1);
row.SetField("budytd2", entity.budytd2);
row.SetField("budytd3", entity.budytd3);
row.SetField("budytd4", entity.budytd4);
row.SetField("budytd5", entity.budytd5);
row.SetField("budytd6", entity.budytd6);
row.SetField("budytd7", entity.budytd7);
row.SetField("budytd8", entity.budytd8);
row.SetField("budytd9", entity.budytd9);
row.SetField("budytd10", entity.budytd10);
row.SetField("budytd11", entity.budytd11);
row.SetField("budytd12", entity.budytd12);
row.SetField("budytd13", entity.budytd13);
row.SetField("pctytd1", entity.pctytd1);
row.SetField("pctytd2", entity.pctytd2);
row.SetField("pctytd3", entity.pctytd3);
row.SetField("pctytd4", entity.pctytd4);
row.SetField("pctytd5", entity.pctytd5);
row.SetField("pctytd6", entity.pctytd6);
row.SetField("pctytd7", entity.pctytd7);
row.SetField("pctytd8", entity.pctytd8);
row.SetField("pctytd9", entity.pctytd9);
row.SetField("pctytd10", entity.pctytd10);
row.SetField("pctytd11", entity.pctytd11);
row.SetField("pctytd12", entity.pctytd12);
row.SetField("pctytd13", entity.pctytd13);
row.SetField("actual1", entity.actual1);
row.SetField("actual2", entity.actual2);
row.SetField("actual3", entity.actual3);
row.SetField("actual4", entity.actual4);
row.SetField("actual5", entity.actual5);
row.SetField("actual6", entity.actual6);
row.SetField("actual7", entity.actual7);
row.SetField("actual8", entity.actual8);
row.SetField("actual9", entity.actual9);
row.SetField("actual10", entity.actual10);
row.SetField("actual11", entity.actual11);
row.SetField("actual12", entity.actual12);
row.SetField("actual13", entity.actual13);
row.SetField("gl13perfl", entity.gl13perfl);
row.SetField("calcmethod", entity.calcmethod);
row.SetField("displaytext", entity.displaytext);
row.SetField("userfield", entity.userfield);
}
public static Glsbreqcalcresults BuildGlsbreqcalcresultsFromRow(DataRow row)
{
Glsbreqcalcresults entity = new Glsbreqcalcresults();
entity.budgettype = row.Field <bool>("budgettype");
entity.annbud = row.IsNull("annbud") ? decimal.Zero : row.Field <decimal>("annbud");
entity.periodlbl1 = row.IsNull("periodlbl1") ? string.Empty : row.Field <string>("periodlbl1");
entity.periodlbl2 = row.IsNull("periodlbl2") ? string.Empty : row.Field <string>("periodlbl2");
entity.periodlbl3 = row.IsNull("periodlbl3") ? string.Empty : row.Field <string>("periodlbl3");
entity.periodlbl4 = row.IsNull("periodlbl4") ? string.Empty : row.Field <string>("periodlbl4");
entity.periodlbl5 = row.IsNull("periodlbl5") ? string.Empty : row.Field <string>("periodlbl5");
entity.periodlbl6 = row.IsNull("periodlbl6") ? string.Empty : row.Field <string>("periodlbl6");
entity.periodlbl7 = row.IsNull("periodlbl7") ? string.Empty : row.Field <string>("periodlbl7");
entity.periodlbl8 = row.IsNull("periodlbl8") ? string.Empty : row.Field <string>("periodlbl8");
entity.periodlbl9 = row.IsNull("periodlbl9") ? string.Empty : row.Field <string>("periodlbl9");
entity.periodlbl10 = row.IsNull("periodlbl10") ? string.Empty : row.Field <string>("periodlbl10");
entity.periodlbl11 = row.IsNull("periodlbl11") ? string.Empty : row.Field <string>("periodlbl11");
entity.periodlbl12 = row.IsNull("periodlbl12") ? string.Empty : row.Field <string>("periodlbl12");
entity.periodlbl13 = row.IsNull("periodlbl13") ? string.Empty : row.Field <string>("periodlbl13");
entity.peramt1 = row.IsNull("peramt1") ? decimal.Zero : row.Field <decimal>("peramt1");
entity.peramt2 = row.IsNull("peramt2") ? decimal.Zero : row.Field <decimal>("peramt2");
entity.peramt3 = row.IsNull("peramt3") ? decimal.Zero : row.Field <decimal>("peramt3");
entity.peramt4 = row.IsNull("peramt4") ? decimal.Zero : row.Field <decimal>("peramt4");
entity.peramt5 = row.IsNull("peramt5") ? decimal.Zero : row.Field <decimal>("peramt5");
entity.peramt6 = row.IsNull("peramt6") ? decimal.Zero : row.Field <decimal>("peramt6");
entity.peramt7 = row.IsNull("peramt7") ? decimal.Zero : row.Field <decimal>("peramt7");
entity.peramt8 = row.IsNull("peramt8") ? decimal.Zero : row.Field <decimal>("peramt8");
entity.peramt9 = row.IsNull("peramt9") ? decimal.Zero : row.Field <decimal>("peramt9");
entity.peramt10 = row.IsNull("peramt10") ? decimal.Zero : row.Field <decimal>("peramt10");
entity.peramt11 = row.IsNull("peramt11") ? decimal.Zero : row.Field <decimal>("peramt11");
entity.peramt12 = row.IsNull("peramt12") ? decimal.Zero : row.Field <decimal>("peramt12");
entity.peramt13 = row.IsNull("peramt13") ? decimal.Zero : row.Field <decimal>("peramt13");
entity.budpct1 = row.IsNull("budpct1") ? decimal.Zero : row.Field <decimal>("budpct1");
entity.budpct2 = row.IsNull("budpct2") ? decimal.Zero : row.Field <decimal>("budpct2");
entity.budpct3 = row.IsNull("budpct3") ? decimal.Zero : row.Field <decimal>("budpct3");
entity.budpct4 = row.IsNull("budpct4") ? decimal.Zero : row.Field <decimal>("budpct4");
entity.budpct5 = row.IsNull("budpct5") ? decimal.Zero : row.Field <decimal>("budpct5");
entity.budpct6 = row.IsNull("budpct6") ? decimal.Zero : row.Field <decimal>("budpct6");
entity.budpct7 = row.IsNull("budpct7") ? decimal.Zero : row.Field <decimal>("budpct7");
entity.budpct8 = row.IsNull("budpct8") ? decimal.Zero : row.Field <decimal>("budpct8");
entity.budpct9 = row.IsNull("budpct9") ? decimal.Zero : row.Field <decimal>("budpct9");
entity.budpct10 = row.IsNull("budpct10") ? decimal.Zero : row.Field <decimal>("budpct10");
entity.budpct11 = row.IsNull("budpct11") ? decimal.Zero : row.Field <decimal>("budpct11");
entity.budpct12 = row.IsNull("budpct12") ? decimal.Zero : row.Field <decimal>("budpct12");
entity.budpct13 = row.IsNull("budpct13") ? decimal.Zero : row.Field <decimal>("budpct13");
entity.budytd1 = row.IsNull("budytd1") ? decimal.Zero : row.Field <decimal>("budytd1");
entity.budytd2 = row.IsNull("budytd2") ? decimal.Zero : row.Field <decimal>("budytd2");
entity.budytd3 = row.IsNull("budytd3") ? decimal.Zero : row.Field <decimal>("budytd3");
entity.budytd4 = row.IsNull("budytd4") ? decimal.Zero : row.Field <decimal>("budytd4");
entity.budytd5 = row.IsNull("budytd5") ? decimal.Zero : row.Field <decimal>("budytd5");
entity.budytd6 = row.IsNull("budytd6") ? decimal.Zero : row.Field <decimal>("budytd6");
entity.budytd7 = row.IsNull("budytd7") ? decimal.Zero : row.Field <decimal>("budytd7");
entity.budytd8 = row.IsNull("budytd8") ? decimal.Zero : row.Field <decimal>("budytd8");
entity.budytd9 = row.IsNull("budytd9") ? decimal.Zero : row.Field <decimal>("budytd9");
entity.budytd10 = row.IsNull("budytd10") ? decimal.Zero : row.Field <decimal>("budytd10");
entity.budytd11 = row.IsNull("budytd11") ? decimal.Zero : row.Field <decimal>("budytd11");
entity.budytd12 = row.IsNull("budytd12") ? decimal.Zero : row.Field <decimal>("budytd12");
entity.budytd13 = row.IsNull("budytd13") ? decimal.Zero : row.Field <decimal>("budytd13");
entity.pctytd1 = row.IsNull("pctytd1") ? decimal.Zero : row.Field <decimal>("pctytd1");
entity.pctytd2 = row.IsNull("pctytd2") ? decimal.Zero : row.Field <decimal>("pctytd2");
entity.pctytd3 = row.IsNull("pctytd3") ? decimal.Zero : row.Field <decimal>("pctytd3");
entity.pctytd4 = row.IsNull("pctytd4") ? decimal.Zero : row.Field <decimal>("pctytd4");
entity.pctytd5 = row.IsNull("pctytd5") ? decimal.Zero : row.Field <decimal>("pctytd5");
entity.pctytd6 = row.IsNull("pctytd6") ? decimal.Zero : row.Field <decimal>("pctytd6");
entity.pctytd7 = row.IsNull("pctytd7") ? decimal.Zero : row.Field <decimal>("pctytd7");
entity.pctytd8 = row.IsNull("pctytd8") ? decimal.Zero : row.Field <decimal>("pctytd8");
entity.pctytd9 = row.IsNull("pctytd9") ? decimal.Zero : row.Field <decimal>("pctytd9");
entity.pctytd10 = row.IsNull("pctytd10") ? decimal.Zero : row.Field <decimal>("pctytd10");
entity.pctytd11 = row.IsNull("pctytd11") ? decimal.Zero : row.Field <decimal>("pctytd11");
entity.pctytd12 = row.IsNull("pctytd12") ? decimal.Zero : row.Field <decimal>("pctytd12");
entity.pctytd13 = row.IsNull("pctytd13") ? decimal.Zero : row.Field <decimal>("pctytd13");
entity.actual1 = row.IsNull("actual1") ? decimal.Zero : row.Field <decimal>("actual1");
entity.actual2 = row.IsNull("actual2") ? decimal.Zero : row.Field <decimal>("actual2");
entity.actual3 = row.IsNull("actual3") ? decimal.Zero : row.Field <decimal>("actual3");
entity.actual4 = row.IsNull("actual4") ? decimal.Zero : row.Field <decimal>("actual4");
entity.actual5 = row.IsNull("actual5") ? decimal.Zero : row.Field <decimal>("actual5");
entity.actual6 = row.IsNull("actual6") ? decimal.Zero : row.Field <decimal>("actual6");
entity.actual7 = row.IsNull("actual7") ? decimal.Zero : row.Field <decimal>("actual7");
entity.actual8 = row.IsNull("actual8") ? decimal.Zero : row.Field <decimal>("actual8");
entity.actual9 = row.IsNull("actual9") ? decimal.Zero : row.Field <decimal>("actual9");
entity.actual10 = row.IsNull("actual10") ? decimal.Zero : row.Field <decimal>("actual10");
entity.actual11 = row.IsNull("actual11") ? decimal.Zero : row.Field <decimal>("actual11");
entity.actual12 = row.IsNull("actual12") ? decimal.Zero : row.Field <decimal>("actual12");
entity.actual13 = row.IsNull("actual13") ? decimal.Zero : row.Field <decimal>("actual13");
entity.gl13perfl = row.Field <bool>("gl13perfl");
entity.calcmethod = row.IsNull("calcmethod") ? string.Empty : row.Field <string>("calcmethod");
entity.displaytext = row.IsNull("displaytext") ? string.Empty : row.Field <string>("displaytext");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}
