public bool isDirty()
{
ObservableCollection<Village> tempVillageList = program.getAllRelatedVillage();
if (villageList.Count != tempVillageList.Count)
return true;
foreach (Village village in villageList)
{
int villageID = village.id;
Village villageCopy = new Village();
villageCopy.id = villageID;
villageCopy.select();
if (!village.compare(villageCopy))
{
return true;
}
int innerRoadID = village.innerRoad.id;
InnerRoad innerRoadCopy = new InnerRoad();
innerRoadCopy.id = innerRoadID;
innerRoadCopy.select();
if (!village.innerRoad.compare(innerRoadCopy))
{
return true;
}
}
return false;
}
public InnerRoad getRelatedInnerRoad()
{
if (!isValid(new List<string>() { "prID", "vName", "vBoundary", "vInUse" }))
return null;
string sqlCommand = String.Format("select irID from InnerRoad where vID={0}", vID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectInnerRoadIDByVillageID(sqlCommand);
if (reader.HasRows)
{
reader.Read();
int innerRoadID = Int32.Parse(reader[0].ToString());
InnerRoad innerRoad = new InnerRoad();
innerRoad.id = innerRoadID;
innerRoad.select();
return innerRoad;
}
else
{
return null;
}
}
public bool isDirty()
{
foreach (InnerRoad innerRoad in innerRoadList)
{
int innerRoadID = innerRoad.id;
InnerRoad innerRoadCopy = new InnerRoad();
innerRoadCopy.id = innerRoadID;
innerRoadCopy.select();
if (!innerRoad.compare(innerRoadCopy))
{
return true;
}
}
return false;
}
public ObservableCollection<InnerRoad> getAllRelatedInnerRoad()
{
if (!isValid(new List<string>() { "prName", "pID" }))
return null;
ObservableCollection<InnerRoad> innerRoadList = new ObservableCollection<InnerRoad>();
string sqlCommand = String.Format(@"select irID from InnerRoad where prID={0}", prID);
Sql sql = new Sql();
SqlDataReader reader = sql.selectAllInnerRoadByPrID(sqlCommand);
if (reader.HasRows)
{
while (reader.Read())
{
int irID = Int32.Parse(reader[0].ToString());
InnerRoad innerRoad = new InnerRoad();
innerRoad.id = irID;
innerRoad.select();
innerRoadList.Add(innerRoad);
}
sql.closeConnection();
return innerRoadList;
}
else
{
sql.closeConnection();
return null;
}
}