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); }