public BaseListModel <Producer> GetPart(int startRow = 1)
{
var connection = oracleComponent.GetOpenConnection();
var baseListModel = new BaseListModel <Producer>
{
Entities = GetList(oracleComponent.CommandForGetPart(connection, "Producers", startRow)),
EntitiesCount = oracleComponent.GetRowsCount(connection, "Producers")
};
connection.Dispose();
return(baseListModel);
}
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());
}