public static void Update(Garbage garbageForUpdate)
{
using (GarbageDal dal = new GarbageDal())
{
dal.UpdateGarbage(garbageForUpdate.City, garbageForUpdate.Area, garbageForUpdate.Street, garbageForUpdate.SensorName, garbageForUpdate.GarbageCode);
}
}
public static void Add(Garbage garbage)
{
using (GarbageDal dal = new GarbageDal())
{
dal.AddGarbage(garbage.City, garbage.Area, garbage.Street, garbage.SensorName);
}
}
public static void Delete(int garbageCode)
{
using (GarbageDal dal = new GarbageDal())
{
dal.DeleteGarbage(garbageCode);
}
}
public static List <Garbage> GetByArea(string area)
{
listGarbages.Clear();
using (GarbageDal dal = new GarbageDal())
{
SqlDataReader reader = dal.GetGarbagesByArea(area);
while (reader.Read())
{
Garbage garbage = new Garbage(int.Parse(reader["garbageCode"].ToString()), reader["city"].ToString(), reader["area"].ToString(), reader["street"].ToString(), reader["sensorName"].ToString());
listGarbages.Add(garbage);
}
}
return(listGarbages);
}
