public override void TearDown()
{
base.TearDown();
IStorageManager manager = StorageManagerFactory.CreateDatabaseManager(_testConnectionString);
manager.Query(Properties.Resources.clean);
}
public IEnumerable <ReportOverview> Get(string workArea, string productionLineFilter, string workCellFilter,
string ruleTypeFilter,
string materialFilter,
int pageNumber, int pageSize)
{
var list = new List <ReportOverview>();
IQueryOperations storageManager = StorageManagerFactory.CreateDatabaseManager(this.ConnectionString);
var set = storageManager.ExecuteCommand("sp_VCC_local_reportOverview",
new[]
{
this.CreateDataParameter("@workArea", workArea),
this.CreateDataParameter("@productionLineFilter", productionLineFilter),
this.CreateDataParameter("@workCellFilter", workCellFilter),
this.CreateDataParameter("@ruleTypeFilter", ruleTypeFilter),
this.CreateDataParameter("@materialFilter", materialFilter),
this.CreateDataParameter("@pageNumber", pageNumber),
this.CreateDataParameter("@pageSize", pageSize),
});
if (set.IsEmpty())
{
return(list);
}
var rows = set.Tables[0].Rows.Cast <DataRow>();
return(rows.MapTo <IEnumerable <ReportOverview> >());
}
public override void Setup()
{
IStorageManager manager = StorageManagerFactory.CreateDatabaseManager(_testConnectionString);
manager.Query(Properties.Resources._01_sp_VCC_local_reportOverview);
manager.Query(Properties.Resources._02_Split);
manager.Query(Properties.Resources._03_ReportOverview);
manager.Query(Properties.Resources._04_data);
base.Setup();
}
/// <summary>
/// Effettua un test della connessione data la stringa di connessione
/// </summary>
/// <param name="connectionString">Stringa di connesione allo storage</param>
/// <param name="error">errore restituito dalla procedura</param>
/// <returns>true se si connette, false altrimenti</returns>
public static bool TestConnectionByConnString(string connectionString, out string error)
{
// La connection string deve contenere almeno una proprietà con un =
if (!string.IsNullOrEmpty(connectionString) && connectionString.Contains("="))
{
return(StorageManagerFactory.CreateDatabaseManager(connectionString).TestConnection(connectionString, out error));
}
error = $"connectionString non valida: {connectionString}";
return(false);
}
/// <summary>
/// Constructor.
/// </summary>
public NGRIDServer()
{
_settings = NGRIDSettings.Instance;
_serverGraph = new NGRIDServerGraph();
_clientApplicationList = new NGRIDClientApplicationList();
_ngridManager = new NGRIDController("NGRIDController");
_storageManager = StorageManagerFactory.CreateStorageManager();
_routingTable = new RoutingTable();
_communicationLayer = new CommunicationLayer();
_organizationLayer = new OrganizationLayer(_communicationLayer, _storageManager, _routingTable, _serverGraph, _clientApplicationList, _ngridManager);
_ngridManager.OrganizationLayer = _organizationLayer;
}
// GET api/<controller>
public IEnumerable <ReportOverviewViewModel> Get(string area)
{
var list = new List <ReportOverviewViewModel>();
IQueryOperations storageManager = StorageManagerFactory.CreateDatabaseManager(_connectionString);
var set = storageManager.ExecuteCommand("sp_VCC_local_reportOverview", new[] { new SqlParameter("@workArea", area) });
if (set.IsEmpty())
{
return(list);
}
var rows = set.Tables[0].Rows.Cast <DataRow>();
return(rows.MapTo <IEnumerable <ReportOverviewViewModel> >());
}
