/// <summary> /// Update a database row from a class /// </summary> public static void UpdateRowFromAofinancials(ref DataRow row, Aofinancials entity) { row.SetField("cono", entity.cono); row.SetField("glsize1", entity.glsize1); row.SetField("glsize2", entity.glsize2); row.SetField("glsize3", entity.glsize3); row.SetField("glsize4", entity.glsize4); row.SetField("gldelim1", entity.gldelim1); row.SetField("gldelim2", entity.gldelim2); row.SetField("gldelim3", entity.gldelim3); row.SetField("gldefper", entity.gldefper); row.SetField("glbegper", entity.glbegper); row.SetField("glperahd", entity.glperahd); row.SetField("glendper", entity.glendper); row.SetField("glperbck", entity.glperbck); row.SetField("glcurrfl", entity.glcurrfl); row.SetField("glbalhistfl", entity.glbalhistfl); row.SetField("glcurfisc", entity.glcurfisc); row.SetField("gl13perfl", entity.gl13perfl); row.SetField("glbegfisc", entity.glbegfisc); row.SetField("glbegfl", entity.glbegfl); row.SetField("glenddt1", entity.glenddt1); row.SetField("glenddt2", entity.glenddt2); row.SetField("glenddt3", entity.glenddt3); row.SetField("glenddt4", entity.glenddt4); row.SetField("glenddt5", entity.glenddt5); row.SetField("glenddt6", entity.glenddt6); row.SetField("glenddt7", entity.glenddt7); row.SetField("glenddt8", entity.glenddt8); row.SetField("glenddt9", entity.glenddt9); row.SetField("glenddt10", entity.glenddt10); row.SetField("glenddt11", entity.glenddt11); row.SetField("glenddt12", entity.glenddt12); row.SetField("glenddt13", entity.glenddt13); row.SetField("glprofpct1", entity.glprofpct1); row.SetField("glprofpct2", entity.glprofpct2); row.SetField("glprofpct3", entity.glprofpct3); row.SetField("glprofpct4", entity.glprofpct4); row.SetField("GLNo1", entity.gLNo1); row.SetField("GLNo2", entity.gLNo2); row.SetField("GLNo3", entity.gLNo3); row.SetField("GLNo4", entity.gLNo4); row.SetField("GLNo5", entity.gLNo5); row.SetField("GLNo6", entity.gLNo6); row.SetField("GLNo7", entity.gLNo7); row.SetField("GLNo8", entity.gLNo8); row.SetField("GLNo9", entity.gLNo9); row.SetField("GLNoDesc1", entity.gLNoDesc1); row.SetField("GLNoDesc2", entity.gLNoDesc2); row.SetField("GLNoDesc3", entity.gLNoDesc3); row.SetField("GLNoDesc4", entity.gLNoDesc4); row.SetField("GLNoDesc5", entity.gLNoDesc5); row.SetField("GLNoDesc6", entity.gLNoDesc6); row.SetField("GLNoDesc7", entity.gLNoDesc7); row.SetField("GLNoDesc8", entity.gLNoDesc8); row.SetField("GLNoDesc9", entity.gLNoDesc9); row.SetField("crglfl", entity.crglfl); row.SetField("croefl", entity.croefl); row.SetField("crarfl", entity.crarfl); row.SetField("validate-only", entity.validateOnly); row.SetField("sasc-rowid", entity.sascRowid.ToByteArray()); row.SetField("userfield", entity.userfield); }
public static Aofinancials BuildAofinancialsFromRow(DataRow row) { Aofinancials entity = new Aofinancials(); entity.cono = row.IsNull("cono") ? 0 : row.Field <int>("cono"); entity.glsize1 = row.IsNull("glsize1") ? 0 : row.Field <int>("glsize1"); entity.glsize2 = row.IsNull("glsize2") ? 0 : row.Field <int>("glsize2"); entity.glsize3 = row.IsNull("glsize3") ? 0 : row.Field <int>("glsize3"); entity.glsize4 = row.IsNull("glsize4") ? 0 : row.Field <int>("glsize4"); entity.gldelim1 = row.IsNull("gldelim1") ? string.Empty : row.Field <string>("gldelim1"); entity.gldelim2 = row.IsNull("gldelim2") ? string.Empty : row.Field <string>("gldelim2"); entity.gldelim3 = row.IsNull("gldelim3") ? string.Empty : row.Field <string>("gldelim3"); entity.gldefper = row.IsNull("gldefper") ? 0 : row.Field <int>("gldefper"); entity.glbegper = row.IsNull("glbegper") ? 0 : row.Field <int>("glbegper"); entity.glperahd = row.IsNull("glperahd") ? 0 : row.Field <int>("glperahd"); entity.glendper = row.IsNull("glendper") ? 0 : row.Field <int>("glendper"); entity.glperbck = row.IsNull("glperbck") ? 0 : row.Field <int>("glperbck"); entity.glcurrfl = row.Field <bool>("glcurrfl"); entity.glbalhistfl = row.Field <bool>("glbalhistfl"); entity.glcurfisc = row.IsNull("glcurfisc") ? 0 : row.Field <int>("glcurfisc"); entity.gl13perfl = row.Field <bool>("gl13perfl"); entity.glbegfisc = row.IsNull("glbegfisc") ? 0 : row.Field <int>("glbegfisc"); entity.glbegfl = row.Field <bool>("glbegfl"); entity.glenddt1 = row.Field <DateTime?>("glenddt1"); entity.glenddt2 = row.Field <DateTime?>("glenddt2"); entity.glenddt3 = row.Field <DateTime?>("glenddt3"); entity.glenddt4 = row.Field <DateTime?>("glenddt4"); entity.glenddt5 = row.Field <DateTime?>("glenddt5"); entity.glenddt6 = row.Field <DateTime?>("glenddt6"); entity.glenddt7 = row.Field <DateTime?>("glenddt7"); entity.glenddt8 = row.Field <DateTime?>("glenddt8"); entity.glenddt9 = row.Field <DateTime?>("glenddt9"); entity.glenddt10 = row.Field <DateTime?>("glenddt10"); entity.glenddt11 = row.Field <DateTime?>("glenddt11"); entity.glenddt12 = row.Field <DateTime?>("glenddt12"); entity.glenddt13 = row.Field <DateTime?>("glenddt13"); entity.glprofpct1 = row.IsNull("glprofpct1") ? decimal.Zero : row.Field <decimal>("glprofpct1"); entity.glprofpct2 = row.IsNull("glprofpct2") ? decimal.Zero : row.Field <decimal>("glprofpct2"); entity.glprofpct3 = row.IsNull("glprofpct3") ? decimal.Zero : row.Field <decimal>("glprofpct3"); entity.glprofpct4 = row.IsNull("glprofpct4") ? decimal.Zero : row.Field <decimal>("glprofpct4"); entity.gLNo1 = row.IsNull("GLNo1") ? string.Empty : row.Field <string>("GLNo1"); entity.gLNo2 = row.IsNull("GLNo2") ? string.Empty : row.Field <string>("GLNo2"); entity.gLNo3 = row.IsNull("GLNo3") ? string.Empty : row.Field <string>("GLNo3"); entity.gLNo4 = row.IsNull("GLNo4") ? string.Empty : row.Field <string>("GLNo4"); entity.gLNo5 = row.IsNull("GLNo5") ? string.Empty : row.Field <string>("GLNo5"); entity.gLNo6 = row.IsNull("GLNo6") ? string.Empty : row.Field <string>("GLNo6"); entity.gLNo7 = row.IsNull("GLNo7") ? string.Empty : row.Field <string>("GLNo7"); entity.gLNo8 = row.IsNull("GLNo8") ? string.Empty : row.Field <string>("GLNo8"); entity.gLNo9 = row.IsNull("GLNo9") ? string.Empty : row.Field <string>("GLNo9"); entity.gLNoDesc1 = row.IsNull("GLNoDesc1") ? string.Empty : row.Field <string>("GLNoDesc1"); entity.gLNoDesc2 = row.IsNull("GLNoDesc2") ? string.Empty : row.Field <string>("GLNoDesc2"); entity.gLNoDesc3 = row.IsNull("GLNoDesc3") ? string.Empty : row.Field <string>("GLNoDesc3"); entity.gLNoDesc4 = row.IsNull("GLNoDesc4") ? string.Empty : row.Field <string>("GLNoDesc4"); entity.gLNoDesc5 = row.IsNull("GLNoDesc5") ? string.Empty : row.Field <string>("GLNoDesc5"); entity.gLNoDesc6 = row.IsNull("GLNoDesc6") ? string.Empty : row.Field <string>("GLNoDesc6"); entity.gLNoDesc7 = row.IsNull("GLNoDesc7") ? string.Empty : row.Field <string>("GLNoDesc7"); entity.gLNoDesc8 = row.IsNull("GLNoDesc8") ? string.Empty : row.Field <string>("GLNoDesc8"); entity.gLNoDesc9 = row.IsNull("GLNoDesc9") ? string.Empty : row.Field <string>("GLNoDesc9"); entity.crglfl = row.Field <bool>("crglfl"); entity.croefl = row.Field <bool>("croefl"); entity.crarfl = row.Field <bool>("crarfl"); entity.validateOnly = row.Field <bool>("validate-only"); entity.sascRowid = row.Field <byte[]>("sasc-rowid").ToStringEncoded(); entity.userfield = row.IsNull("userfield") ? string.Empty : row.Field <string>("userfield"); return(entity); }