using System.Configuration;
using System.Data;
using System.Data.SqlClient;

namespace test.DataAccess
{
    public class MemberDA
    {
        private static string connectionString = ConfigurationManager.ConnectionStrings["DataSource.Connection"].ConnectionString;
        public static string GetLoggedinID()
        {
            string _id = "";
            try
            {
                if (AppPrincipal.CurrentIdentity.IsAuthenticated && AppPrincipal.CurrentIdentity.LoginIdentity != "")
                {
                    _id = AppPrincipal.CurrentIdentity.LoginIdentity;
                }
            }
            catch { }
            return _id;
        }
        public static bool CheckRegistered(string ID)
        {
            bool isRegistered = true;
            string queryString = "SELECT * FROM TEST_APP_INIT WHERE OUTCOME = 'NEW' AND ID = @ID";

            using (SqlConnection connection = new SqlConnection(connectionString))
            {
                SqlCommand cmd = new SqlCommand(queryString, connection);
                cmd.Parameters.Add("@ID", SqlDbType.VarChar, 10).Value = ID;
                connection.Open();
                SqlDataReader reader = cmd.ExecuteReader();

                try
                {
                    while (reader.Read())
                    {
                        isRegistered = false;
                    }
                }
                finally
                {
                    reader.Close();
                }

                connection.Close();
            }

            return isRegistered;
        }
    }
}