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