/// <summary>
/// Gets Emails address routes.
/// </summary>
/// <returns></returns>
public DataView GetRouteList()
{
switch(m_DB_Type)
{
#region DB_Type.XML
case DB_Type.XML:
if(!dsRouting.Tables["Routing"].Columns.Contains("Length")){
dsRouting.Tables["Routing"].Columns.Add("Length",Type.GetType("System.Int32"),"Len(Pattern)");
}
DataView dv = new DataView(dsRouting.Tables["Routing"]);
dv.Sort = "DomainID ASC,Length DESC,PATTERN DESC";
return dv;
#endregion
#region DB_Type.MSSQL
case DB_Type.MSSQL:
using(WSqlCommand sqlCmd = new WSqlCommand(m_ConStr,"lspr_GetRouteList")){
// sqlCmd.AddParameter("@DomainName",SqlDbType.NVarChar,source);
DataSet ds = sqlCmd.Execute();
ds.Tables[0].TableName = "Routing";
if(!ds.Tables["Routing"].Columns.Contains("Length")){
ds.Tables["Routing"].Columns.Add("Length",Type.GetType("System.Int32"),"Len(Pattern)");
}
ds.Tables["Routing"].DefaultView.Sort = "DomainID ASC,Length DESC,PATTERN DESC";
return ds.Tables["Routing"].DefaultView;
}
#endregion
#region DB_Type.WebServices
case DB_Type.WebServices:
using(RemoteAdmin eng = new RemoteAdmin()){
_Core.InitWebService(m_WebServicesUrl,m_WebServicesPwd,m_WebServicesUser,eng);
return eng.GetRouteList().Tables["Routing"].DefaultView;
}
#endregion
}
return null;
}
