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; }