public static MySqlDataAdapter ByDate(DateTime startDate, DateTime endDate, String id_sensor)
{
String strStartDate = MapToDataBase.MapDate(startDate);
String strEndDate = MapToDataBase.MapDate(endDate);
String sql_query =
"SELECT * FROM dataline WHERE dataline.dateTime >= '" + strStartDate +
"' AND dataline.dateTime <= '" + strEndDate + "'" +
" AND dataline.idSensor = '" + id_sensor + "'";
MySqlCommand dataFromBase = SelectInDataBase.WithParameter(sql_query, DataBaseConnect.getInstance());
return(DataBaseToWinForm.Transform(dataFromBase));
}
public static MySqlDataAdapter all()
{
MySqlCommand dataFromBase = SelectAll.Data(DataBaseConnect.getInstance());
return(DataBaseToWinForm.Transform(dataFromBase));
}
