public static object[] Fill(Datensatz Datensatz)
{
object[] record = new object[FieldCount];
record[0] = Datensatz.Key;
record[1] = Datensatz.F1;
record[2] = Datensatz.F1_calc;
record[3] = Datensatz.F2;
record[4] = Datensatz.F2_calc;
record[5] = Datensatz.F3;
record[6] = Datensatz.F3_calc;
record[7] = Datensatz.F4;
record[8] = Datensatz.F4_calc;
record[9] = Datensatz.F5;
record[10] = Datensatz.F5_calc;
record[11] = Datensatz.F6;
record[12] = Datensatz.F6_calc;
record[13] = Datensatz.F7;
record[14] = Datensatz.F7_calc;
record[15] = Datensatz.F8;
record[16] = Datensatz.F8_calc;
record[17] = Datensatz.F9;
record[18] = Datensatz.F9_calc;
record[19] = Datensatz.F10;
record[20] = Datensatz.F10_calc;
return(record);
}
public Datensatz RowTransformationDB(Datensatz row)
{
row.F1_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F1).IntervalScore;
row.F2_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F2).IntervalScore;
row.F3_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F3).IntervalScore;
row.F4_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F4).IntervalScore;
row.F5_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F5).IntervalScore;
row.F6_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F6).IntervalScore;
row.F7_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F7).IntervalScore;
row.F8_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F8).IntervalScore;
row.F9_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F9).IntervalScore;
row.F10_calc = IntervalPointSearch.IntervalPointLinearSearch(MetrischeSkala, (decimal)row.F10).IntervalScore;
return(row);
}
public static Datensatz Read(IDataRecord record)
{
var Datensatz = new Datensatz();
Datensatz.Key = record.GetInt32(0);
Datensatz.F1 = record.GetInt32(1);
Datensatz.F2 = record.GetInt32(2);
Datensatz.F3 = record.GetInt32(3);
Datensatz.F4 = record.GetInt32(4);
Datensatz.F5 = record.GetInt32(5);
Datensatz.F6 = record.GetInt32(6);
Datensatz.F7 = record.GetInt32(7);
Datensatz.F8 = record.GetInt32(8);
Datensatz.F9 = record.GetInt32(9);
Datensatz.F10 = record.GetInt32(10);
return(Datensatz);
}
private void Kostenrechnung(int ID, string file, ref int total_time, ref decimal total_cost, ref decimal avrg_wage)
{
string[] raw_data = File.ReadAllText(file).Replace("\r\n", "").Split(';');
Datensatz[] data = new Datensatz[(raw_data.Length - 1) / 4];
int counter = 0;
for (int i = 0; i < raw_data.Length - 1; i += 4, counter++)
{
Datensatz new_data = new Datensatz();
new_data.ID = Convert.ToInt32(raw_data[i]);
new_data.Date = Convert.ToDateTime(raw_data[i + 1]);
new_data.duration = Convert.ToInt32(raw_data[i + 2]);
new_data.wage = Convert.ToDecimal(raw_data[i + 3]);
data[counter] = new_data;
}
counter = 0;
foreach (var item in data)
{
if (item.ID == ID)
{
counter++;
}
}
Datensatz[] data_of_id = new Datensatz[counter];
counter = 0;
foreach (var item in data)
{
if (item.ID == ID)
{
data_of_id[counter] = item;
counter++;
}
}
total_time = 0;
total_cost = 0;
avrg_wage = 0;
foreach (var datapoint in data_of_id)
{
total_time += datapoint.duration;
total_cost += datapoint.wage * datapoint.duration;
}
avrg_wage = total_cost / total_time;
return;
}