public Total(Total total) { Type t = total.GetType(); foreach (FieldInfo fieldInf in t.GetFields()) { fieldInf.SetValue(this, fieldInf.GetValue(total)); } foreach (PropertyInfo propInf in t.GetProperties()) { propInf.SetValue(this, propInf.GetValue(total)); } }
/// <summary> /// Excels to total. /// </summary> /// <param name="totals">The totals.</param> /// <param name="rows">The rows.</param> public static Total ExcelToTotal(DataRow row) { Total total = new Total(); total.Vorname = row[ExcelExtension.GetExcelColumnName(() => total.Vorname)].ToString().ToNullableString(); total.Nachname = row[ExcelExtension.GetExcelColumnName(() => total.Nachname)].ToString().ToNullableString(); total.Deutsch = row[ExcelExtension.GetExcelColumnName(() => total.Deutsch)].ToString().ToNullable <double>().RoundNullableDouble(); total.Mathe = row[ExcelExtension.GetExcelColumnName(() => total.Mathe)].ToString().ToNullable <double>().RoundNullableDouble(); total.Sachkunde = row[ExcelExtension.GetExcelColumnName(() => total.Sachkunde)].ToString().ToNullable <double>().RoundNullableDouble(); total.Musik = row[ExcelExtension.GetExcelColumnName(() => total.Musik)].ToString().ToNullable <double>().RoundNullableDouble(); total.Englisch = row[ExcelExtension.GetExcelColumnName(() => total.Englisch)].ToString().ToNullable <double>().RoundNullableDouble(); total.Ethik = row[ExcelExtension.GetExcelColumnName(() => total.Ethik)].ToString().ToNullable <double>().RoundNullableDouble(); total.Kunst = row[ExcelExtension.GetExcelColumnName(() => total.Kunst)].ToString().ToNullable <double>().RoundNullableDouble(); total.Sport = row[ExcelExtension.GetExcelColumnName(() => total.Sport)].ToString().ToNullable <double>().RoundNullableDouble(); total.Religion = row[ExcelExtension.GetExcelColumnName(() => total.Religion)].ToString().ToNullable <double>().RoundNullableDouble(); total.Werken = row[ExcelExtension.GetExcelColumnName(() => total.Werken)].ToString().ToNullable <double>().RoundNullableDouble(); total.MwS = row[ExcelExtension.GetExcelColumnName(() => total.MwS)].ToString().ToNullable <double>().RoundNullableDouble(); return(total); }