public static User FetchUserByID(string uid)
{
User user = null;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "SELECT * FROM User " +
"WHERE uid = @uid";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@uid", uid);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.SingleRow);
if (reader.Read())
{
user = new User
{
uid = (long)reader["uid"],
email = reader["email"].ToString()
};
}
}catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(user);
}
public static bool UpdateUser(string uid, User newUser)
{
bool retVal = false;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "UPDATE User SET email = @email WHERE uid = @uid";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@uid", newUser.uid);
command.Parameters.AddWithValue("@email", newUser.email);
try
{
connection.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
retVal = true;
}
else
{
retVal = false;
}
}
catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(retVal);
}
public static bool DeleteUser(string uid)
{
bool retVal = false;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "DELETE FROM User WHERE uid = @uid";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@uid", uid);
try
{
connection.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
retVal = true;
}
else
{
retVal = false;
}
}catch (SqlException e)
{
Console.Write(e);
}
return(retVal);
}
public static Wallet FetchWalletByKey(string address)
{
Wallet wallet = null;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "SELECT * FROM Wallet " +
"WHERE address = @address";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@address", address);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader(System.Data.CommandBehavior.SingleRow);
if (reader.Read())
{
wallet = new Wallet
{
address = reader["address"].ToString(),
amount = (double)reader["amount"],
userID = (long)reader["userID"]
};
}
}catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(wallet);
}
public static List <Wallet> FetchUserWallets(long userID)
{
List <Wallet> wallets = new List <Wallet>();
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "SELECT * FROM Wallets" +
"WHERE userID = @userID";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@userID", userID);
try
{
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
wallets.Add(new Wallet(reader["address"].ToString(),
(long)reader["userID"],
(double)reader["amount"]));
}
}catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(wallets);
}
public static bool UpdateWallet(string address, Wallet newWallet)
{
bool retVal = false;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query = "UPDATE Wallet SET userID = @userID, amount = @amount WHERE address = @address";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@userID", newWallet.userID);
command.Parameters.AddWithValue("@amount", newWallet.amount);
command.Parameters.AddWithValue("@address", address);
try
{
connection.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
retVal = true;
}
else
{
retVal = false;
}
}
catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(retVal);
}
public static bool AddWallet(Wallet wallet)
{
bool retVal = false;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query =
"INSERT Wallet" +
"(address, userID, amount)" +
"VALUES (@address, @userID, @amount)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@address", wallet.address);
command.Parameters.AddWithValue("@userID", wallet.userID);
command.Parameters.AddWithValue("@amount", wallet.amount);
try
{
connection.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
retVal = true;
}
else
{
retVal = false;
}
}
catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(retVal);
}
public static bool AddUser(User user)
{
bool retVal = false;
SqlConnection connection = new SqlConnection(DBUtils.GetConnectionString());
string query =
"INSERT User" +
"(uid, email)" +
"VALUES (@uid, @email)";
SqlCommand command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@id", user.uid);
command.Parameters.AddWithValue("@emailaddress", user.email);
try
{
connection.Open();
int count = command.ExecuteNonQuery();
if (count > 0)
{
retVal = true;
}
else
{
retVal = false;
}
}
catch (SqlException e)
{
Console.Write(e);
}
finally
{
connection.Close();
}
return(retVal);
}
