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