/// <summary> /// Updates security entry. /// </summary> /// <param name="securityID"></param> /// <param name="Description"></param> /// <param name="protocol"></param> /// <param name="type"></param> /// <param name="action"></param> /// <param name="content"></param> /// <param name="startIP"></param> /// <param name="endIP"></param> /// <returns></returns> public void UpdateSecurityEntry(string securityID,string Description,string protocol,string type,string action,string content,long startIP,long endIP) { switch(m_DB_Type) { #region DB_Type.XML case DB_Type.XML: DataSet dsSecurityCopy = dsSecurity.Copy(); using(DataView dv = new DataView(dsSecurityCopy.Tables["Security_List"])){ dv.RowFilter = "SecurityID='" + securityID + "'"; if(dv.Count > 0){ dv[0]["Description"] = Description; dv[0]["Protocol"] = protocol; dv[0]["Type"] = type; dv[0]["Action"] = action; dv[0]["Content"] = content; dv[0]["StartIP"] = startIP; dv[0]["EndIP"] = endIP; } dsSecurityCopy.WriteXml(m_DataPath + "Security.xml",XmlWriteMode.IgnoreSchema); } break; #endregion #region DB_Type.MSSQL case DB_Type.MSSQL: using(WSqlCommand sqlCmd = new WSqlCommand(m_ConStr,"lspr_UpdateSecurityEntry")){ sqlCmd.AddParameter("@SecurityID" ,SqlDbType.UniqueIdentifier,securityID); sqlCmd.AddParameter("@Description" ,SqlDbType.NVarChar ,Description); sqlCmd.AddParameter("@Protocol" ,SqlDbType.NVarChar ,protocol); sqlCmd.AddParameter("@Type" ,SqlDbType.NVarChar ,type); sqlCmd.AddParameter("@Action" ,SqlDbType.NVarChar ,action); sqlCmd.AddParameter("@Content" ,SqlDbType.NVarChar ,content); sqlCmd.AddParameter("@StartIP" ,SqlDbType.BigInt ,startIP); sqlCmd.AddParameter("@EndIP" ,SqlDbType.BigInt ,endIP); 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.UpdateSecurityEntry(securityID,Description,protocol,type,action,content,startIP,endIP); } break; #endregion } }