public HydroTopologyViewModel(HydroTopology hydroTopology)
{
this.hydroTopology = hydroTopology;
elementsList = new List <string>();
SetElementsList();
SetTypesList();
}
public HydroTopologyViewModel()
{
hydroTopology = new HydroTopology();
hydroTopology.System = HydroTopologyPanel.HydroSystemName;
elementsList = new List <string>();
typesList = new List <string>();
}
public static void DeleteElement(HydroTopology dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Sistema = '{1}' " +
"AND Elemento = '{2}' " +
"AND Tipo = '{3}'",
table, dataObject.System, dataObject.Element, dataObject.Type);
DataBaseManager.ExecuteQuery(query);
}
public static int UpdateObject(HydroTopology dataObject)
{
bool isNew = false;
string query = string.Format("SELECT Sistema " +
"FROM {0} " +
"WHERE Id = {1}", table, dataObject.Id);
OleDbDataReader reader = DataBaseManager.ReadData(query);
if (!reader.Read())
{
query = string.Format("INSERT INTO {0}(Sistema, Elemento, Tipo, TipoElemento) " +
"VALUES('{1}', '{2}', '{3}', '{4}')",
table, dataObject.System, dataObject.Element,
dataObject.Type, dataObject.ElementType);
isNew = true;
}
else
{
query = string.Format("UPDATE {0} SET " +
"Sistema = '{1}', " +
"Elemento = '{2}', " +
"Tipo = '{3}', " +
"TipoElemento = '{4}' " +
"WHERE Id = {5}",
table, dataObject.System, dataObject.Element,
dataObject.Type, dataObject.ElementType, dataObject.Id);
}
DataBaseManager.DbConnection.Close();
DataBaseManager.ExecuteQuery(query);
if (isNew)
{
query = string.Format("SELECT Max(Id) FROM {0}", table);
reader = DataBaseManager.ReadData(query);
reader.Read();
int id = Convert.ToInt32(reader.GetValue(0));
DataBaseManager.DbConnection.Close();
return(id);
}
else
{
return(-1);
}
}
