public static Customer GetCustomerByEmailOrName()

in Source/Website/Data_Layer/CustomerData.cs [49:70]

• 18 lines of code
• 4 McCabe index (conditional complexity)

        public static Customer GetCustomerByEmailOrName(string emailOrName)
        {
            var query = "SELECT TOP 1 * FROM CUSTOMERS WHERE FirstName = @emailOrName OR Email = @emailOrName";
            var param = new SqlParameter("@emailOrName", emailOrName);

            try
            {
                var result = DataAccessHandler.ExecuteSelect(query, new SqlParameter[] { param });

                if(result.Rows.Count > 0 && result.Rows[0] != null)
                {
                    return GetMappedCustomer(result.Rows[0]);
                }

                return null;
                
            }
            catch (Exception e)
            {
                throw e;
            }
        }