public int AverageAmount(List<Accident> accidentlist) { Accident acc = new Accident(); return acc.GetAverage(accidentlist); }
public List<Accident> getListByDateFromDB(DateTime Date, int DeviceNr) { List<Accident> dayAccidents = new List<Accident>(); DateTime newDate = DateTime.Parse(Date.ToShortDateString()); trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("getInfoFromDate" , trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@Date", newDate)); cmd.Parameters.Add(new SqlParameter("@DeviceNr", DeviceNr)); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.HasRows && rdr.Read()) { // Device D = new Device(int.Parse(rdr["DeviceNR"].ToString()), User); Accident acc = new Accident(int.Parse((rdr["AccidentID"]).ToString()), int.Parse((rdr["Amount"]).ToString()), DateTime.Parse((rdr["TimeOfAccident"]).ToString()),int.Parse((rdr["DeviceID"]).ToString()), int.Parse((rdr["Drinks"]).ToString()), DateTime.Parse((rdr["TimeSleep"]).ToString()), DateTime.Parse((rdr["TimeToilet"]).ToString()), int.Parse((rdr["Toilet"]).ToString()), int.Parse((rdr["Version"]).ToString())); dayAccidents.Add(acc); } } catch (Exception e) { trans.RollBack(); throw e; // trans.getcon().Close(); } //trans.Commit(); trans.getcon().Close(); return dayAccidents; }
public List<Accident> ReadAccidents(int UserID) { trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("ReadAccidents", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@UserID", UserID)); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.HasRows && rdr.Read()) { Accident A = new Accident(int.Parse(rdr["AccidentID"].ToString()), int.Parse(rdr["Amount"].ToString()), DateTime.Parse(rdr["TimeOfAccident"].ToString()), new Device(int.Parse(rdr["DeviceID"].ToString()), User)); A.Version = int.Parse(rdr["Version"].ToString()); tempList.Add(A); } } catch (Exception e) { trans.RollBack(); throw e; } trans.getcon().Close(); return tempList; }
public List<Accident> getAverageFromDB(DateTime selectStart, DateTime selectEnd, int DeviceNr) { List<Accident> averageAccidents = new List<Accident>(); trans = new Transaction(); trans.BegindTransactions(); try { cmd = new SqlCommand("getAverage", trans.getcon(), trans.GetTransaction()); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@DeviceID", DeviceNr)); cmd.Parameters.Add(new SqlParameter("@StartDate", selectStart)); cmd.Parameters.Add(new SqlParameter("@EndDate", selectEnd)); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { // Device D = new Device(int.Parse(rdr["DeviceNR"].ToString()), User); Accident A = new Accident(int.Parse((rdr["Amount"]).ToString())); averageAccidents.Add(A); } rdr.Close(); } catch (Exception e) { //trans.RollBack(); throw e; //trans.getcon().Close(); } //trans.Commit(); trans.getcon().Close(); return averageAccidents; }