public bool AddTransfer(TransferLogEntry transferlog)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(
"INSERT INTO transfers (transfer_type_id, transfer_status_id, account_from, account_to, amount) VALUES (@transfer_type_id, @transfer_status_id, @account_from, @account_to, @amount);", conn);
cmd.Parameters.AddWithValue("@transfer_type_id", transferlog.TransferTypeId);
cmd.Parameters.AddWithValue("@transfer_status_id", transferlog.TransferStatusId);
cmd.Parameters.AddWithValue("@account_from", transferlog.AccountFrom);
cmd.Parameters.AddWithValue("@account_to", transferlog.AccountTo);
cmd.Parameters.AddWithValue("@amount", transferlog.Amount);
int count = cmd.ExecuteNonQuery();
if (count == 1)
{
return(true);
}
else
{
return(false);
}
}
}
catch (SqlException ex)
{
throw;
}
}
public List <TransferLogEntry> DisplayMyTransfers(int userID)
{
List <TransferLogEntry> myTransfers = new List <TransferLogEntry>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
//SqlCommand cmd = new SqlCommand("SELECT * FROM transfers WHERE account_from = @userID OR account_to = @userID; ", conn);
SqlCommand cmd2 = new SqlCommand("SELECT * FROM transfers JOIN accounts a1 on transfers.account_to = a1.user_id JOIN accounts a2 on transfers.account_from = a2.user_id JOIN users u1 on a1.user_id = u1.user_id JOIN users u2 on a2.user_id = u2.user_id WHERE account_from = 2 OR account_to = 3 AND account_from = 3 OR account_to = 1;", conn);
cmd2.Parameters.AddWithValue("@userID", userID);
SqlDataReader reader = cmd2.ExecuteReader();
while (reader.Read())
{
TransferLogEntry transferDetail = new TransferLogEntry()
{
TransferId = Convert.ToInt32(reader["transfer_id"]),
TransferTypeId = Convert.ToInt32(reader["transfer_type_id"]),
TransferStatusId = Convert.ToInt32(reader["transfer_status_id"]),
AccountFrom = Convert.ToInt32(reader["account_from"]),
AccountTo = Convert.ToInt32(reader["account_to"]),
Amount = Convert.ToDecimal(reader["amount"]),
UserNameFrom = Convert.ToString(reader["usernameFrom"]),
UserNameTo = Convert.ToString(reader["usernameTo"])
};
myTransfers.Add(transferDetail);
}
}
}
catch (SqlException ex)
{
throw;
}
return(myTransfers);
}
