/// <summary>
/// Checks if specifeid Emails address belongs to somebody in this server.
/// </summary>
/// <param name="emailAddress">Emails address which to check.</param>
/// <returns>Returns true if Emails address is found.</returns>
public bool EmailAddressExists(string emailAddress)
{
bool retVal = false;
switch(m_DB_Type)
{
#region DB_Type.XML
case DB_Type.XML:
emailAddress = emailAddress.Replace("*","[*]");
emailAddress = emailAddress.Replace("%","[%]");
using(DataView dv = new DataView(dsUsers.Tables["Users"])){
dv.RowFilter = "Emails LIKE '*[<]" + emailAddress + "[>]*'";
if(dv.Count > 0){
retVal = true;
}
}
break;
#endregion
#region DB_Type.MSSQL
case DB_Type.MSSQL:
using(WSqlCommand sqlCmd = new WSqlCommand(m_ConStr,"lspr_EmailAddressExists")){
sqlCmd.AddParameter("@EmailAddress",SqlDbType.NVarChar,emailAddress);
DataSet ds = sqlCmd.Execute();
ds.Tables[0].TableName = "Users";
if(ds.Tables["Users"].Rows.Count > 0){
return true;
}
else{
return false;
}
}
#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.EmailAddressExists(emailAddress);
}
#endregion
}
return retVal;
}
