public IEnumerable <UserLibraryRelativeTable> GetAllPurchase()
{
try
{
List <UserLibraryRelativeTable> purchaseslist = new List <UserLibraryRelativeTable>();
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("readPurchaseAll", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
UserLibraryRelativeTable purchase = new UserLibraryRelativeTable();
purchase.Id_Purchase = Convert.ToInt32(reader["Id_Purchase"]);
purchase.Id_User = Convert.ToInt32(reader["Id_User"]);
purchase.Id_Game = Convert.ToInt32(reader["Id_Game"]);
purchaseslist.Add(purchase);
}
connection.Close();
}
return(purchaseslist);
}
catch { throw; }
}
public UserLibraryRelativeTable GetPurchaseById(int Id_Purchase)
{
try
{
UserLibraryRelativeTable purchase = new UserLibraryRelativeTable();
using (SqlConnection connection = new SqlConnection(connectionString))
{
//string sqlQuery = "SELECT * FROM UserLibraryRelativeTable WHERE Id_Purchase= " + Id_Purchase;
SqlCommand command = new SqlCommand("readPurchaseById", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
purchase.Id_Purchase = Convert.ToInt32(reader["Id_Purchase"]);
purchase.Id_User = Convert.ToInt32(reader["Id_User"]);
purchase.Id_Game = Convert.ToInt32(reader["Id_Game"]);
}
}
return(purchase);
}
catch { throw; }
}
public int AddPurchase(UserLibraryRelativeTable purchase)
{
try
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand("createPurchase", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue(@"Id_User", purchase.Id_User);
command.Parameters.AddWithValue(@"Id_Game", purchase.Id_Game);
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(1);
}
catch
{ throw; }
}
public int Create([FromBody] UserLibraryRelativeTable purchase)
{
return(purchaseobj.AddPurchase(purchase));
}
