/// <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); }