/// <summary>
/// Update a database row from a class
/// </summary>
public static void UpdateRowFromGliabdgcmpresults(ref DataRow row, Gliabdgcmpresults entity)
{
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("period6", entity.period6);
row.SetField("period7", entity.period7);
row.SetField("period8", entity.period8);
row.SetField("period9", entity.period9);
row.SetField("period10", entity.period10);
row.SetField("period11", entity.period11);
row.SetField("period12", entity.period12);
row.SetField("period13", entity.period13);
row.SetField("ptd1", entity.ptd1);
row.SetField("ptd2", entity.ptd2);
row.SetField("ptd3", entity.ptd3);
row.SetField("ptd4", entity.ptd4);
row.SetField("ptd5", entity.ptd5);
row.SetField("ptd6", entity.ptd6);
row.SetField("ptd7", entity.ptd7);
row.SetField("ptd8", entity.ptd8);
row.SetField("ptd9", entity.ptd9);
row.SetField("ptd10", entity.ptd10);
row.SetField("ptd11", entity.ptd11);
row.SetField("ptd12", entity.ptd12);
row.SetField("ptd13", entity.ptd13);
row.SetField("ptdbdg1", entity.ptdbdg1);
row.SetField("ptdbdg2", entity.ptdbdg2);
row.SetField("ptdbdg3", entity.ptdbdg3);
row.SetField("ptdbdg4", entity.ptdbdg4);
row.SetField("ptdbdg5", entity.ptdbdg5);
row.SetField("ptdbdg6", entity.ptdbdg6);
row.SetField("ptdbdg7", entity.ptdbdg7);
row.SetField("ptdbdg8", entity.ptdbdg8);
row.SetField("ptdbdg9", entity.ptdbdg9);
row.SetField("ptdbdg10", entity.ptdbdg10);
row.SetField("ptdbdg11", entity.ptdbdg11);
row.SetField("ptdbdg12", entity.ptdbdg12);
row.SetField("ptdbdg13", entity.ptdbdg13);
row.SetField("ptdpct1", entity.ptdpct1);
row.SetField("ptdpct2", entity.ptdpct2);
row.SetField("ptdpct3", entity.ptdpct3);
row.SetField("ptdpct4", entity.ptdpct4);
row.SetField("ptdpct5", entity.ptdpct5);
row.SetField("ptdpct6", entity.ptdpct6);
row.SetField("ptdpct7", entity.ptdpct7);
row.SetField("ptdpct8", entity.ptdpct8);
row.SetField("ptdpct9", entity.ptdpct9);
row.SetField("ptdpct10", entity.ptdpct10);
row.SetField("ptdpct11", entity.ptdpct11);
row.SetField("ptdpct12", entity.ptdpct12);
row.SetField("ptdpct13", entity.ptdpct13);
row.SetField("ytd1", entity.ytd1);
row.SetField("ytd2", entity.ytd2);
row.SetField("ytd3", entity.ytd3);
row.SetField("ytd4", entity.ytd4);
row.SetField("ytd5", entity.ytd5);
row.SetField("ytd6", entity.ytd6);
row.SetField("ytd7", entity.ytd7);
row.SetField("ytd8", entity.ytd8);
row.SetField("ytd9", entity.ytd9);
row.SetField("ytd10", entity.ytd10);
row.SetField("ytd11", entity.ytd11);
row.SetField("ytd12", entity.ytd12);
row.SetField("ytd13", entity.ytd13);
row.SetField("ytdbdg1", entity.ytdbdg1);
row.SetField("ytdbdg2", entity.ytdbdg2);
row.SetField("ytdbdg3", entity.ytdbdg3);
row.SetField("ytdbdg4", entity.ytdbdg4);
row.SetField("ytdbdg5", entity.ytdbdg5);
row.SetField("ytdbdg6", entity.ytdbdg6);
row.SetField("ytdbdg7", entity.ytdbdg7);
row.SetField("ytdbdg8", entity.ytdbdg8);
row.SetField("ytdbdg9", entity.ytdbdg9);
row.SetField("ytdbdg10", entity.ytdbdg10);
row.SetField("ytdbdg11", entity.ytdbdg11);
row.SetField("ytdbdg12", entity.ytdbdg12);
row.SetField("ytdbdg13", entity.ytdbdg13);
row.SetField("ytdpct1", entity.ytdpct1);
row.SetField("ytdpct2", entity.ytdpct2);
row.SetField("ytdpct3", entity.ytdpct3);
row.SetField("ytdpct4", entity.ytdpct4);
row.SetField("ytdpct5", entity.ytdpct5);
row.SetField("ytdpct6", entity.ytdpct6);
row.SetField("ytdpct7", entity.ytdpct7);
row.SetField("ytdpct8", entity.ytdpct8);
row.SetField("ytdpct9", entity.ytdpct9);
row.SetField("ytdpct10", entity.ytdpct10);
row.SetField("ytdpct11", entity.ytdpct11);
row.SetField("ytdpct12", entity.ytdpct12);
row.SetField("ytdpct13", entity.ytdpct13);
row.SetField("l13per", entity.l13per);
row.SetField("userfield", entity.userfield);
}
public static Gliabdgcmpresults BuildGliabdgcmpresultsFromRow(DataRow row)
{
Gliabdgcmpresults entity = new Gliabdgcmpresults();
entity.period1 = row.IsNull("period1") ? string.Empty : row.Field <string>("period1");
entity.period2 = row.IsNull("period2") ? string.Empty : row.Field <string>("period2");
entity.period3 = row.IsNull("period3") ? string.Empty : row.Field <string>("period3");
entity.period4 = row.IsNull("period4") ? string.Empty : row.Field <string>("period4");
entity.period5 = row.IsNull("period5") ? string.Empty : row.Field <string>("period5");
entity.period6 = row.IsNull("period6") ? string.Empty : row.Field <string>("period6");
entity.period7 = row.IsNull("period7") ? string.Empty : row.Field <string>("period7");
entity.period8 = row.IsNull("period8") ? string.Empty : row.Field <string>("period8");
entity.period9 = row.IsNull("period9") ? string.Empty : row.Field <string>("period9");
entity.period10 = row.IsNull("period10") ? string.Empty : row.Field <string>("period10");
entity.period11 = row.IsNull("period11") ? string.Empty : row.Field <string>("period11");
entity.period12 = row.IsNull("period12") ? string.Empty : row.Field <string>("period12");
entity.period13 = row.IsNull("period13") ? string.Empty : row.Field <string>("period13");
entity.ptd1 = row.IsNull("ptd1") ? decimal.Zero : row.Field <decimal>("ptd1");
entity.ptd2 = row.IsNull("ptd2") ? decimal.Zero : row.Field <decimal>("ptd2");
entity.ptd3 = row.IsNull("ptd3") ? decimal.Zero : row.Field <decimal>("ptd3");
entity.ptd4 = row.IsNull("ptd4") ? decimal.Zero : row.Field <decimal>("ptd4");
entity.ptd5 = row.IsNull("ptd5") ? decimal.Zero : row.Field <decimal>("ptd5");
entity.ptd6 = row.IsNull("ptd6") ? decimal.Zero : row.Field <decimal>("ptd6");
entity.ptd7 = row.IsNull("ptd7") ? decimal.Zero : row.Field <decimal>("ptd7");
entity.ptd8 = row.IsNull("ptd8") ? decimal.Zero : row.Field <decimal>("ptd8");
entity.ptd9 = row.IsNull("ptd9") ? decimal.Zero : row.Field <decimal>("ptd9");
entity.ptd10 = row.IsNull("ptd10") ? decimal.Zero : row.Field <decimal>("ptd10");
entity.ptd11 = row.IsNull("ptd11") ? decimal.Zero : row.Field <decimal>("ptd11");
entity.ptd12 = row.IsNull("ptd12") ? decimal.Zero : row.Field <decimal>("ptd12");
entity.ptd13 = row.IsNull("ptd13") ? decimal.Zero : row.Field <decimal>("ptd13");
entity.ptdbdg1 = row.IsNull("ptdbdg1") ? decimal.Zero : row.Field <decimal>("ptdbdg1");
entity.ptdbdg2 = row.IsNull("ptdbdg2") ? decimal.Zero : row.Field <decimal>("ptdbdg2");
entity.ptdbdg3 = row.IsNull("ptdbdg3") ? decimal.Zero : row.Field <decimal>("ptdbdg3");
entity.ptdbdg4 = row.IsNull("ptdbdg4") ? decimal.Zero : row.Field <decimal>("ptdbdg4");
entity.ptdbdg5 = row.IsNull("ptdbdg5") ? decimal.Zero : row.Field <decimal>("ptdbdg5");
entity.ptdbdg6 = row.IsNull("ptdbdg6") ? decimal.Zero : row.Field <decimal>("ptdbdg6");
entity.ptdbdg7 = row.IsNull("ptdbdg7") ? decimal.Zero : row.Field <decimal>("ptdbdg7");
entity.ptdbdg8 = row.IsNull("ptdbdg8") ? decimal.Zero : row.Field <decimal>("ptdbdg8");
entity.ptdbdg9 = row.IsNull("ptdbdg9") ? decimal.Zero : row.Field <decimal>("ptdbdg9");
entity.ptdbdg10 = row.IsNull("ptdbdg10") ? decimal.Zero : row.Field <decimal>("ptdbdg10");
entity.ptdbdg11 = row.IsNull("ptdbdg11") ? decimal.Zero : row.Field <decimal>("ptdbdg11");
entity.ptdbdg12 = row.IsNull("ptdbdg12") ? decimal.Zero : row.Field <decimal>("ptdbdg12");
entity.ptdbdg13 = row.IsNull("ptdbdg13") ? decimal.Zero : row.Field <decimal>("ptdbdg13");
entity.ptdpct1 = row.IsNull("ptdpct1") ? decimal.Zero : row.Field <decimal>("ptdpct1");
entity.ptdpct2 = row.IsNull("ptdpct2") ? decimal.Zero : row.Field <decimal>("ptdpct2");
entity.ptdpct3 = row.IsNull("ptdpct3") ? decimal.Zero : row.Field <decimal>("ptdpct3");
entity.ptdpct4 = row.IsNull("ptdpct4") ? decimal.Zero : row.Field <decimal>("ptdpct4");
entity.ptdpct5 = row.IsNull("ptdpct5") ? decimal.Zero : row.Field <decimal>("ptdpct5");
entity.ptdpct6 = row.IsNull("ptdpct6") ? decimal.Zero : row.Field <decimal>("ptdpct6");
entity.ptdpct7 = row.IsNull("ptdpct7") ? decimal.Zero : row.Field <decimal>("ptdpct7");
entity.ptdpct8 = row.IsNull("ptdpct8") ? decimal.Zero : row.Field <decimal>("ptdpct8");
entity.ptdpct9 = row.IsNull("ptdpct9") ? decimal.Zero : row.Field <decimal>("ptdpct9");
entity.ptdpct10 = row.IsNull("ptdpct10") ? decimal.Zero : row.Field <decimal>("ptdpct10");
entity.ptdpct11 = row.IsNull("ptdpct11") ? decimal.Zero : row.Field <decimal>("ptdpct11");
entity.ptdpct12 = row.IsNull("ptdpct12") ? decimal.Zero : row.Field <decimal>("ptdpct12");
entity.ptdpct13 = row.IsNull("ptdpct13") ? decimal.Zero : row.Field <decimal>("ptdpct13");
entity.ytd1 = row.IsNull("ytd1") ? decimal.Zero : row.Field <decimal>("ytd1");
entity.ytd2 = row.IsNull("ytd2") ? decimal.Zero : row.Field <decimal>("ytd2");
entity.ytd3 = row.IsNull("ytd3") ? decimal.Zero : row.Field <decimal>("ytd3");
entity.ytd4 = row.IsNull("ytd4") ? decimal.Zero : row.Field <decimal>("ytd4");
entity.ytd5 = row.IsNull("ytd5") ? decimal.Zero : row.Field <decimal>("ytd5");
entity.ytd6 = row.IsNull("ytd6") ? decimal.Zero : row.Field <decimal>("ytd6");
entity.ytd7 = row.IsNull("ytd7") ? decimal.Zero : row.Field <decimal>("ytd7");
entity.ytd8 = row.IsNull("ytd8") ? decimal.Zero : row.Field <decimal>("ytd8");
entity.ytd9 = row.IsNull("ytd9") ? decimal.Zero : row.Field <decimal>("ytd9");
entity.ytd10 = row.IsNull("ytd10") ? decimal.Zero : row.Field <decimal>("ytd10");
entity.ytd11 = row.IsNull("ytd11") ? decimal.Zero : row.Field <decimal>("ytd11");
entity.ytd12 = row.IsNull("ytd12") ? decimal.Zero : row.Field <decimal>("ytd12");
entity.ytd13 = row.IsNull("ytd13") ? decimal.Zero : row.Field <decimal>("ytd13");
entity.ytdbdg1 = row.IsNull("ytdbdg1") ? decimal.Zero : row.Field <decimal>("ytdbdg1");
entity.ytdbdg2 = row.IsNull("ytdbdg2") ? decimal.Zero : row.Field <decimal>("ytdbdg2");
entity.ytdbdg3 = row.IsNull("ytdbdg3") ? decimal.Zero : row.Field <decimal>("ytdbdg3");
entity.ytdbdg4 = row.IsNull("ytdbdg4") ? decimal.Zero : row.Field <decimal>("ytdbdg4");
entity.ytdbdg5 = row.IsNull("ytdbdg5") ? decimal.Zero : row.Field <decimal>("ytdbdg5");
entity.ytdbdg6 = row.IsNull("ytdbdg6") ? decimal.Zero : row.Field <decimal>("ytdbdg6");
entity.ytdbdg7 = row.IsNull("ytdbdg7") ? decimal.Zero : row.Field <decimal>("ytdbdg7");
entity.ytdbdg8 = row.IsNull("ytdbdg8") ? decimal.Zero : row.Field <decimal>("ytdbdg8");
entity.ytdbdg9 = row.IsNull("ytdbdg9") ? decimal.Zero : row.Field <decimal>("ytdbdg9");
entity.ytdbdg10 = row.IsNull("ytdbdg10") ? decimal.Zero : row.Field <decimal>("ytdbdg10");
entity.ytdbdg11 = row.IsNull("ytdbdg11") ? decimal.Zero : row.Field <decimal>("ytdbdg11");
entity.ytdbdg12 = row.IsNull("ytdbdg12") ? decimal.Zero : row.Field <decimal>("ytdbdg12");
entity.ytdbdg13 = row.IsNull("ytdbdg13") ? decimal.Zero : row.Field <decimal>("ytdbdg13");
entity.ytdpct1 = row.IsNull("ytdpct1") ? decimal.Zero : row.Field <decimal>("ytdpct1");
entity.ytdpct2 = row.IsNull("ytdpct2") ? decimal.Zero : row.Field <decimal>("ytdpct2");
entity.ytdpct3 = row.IsNull("ytdpct3") ? decimal.Zero : row.Field <decimal>("ytdpct3");
entity.ytdpct4 = row.IsNull("ytdpct4") ? decimal.Zero : row.Field <decimal>("ytdpct4");
entity.ytdpct5 = row.IsNull("ytdpct5") ? decimal.Zero : row.Field <decimal>("ytdpct5");
entity.ytdpct6 = row.IsNull("ytdpct6") ? decimal.Zero : row.Field <decimal>("ytdpct6");
entity.ytdpct7 = row.IsNull("ytdpct7") ? decimal.Zero : row.Field <decimal>("ytdpct7");
entity.ytdpct8 = row.IsNull("ytdpct8") ? decimal.Zero : row.Field <decimal>("ytdpct8");
entity.ytdpct9 = row.IsNull("ytdpct9") ? decimal.Zero : row.Field <decimal>("ytdpct9");
entity.ytdpct10 = row.IsNull("ytdpct10") ? decimal.Zero : row.Field <decimal>("ytdpct10");
entity.ytdpct11 = row.IsNull("ytdpct11") ? decimal.Zero : row.Field <decimal>("ytdpct11");
entity.ytdpct12 = row.IsNull("ytdpct12") ? decimal.Zero : row.Field <decimal>("ytdpct12");
entity.ytdpct13 = row.IsNull("ytdpct13") ? decimal.Zero : row.Field <decimal>("ytdpct13");
entity.l13per = row.Field <bool>("l13per");
entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield");
return(entity);
}