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