/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(DatabaseId databaseId, out StoredProceduresListViewModel storedProceduresListViewModel)
{
// Initialize
questStatus status = null;
storedProceduresListViewModel = null;
// Get query options from query string
QueryOptions queryOptions = null;
BaseListModeler baseListModeler = new BaseListModeler(this.HttpRequestBase, new UserSession());
status = baseListModeler.ParsePagingOptions(this.HttpRequestBase, out queryOptions);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Set up query options.
// TEMPORARY: OPTIMIZE THIS
List <SearchField> searchFieldList = new List <SearchField>();
SearchField searchField = new SearchField();
searchField.Name = "DatabaseId";
searchField.SearchOperation = SearchOperation.Equal;
searchField.Type = typeof(int);
searchField.Value = databaseId.Id.ToString();
searchFieldList.Add(searchField);
SearchOptions searchOptions = new SearchOptions();
searchOptions.SearchFieldList = searchFieldList;
queryOptions.SearchOptions = searchOptions;
QueryResponse queryResponse = null;
// Get Database storedProcedures
List <StoredProcedure> storedProceduresetList = null;
StoredProceduresMgr storedProceduresMgr = new StoredProceduresMgr(this.UserSession);
status = storedProceduresMgr.List(queryOptions, out storedProceduresetList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort by name
storedProceduresetList.Sort(delegate(StoredProcedure i1, StoredProcedure i2) { return(i1.Name.CompareTo(i2.Name)); });
// Transfer model.
// TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsStoredProcedureModel.
storedProceduresListViewModel = new StoredProceduresListViewModel(this.UserSession);
QueryResponseViewModel queryResponseViewModel = null;
status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
storedProceduresListViewModel.QueryResponse = queryResponseViewModel;
foreach (Quest.Functional.MasterPricing.StoredProcedure storedProcedure in storedProceduresetList)
{
StoredProcedureLineItemViewModel storedProcedureLineItemViewModel = new StoredProcedureLineItemViewModel();
BufferMgr.TransferBuffer(storedProcedure, storedProcedureLineItemViewModel);
storedProceduresListViewModel.Items.Add(storedProcedureLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public bool Execute(string[] paramsList)
{
BufferMgr.Setup(GatewayServerConfig.Configuration.BuffSize, GatewayServerConfig.Configuration.BuffPoolSize);
return(true);
}
protected override ClientBase CreateClient(Socket sock)
{
return(new ServerClient(sock, BufferMgr.AcquireBuffer(), BufferMgr.AcquireBuffer()));
}
public virtual void Accept(Socket socket)
{
Accept(socket, BufferMgr.AcquireBuffer(), BufferMgr.AcquireBuffer());
}
protected virtual void OnDisconnected()
{
BufferMgr.ReleaseBuffer(sBuffer);
BufferMgr.ReleaseBuffer(rBuffer);
}
// Use this for initialization
void Start()
{
m_BufferMgr = new BufferMgr(transform.parent.parent.transform);
buffScale = 1f;
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region LIST
//----------------------------------------------------------------------------------------------------------------------------------
// LIST
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus List(ColumnListViewModel viewModel, out ColumnListViewModel columnListViewModel)
{
// Initialize
questStatus status = null;
columnListViewModel = null;
// Read the database
DatabaseId databaseId = new DatabaseId(viewModel.DatabaseId);
DatabaseBaseViewModel databaseBaseViewModel = null;
DatabaseBaseModeler databaseBaseModeler = new DatabaseBaseModeler(this.HttpRequestBase, this.UserSession);
status = databaseBaseModeler.GetDatabase(databaseId, out databaseBaseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get columns according to parent entity type
ColumnsMgr columnsMgr = new ColumnsMgr(this.UserSession);
List <Column> columnList = null;
Table table = null;
View view = null;
if (String.Equals(viewModel.ParentEntityType, "table", StringComparison.InvariantCultureIgnoreCase))
{
// Get table columns
TableId tableId = new TableId(viewModel.Id);
status = columnsMgr.Read(tableId, out columnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read the table info
TablesMgr tablesMgr = new TablesMgr(this.UserSession);
status = tablesMgr.Read(tableId, out table);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
else if (String.Equals(viewModel.ParentEntityType, "view", StringComparison.InvariantCultureIgnoreCase))
{
// Get view columns
ViewId viewId = new ViewId(viewModel.Id);
status = columnsMgr.Read(viewId, out columnList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Read the view info
ViewsMgr viewsMgr = new ViewsMgr(this.UserSession);
status = viewsMgr.Read(viewId, out view);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
}
else
{
return(new questStatus(Severity.Error, String.Format("Invalid ParentEntityType: {0}", viewModel.ParentEntityType)));
}
// Sort by display order
columnList.Sort(delegate(Column i1, Column i2) { return(i1.DisplayOrder.CompareTo(i2.DisplayOrder)); });
// Transfer model.
columnListViewModel = new ColumnListViewModel(this.UserSession, viewModel);
columnListViewModel.DatabaseId = databaseId.Id;
columnListViewModel.Database = databaseBaseViewModel;
columnListViewModel.Id = viewModel.Id;
columnListViewModel.ParentEntityType = viewModel.ParentEntityType;
if (table != null)
{
TableViewModel tableViewModel = new TableViewModel();
BufferMgr.TransferBuffer(table, tableViewModel);
columnListViewModel.Table = tableViewModel;
}
if (view != null)
{
ViewViewModel viewViewModel = new ViewViewModel();
BufferMgr.TransferBuffer(view, viewViewModel);
columnListViewModel.View = viewViewModel;
}
foreach (Column column in columnList)
{
ColumnLineItemViewModel columnLineItemViewModel = new ColumnLineItemViewModel();
BufferMgr.TransferBuffer(column, columnLineItemViewModel);
columnListViewModel.Items.Add(columnLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
