public void RegisterTableDescriptor()
{
var ds = new DatabaseService();
var mysql = new DatabaseDescriptor("UserManagement", new SqLiteDbDriver(
"Data Source=:memory:"));
var mongo = new DatabaseDescriptor("CommandQueue", new MongoDbDriver(
"mongodb://db1.example.net,db2.example.net:2500/?replicaSet=test"));
ds.RegisterDatabase(mysql);
ds.RegisterDatabase(mongo);
RegisterDataTypes(ds);
var users = CreateUsers(ds);
var roles = CreateRoles(ds);
SetupFkFromUsersToRoles(roles, users);
ds["UserManagement"].RegisterTable(users);
ds["UserManagement"].RegisterTable(roles);
ds["UserManagement"].Verify();
ds["UserManagement"].CreateDb();
var queue = CreateQueue(ds);
ds["CommandQueue"].RegisterTable(queue);
ds["CommandQueue"].Verify();
Assert.IsTrue(ds.Verify());
}
public ActionResult Search(int feedId, string query, int? tiled, int? faces)
{
bool tiledValue = tiled.HasValue && tiled.Value == 1;
bool facesValue = faces.HasValue && faces.Value == 1;
using (var db = new DatabaseService())
{
ViewBag.Feeds = db.GetAllFeeds().ToList();
ViewBag.tiled = tiledValue;
ViewBag.faces = facesValue;
var entries = db.GetAllEntries();
if (feedId > 0)
entries = entries.Where(e => e.feed_id == feedId);
if (tiledValue)
entries = entries.Where(e => e.imagewidth != null && e.imageheight != null);
if (facesValue)
entries = entries.Where(e => e.facial_amount > 0).OrderByDescending(e => e.facial_amount);
if (!string.IsNullOrEmpty(query))
{
int idQuery = 0;
Int32.TryParse(query, out idQuery);
entries = entries.Where(e => e.id == idQuery || e.object_name.Contains(query));
}
ViewBag.Amount = entries.Count();
if (tiledValue)
return View("tiled", entries.Take(500).ToList());
return View(entries.Take(100).ToList());
}
}
public HttpResponseMessage GetModulesMetadata([FromUri]KenticoInstanceConfig config, [FromUri] string category = null)
{
try
{
DatabaseService dbService = new DatabaseService(config.Server, config.Database, config.User, config.Password);
var kenticoVersion = GetKenticoVersion(dbService);
// Get all modules of given version
var modules = ModuleLoader.Modules
.Select(x => x.GetModuleMetadata())
.Where(x => x.SupportedVersions.Contains(kenticoVersion));
// Filter modules by category - return either specified category, or the rest
if (String.IsNullOrEmpty(category))
{
foreach (var separateCategory in SeparateCategories)
{
modules = modules.Where(x => x.Category == null || !x.Category.StartsWith(separateCategory, StringComparison.InvariantCultureIgnoreCase));
}
}
else
{
modules = modules.Where(x => x.Category != null && x.Category.StartsWith(category, StringComparison.InvariantCultureIgnoreCase));
}
return Request.CreateResponse(HttpStatusCode.OK, modules);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e.Message);
}
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
List<string> report = new List<string>();
bool isWebSite = ProjectCodeFilesHelper.Current.IsWebSiteProject(instanceInfo.Directory);
List<string> customerCodeFiles = ProjectCodeFilesHelper.Current.GetCustomerProjectCodeFiles(instanceInfo.Directory, instanceInfo.Version, isWebSite, true).ToList();
if (customerCodeFiles.Count == 0)
{
return new ModuleResults
{
ResultComment = "No customer files found.",
Status = Status.Good
};
}
report.AddRange(customerCodeFiles);
VulnerabilityAnalysisResults results = new VulnerabilityAnalysisResults();
AnalyseVulnerabilities(instanceInfo.Directory, customerCodeFiles, ref results);
string resultString = PrintResults(results);
if (!String.IsNullOrEmpty(resultString))
{
report.Add(String.Empty);
report.AddRange(resultString.Split(new[] { "<br />" }, StringSplitOptions.None));
}
return new ModuleResults
{
Result = report,
Trusted = true
};
}
public void DatabaseServiceStoreLoadUri()
{
var expectedPseudoObject = new PseudoClass()
{
Source1 = new Uri(defaultUriString),
Source2 = new Uri(defaultUriString2),
Source3 = new Uri(defaultUriString)
};
var dbService = new DatabaseService();
dbService.CreateTable<PseudoClass>();
// Insert into database
dbService.InsertIntoDatabase(expectedPseudoObject);
// Read from database
var actualPseudoObjectList = dbService.ReadListFromDatabase<PseudoClass>();
var actualPseudoObject = actualPseudoObjectList.FirstOrDefault();
// Check result
PseudoComparer comparer = new PseudoComparer();
Assert.AreEqual(1, actualPseudoObjectList.Count);
Assert.IsNotNull(actualPseudoObject);
Assert.IsNotNull(actualPseudoObject.Source1);
Assert.IsNotNull(actualPseudoObject.Source2);
Assert.IsNotNull(actualPseudoObject.Source3);
Assert.IsTrue(comparer.Equals(expectedPseudoObject, actualPseudoObject));
// Delete pseudo object from database
dbService.DeleteFromDatabase(actualPseudoObject);
// Read pseudo object from database. No objects should be found
actualPseudoObjectList = dbService.ReadListFromDatabase<PseudoClass>();
Assert.AreEqual(0, actualPseudoObjectList.Count);
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetTableFromFile("BigTablesModuleAzure.sql");
return new ModuleResults
{
Result = results,
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetPrintsFromFile("Setup/SiteDomainAliasesSetupModule.sql");
return new ModuleResults
{
Result = results
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetPrintsFromFile("CMSFileModule.sql");
return new ModuleResults
{
Result = results,
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetDataSetFromFile("Setup/LicenseSetupModule.sql");
return new ModuleResults
{
Result = results
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetTableFromFile("AttachmentsBySizeModule.sql");
return new ModuleResults
{
Result = results,
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo)
{
List<string> report = new List<string>();
mDatabaseService = instanceInfo.DBService;
mInstancePath = instanceInfo.Directory.FullName;
HashSet<string> transformationNames = new HashSet<string>();
mTransformationFullNames = new HashSet<string>();
DataTable webPartsInTransformationsTable = GetPageTemplateWebParts(LikePageTemplateDisplayName);
foreach (DataRow webPart in webPartsInTransformationsTable.Rows)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(webPart["PageTemplateWebParts"] as string);
IEnumerable<string> templateTransformationFullNames = GetTransformationNamesInPageTemplateWebParts(xmlDoc);
foreach (string templateTransformationFullName in templateTransformationFullNames)
{
mTransformationFullNames.Add(templateTransformationFullName);
string transformationName = templateTransformationFullName.Substring(templateTransformationFullName.LastIndexOf('.') + 1);
transformationNames.Add(transformationName);
}
}
DataTable transformationCodesTable = GetTransformationCodes(transformationNames);
foreach (DataRow transformation in transformationCodesTable.Rows)
{
int transformationId = (int) transformation["TransformationID"];
string transformationName = transformation["TransformationName"] as string;
string transformationCode = transformation["TransformationCode"] as string;
string xssResult = null;
AnalyseXss(transformationId, transformationName, transformationCode, ref xssResult);
if (!String.IsNullOrEmpty(xssResult))
{
report.Add(xssResult);
}
}
if (report.Count == 0)
{
return new ModuleResults
{
ResultComment = "No problems in transformations found.",
Status = Status.Good
};
}
return new ModuleResults
{
Result = report,
Trusted = true
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var sitemaps = dbService.ExecuteAndGetDataSetFromFile("SiteMapModule.sql");
// Postprocess sitemaps of all sites
foreach (DataTable sitemap in sitemaps.Tables)
{
bool outputCacheEnabled = dbService.GetSetting<bool>("CMSEnableOutputCache", sitemap.TableName);
// process every row of the sitemap
foreach (DataRow row in sitemap.Rows)
{
// Get effective value of columns that can be inherited
foreach (var column in ColumnsWithInheritance)
{
string origColName = column.Key + "Orig";
// Add new column to the table for storing original column value
if (!sitemap.Columns.Contains(origColName))
{
int colIndex = sitemap.Columns.IndexOf(column.Key);
sitemap.Columns.Add(origColName).SetOrdinal(colIndex);
}
// Copy original value to the new column
row[origColName] = row[column.Key];
if (column.Key == "OutputCache" && !outputCacheEnabled)
{
// Special case - output cache can be disabled in settings and then effective value is always 0
row[column.Key] = 0;
}
else
{
// Set effective value to the column
row[column.Key] = GetEffectiveColumnResult(sitemap, row, column.Key, column.Value);
}
}
}
// All post processing for the table is done - remove columns that might not be visible
sitemap.Columns.Cast<DataColumn>()
.Select(x => x.ColumnName)
.Except(VisibleColumns)
.ToList()
.ForEach(x => sitemap.Columns.Remove(x));
}
return new ModuleResults
{
Result = sitemaps,
};
}
public ActionResult Index()
{
var rnd = new Random();
using (var db = new DatabaseService())
{
var allentries = GetEntries(db, 1);
var dbNextEntry = allentries.ElementAt(rnd.Next(0, allentries.Count));
var dbNextFace = GetFace(dbNextEntry);
return View(dbNextEntry.id);
}
}
public ActionResult Index()
{
using (var db = new DatabaseService())
{
ViewBag.Feeds = db.GetAllFeeds().ToList();
ViewBag.tiled = false;
ViewBag.faces = false;
IEnumerable<KeyValuePair<Feed, int>> feeds = db.GetAllFeeds().Select(f => new KeyValuePair<Feed, int>(f, f.Entries.Count()));
return View(feeds.ToList());
}
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
List<string> responses = new List<string>();
var activityCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_Activity");
if (activityCount > 10000000)
{
responses.Add("There is over 10 000 000 (" + activityCount + " exactly) activities in the database. Consider using deleting old page visits or setting up the old contact's deletion");
}
var contactsCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_Contact");
if (contactsCount > 1000000)
{
responses.Add("There is over 1 000 000 (" + contactsCount + " exactly) contacts in the database. Consider using old contact's deletion");
var anonymousCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_Contact WHERE ContactLastName LIKE 'Anonymous%'");
var mergedCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_Contact WHERE ContactMergedWithContactID NOT NULL");
responses.Add("Out of these " + contactsCount + " contacts, " + anonymousCount + " are anonymous and " + mergedCount + " are merged");
}
var contactGroupCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_ContactGroup");
if (contactGroupCount > 50)
{
responses.Add("There is over 100 contact groups (" + contactGroupCount + " exactly). This might affect performance, are all of those really neccessary?");
}
var scoringRuleCount = dbService.ExecuteAndGetScalar<int>("SELECT COUNT(*) FROM OM_Rule");
if (scoringRuleCount > 50)
{
responses.Add("There is over 100 scoring rules (" + scoringRuleCount + " exactly). This might affect performance, are all of those really neccessary?");
}
if (responses.Any())
{
return new ModuleResults
{
Result = responses,
ResultComment = @"Check the counts in the result table. Exceeding the limits doesn't mean it must be wrong.
It depends on other things like traffic, hardware and so on.",
Status = Status.Error,
};
}
else
{
return new ModuleResults
{
ResultComment = "All of critical Online marketing are small enough to use Online marketing without affecting performance.",
Status = Status.Good
};
}
}
private static void RegisterDataTypes(DatabaseService ds)
{
ds.AddFieldDescriptor("username", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 5,
MaxLength = 30
});
ds.AddFieldDescriptor("nickname", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 5,
MaxLength = 30
});
ds.AddFieldDescriptor("password", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 8,
MaxLength = 30
});
ds.AddFieldDescriptor("role", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 8,
MaxLength = 30
});
ds.AddFieldDescriptor("timestamp", new FieldDescriptor
{
DataType = typeof(DateTime),
MinLength = 8,
MaxLength = 30
});
ds.AddFieldDescriptor("message", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 0,
MaxLength = 16000
});
ds.AddFieldDescriptor("destination", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 10,
MaxLength = 10
});
ds.AddFieldDescriptor("messagetype", new FieldDescriptor
{
DataType = typeof(string),
MinLength = 10,
MaxLength = 10
});
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var urls = dbService.ExecuteAndGetTableFromFile("ScreenshotterModule.sql");
// Start process in separate thread to make website responsive.
Thread t = new Thread(StartScreenshotting);
t.Start(new object[] { instanceInfo, urls });
return new ModuleResults
{
Result = urls
};
}
public HttpResponseMessage GetKenticoVersion([FromUri]KenticoInstanceConfig config)
{
try
{
DatabaseService dbService = new DatabaseService(config.Server, config.Database, config.User, config.Password);
var version = GetKenticoVersion(dbService);
return Request.CreateResponse(HttpStatusCode.OK, version);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.BadRequest, e.Message);
}
}
public void ShouldGetDatabases()
{
var repositoryMock = new Mock<IDatabaseRepository>();
repositoryMock.Setup(r => r.GetDatabases()).Returns(GetDatabasesList());
var service = new DatabaseService(repositoryMock.Object);
var result = service.GetDatabases();
Assert.AreEqual(4, result.Count, "There should be 4 databases.");
Assert.AreEqual("db0", result[0].Name, "The first db should be 'db0'");
Assert.AreEqual("db1", result[1].Name, "The second db should be 'db1'");
Assert.AreEqual("db2", result[2].Name, "The third db should be 'db2'");
Assert.AreEqual("db3", result[3].Name, "The fourth db should be 'db3'");
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
if (instanceInfo.Version == new Version("6.0"))
{
return new ModuleResults
{
Result = dbService.ExecuteAndGetPrintsFromFile("WebPartColumnsModule6.sql"),
};
}
return new ModuleResults
{
Result = dbService.ExecuteAndGetPrintsFromFile("WebPartColumnsModule.sql"),
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
DataTable expiredTokens = new DataTable("Expired account tokens");
expiredTokens.Columns.Add("SocialNetwork");
expiredTokens.Columns.Add("SiteName");
expiredTokens.Columns.Add("AccountName");
if (instanceInfo.Version != new Version("8.0"))
{
// LinkedIn integration is in 8.1 and newer
var linResults = dbService.ExecuteAndGetTableFromFile("ExpiredTokensModule-LinkedIn.sql");
foreach (DataRow token in linResults.Rows)
{
var row = expiredTokens.NewRow();
row["SocialNetwork"] = "LinkedIn";
row["SiteName"] = token["SiteName"];
row["AccountName"] = token["AccountName"];
expiredTokens.Rows.Add(row);
}
}
var fbResults = dbService.ExecuteAndGetTableFromFile("ExpiredTokensModule-Facebook.sql");
if (fbResults.Rows.Count > 0)
{
foreach (DataRow token in fbResults.Rows)
{
var row = expiredTokens.NewRow();
row["SocialNetwork"] = "Facebook";
row["SiteName"] = token["SiteName"];
row["AccountName"] = token["AccountName"];
expiredTokens.Rows.Add(row);
}
}
if (expiredTokens.Rows.Count > 0)
{
return new ModuleResults
{
Result = expiredTokens,
Status = Status.Error,
ResultComment = "Tokens have expired, posting stuff on some social markenting accounts doesn't work at all for accounts in results. Tell customer to reauthorize the pages.",
};
}
return new ModuleResults
{
Status = Status.Good,
ResultComment = "There are no expired tokens.",
};
}
/// <summary>
/// parses OAI XML and returns each item individually
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public IEnumerable<Entry> GetSubmittableEntries(DatabaseService db)
{
List<string> uniqueIds = db.GetUniqueIds(Feed);
foreach (var entry in GetEntries())
{
if (uniqueIds.Contains(entry.object_id))
{
log.Debug("Skip " + entry.object_id);
continue;
}
uniqueIds.Add(entry.object_id);
yield return entry;
}
}
public ModuleResults GetResults(InstanceInfo instanceInfo)
{
List<string> report = new List<string>();
mDatabaseService = instanceInfo.DBService;
DataTable webPartsInTransformationsTable = GetPageTemplateWebParts(LikePageTemplateDisplayName);
List<string> whereOrderResults = new List<string>();
List<string> otherResults = new List<string>();
foreach (DataRow webPart in webPartsInTransformationsTable.Rows)
{
string pageTemplateDisplayName = webPart["PageTemplateDisplayName"] as string;
XmlDocument webPartsXmlDoc = new XmlDocument();
webPartsXmlDoc.LoadXml(webPart["PageTemplateWebParts"] as string);
whereOrderResults.AddRange(AnalyseWhereAndOrderByConditionsInPageTemplateWebParts(webPartsXmlDoc, pageTemplateDisplayName));
otherResults.AddRange(AnalysePageTemplateWebParts(webPartsXmlDoc, pageTemplateDisplayName));
}
if (whereOrderResults.Count > 0)
{
report.Add("------------------------ Web parts - Where and Order condition results - Potential SQL injections -----------------");
report.AddRange(whereOrderResults);
}
if (otherResults.Count > 0)
{
report.Add("------------------------ Macros in DB - Potential XSS -----------------");
report.AddRange(otherResults);
}
if (report.Count == 0)
{
return new ModuleResults
{
ResultComment = "No problems in web parts found.",
Status = Status.Good
};
}
StringBuilder res = new StringBuilder();
report.ForEach(it => res.Append(it.Replace("\n", "<br />")));
return new ModuleResults
{
Result = report,
Trusted = true
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
DataTable sourceUIElements = dbService.ExecuteAndGetTableFromFile(String.Format("UIElementsDiffV{0}.sql", instanceInfo.Version.Major));
var kenticoUIElements = new DataTable();
kenticoUIElements.ReadXml(String.Format("./Data/DefaultUIElements/{0}{1}.xml", instanceInfo.Version.Major, instanceInfo.Version.Minor));
RemoveHashesFromStringRecords(sourceUIElements);
var result = Diff(kenticoUIElements, sourceUIElements);
return new ModuleResults
{
Result = result
};
}
public ActionResult Search()
{
DatabaseService ds = new DatabaseService();
IEnumerable<SelectListItem> vc = ds.getCategory().Select(r => new SelectListItem
{
Text = r.vehicle_category_description,
Value = r.vehicle_category_description
});
ViewData["ddlVehicleCategory"] = new SelectList(vc, "Text", "Value");
IEnumerable<SelectListItem> bc = ds.getBodyStyle().Select(r => new SelectListItem
{
Text = r.body_style,
Value = r.body_style
});
ViewData["ddlBodyStyle"] = new SelectList(bc, "Text", "Value");
IEnumerable<SelectListItem> pup = ds.getPickUp().Select(r => new SelectListItem
{
Text = r.current_city,
Value = r.current_city
});
ViewData["ddlPickUp"] = new SelectList(pup, "Text", "Value");
SelectList returnCity = new SelectList(new Dictionary<string, string>
{
{"Adelaide", "Adelaide"},
{"Brisbane", "Brisbane"},
{"Melbourne", "Melbourne"},
{"Sydney", "Sydney"},
{"Perth", "Perth" }
},
"Value", "Key");
ViewData["ddlReturnCity"] = returnCity;
SelectList sort = new SelectList(new Dictionary<string, string>
{
{"Daily hire rate", "Daily hire rate"},
{"Manufacturer Name", "Manufacturer Name"},
{"Manufactuere Date", "Manufactuere Date"},
},
"Value", "Key");
ViewData["sort"] = sort;
return View();
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
if (!TestUrl(instanceInfo.Url, "robots.txt"))
{
return new ModuleResults
{
Status = Status.Warning,
Result = "Missing! Please add the robots.txt into the web root",
};
}
return new ModuleResults
{
Status = Status.Good,
Result = "All good, robots.txt found.",
};
}
public HttpResponseMessage GetModuleResult(string moduleName, [FromUri]KenticoInstanceConfig config)
{
try
{
DatabaseService dbService = new DatabaseService(config.Server, config.Database, config.User, config.Password);
var version = GetKenticoVersion(dbService);
InstanceInfo instanceInfo = new InstanceInfo(version, new Uri(config.Url), new DirectoryInfo(config.Path));
var result = ModuleLoader.GetModule(moduleName).GetResults(instanceInfo, dbService);
return Request.CreateResponse(HttpStatusCode.OK, result);
}
catch (Exception e)
{
return Request.CreateResponse(HttpStatusCode.InternalServerError,
String.Format("Error in \"{0}\" module. Error message: {1}", moduleName, e.Message));
}
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var contactNumber = dbService.ExecuteAndGetScalar<int>(@"SELECT COUNT(*) FROM OM_Contact");
var results = dbService.ExecuteAndGetTableFromFile(@"OMInactiveContactsDeletion.sql");
return new ModuleResults
{
Result = results,
ResultComment = @"Inactive contact deletion setting should be always set up, so that the database doesn't get too big over time.
It is a business decision what contacts could be deleted. There are now " + (contactNumber < 10000 ? "only " : "") + contactNumber + " contacts in the database.",
Status = (contactNumber > 100000 && results.Rows.Count > 0)
? Status.Error
: (results.Rows.Count > 0)
? Status.Warning
: Status.Good
};
}
public ModuleResults GetResults(InstanceInfo instanceInfo, DatabaseService dbService)
{
var results = dbService.ExecuteAndGetPrintsFromFile("ScheduledTasksModule.sql");
var res = new ModuleResults
{
Result = results,
};
if (results.Any(x => x.Contains("DISABLE SCHEDULED TASK!")
|| x.Contains("DON NOT RUN THE task as EXTERNAL")
|| x.Contains("RUN THE task as EXTERNAL")))
{
res.Status = Status.Warning;
}
return res;
}
private List<Entry> GetEntries(DatabaseService db, int amountOfFaces)
{
List<int> preferredids = new List<int>() {
2468, 48083, 47949, 23679, 41523, 15819, 48189, 38872, 23689, 23685, 38462,
3088, 23683, 40049, 4799, 39316, 40495, 20599, 18432, 40497
};
List<int> excludeids = new List<int>() {
21080, 13728, 16923, 24345, 38270, 14921, 24373
};
var rnd = new Random();
var dbEntries = db.GetAllEntries().Where(e => e.facial_amount == amountOfFaces && (e.imageheight >= 350 || e.imagewidth >= 350));
dbEntries = dbEntries.Where(e => e.feed_id != 1); // not rijksmuseum, size klopt niet!
dbEntries = dbEntries.Where(e => preferredids.Contains(e.id));
dbEntries = dbEntries.Where(e => !excludeids.Contains(e.id));
return dbEntries.OrderBy(e => rnd.Next()).Take(100).ToList();
}
private void bindListBox()
{
var list = DatabaseService.getAllDatabaseEntriesSortedByName();
listBoxConnectionList.DataSource = list;
}
public virtual void NextQuestion()
{
DatabaseService service = new DatabaseService(_Bot, _db);
string text = "";
try {
// Call successor
switch (_Bot.LineEvent.type)
{
case "message":
if (_Bot.LineEvent.message.type.Equals("text"))
{
text = _Bot.LineEvent.message.text;
}
else
{
throw new Exception(new Error(ErrCode.S010).Message);
}
break;
case "postback":
text = _Bot.LineEvent.postback.Params != null ? ((_Bot.LineEvent.postback.Params.datetime != null) ? _Bot.LineEvent.postback.Params.datetime : ((_Bot.LineEvent.postback.Params.date != null) ? _Bot.LineEvent.postback.Params.date : (_Bot.LineEvent.postback.Params.time != null) ? _Bot.LineEvent.postback.Params.time : _Bot.LineEvent.postback.data)) : _Bot.LineEvent.postback.data;
break;
default:
throw new Exception(new Error(ErrCode.S002).Message);
}
if (service.LastQuestionNumber(_Bot.UserInfo.userId, this.GetType().FullName) == 0)
{
service.AddRecord(_Bot.UserInfo.userId, 1, this.GetType().FullName);
this.PushQuestion(1);
}
else
{
List <string> _BreakKeyWords = new List <string> {
"break", "exit", "放棄", "quit", "cancel", "stop", "abandon", "取消", "離開", "q", "leave", "bye"
};
if (_BreakKeyWords.Contains(text))
{
service.Remove(_Bot.UserInfo.userId, this.GetType().FullName);
return;
}
int lastQuestionNumber = service.LastQuestionNumber(_Bot.UserInfo.userId, this.GetType().FullName);
bool flag = this.IsAnswerPassed(lastQuestionNumber, text);
if (flag)
{
foreach (PropertyInfo pi in this.GetType().GetProperties())
{
Order order = pi.GetCustomAttribute <Order> ();
if (order != null && order.Id == lastQuestionNumber)
{
pi.SetValue(this, text);
}
}
service.Update(_Bot.UserInfo.userId, lastQuestionNumber, text, this.GetType().FullName);
if (this.MaxOrder == lastQuestionNumber)
{
List <TemplateActionBase> actions = new List <TemplateActionBase> ();
for (int i = 1; i <= this.MaxOrder; i++)
{
foreach (PropertyInfo pi in this.GetType().GetProperties())
{
Order order = pi.GetCustomAttribute <Order> ();
if (order != null && order.Id == i)
{
actions.Add(new MessageAction()
{
label = this.GetQuestionTextOnly(i) + " " + pi.GetValue(this), text = pi.GetValue(this).ToString()
});
}
}
}
Save();
Column column = new Column()
{
thumbnailImageUrl = new Uri("https://beauty-upgrade.tw/wp-content/uploads/2019/06/6-12.jpg"), title = "明細", actions = actions, text = "你的明細如下"
};
CarouselTemplate template = new CarouselTemplate()
{
columns = new List <Column> ()
{
column
}
};
service.Remove(_Bot.UserInfo.userId, this.GetType().FullName);
TemplateMessage a = new TemplateMessage(template);
_Bot.PushMessage(a);
}
else
{
service.AddRecord(_Bot.UserInfo.userId, lastQuestionNumber + 1, this.GetType().FullName);
this.PushQuestion(lastQuestionNumber + 1);
}
}
else
{
this.PushComplaint(lastQuestionNumber);
}
}
} catch (Exception ex) {
Console.WriteLine(ex.StackTrace);
_Bot.Notify(ex);
}
}
public bool run()
{
if (DialogResult.Yes == MessageBox.Show("저장하시겠습니까??", "MDB변경", MessageBoxButtons.YesNo))
{
MDB.CurrentMDB.SaveWork("MDB변환");
}
else
{
//MDB.CurrentMDB.ReleaseAll();
return(false);
}
Project curproject = Project.CurrentProject;
string projectname = curproject.Name;
orgmdbname = MDB.CurrentMDB.Name;
//curproject.Open("408506", "SYSTEM", "XXXXXX");
//MDB mdb = Project.OpenMDB(MDBSetup.CreateMDBSetup("/MIGRATION"));
treeProject.Nodes.Clear();
var projectlist = Aveva.Pdms.PdmsApplication.ProjectList();
foreach (string proj in projectlist.Keys.OfType <string>().OrderBy(x => x))
{
if ((String)projectlist[proj] == projectname)
{
project = proj;
}
treeProject.Nodes.Add(proj, proj + "(" + projectlist[proj].ToString() + ")");
treeProject.Nodes[proj].Text += string.Empty;
treeProject.Nodes[proj].ImageIndex = 0;
treeProject.Nodes[proj].ForeColor = Color.Green;
treeProject.Nodes[proj].NodeFont = new Font("굴림", 11.0f, FontStyle.Bold);
treeProject.Nodes[proj].Text += string.Empty;
string projid = (string)projectlist[proj];
//Project.CurrentProject.GetMdbData();
//연결하는 순간 Design Explorer의 Element가 초기화된다.
string[] mdblist = Aveva.Pdms.Database.DatabaseService.ProjectMdbData(projid);
string[] userlist = DatabaseService.ProjectUserData(projid);
foreach (string mdb in mdblist)
{
treeProject.Nodes[proj].Nodes.Add(mdb, mdb);
treeProject.Nodes[proj].Nodes[mdb].ToolTipText = mdb;
treeProject.Nodes[proj].Nodes[mdb].NodeFont = new Font("굴림", 9.0f);
treeProject.Nodes[proj].Nodes[mdb].ImageIndex = 1;
}
}
//if (orgmdbname != "Null Element")
//{
// curproject.Open(project, "SYSTEM", "XXXXXX");
// Project.OpenMDB(MDBSetup.CreateMDBSetup("/"+orgmdbname));
//}
return(true);
}
// Constructor
public RankingService(DiscordSocketClient discord, DatabaseService databaseService)
{
this.discord = discord;
database = databaseService.GetContext();
}
public MarketModule(DatabaseService _database)
{
database = _database;
}
public CourseSyncStep(OscaAppService oscaAppService, DatabaseService databaseService)
{
this.oscaAppService = oscaAppService;
this.databaseService = databaseService;
}
public PlayerManager(ILogger <PlayerManager> logger, ISessionManager sessionManager, DatabaseService databaseService)
{
_logger = logger;
_sessionManager = sessionManager;
_databaseService = databaseService;
_sessionManager.Removed += SessionDisconnected;
}
public static void Main(string[] args) {
Analyzer.AnalysisMethod analysisMethod = Analyzer.AnalysisMethod.SCMS;
//Analyzer.AnalysisMethod analysisMethod = Analyzer.AnalysisMethod.MandelEllis;
string scanPath = "";
double skipDurationAboveSeconds = -1; // less than zero disables this
string queryPath = "";
int queryId = -1;
int numToTake = 20;
double percentage = 0.4; // percentage below and above when querying
bool resetdb = false;
bool silent = false;
AudioFeature.DistanceType distanceType = AudioFeature.DistanceType.KullbackLeiblerDivergence;
// Command line parsing
Arguments CommandLine = new Arguments(args);
if(CommandLine["match"] != null) {
queryPath = CommandLine["match"];
}
if(CommandLine["matchid"] != null) {
string matchId = CommandLine["matchid"];
queryId = int.Parse(matchId);
}
if(CommandLine["scandir"] != null) {
scanPath = CommandLine["scandir"];
}
if(CommandLine["skipduration"] != null) {
double.TryParse(CommandLine["skipduration"], NumberStyles.Number,CultureInfo.InvariantCulture, out skipDurationAboveSeconds);
}
if(CommandLine["num"] != null) {
string num = CommandLine["num"];
numToTake = int.Parse(num);
}
if(CommandLine["percentage"] != null) {
double.TryParse(CommandLine["percentage"], NumberStyles.Number,CultureInfo.InvariantCulture, out percentage);
}
if(CommandLine["type"] != null) {
string type = CommandLine["type"];
if (type.Equals("kl", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.KullbackLeiblerDivergence;
} else if (type.StartsWith("dtw", StringComparison.InvariantCultureIgnoreCase)) {
if (type.Equals("dtwe", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.Dtw_Euclidean;
} else if (type.Equals("dtwe2", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.Dtw_SquaredEuclidean;
} else if (type.Equals("dtwman", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.Dtw_Manhattan;
} else if (type.Equals("dtwmax", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.Dtw_Maximum;
} else if (type.Equals("ucrdtw", StringComparison.InvariantCultureIgnoreCase)) {
distanceType = AudioFeature.DistanceType.UCR_Dtw;
} else {
distanceType = AudioFeature.DistanceType.Dtw_Euclidean;
}
}
}
if(CommandLine["dtw"] != null || CommandLine["dtwe"] != null) {
distanceType = AudioFeature.DistanceType.Dtw_Euclidean;
}
if(CommandLine["dtwe2"] != null) {
distanceType = AudioFeature.DistanceType.Dtw_SquaredEuclidean;
}
if(CommandLine["dtwman"] != null) {
distanceType = AudioFeature.DistanceType.Dtw_Manhattan;
}
if(CommandLine["dtwmax"] != null) {
distanceType = AudioFeature.DistanceType.Dtw_Maximum;
}
if(CommandLine["kl"] != null) {
distanceType = AudioFeature.DistanceType.KullbackLeiblerDivergence;
}
if(CommandLine["ucrdtw"] != null) {
distanceType = AudioFeature.DistanceType.UCR_Dtw;
}
if(CommandLine["resetdb"] != null) {
resetdb = true;
}
if(CommandLine["silent"] != null) {
silent = true;
}
if(CommandLine["permutations"] != null) {
Console.WriteLine("Generating hash permutations for used by the Soundfingerprinting methods.");
Console.WriteLine("Saving to file: {0}", "Soundfingerprinting\\perms-new.csv");
Console.WriteLine();
PermutationGeneratorService permutationGeneratorService = new PermutationGeneratorService();
Analyzer.GenerateAndSavePermutations(permutationGeneratorService, "Soundfingerprinting\\perms-new.csv");
return;
}
if(CommandLine["?"] != null) {
PrintUsage();
return;
}
if(CommandLine["help"] != null) {
PrintUsage();
return;
}
if(CommandLine["gui"] != null) {
StartGUI();
return;
}
if (queryPath == "" && queryId == -1 && scanPath == "") {
PrintUsage();
return;
}
// Get database
Db mandelEllisScmsDatabase = new Db(); // For MandelEllis and SCMS
// Instansiate soundfingerprinting Repository
FingerprintService fingerprintService = Analyzer.GetSoundfingerprintingService();
DatabaseService databaseService = DatabaseService.Instance; // For AudioFingerprinting
IPermutations permutations = new LocalPermutations("Soundfingerprinting\\perms.csv", ",");
//IPermutations permutations = new LocalPermutations("Soundfingerprinting\\perms-new.csv", ",");
Repository repository = new Repository(permutations, databaseService, fingerprintService);
if (scanPath != "") {
if (IOUtils.IsDirectory(scanPath)) {
if (resetdb) {
// For MandelEllis and Scms
mandelEllisScmsDatabase.RemoveTable();
mandelEllisScmsDatabase.AddTable();
// For AudioFingerprinting
databaseService.RemoveFingerprintTable();
databaseService.AddFingerprintTable();
databaseService.RemoveHashBinTable();
databaseService.AddHashBinTable();
databaseService.RemoveTrackTable();
databaseService.AddTrackTable();
}
Console.WriteLine("FindSimilar. Version {0}.", VERSION);
ScanDirectory(scanPath, mandelEllisScmsDatabase, repository, skipDurationAboveSeconds, silent);
} else {
Console.Out.WriteLine("No directory found {0}!", scanPath);
}
}
if (queryPath != "") {
FileInfo fi = new FileInfo(queryPath);
if (fi.Exists) {
FindSimilar(queryPath, mandelEllisScmsDatabase, analysisMethod, numToTake, percentage, distanceType);
} else {
Console.Out.WriteLine("No file found {0}!", queryPath);
}
}
if (queryId != -1) {
FindSimilar(new int[] { queryId }, mandelEllisScmsDatabase, analysisMethod, numToTake, percentage, distanceType);
}
System.Console.ReadLine();
}
public RecallQueriesModule(DatabaseService dbs)
{
this.dsv = dbs;
}
public CarPageVM(INavigationService navigationService, DatabaseService databaseService)
{
this.navigationService = navigationService;
this.databaseService = databaseService;
SetupDatas();
}
private void buttonDelete_Click(object sender, EventArgs e)
{
SelectedDatabaseEntry = (DatabaseEntry)listBoxConnectionList.SelectedItem;
DatabaseService.deleteDatabase(SelectedDatabaseEntry);
bindListBox();
}
public RoomTypeRepository(DatabaseService <RoomType> databaseService)
{
_databaseService = databaseService;
}
/// <summary>
/// Guestin cevaplarini tablolara insert eder.
/// </summary>
/// <param name="pollid">Anket Id</param>
/// <param name="ownerid">Anketi acan kullanicinin Id si</param>
/// <param name="ownertype">Anketi acan kullanici type i</param>
/// <param name="guestanswerdata">Kullanicinin cevaplari : [{QuestionId:'SoruId',AnswerId:'CevapId'}]</param>
/// <param name="staffid">eger private anket ise doldurulur o an anketi yapan staffid sidir</param>
/// <param name="authkey">eger private anket ise doldurulur o an anketi yapan authkey idir</param>
/// <param name="fielddata">PollMaster da belirtilen field larin doldurulmus verisini alir database e basar.[{"FieldCode":"ad-soyad","FieldValue":"test"}]</param>
/// <returns></returns>
public string SetGuestAnswers(dynamic jsonData)
{
string fieldData = jsonData.fielddata;
long pollId = jsonData.pollid;
long ownerId = jsonData.ownerid;
string ownerType = jsonData.ownertype;
int complateSecond = jsonData.complatesecond;
string ip = jsonData.ip;
List <GuestAnswer> answerList = jsonData.guestanswerdata.ToObject <List <GuestAnswer> >();
poll pollMaster =
EntityConnectionService.Poll.GetSingle(x => x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType));
if (pollMaster == null)
{
return(Helper.GetResult(false, "0x0012"));
}
if (pollMaster.active != "X")
{
return(Helper.GetResult(false, "0x0020"));
}
if (pollMaster.isipcheck == ("X"))
{
guest pollGuest = EntityConnectionService.Guest.GetSingle(x => x.ip == ip && x.ownerid == ownerId && x.ownertype == ownerType && x.pollid == pollId);
if (pollGuest != null)
{
return(Helper.GetResult(false, "0x0018"));
}
}
if (pollMaster.isprivate == ("X"))
{
long staffId = jsonData.staffid;
string authKey = jsonData.authkey;
staff loggedUser = DatabaseService.CheckStaffAuth(staffId, authKey, ownerId);
if (loggedUser == null)
{
return(Helper.GetResult(false, "0x0017"));
}
}
guest guest = new guest
{
fielddata = fieldData,
pollid = pollId,
ownerid = ownerId,
ownertype = ownerType,
ip = ip,
complatesecond = complateSecond
};
if (!EntityConnectionService.Guest.Add(guest))
{
return(Helper.GetResult(false, "0x0013"));
}
List <guestanswer> guestanswers = new List <guestanswer>();
for (int i = 0; i < answerList.Count; i++)
{
guestanswers.Add(new guestanswer()
{
pollid = pollId,
ownerid = ownerId,
ownertype = ownerType,
questionid = answerList[i].QuestionId,
answerid = answerList[i].AnswerId,
guestid = guest.guestid
});
}
if (!EntityConnectionService.GuestAnswer.Add(guestanswers.ToArray()))
{
return(Helper.GetResult(false, "0x0014"));
}
return(Helper.GetResult(true, true));
}
public WallpaperService(DatabaseService dbservice, IConfiguration configuration, Mapper mapper)
{
this.dbservice = dbservice;
this.configuration = configuration;
this.mapper = mapper;
}
public TimetableConfigService(DatabaseService databaseService)
{
_databaseService = databaseService;
}
public BuildingRepository(DatabaseService <Building> databaseService)
{
_databaseService = databaseService;
}
public GeneralModule(DatabaseService _database)
{
database = _database;
}
public DepartmentListViewModel(INavigation navigation, DatabaseService databaseService)
{
this.navigation = navigation;
this.databaseService = databaseService;
}
protected override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
SetTheme(Resource.Style.Theme_BoeingTheme);
Syncfusion.Licensing.SyncfusionLicenseProvider.RegisterLicense("MzQwMzU3QDMxMzgyZTMzMmUzMFRVeTIvbUJuNE1zR2d5bWR6eHdGdjRqR0F4RE11SHpYd1FhU24vUUhIak09");
//int uiOptions = (int)Window.DecorView.SystemUiVisibility;
//uiOptions = (int)SystemUiFlags.HideNavigation | (int)SystemUiFlags.Fullscreen;
//Window.DecorView.SystemUiVisibility = (StatusBarVisibility)uiOptions;
unityContainer = new UnityContainer();
unityContainer.RegisterInstance <ISettingsService>("SettingsService", SettingsService.Instance());
unityContainer.RegisterInstance <IFuelDistributionService>("FuelDistributionService", FuelDistributionService.Instance());
unityContainer.RegisterInstance <IFuelUpliftService>("FuelUpliftService", FuelUpliftService.Instance());
unityContainer.RegisterInstance <IFuelOrderService>("FuelOrderService", FuelOrderService.Instance());
unityContainer.RegisterInstance <IFuelCheckDataInputService>("FuelCheckDataInputService", FuelCheckDataInputService.Instance());
unityContainer.RegisterInstance <IFuelCheckListService>("FuelCheckListService", FuelCheckListService.Instance());
unityContainer.RegisterInstance <IEventService>("EventService", EventService.Instance());
unityContainer.RegisterInstance <IDatabaseService>("DatabaseService", DatabaseService.Instance(unityContainer.Resolve <ISettingsService>("SettingsService").GetLocalFilePath("fuelchecks.db")));
unityContainer.RegisterInstance <IBaggageDistributionService>("BaggageDistributionService", BaggageDistributionService.Instance());
unityContainer.RegisterInstance <IBrakeCoolingService>("BrakeCoolingService", BrakeCoolingService.Instance());
unityContainer.RegisterInstance <ICircuitBreakerService>("CircuitBreakerService", CircuitBreakerService.Instance());
eventService = unityContainer.Resolve <IEventService>("EventService");
UnityServiceLocator unityServiceLocator = new UnityServiceLocator(unityContainer);
ServiceLocator.SetLocatorProvider(() => unityServiceLocator);
SetContentView(Resource.Layout.main);
var toolbar = FindViewById <Toolbar>(Resource.Id.toolbar);
if (toolbar != null)
{
SetSupportActionBar(toolbar);
SupportActionBar.SetDisplayHomeAsUpEnabled(true);
SupportActionBar.SetHomeButtonEnabled(true);
}
drawerLayout = FindViewById <DrawerLayout>(Resource.Id.drawer_layout);
//Set hamburger items menu
SupportActionBar.SetHomeAsUpIndicator(Resource.Drawable.ic_menu);
//setup navigation view
navigationView = FindViewById <NavigationView>(Resource.Id.nav_view);
bottomNavigationView = FindViewById <NavigationView>(Resource.Id.nav_view_bottom);
//handle navigation
navigationView.NavigationItemSelected += (sender, e) =>
{
//(sender as NavigationView).PerformHapticFeedback(FeedbackConstants.VirtualKey, FeedbackFlags.IgnoreGlobalSetting);
if (previousItem != null)
{
previousItem.SetChecked(false);
}
navigationView.SetCheckedItem(e.MenuItem.ItemId);
previousItem = e.MenuItem;
switch (e.MenuItem.ItemId)
{
case Resource.Id.nav_fuel_order:
ListItemClicked(0);
break;
case Resource.Id.nav_fuel_check:
ListItemClicked(1);
break;
case Resource.Id.nav_baggage_distribution:
ListItemClicked(2);
break;
case Resource.Id.nav_brake_cooling:
ListItemClicked(3);
break;
case Resource.Id.circuit_breaker:
ListItemClicked(4);
break;
case Resource.Id.nav_checklists:
ListItemClicked(5);
break;
case Resource.Id.nav_manouvers:
ListItemClicked(6);
break;
case Resource.Id.nav_limitations:
ListItemClicked(7);
break;
}
e.MenuItem.SetChecked(true);
if (lastMenuItem != null && lastMenuItem.ItemId != e.MenuItem.ItemId)
{
lastMenuItem.SetChecked(false);
lastMenuItem = e.MenuItem;
}
drawerLayout.CloseDrawers();
};
bottomNavigationView.NavigationItemSelected += (sender, e) =>
{
if (e.MenuItem.ItemId == Resource.Id.nav_settings)
{
ListItemClicked(8);
e.MenuItem.SetChecked(true);
if (lastMenuItem != null && lastMenuItem.ItemId != e.MenuItem.ItemId)
{
lastMenuItem.SetChecked(false);
lastMenuItem = e.MenuItem;
}
}
drawerLayout.CloseDrawers();
};
//if first time you will want to go ahead and click first item.
if (savedInstanceState == null)
{
navigationView.SetCheckedItem(Resource.Id.nav_fuel_order);
lastMenuItem = navigationView.Menu.FindItem(Resource.Id.nav_fuel_order);
ListItemClicked(0);
}
}
public TabletPageViewModel(INavigationService navigationService, DatabaseService databaseService)
{
this.navigationService = navigationService;
this.databaseService = databaseService;
SetupTabletList();
}
public TodoRepositoryAbstract(DatabaseService database) : base(database)
{
}
public BloodBankRepository(DatabaseService databaseService) : base(databaseService)
{
}
public TodoModel(ILogger <TodoModel> logger, DatabaseService databaseService)
{
_logger = logger;
DatabaseService = databaseService;
}
public async Task <IActionResult> GetDocuments(string dbname, string index)
{
return(Ok(DocumentMapper.MapToDtos(await DatabaseService.GetAll(new IndexModel(dbname, index)))));
}
public PoloniexResetAllTradesHandler(PoloniexService poloniexService, DatabaseService databaseService, IMicroBus bus)
{
_poloniexService = poloniexService;
_databaseService = databaseService;
_bus = bus;
}
public MainController(DatabaseService databaseService, MqService mqService, AuthService authService)
{
this.databaseService = databaseService;
this.mqService = mqService;
this.authService = authService;
}
public LocationService()
{
_databaseService = DependencyInjection.Container.Resolve <DatabaseService>();
}
/// <summary>
/// Verilen bilgilere ait anketin verisini dondurur.
/// </summary>
/// <param name="pollid">Anket idsi</param>
/// <param name="ownerid">Anketi olusturan kullanici idsi</param>
/// <param name="ownertype">Anketi olusturan kullanici type i</param>
/// <returns></returns>
public string GetPollData(dynamic jsonData)
{
long pollId = jsonData.pollid;
long ownerId = jsonData.ownerid;
string ownerType = jsonData.ownertype;
poll pollMaster =
EntityConnectionService.Poll.GetSingle(x => x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType));
if (pollMaster == null)
{
return(Helper.GetResult(false, "0x0012"));
}
if (pollMaster.isipcheck == ("X"))
{
string ip = jsonData.ip;
guest pollGuest = EntityConnectionService.Guest.GetSingle(x => x.ip == ip && x.ownerid == ownerId && x.ownertype == ownerType && x.pollid == pollId);
if (pollGuest != null)
{
return(Helper.GetResult(false, "0x0018"));
}
}
if (pollMaster.isprivate == "X")
{
long staffId = jsonData.staffid;
string authKey = jsonData.authkey;
staff loggedUser = DatabaseService.CheckStaffAuth(staffId, authKey, ownerId);
if (loggedUser == null)
{
return(Helper.GetResult(false, "0x0017"));
}
}
pollMaster.viewcount++;
EntityConnectionService.Poll.Update(pollMaster);
List <question> questionList =
EntityConnectionService.Question.GetList(
x =>
x.pollid.Equals(pollId) && x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType)).ToList();
PollModel poll = new PollModel();
poll.PollId = pollMaster.pollid;
poll.IsPassword = pollMaster.ispassword;
poll.Password = pollMaster.password;
poll.PollTitle = pollMaster.polltitle;
poll.Questions = new List <Question>();
poll.Fields = pollMaster.fielddata;
poll.IsCookieCheck = pollMaster.iscookiecheck;
poll.Active = pollMaster.active;
for (int i = 0; i < questionList.Count; i++)
{
Question localQuestion = new Question
{
Content = questionList[i].content,
QuestionId = questionList[i].questionid,
QuestionType = questionList[i].questiontype,
Answers = new List <Answer>()
};
List <answer> answerList =
EntityConnectionService.Answer.GetList(
x =>
x.pollid.Equals(pollId) && x.questionid.Equals(localQuestion.QuestionId) &&
x.ownerid.Equals(ownerId) && x.ownertype.Equals(ownerType)).ToList();
for (int j = 0; j < answerList.Count; j++)
{
Answer localAnswer = new Answer
{
AnswerId = answerList[j].answerid,
Content = answerList[j].content,
AnswerType = answerList[j].answertype
};
localQuestion.Answers.Add(localAnswer);
}
poll.Questions.Add(localQuestion);
}
return(Helper.GetResult(true, poll));
}
private void btnSearch_Click(object sender, RoutedEventArgs e)
{
SearchModel searchModel = new SearchModel();
string searchType = cbSearchType.Text;
if (searchType == "Mã sách")
{
if (int.TryParse(txtSearch.Text, out int searchId))
{
searchModel.Id = searchId;
}
}
else if (searchType == "Tên sách")
{
searchModel.Name = txtSearch.Text;
}
else if (searchType == "Loại sách")
{
searchModel.BookType = txtSearch.Text;
}
else if (searchType == "Tác giả")
{
searchModel.Author = txtSearch.Text;
}
else if (searchType == "Giá")
{
var txt = txtSearch.Text.Replace(" ", "");
if (txt.Contains("-"))
{
var splited = txt.Split('-');
if (int.TryParse(splited[0], out int priceFrom) && int.TryParse(splited[1], out int priceTo))
{
if (priceTo >= priceFrom)
{
searchModel.PriceFrom = priceFrom;
searchModel.PriceTo = priceTo;
}
else
{
searchModel.PriceFrom = priceTo;
searchModel.PriceTo = priceFrom;
}
}
}
else
{
if (int.TryParse(txt, out int price))
{
searchModel.PriceFrom = price;
searchModel.PriceTo = price;
}
}
}
data = DatabaseService.SearchBooks(searchModel, loginModel != null ? loginModel.token : "");
dgBooks.ItemsSource = null;
dgBooks.ItemsSource = data;
dgBooks.SelectedIndex = -1;
if (loginModel != null && loginModel.role.Equals("Admin"))
{
dgBooksStatusCol.Visibility = Visibility.Visible;
}
else
{
dgBooksStatusCol.Visibility = Visibility.Hidden;
}
}
public GameMasterCommands(PlayerManager playerManager, DatabaseService databaseService)
{
_playerManager = playerManager;
_databaseService = databaseService;
}
