public bool isDirty()
{
foreach (MainRoad mainRoad in mainRoadList)
{
if (mainRoad.needDelete)
return true;
}
ObservableCollection<MainRoad> tempMainRoadList = program.getAllRelatedMainRoad();
if (tempMainRoadList == null)
tempMainRoadList = new ObservableCollection<MainRoad>();
if (tempMainRoadList.Count != mainRoadList.Count)
return true;
foreach (MainRoad mainRoad in mainRoadList)
{
int mainRoadID = mainRoad.id;
MainRoad mainRoadCopy = new MainRoad();
mainRoadCopy.id = mainRoadID;
mainRoadCopy.select();
if (!mainRoad.compare(mainRoadCopy))
return true;
}
return false;
}
public ObservableCollection<MainRoad> getAllRelatedMainRoad()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<MainRoad> mainRoadList = new ObservableCollection<MainRoad>();
string sqlCommand = String.Format(@"select mrID from MainRoad where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectAllMainRoadIDByPrID(sqlCommand);
if (reader.HasRows)
{
while (reader.Read())
{
int mrID = Int32.Parse(reader[0].ToString());
MainRoad mainRoad = new MainRoad();
mainRoad.id = mrID;
mainRoad.select();
mainRoadList.Add(mainRoad);
}
sql.closeConnection();
return mainRoadList;
}
else
{
sql.closeConnection();
return null;
}
}
