Example #1
0
        private bool CheckIsExistingUser(string email)
        {
            bool isExistingUser = false;
            DataTable datTable = new DataTable();
            int rows = 0;
            StringBuilder sqliteQuerySelect = new StringBuilder();
            sqliteQuerySelect.Append("SELECT ");
            sqliteQuerySelect.Append("count(*) AS NumberOfUsers ");
            sqliteQuerySelect.Append("FROM users ");
            sqliteQuerySelect.Append("WHERE email = @email");
            SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();
            sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
            sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@email", email);
            dataAccessObject = new DataAccessLayer();
            datTable = dataAccessObject.Select(sqliteQuerySelect.ToString(), sqliteDataAdapterSelect);

            if (datTable != null && datTable.Rows.Count > 0)
            {
                var distinctRows = from DataRow dRow in datTable.Rows
                                   select new { column1 = dRow["NumberOfUsers"] };
                if (distinctRows != null)
                {
                    foreach (var row in distinctRows)
                    {
                        rows = Convert.ToInt32(row.column1);
                        break;
                    }
                }
            }
            if (rows == 1)
            {
                isExistingUser = true;
            }
            return isExistingUser;
        }
Example #2
0
        private DataTable GetOrders(int userID)
        {
            DataTable     datTable          = new DataTable();
            StringBuilder sqliteQuerySelect = new StringBuilder();

            sqliteQuerySelect.Append("SELECT ");
            sqliteQuerySelect.Append("id, ");
            sqliteQuerySelect.Append("user_id, ");
            sqliteQuerySelect.Append("payment_id, ");
            sqliteQuerySelect.Append("state, ");
            sqliteQuerySelect.Append("amount, ");
            sqliteQuerySelect.Append("description, ");
            sqliteQuerySelect.Append("created_at, ");
            sqliteQuerySelect.Append("updated_at ");
            sqliteQuerySelect.Append("FROM orders ");
            sqliteQuerySelect.Append("WHERE user_id = @user_id ");
            sqliteQuerySelect.Append("ORDER BY updated_at DESC, id DESC");
            SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();

            sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
            sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@user_id", userID);
            dataAccessObject = new DataAccessLayer();
            datTable         = dataAccessObject.Select(sqliteQuerySelect.ToString(), sqliteDataAdapterSelect);
            return(datTable);
        }
Example #3
0
 private DataTable GetUser(string email)
 {
     DataTable datTable = new DataTable();
     StringBuilder sqliteQuerySelect = new StringBuilder();
     sqliteQuerySelect.Append("SELECT ");
     sqliteQuerySelect.Append("id, ");
     sqliteQuerySelect.Append("email, ");
     sqliteQuerySelect.Append("encrypted_password, ");
     sqliteQuerySelect.Append("sign_in_count, ");
     sqliteQuerySelect.Append("current_sign_in_at, ");
     sqliteQuerySelect.Append("last_sign_in_at, ");
     sqliteQuerySelect.Append("last_sign_in_ip, ");
     sqliteQuerySelect.Append("created_at, ");
     sqliteQuerySelect.Append("updated_at, ");
     sqliteQuerySelect.Append("credit_card_id, ");
     sqliteQuerySelect.Append("credit_card_description ");
     sqliteQuerySelect.Append("FROM users ");
     sqliteQuerySelect.Append("WHERE email = @email");
     SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();
     sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
     sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@email", email);
     dataAccessObject = new DataAccessLayer();
     datTable = dataAccessObject.Select(sqliteQuerySelect.ToString(), sqliteDataAdapterSelect);
     return datTable;
 }
 private DataTable GetPaymentID(string orderID)
 {
     DataTable datTable = new DataTable();
     string sqliteQuery = "SELECT payment_id FROM orders WHERE id = @id";
     SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();
     sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
     sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@id", orderID);
     dataAccessObject = new DataAccessLayer();
     datTable = dataAccessObject.Select(sqliteQuery, sqliteDataAdapterSelect);
     return datTable;
 }
