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 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(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 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(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(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();
}
public List <ActiveOrderView> GetActiveOrdersView()
{
var connection = oracleComponent.GetOpenConnection();
var command = oracleComponent.GetCommand(connection, "select * from ActiveOrdersView", CommandType.Text);
OracleDataReader dataReader = command.ExecuteReader();
var activeOrderViewList = new List <ActiveOrderView>();
while (dataReader.Read())
{
activeOrderViewList.Add(new ActiveOrderView
{
UserId = dataReader.GetInt32(0),
FirstName = dataReader.GetString(1),
LastName = dataReader.GetString(2),
MiddleName = dataReader.GetString(3),
OrderDate = dataReader.GetDateTime(4),
ShipDate = dataReader.GetDateTime(5),
Adress = dataReader.GetString(6)
});
}
dataReader.Close();
connection.Dispose();
return(activeOrderViewList);
}
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 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());
}