public static OutsideCondition LoadCurrentCondition(int locationId)
{
OutsideConditions conditions = OutsideConditions.LoadOutsideConditions("SELECT * FROM outside_conditions WHERE location_id=@LocationId ORDER BY ID DESC limit 1;", CommandType.Text, new MySqlParameter[] { new MySqlParameter("@LocationId", locationId) });
if (conditions.Count == 0)
{
return(null);
}
else
{
return(conditions[0]);
}
}
public static OutsideConditions LoadRange(int locationId, DateTime startDate, DateTime endDate)
{
return(OutsideConditions.LoadOutsideConditions("SELECT * FROM outside_conditions WHERE location_id=@LocationId AND log_date BETWEEN @StartDate and @EndDate", CommandType.Text, new MySqlParameter[] { new MySqlParameter("@LocationId", locationId), new MySqlParameter("@StartDate", startDate), new MySqlParameter("@EndDate", endDate) }));
}
public static OutsideConditions LoadOutsideConditionsByUserId(System.Int32 userId)
{
return(OutsideConditions.LoadOutsideConditions("LoadOutsideConditionsByUserId", CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@UserId", userId) }));
}
public static OutsideConditions LoadAllOutsideConditions()
{
return(OutsideConditions.LoadOutsideConditions("LoadOutsideConditionsAll", CommandType.StoredProcedure, null));
}
public static OutsideConditions LoadOutsideConditionsByLocationId(int locationId)
{
return(OutsideConditions.LoadOutsideConditions("outside_conditions_load_by_location_id", CommandType.StoredProcedure, new MySqlParameter[] { new MySqlParameter("@location_id", locationId) }));
}
