/// <summary>
/// Deletes route.
/// </summary>
/// <param name="routeID"></param>
public void DeleteRoute(string routeID)
{
switch(m_DB_Type)
{
#region DB_Type.XML
case DB_Type.XML:
DataSet dsRoutingCopy = dsRouting.Copy();
using(DataView dv = new DataView(dsRoutingCopy.Tables["Routing"])){
dv.RowFilter = "RouteID='" + routeID + "'";
if(dv.Count > 0){
dsRoutingCopy.Tables["Routing"].Rows.Remove(dv[0].Row);
}
dsRoutingCopy.Tables["Routing"].Columns.Remove("Length");
dsRoutingCopy.WriteXml(m_DataPath + "Routing.xml",XmlWriteMode.IgnoreSchema);
}
break;
#endregion
#region DB_Type.MSSQL
case DB_Type.MSSQL:
using(WSqlCommand sqlCmd = new WSqlCommand(m_ConStr,"lspr_DeleteRoute")){
sqlCmd.AddParameter("@RouteID" ,SqlDbType.UniqueIdentifier,routeID);
DataSet ds = sqlCmd.Execute();
}
break;
#endregion
#region DB_Type.WebServices
case DB_Type.WebServices:
using(RemoteAdmin eng = new RemoteAdmin()){
_Core.InitWebService(m_WebServicesUrl,m_WebServicesPwd,m_WebServicesUser,eng);
eng.DeleteRoute(routeID);
}
break;
#endregion
}
}
