public void Create(ShoppingCart model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddShoppingCart", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "UserIdVar", OracleDbType.Int32, model.UserId); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public void Create(Producer model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddProducer", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "NameVar", OracleDbType.Varchar2, model.Name); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public string GetDiff(int?firstId, int?secondId) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "Comparison", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "FirstId", OracleDbType.Int32, firstId); oracleComponent.AddParameter(command, "SecondId", OracleDbType.Int32, secondId); oracleComponent.AddOutParameter(command, "Differences", OracleDbType.Varchar2, ""); command.ExecuteNonQuery(); return(command.Parameters["Differences"]?.Value?.ToString()); }
public void Create(OrderDetails model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddOrderDetails", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "OrderIdVar", OracleDbType.Int32, model.OrderId); oracleComponent.AddParameter(command, "ProductIdVar", OracleDbType.Int32, model.ProductId); oracleComponent.AddParameter(command, "QuantityVar", OracleDbType.Int32, model.Quantity); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public List <ProductViewModel> FindProducts(string searchString) { var connection = oracleComponent.GetOpenConnection(); searchString = "%" + searchString + "%"; var command = oracleComponent.GetCommand(connection, "select * from ProductsFullInfo where name like :searchString or producer like :searchString", CommandType.Text); oracleComponent.AddParameter(command, "searchString", OracleDbType.Varchar2, searchString); OracleDataReader dataReader = command.ExecuteReader(); var productViewModelList = new List <ProductViewModel>(); while (dataReader.Read()) { productViewModelList.Add(new ProductViewModel { Id = dataReader.GetInt32(0), Name = dataReader.GetString(1), Producer = dataReader.GetString(2), Description = dataReader.GetString(3), Category = dataReader.GetString(4), Subcategory = dataReader.GetString(5), Price = dataReader.GetInt32(6), Quantity = dataReader.GetInt32(7) }); } dataReader.Close(); connection.Dispose(); return(productViewModelList); }
public void Create(Product model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddProduct", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "NameVar", OracleDbType.Varchar2, model.Name); oracleComponent.AddParameter(command, "DescriptionVar", OracleDbType.Varchar2, model.Description); oracleComponent.AddParameter(command, "SubcategoryIdVar", OracleDbType.Varchar2, model.SubcategoryId); oracleComponent.AddParameter(command, "ProducerIdVar", OracleDbType.Varchar2, model.ProducerId); oracleComponent.AddParameter(command, "PriceVar", OracleDbType.Varchar2, model.Price); oracleComponent.AddParameter(command, "QuantityVar", OracleDbType.Varchar2, model.Quantity); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public void Create(Order model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddOrder", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "UserIdVar", OracleDbType.Int32, model.UserId); oracleComponent.AddParameter(command, "OrderDateVar", OracleDbType.Date, model.OrderDate); oracleComponent.AddParameter(command, "ShipDateVar", OracleDbType.Date, model.ShipDate); oracleComponent.AddParameter(command, "AdressVar", OracleDbType.Varchar2, model.Adress); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public void Create(Review model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddReview", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "ProductIdVar", OracleDbType.Int32, model.ProductId); oracleComponent.AddParameter(command, "UserIdVar", OracleDbType.Int32, model.UserId); oracleComponent.AddParameter(command, "RatingVar", OracleDbType.Int32, model.Rating); oracleComponent.AddParameter(command, "CommentsVar", OracleDbType.Varchar2, model.Comments); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }
public void Create(User model) { var connection = oracleComponent.GetOpenConnection(); var command = oracleComponent.GetCommand(connection, "AddUser", CommandType.StoredProcedure); oracleComponent.AddParameter(command, "FirstNameVar", OracleDbType.Varchar2, model.FirstName); oracleComponent.AddParameter(command, "MiddleNameVar", OracleDbType.Varchar2, model.MiddleName); oracleComponent.AddParameter(command, "LastNameVar", OracleDbType.Varchar2, model.LastName); oracleComponent.AddParameter(command, "EmailVar", OracleDbType.Varchar2, model.Email); oracleComponent.AddParameter(command, "PhoneNumberVar", OracleDbType.Varchar2, model.PhoneNumber); oracleComponent.AddParameter(command, "PasswordVar", OracleDbType.Varchar2, model.Password); command.ExecuteNonQuery(); command.Dispose(); connection.Close(); }