public SearchResult SearchSettings(SearchParameter[] args)
{
// Create default value to reply.
var sr = new SearchResult();
sr.Presets = new Preset[0];
sr.PadSettings = new PadSetting[0];
sr.Summaries = new Summary[0];
sr.Settings = new UserSetting[0];
var hasArgs = args != null && args.Length > 0;
// Workaround fix.
args = args.Where(x => !x.IsEmpty()).ToArray();
// Create database.
var db = new x360ceModelContainer();
// Get user instances.
var p = SearchParameterCollection.GetSqlParameter(args);
// If user device instances supplied.
var hasInstances = args.Any(x => x.InstanceGuid != Guid.Empty);
// If user device products supplied.
var hasProducts = args.Any(x => x.ProductGuid != Guid.Empty);
List <PadSetting> padSettings = null;
// If get My Settings" then...
if (hasInstances)
{
var ds = EngineHelper.GetSettings(args);
sr.Settings = SqlHelper.ConvertToList <UserSetting>(ds.Tables[0]).ToArray();
AddToList(ds.Tables[1], ref padSettings);
}
// If get "Default Settings for My Controllers" then...
if (hasProducts)
{
var ds = EngineHelper.GetPresets(args);
sr.Summaries = SqlHelper.ConvertToList <Summary>(ds.Tables[0]).ToArray();
AddToList(ds.Tables[1], ref padSettings);
}
// If get "Default Settings for Most Popular Controllers" then...
if (!hasInstances && !hasProducts && hasArgs)
{
// Get presets.
var ds = EngineHelper.GetPresets(new SearchParameter[0]);
sr.Presets = SqlHelper.ConvertToList <Preset>(ds.Tables[0]).ToArray();
AddToList(ds.Tables[1], ref padSettings);
}
if (padSettings != null)
{
sr.PadSettings = padSettings.ToArray();
}
db.Dispose();
db = null;
return(sr);
}
public SearchResult SearchSettings(SearchParameter[] args)
{
// Create default value to reply.
var sr = new SearchResult();
sr.Presets = new Preset[0];
sr.PadSettings = new PadSetting[0];
sr.Summaries = new Summary[0];
sr.Settings = new Setting[0];
// Create database.
var db = new x360ceModelContainer();
// Get user instances.
var p = SearchParameterCollection.GetSqlParameter(args);
// Get most popular settings for user controllers.
var products = args.Where(x => x.ProductGuid != Guid.Empty).Select(x => x.ProductGuid).Distinct().ToArray();
// Get all device instances of the user.
var hasInstances = args.Any(x => x.InstanceGuid != Guid.Empty);
if (hasInstances)
{
var ds = EngineHelper.GetSettings(args);
sr.Settings = SqlHelper.ConvertToList <Setting>(ds.Tables[0]).ToArray();
sr.PadSettings = SqlHelper.ConvertToList <PadSetting>(ds.Tables[1]).ToArray();
}
else if (products.Length > 0)
{
// Get presets.
var ds = EngineHelper.GetPresets(args);
sr.Summaries = SqlHelper.ConvertToList <Summary>(ds.Tables[0]).ToArray();
sr.PadSettings = SqlHelper.ConvertToList <PadSetting>(ds.Tables[1]).ToArray();
}
else if (args != null && args.Length > 0)
{
// Get presets.
var ds = EngineHelper.GetPresets(new SearchParameter[0]);
sr.Presets = SqlHelper.ConvertToList <Preset>(ds.Tables[0]).ToArray();
sr.PadSettings = SqlHelper.ConvertToList <PadSetting>(ds.Tables[1]).ToArray();
}
db.Dispose();
db = null;
return(sr);
}
public SearchResult SearchSettings(SearchParameter[] args)
{
var sr = new SearchResult();
var db = new x360ceModelContainer();
// Get all device instances of the user.
var p = SearchParameterCollection.GetSqlParameter(args);
var hasInstances = args.Any(x => x.InstanceGuid != Guid.Empty);
var hasFiles = args.Any(x => !string.IsNullOrEmpty(x.FileName));
var hasProducts = args.Any(x => x.ProductGuid != Guid.Empty);
if (hasInstances)
{
// Get user instances.
sr.Settings = db.ExecuteStoreQuery <Setting>("exec x360ce_GetUserInstances @args", p).ToArray();
// Get list of products (unique identifiers).
var products = args.Where(x => x.ProductGuid != Guid.Empty).Select(x => x.ProductGuid).Distinct().ToArray();
var files = args.Where(x => !string.IsNullOrEmpty(x.FileName) || !string.IsNullOrEmpty(x.FileProductName)).ToList();
if (products.Length == 0)
{
sr.Summaries = new Summary[0];
}
else
{
files.Add(new SearchParameter()
{
FileName = "", FileProductName = ""
});
Expression body = null;
var param = Expression.Parameter(typeof(Summary), "x");
var pgParam = Expression.PropertyOrField(param, "ProductGuid");
var fnParam = Expression.PropertyOrField(param, "FileName");
var fpParam = Expression.PropertyOrField(param, "FileProductName");
for (int i = 0; i < products.Length; i++)
{
var productGuid = products[i];
for (int f = 0; f < files.Count; f++)
{
var fileName = files[f].FileName;
var fileProductName = files[f].FileProductName;
var exp1 = Expression.AndAlso(
Expression.Equal(pgParam, Expression.Constant(productGuid)),
Expression.Equal(fnParam, Expression.Constant(fileName))
);
exp1 = Expression.AndAlso(exp1, Expression.Equal(fpParam, Expression.Constant(fileProductName)));
body = body == null ? exp1 : Expression.OrElse(body, exp1).Reduce();
}
}
var lambda = Expression.Lambda <Func <Summary, bool> >(body, param);
// Select only TOP 10 configurations per controller and file.
var summaries = db.Summaries.Where(lambda).ToArray();
var topSummaries = new List <Summary>();
var productGuids = db.Summaries.Where(lambda).Select(x => x.ProductGuid).Distinct();
foreach (var pg in productGuids)
{
var controllerSummaries = summaries.Where(x => x.ProductGuid == pg);
var fileNames = controllerSummaries.Select(x => x.FileName).Distinct();
foreach (var fileName in fileNames)
{
// Top 10 configurations per file
topSummaries.AddRange(controllerSummaries.Where(x => x.FileName == fileName).OrderByDescending(x => x.Users).Take(10));
}
}
sr.Summaries = topSummaries.OrderBy(x => x.ProductName).ThenBy(x => x.FileName).ThenBy(x => x.FileProductName).ThenBy(x => x.Users).ToArray();
}
}
else if (args != null && args.Length > 0)
{
// Get presets.
var item = args.FirstOrDefault();
var ds = EngineHelper.GetPresets(new SearchParameter[0]);
sr.Presets = SqlHelper.ConvertToList <Preset>(ds.Tables[0]).ToArray();
sr.PadSettings = SqlHelper.ConvertToList <PadSetting>(ds.Tables[1]).ToArray();
sr.Summaries = new Summary[0];
sr.Settings = new Setting[0];
}
else
{
sr.Presets = new Preset[0];
sr.PadSettings = new PadSetting[0];
sr.Summaries = new Summary[0];
sr.Settings = new Setting[0];
}
db.Dispose();
db = null;
return(sr);
}
/// <summary>
/// Find Jobs currently On Hold matching criteria paassed in
/// </summary>
/// <param name="parameters"></param>
/// <returns></returns>
public static System.Data.DataSet GetJobsOnHoldByCriteria(SearchParameterCollection parameters)
{
DataSet dsResults = null;
DataAccess objADO = new DataAccess();
ArrayList colParameters = new ArrayList();
string strStoredProcedure = "selJobsOnHoldBySearchParameters";
objADO = Domain.GetADOInstance();
if (parameters != null)
{
foreach (SearchParameter parameter in parameters)
{
SqlParameter sqlParameter = new SqlParameter();
sqlParameter.ParameterName = "@" + parameter.Name;
if (parameter.Value is string[])
{
string arrayValues = string.Empty;
foreach (string item in (parameter.Value as string[]))
{
if (arrayValues.Equals(string.Empty))
{
arrayValues = item.Trim();
}
else
{
arrayValues += "," + item.Trim();
}
}
sqlParameter.Value = arrayValues;
}
else
{
sqlParameter.Value = parameter.Value;
}
colParameters.Add(sqlParameter);
}
}
dsResults = objADO.GetDataSet(strStoredProcedure, (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)), 600); // Slow query so set long commandTimeout
objADO = null;
dsResults.Tables[0].TableName = "JobsOnHold";
return dsResults;
}
