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