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