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