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