Example #5
0
        private DataTable GetPaymentID(string orderID)
        {
            DataTable         datTable                = new DataTable();
            string            sqliteQuery             = "SELECT payment_id FROM orders WHERE id = @id";
            SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();

            sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
            sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@id", orderID);
            dataAccessObject = new DataAccessLayer();
            datTable         = dataAccessObject.Select(sqliteQuery, sqliteDataAdapterSelect);
            return(datTable);
        }
 private DataTable GetOrders(int userID)
 {
     DataTable datTable = new DataTable();
     StringBuilder sqliteQuerySelect = new StringBuilder();
     sqliteQuerySelect.Append("SELECT ");
     sqliteQuerySelect.Append("id, ");
     sqliteQuerySelect.Append("user_id, ");
     sqliteQuerySelect.Append("payment_id, ");
     sqliteQuerySelect.Append("state, ");
     sqliteQuerySelect.Append("amount, ");
     sqliteQuerySelect.Append("description, ");
     sqliteQuerySelect.Append("created_at, ");
     sqliteQuerySelect.Append("updated_at ");
     sqliteQuerySelect.Append("FROM orders ");
     sqliteQuerySelect.Append("WHERE user_id = @user_id ");
     sqliteQuerySelect.Append("ORDER BY updated_at DESC, id DESC");
     SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();
     sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
     sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@user_id", userID);
     dataAccessObject = new DataAccessLayer();
     datTable = dataAccessObject.Select(sqliteQuerySelect.ToString(), sqliteDataAdapterSelect);
     return datTable;
 }
 private DataTable GetUser(string email)
 {
     DataTable datTable = null;
     StringBuilder selectQuery = new StringBuilder();
     selectQuery.Append("SELECT ");
     selectQuery.Append("id, ");
     selectQuery.Append("email, ");
     selectQuery.Append("encrypted_password, ");
     selectQuery.Append("sign_in_count, ");
     selectQuery.Append("credit_card_id ");
     selectQuery.Append("FROM users ");
     selectQuery.Append("WHERE email = @email;");
     using (SQLiteCommand commandSQLite = new SQLiteCommand(selectQuery.ToString()))
     {
         commandSQLite.Parameters.AddWithValue("@email", email);
         DataAccessLayer dataAccessObject = new DataAccessLayer();
         datTable = dataAccessObject.Select(commandSQLite);
     }
     return datTable;
 }
 private DataTable GetOrders(int userId)
 {
     DataTable datTable = null;
     StringBuilder selectQuery = new StringBuilder();
     selectQuery.Append("SELECT ");
     selectQuery.Append("DISTINCT id, ");
     selectQuery.Append("user_id, ");
     selectQuery.Append("payment_id, ");
     selectQuery.Append("state, ");
     selectQuery.Append("amount, ");
     selectQuery.Append("description, ");
     selectQuery.Append("created_at, ");
     selectQuery.Append("updated_at ");
     selectQuery.Append("FROM orders ");
     selectQuery.Append("WHERE user_id = @user_id ORDER BY id DESC LIMIT 1;");
     using (SQLiteCommand commandSQLite = new SQLiteCommand(selectQuery.ToString()))
     {
         commandSQLite.Parameters.AddWithValue("@user_id", userId);
         DataAccessLayer dataAccessObject = new DataAccessLayer();
         datTable = dataAccessObject.Select(commandSQLite);
     }
     return datTable;
 }
        private bool CheckIsExistingUser(SignUpModel model)
        {
            bool isExistingUser = false;
            DataTable datTable = new DataTable();
            int rows = 0;
            var email = model.Email.Trim();
            StringBuilder sqliteQuerySelect = new StringBuilder();
            sqliteQuerySelect.Append("SELECT ");
            sqliteQuerySelect.Append("count(*) AS NumberOfUsers ");
            sqliteQuerySelect.Append("FROM users ");
            sqliteQuerySelect.Append("WHERE email = @email");
            SQLiteDataAdapter sqliteDataAdapterSelect = new SQLiteDataAdapter();
            sqliteDataAdapterSelect.SelectCommand = new SQLiteCommand();
            sqliteDataAdapterSelect.SelectCommand.Parameters.AddWithValue("@email", email);
            dataAccessObject = new DataAccessLayer();
            datTable = dataAccessObject.Select(sqliteQuerySelect.ToString(), sqliteDataAdapterSelect);

            if (datTable != null && datTable.Rows.Count > 0)
            {
                var distinctRows = from DataRow dRow in datTable.Rows
                                   select new { column1 = dRow["NumberOfUsers"] };
                if (distinctRows != null)
                {
                    foreach (var row in distinctRows)
                    {
                        rows = Convert.ToInt32(row.column1);
                        break;
                    }
                }
            }
            if (rows == 1)
            {
                isExistingUser = true;
            }
            return isExistingUser;
        }
 private bool CheckIsExistingUser(string email)
 {
     bool isExistingUser = false;
     DataTable datTable = null;
     int rows = 0;
     StringBuilder selectQuery = new StringBuilder();
     selectQuery.Append("SELECT ");
     selectQuery.Append("count(*) AS NumberOfUsers ");
     selectQuery.Append("FROM users ");
     selectQuery.Append("WHERE email = @email;");
     using (SQLiteCommand commandSQLite = new SQLiteCommand(selectQuery.ToString()))
     {
         commandSQLite.Parameters.AddWithValue("@email", email);
         DataAccessLayer dataAccessObject = new DataAccessLayer();
         datTable = dataAccessObject.Select(commandSQLite);
     }
     if (datTable != null && datTable.Rows.Count > 0)
     {
         var distinctRows = (from DataRow dRow in datTable.Rows
                             select new { column1 = dRow["NumberOfUsers"] }).Distinct();
         if (distinctRows != null)
         {
             foreach (var row in distinctRows)
             {
                 rows = Convert.ToInt32(row.column1);
                 break;
             }
         }
     }
     if (rows == 1)
     {
         isExistingUser = true;
     }
     return isExistingUser;
 }
 private DataTable GetPaymentId(string orderId)
 {
     DataTable datTable = null;
     string selectQuery = "SELECT payment_id FROM orders WHERE id = @id;";
     using (SQLiteCommand commandSQLite = new SQLiteCommand(selectQuery))
     {
         commandSQLite.Parameters.AddWithValue("@id", orderId);
         DataAccessLayer dataAccessObject = new DataAccessLayer();
         datTable = dataAccessObject.Select(commandSQLite);
     }
     return datTable;
 }