public virtual void RemoveProduct(UserOwnedProductModel mdl)
{
OwnedProducts.Remove(mdl);
if (DBContext != null)
{
DBContext.OwnedProducts.Remove(mdl);
}
}
public virtual void AddProduct(UserOwnedProductModel mdl)
{
mdl.Owner = this;
OwnedProducts.Add(mdl);
if (DBContext != null)
{
DBContext.OwnedProducts.Add(mdl);
}
}
/// <summary>
/// Returns a owned product with a exception message in it.
/// </summary>
/// <param name="exception"></param>
/// <returns>Product</returns>
private OwnedProducts OwnedProductException(Exception exception)
{
OwnedProducts owned_product = new OwnedProducts
{
IsActive = false,
Name = exception.Message,
ProductId = -5
};
return(owned_product);
}
/// <summary>
/// Finds a list of userproducts owned by a specific user in the database.
/// </summary>
/// <param name="username"></param>
/// <returns>List<OwnedProducts></returns>
public List <OwnedProducts> GetOwnedProducts(string username)
{
List <OwnedProducts> owned_products;
try
{
using (var connection = new SqlConnection(db.GetConnectionString()))
using (var cmd = connection.CreateCommand())
{
connection.Open();
cmd.CommandText = "SELECT * from Table_Product p INNER JOIN Table_UserProduct up ON p.id = up.productId WHERE up.username = @input";
cmd.Parameters.AddWithValue("input", username);
var reader = cmd.ExecuteReader();
owned_products = new List <OwnedProducts>();
while (reader.Read())
{
OwnedProducts owned_product = new OwnedProducts
{
IsActive = reader.GetBoolean(reader.GetOrdinal("isActive")),
Name = reader.GetString(reader.GetOrdinal("name")),
ProductId = reader.GetInt32(reader.GetOrdinal("productId"))
};
owned_products.Add(owned_product);
}
connection.Close();
}
}
catch (Exception exception)
{
owned_products = new List <OwnedProducts>
{
OwnedProductException(exception)
};
}
return(owned_products);
}
