public bool AddSealedProduct(SealedProductDTO NewProduct)
{
bool Confirmation;
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand InsertSealedProduct = new SqlCommand
{
CommandText = "InsertSealedProduct",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlParameter SetIDParameter = new SqlParameter
{
ParameterName = "SetID",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
SqlValue = NewProduct.SetID
};
InsertSealedProduct.Parameters.Add(SetIDParameter);
SqlParameter SealedProductNameParameter = new SqlParameter
{
ParameterName = "SealedProductName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.VarChar,
SqlValue = NewProduct.SealedProductName
};
InsertSealedProduct.Parameters.Add(SealedProductNameParameter);
SqlParameter PriceParameter = new SqlParameter
{
ParameterName = "Price",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Money,
SqlValue = NewProduct.Price
};
InsertSealedProduct.Parameters.Add(PriceParameter);
InsertSealedProduct.ExecuteNonQuery();
StoreConnection.Close();
Confirmation = true;
return(Confirmation);
}
public SealedProduct GetSealedProductByID(int SealedProductID)
{
SealedProduct FoundProduct = new SealedProduct();
SealedProductDTO SealedProductDTO = new SealedProductDTO();
SealedProductDataController SealedProductDataController = new SealedProductDataController();
SealedProductDTO = SealedProductDataController.GetSealedProduct(SealedProductID);
FoundProduct.SealedProductID = SealedProductDTO.SealedProductID;
FoundProduct.SetID = SealedProductDTO.SetID;
FoundProduct.SealedProductName = SealedProductDTO.SealedProductName;
FoundProduct.Price = SealedProductDTO.Price;
return(FoundProduct);
}
public List <SealedProductDTO> GetSealedProductsByGame(int GameID)
{
List <SealedProductDTO> SealedProducts = new List <SealedProductDTO>();
SqlConnection StoreConnection = new SqlConnection();
StoreConnection.ConnectionString = "Data Source=.;Initial Catalog=TCGStore;Persist Security Info=True;Integrated Security=true;";
StoreConnection.Open();
SqlCommand GetSealedProductByGame = new SqlCommand
{
CommandText = "GetSealedProductByGame",
CommandType = CommandType.StoredProcedure,
Connection = StoreConnection
};
SqlParameter GameIDParameter = new SqlParameter
{
ParameterName = "GameID",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
SqlValue = GameID
};
GetSealedProductByGame.Parameters.Add(GameIDParameter);
SqlDataReader DataReader = GetSealedProductByGame.ExecuteReader();
if (DataReader.Read())
{
while (DataReader.HasRows)
{
SealedProductDTO Product = new SealedProductDTO();
for (int Index = 0; Index < DataReader.FieldCount; Index++)
{
Product.SealedProductID = int.Parse(DataReader["SealedProductID"].ToString());
Product.SealedProductName = DataReader["SealedProductName"].ToString();
Product.SetID = int.Parse(DataReader["SetID"].ToString());
Product.Price = decimal.Parse(DataReader["Price"].ToString());
}
SealedProducts.Add(Product);
}
}
DataReader.Close();
StoreConnection.Close();
return(SealedProducts);
}
public bool Put([FromBody] SealedProduct UpdatedSealedProduct)
{
bool Confirmation;
SealedProductDataController SealedProductDataController = new SealedProductDataController();
SealedProductDTO ProductDTO = new SealedProductDTO
{
SealedProductID = UpdatedSealedProduct.SealedProductID,
SealedProductName = UpdatedSealedProduct.SealedProductName,
SetID = UpdatedSealedProduct.SetID,
Price = UpdatedSealedProduct.Price
};
Confirmation = SealedProductDataController.UpdateSealedProduct(ProductDTO);
return(Confirmation);
}
public bool Post([FromBody] SealedProduct NewProduct)
{
bool Confrimation;
SealedProductDataController SealedProductDataController = new SealedProductDataController();
SealedProductDTO ProductDTO = new SealedProductDTO
{
SealedProductID = NewProduct.SealedProductID,
SealedProductName = NewProduct.SealedProductName,
SetID = NewProduct.SetID,
Price = NewProduct.Price
};
Confrimation = SealedProductDataController.AddSealedProduct(ProductDTO);
return(Confrimation);
}
