/// <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 } }