public questStatus Read(DatabaseId databaseId, out DatabaseEditorViewModel databaseEditorViewModel)
{
// Initialize
questStatus status = null;
databaseEditorViewModel = null;
// Read
Quest.Functional.MasterPricing.Database database = null;
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
databaseEditorViewModel = new DatabaseEditorViewModel(this.UserSession);
BufferMgr.TransferBuffer(database, databaseEditorViewModel);
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
public questStatus GetDatabase(DatabaseId databaseId, out DatabaseBaseViewModel databaseBaseViewModel)
{
// Initialize
questStatus status = null;
databaseBaseViewModel = null;
// Read the database
Quest.Functional.MasterPricing.Database database = null;
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
databaseBaseViewModel = new DatabaseBaseViewModel(this.UserSession);
BufferMgr.TransferBuffer(database, databaseBaseViewModel);
databaseBaseViewModel.LastRefresh = database.LastRefresh.HasValue ?
database.LastRefresh.Value.ToString("MM/dd/yyyy HH:mm:ss") : "";
return(new questStatus(Severity.Success));
}
/*==================================================================================================================================
* Public Methods
*=================================================================================================================================*/
#region Options
//----------------------------------------------------------------------------------------------------------------------------------
// Options
//----------------------------------------------------------------------------------------------------------------------------------
public questStatus GetDatabaseOptions(out List <OptionValuePair> optionsList, string Value = null, string Name = null)
{
// Initialize
questStatus status = null;
optionsList = null;
// Get database
QueryOptions queryOptions = new QueryOptions(100, 1);
List <Quest.Functional.MasterPricing.Database> databaseTypeList = null;
QueryResponse queryResponse = null;
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.List(queryOptions, out databaseTypeList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort
databaseTypeList.Sort(delegate(Quest.Functional.MasterPricing.Database i1, Quest.Functional.MasterPricing.Database i2) { return(i1.Name.CompareTo(i2.Name)); });
// Build options
// Set selected if specified.
optionsList = new List <OptionValuePair>();
foreach (Quest.Functional.MasterPricing.Database Database in databaseTypeList)
{
OptionValuePair optionValuePair = new OptionValuePair();
optionValuePair.Id = Database.Id.ToString();
optionValuePair.Label = Database.Name;
if (Value != null && Value == Database.Id.ToString())
{
optionValuePair.bSelected = true;
}
else if (Name != null && Name == Database.Name)
{
optionValuePair.bSelected = true;
}
optionsList.Add(optionValuePair);
}
// Insert default option
status = AddDefaultOptions(optionsList, "-1", "Select one ...");
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus List(QueryOptions queryOptions, out DatabasesListViewModel databasesListViewModel)
{
// Initialize
questStatus status = null;
databasesListViewModel = null;
// List
QueryResponse queryResponse = null;
List <Quest.Functional.MasterPricing.Database> databaseList = null;
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.List(queryOptions, out databaseList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Sort
databaseList.Sort(delegate(Quest.Functional.MasterPricing.Database i1, Quest.Functional.MasterPricing.Database i2) { return(i1.Name.CompareTo(i2.Name)); });
// Transfer model.
// TODO: USE BaseListModeler to xfer queryOptions to QueryOptionsViewModel.
databasesListViewModel = new DatabasesListViewModel(this.UserSession);
QueryResponseViewModel queryResponseViewModel = null;
status = TransferQueryResponse(queryResponse, out queryResponseViewModel);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
databasesListViewModel.QueryResponse = queryResponseViewModel;
foreach (Quest.Functional.MasterPricing.Database database in databaseList)
{
DatabaseLineItemViewModel databaseLineItemViewModel = new DatabaseLineItemViewModel();
BufferMgr.TransferBuffer(database, databaseLineItemViewModel);
databaseLineItemViewModel.LastRefresh = database.LastRefresh.HasValue ? database.LastRefresh.Value.ToString("MM/dd/yyyy HH:mm:ss") : "";
databasesListViewModel.Items.Add(databaseLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public questStatus Page(out ViewsListViewModel viewsListViewModel)
{
// Initialize
questStatus status = null;
viewsListViewModel = null;
// Set up query options.
// TEMPORARY: OPTIMIZE THIS
List <SearchField> searchFieldList = new List <SearchField>();
SearchOptions searchOptions = new SearchOptions();
searchOptions.SearchFieldList = searchFieldList;
QueryOptions queryOptions = new QueryOptions(100, 1);
queryOptions.SearchOptions = searchOptions;
QueryResponse queryResponse = null;
// List
List <Quest.Functional.MasterPricing.Database> databaseList = null;
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.List(queryOptions, out databaseList, out queryResponse);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Transfer model.
viewsListViewModel = new ViewsListViewModel(this.UserSession);
foreach (Quest.Functional.MasterPricing.Database database in databaseList)
{
ViewLineItemViewModel viewLineItemViewModel = new ViewLineItemViewModel();
BufferMgr.TransferBuffer(database, viewLineItemViewModel);
viewsListViewModel.Items.Add(viewLineItemViewModel);
}
return(new questStatus(Severity.Success));
}
public questStatus GetFilterDatabase(Quest.Functional.MasterPricing.FilterId filterId, out Quest.Functional.MasterPricing.Database database)
{
// Initialize
questStatus status = null;
database = null;
// Get filter
Filter filter = null;
FiltersMgr filtersMgr = new FiltersMgr(this.UserSession);
status = filtersMgr.Read(filterId, out filter);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get tableset
Tableset tableset = null;
TablesetId tablesetId = new TablesetId(filter.TablesetId);
TablesetsMgr tablesetsMgr = new TablesetsMgr(this.UserSession);
status = tablesetsMgr.Read(tablesetId, out tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get database
DatabaseId databaseId = new DatabaseId(tableset.DatabaseId);
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
public questStatus GetDatabaseStoredProcedures(TablesetId tablesetId, out List <StoredProcedure> storedProcedureList)
{
// Initialize
questStatus status = null;
storedProcedureList = null;
// Get tableset
Tableset tableset = null;
TablesetsMgr tablesetsMgr = new TablesetsMgr(this.UserSession);
status = tablesetsMgr.Read(tablesetId, out tableset);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
// Get database
Quest.Functional.MasterPricing.Database database = null;
DatabaseId databaseId = new DatabaseId(tableset.DatabaseId);
DatabasesMgr databasesMgr = new DatabasesMgr(this.UserSession);
status = databasesMgr.Read(databaseId, out database);
if (!questStatusDef.IsSuccessOrWarning(status))
{
return(status);
}
// Get database stored procedures
DbFilterProceduresMgr dbFilterProceduresMgr = new DbFilterProceduresMgr(this.UserSession);
status = GetDatabaseStoredProcedures(database, out storedProcedureList);
if (!questStatusDef.IsSuccess(status))
{
return(status);
}
return(new questStatus(Severity.Success));
}
