private void Purge(DirectoryInfo di) { try { Directory.Delete(di.FullName, true); //foreach (FileInfo file in di.EnumerateFiles()) //{ // //if (WaitForFile(file.FullName)) // file.Delete(); //} //foreach (DirectoryInfo dir in di.EnumerateDirectories()) //{ // dir.Delete(true); //} ResultsTextBox.AppendText("Папка \"" + di.Name + "\" из каталога " + di.Parent.FullName + " успешно удалена!\n"); PurgeButton.Visibility = Visibility.Hidden; } catch (Exception ex) { if (di.Exists) { ResultsTextBox.AppendText("Папка \"" + di.Name + "\" используется. Пожалуйста подождите ещё.\n"); } else { ResultsTextBox.AppendText("Папка \"" + di.Name + "\" не найдена в каталоге " + di.Parent.FullName + "\n"); } } finally { } }
/// <summary> /// Event invoked for each process in <see cref="PowerShellOperations.Example1"/> and /// <see cref="PowerShellOperations.Example2Task"/> /// /// The method <see cref="PowerShellOperations.Example2Task"/> requires <see cref="ControlExtensions.InvokeIfRequired"/> /// to prevent cross threading violation while <see cref="PowerShellOperations.Example1"/> does not cause a violation /// /// </summary> /// <param name="sender"></param> private void PowerShellOperationsOnProcessItemHandler(ProcessItem sender) { ResultsTextBox.InvokeIfRequired(tb => { tb.AppendTextWithNewLines($"{sender}".RemoveExtraSpaces().Beautify()); }); }
/// <summary> /// Загрузка /// </summary> /// private async void Start_Click(object sender, RoutedEventArgs e) { StartButton.IsEnabled = false; try { cts = new CancellationTokenSource(); //ResultsTextBox.Clear(); StopButton.Visibility = Visibility.Visible; await AccessTheWebAsync(UrlTextBox.Text.ToString(), cts.Token); ResultsTextBox.AppendText("Загрузка завершена.\n"); if (new DirectoryInfo(BadDirectory).Exists) { PurgeButton.Visibility = Visibility.Visible; } } catch (OperationCanceledException) { ResultsTextBox.AppendText("Загрузка отменена.\n"); } catch (Exception) { ResultsTextBox.AppendText("Загрузка не удалась.\n"); } finally { StartButton.IsEnabled = true; StopButton.Visibility = Visibility.Hidden; } }
private void RefreshResultsForm() { //MaintextBox.AppendText(grade.ToString()); // MaintextBox.AppendText("\r\n"); ResultsTextBox.Clear(); ResultsTextBox.AppendText($"TotalScore: {quiz.CorrectAnswers} / {quiz.NumberOfQuestions}"); }
private void EncryptFileButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(KeyBoxFile.Text) || string.IsNullOrWhiteSpace(FilePathBox.Text)) { MessageBox.Show("You must enter a key!"); } else { ResultsTextBox.AppendText("Encrypting...\n"); var crypto = new Crypto(KeyBoxFile.Text); string fileContents; using (StreamReader sr = new StreamReader(FilePathBox.Text)) { fileContents = sr.ReadToEnd(); } using ( StreamWriter sw = new StreamWriter(Path.Combine(Path.GetDirectoryName(FilePathBox.Text), Path.GetFileNameWithoutExtension(FilePathBox.Text) + "Encrypted" + ".txt"))) { sw.Write(crypto.Encrypt(fileContents)); sw.Write(Hasher.GenerateBase64Hash(MD5.Create(), fileContents)); } ResultsTextBox.AppendText("Encryption complete.\n"); } }
private void button3_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); //ResultsTextBox.Text = CommandOne(procedureString, connectOne); using (SqlConnection connection = new SqlConnection(connectOne)) { try { SqlCommand command = new SqlCommand(queryString, connection); command.CommandType = CommandType.StoredProcedure; command.CommandText = "[Ten Most Expensive Products]"; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); StringBuilder results = new StringBuilder(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results.Append(reader[i].ToString() + "\t"); } results.Append(Environment.NewLine); } ResultsTextBox.Text = results.ToString(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
/* * Celem ćwiczenia jest uzupełnienie poniższych metod. * Każda metoda powinna zawierać kod C#, który z pomocą LINQ'a będzie realizować * zapytania opisane za pomocą SQL'a. * Rezultat zapytania powinien zostać wyświetlony za pomocą kontrolki DataGrid. * W tym celu końcowy wynik należy rzutować do Listy (metoda ToList()). * Jeśli dane zapytanie zwraca pojedynczy wynik możemy je wyświetlić w kontrolce * TextBox WynikTextBox. */ /// <summary> /// SELECT * FROM Emps WHERE Job = "Backend programmer"; /// </summary> public void Example1Button_Click(object sender, EventArgs e) { //var res = new List<Emp>(); //foreach(var emp in Emps) //{ // if (emp.Job == "Backend programmer") res.Add(emp); //} //1. Query syntax (SQL) // var res = from emp in Emps // where emp.Job == "Backend programmer" // select new // { // Nazwisko = emp.Ename, // Zawod = emp.Job // }; //2. Lambda and Extension methods var res = Emps.Where(emp => emp.Job.Equals("Backend programmer")).Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void button5_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); thisCity = CityTextBox.Text; string paramRequest = "SELECT CustomerID, CompanyName, City FROM Customers WHERE City = @City"; ResultsTextBox.Text = CommandTwo(paramRequest, connectOne, thisCity); }
private void SendAllButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); var responses = ComObject.GetResponsesAtBaudRate(PortsComboBox.SelectedItem.ToString(), GetAllSelectedBauds()); string result = string.Join("\r\n", responses.Select(x => $"Baud {x.Key},{x.Value ?? "No response"}")); ResultsTextBox.Text = result; }
/// <summary> /// SELECT MAX(Salary) FROM Emps; /// </summary> public void Example3Button_Click(object sender, EventArgs e) { var res = Emps.Max(emp => emp.Salary); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
//Znajdź pracownika z najwyższą pensją wykorzystując metodę Aggregate() public void Example11Button_Click(object sender, EventArgs e) { var res = Emps.Aggregate((empA, empB) => empA.Salary > empB.Salary ? empA : empB); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
/// <summary> /// Zwróć wartość "true" jeśli choć jeden /// z elementów kolekcji pracuje jako "Backend programmer". /// </summary> public void Example8Button_Click(object sender, EventArgs e) { var res = Emps.Any(emp => "Backend programmer".Equals(emp.Job)); ResultsTextBox.Clear(); ResultsTextBox.AppendText(res.ToString()); ResultsList.DataSource = null; }
/// <summary> /// SELECT TOP 1 * FROM Emp WHERE Job="Frontend programmer" /// ORDER BY HireDate DESC; /// </summary> public void Example9Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => "Frontend programmer".Equals(emp.Job)) .Take(1) .ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
//Z pomocą języka LINQ i metody SelectMany wykonaj złączenie //typu CROSS JOIN public void Example12Button_Click(object sender, EventArgs e) { var res = Emps.SelectMany(emp => Depts.Select(dept => new { emp.Ename, dept.Dname })).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT ename AS Nazwisko, job AS Praca FROM Emps; /// </summary> public void Example5Button_Click(object sender, EventArgs e) { var res = Emps.Select(emp => new { Nazwisko = emp.Ename, Praca = emp.Job }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT Job AS Praca, COUNT(1) LiczbaPracownikow FROM Emps GROUP BY Job; /// </summary> public void Example7Button_Click(object sender, EventArgs e) { var res = Emps.GroupBy(emp => emp.Job) .Select(emps => new { Praca = emps.Key, Count = emps.Count() }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT * FROM Emps WHERE Salary=(SELECT MAX(Salary) FROM Emps); /// </summary> public void Example4Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => emp.Salary == Emps.Max(empSal => empSal.Salary)) .Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT Emps.Ename, Emps.Job, Depts.Dname FROM Emps /// INNER JOIN Depts ON Emps.Deptno=Depts.Deptno /// Rezultat: Złączenie kolekcji Emps i Depts. /// </summary> public void Example6Button_Click(object sender, EventArgs e) { var res = Emps.Join(Depts, emp => emp.Deptno, dept => dept.Deptno, (emp, dept) => new { emp.Ename, emp.Job, dept.Dname }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
/// <summary> /// SELECT * FROM Emps Job = "Frontend programmer" AND Salary>1000 ORDER BY Ename DESC; /// </summary> public void Example2Button_Click(object sender, EventArgs e) { var res = Emps.Where(emp => emp.Job.Equals("Frontend programmer") && emp.Salary >= 1000) .Select(emp => new { emp.Ename, emp.Salary }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void FeaturesSelectionComputeButton_Click(object sender, RoutedEventArgs e) { if (FeatureClasses == null || !FeatureClasses.Any()) { ResultsTextBox.AppendText($"{Environment.NewLine}There is no class loaded, use Open file button to load some data."); return; } var validFeatureCountInputted = int.TryParse(FeaturesSelectionFeaturesCountTextBox.Text, out int featureCount); if (validFeatureCountInputted) { var computationResultBuilder = new StringBuilder($"{Environment.NewLine}Best {featureCount} features: "); try { var watch = Stopwatch.StartNew(); IEnumerable <int> discriminationResults; switch (SelectedAlgorithm) { case FeatureSelectionAlgorithm.SFS: discriminationResults = new FisherLinearDiscriminator().DiscriminateWithSequentialForwardSelection(FeatureClasses, int.Parse(FeaturesSelectionFeaturesCountTextBox.Text)); break; case FeatureSelectionAlgorithm.Default: default: discriminationResults = new FisherLinearDiscriminator().Discriminate(FeatureClasses, int.Parse(FeaturesSelectionFeaturesCountTextBox.Text)); break; } watch.Stop(); foreach (var featurePosition in discriminationResults) { computationResultBuilder.Append($"{featurePosition}, "); } computationResultBuilder.Remove(computationResultBuilder.Length - 2, 2); computationResultBuilder.AppendLine($"\t{SelectedAlgorithm.ToString()}\tElapsed time: {watch.Elapsed.Minutes} min {watch.Elapsed.Seconds} s"); ResultsTextBox.AppendText(computationResultBuilder.ToString()); } catch (Exception ex) { ResultsTextBox.AppendText($"{Environment.NewLine}Error occured while computing: {ex.Message}."); } } else { ResultsTextBox.AppendText($"{Environment.NewLine}Invalid feature count \"{FeaturesSelectionFeaturesCountTextBox.Text}\" inputted."); } }
private void FindButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); string input = AddressTextBox.Text; if (LookupRadioButton.Checked) { var result = AddressFinder.Find(input); ResultsTextBox.Text = result.ToString(); } else { var result = AddressFinder.Parse(input); ResultsTextBox.Text = result.ToString(); } }
/// <summary> /// SELECT Ename, Job, Hiredate FROM Emps /// UNION /// SELECT "Brak wartości", null, null; /// </summary> public void Example10Button_Click(object sender, EventArgs e) { var res = Emps.Union( new List <Emp> { new Emp { Ename = "Brak wartości", Job = null, HireDate = null } }) .Select(emp => new { emp.Ename, emp.Job, emp.HireDate }).ToList(); ResultsTextBox.Clear(); ResultsList.DataSource = res; }
private void DecryptFileButton_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(KeyBoxFile.Text) || string.IsNullOrWhiteSpace(FilePathBox.Text)) { MessageBox.Show("You must enter a key!"); } else { ResultsTextBox.AppendText("Decrypting...\n"); var crypto = new Crypto(KeyBoxFile.Text); string fileContents; string extractedHash; string decryptedHash; using (StreamReader sr = new StreamReader(FilePathBox.Text)) { fileContents = sr.ReadToEnd(); } extractedHash = Hasher.ExtractHash(fileContents); ExtractedHashBox.Text = extractedHash; fileContents = fileContents.Substring(0, fileContents.Length - 24); var utf8WithBom = new UTF8Encoding(true); using ( StreamWriter sw = new StreamWriter(Path.Combine(Path.GetDirectoryName(FilePathBox.Text), Path.GetFileNameWithoutExtension(FilePathBox.Text) + "Decrypted" + ".txt"), false, utf8WithBom)) { sw.Write(crypto.Decrypt(fileContents)); } using (StreamReader sr = new StreamReader(Path.Combine(Path.GetDirectoryName(FilePathBox.Text), Path.GetFileNameWithoutExtension(FilePathBox.Text) + "Decrypted" + ".txt"))) { fileContents = sr.ReadToEnd(); } decryptedHash = Hasher.GenerateBase64Hash(MD5.Create(), fileContents); ResultsTextBox.AppendText("Decryption complete.\n"); ResultsTextBox.AppendText(string.Format("Decrypted Hash: {0}\n", decryptedHash)); ResultsTextBox.AppendText(string.Format("Extracted Hash: {0}\n", extractedHash)); if (Hasher.VerifyHash(decryptedHash, extractedHash)) { ResultsTextBox.AppendText("Hashes match! Successful decryption.\n"); } else { ResultsTextBox.AppendText("Hashes do not match! Unsuccessful decryption.\n"); } } }
private void LoadData(WorkUnitHistoryModel model) { DataViewComboBox.DataSource = model.QueryBindingSource; DataViewEditButton.BindEnabled(model, nameof(WorkUnitHistoryModel.EditAndDeleteButtonsEnabled)); DataViewDeleteButton.BindEnabled(model, nameof(WorkUnitHistoryModel.EditAndDeleteButtonsEnabled)); rdoPanelProduction.DataSource = model; rdoPanelProduction.ValueMember = "BonusCalculation"; ResultsTextBox.BindText(model, nameof(WorkUnitHistoryModel.TotalEntries)); PageNumberTextBox.BindText(model, nameof(WorkUnitHistoryModel.CurrentPage)); ResultNumberUpDownControl.DataBindings.Add("Value", model, nameof(WorkUnitHistoryModel.ShowEntriesValue), false, DataSourceUpdateMode.OnPropertyChanged); dataGridView1.DataSource = model.HistoryBindingSource; Location = model.FormLocation; LocationChanged += (s, e) => model.FormLocation = WindowState == FormWindowState.Normal ? Location : RestoreBounds.Location; Size = model.FormSize; SizeChanged += (s, e) => model.FormSize = WindowState == FormWindowState.Normal ? Size : RestoreBounds.Size; RestoreColumnSettings(model.FormColumns); }
private void TestRegexButton_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); try { RegexOptions selectedRegexOptions = this.GetSelectedRegexOptions(); Regex regex = new Regex(this.RegexTextBox.Text, selectedRegexOptions); var mch = regex.Match(this.InputTextBox.Text); if (mch.Success) { //this.ResultsTextBox.Text = "MATCH FOUND"; //this.ResultsTextBox.ForeColor = Color.Black; ShowMatch(true); var sb = new StringBuilder(); if (mch.Groups.Count > 0) { sb.AppendLine($"Groups[{mch.Groups.Count}]:"); sb.AppendLine("-------------------------------"); } foreach (var mgo in mch.Groups) { Group mg = mgo as Group; var idx = (mg.Success, mg.Index, End : (mg.Index + mg.Length)); var idxTxt = idx.Success ? $"{idx.Index:0000} - {idx.End:0000}" : " fail! "; sb.AppendLine($"[{idxTxt}]<{mg.Name}>:{mg.Value}"); } ResultsTextBox.Text = sb.ToString(); } else { //this.ResultsTextBox.Text = "NO MATCH FOUND"; //this.ResultsTextBox.ForeColor = Color.Red; ShowMatch(false); } } catch (ArgumentException exception) { this.ResultsTextBox.ForeColor = Color.Red; this.ResultsTextBox.Text = "There was an error in your regular expression:" + Environment.NewLine + exception.Message; } }
private void Window_Loaded(object sender, RoutedEventArgs e) { ResultsTextBox.AppendText( "\"URL\" - страница манги на comic-gardo. \n" + "\"Bad\" - папка для перепутанных изображений с сайта. \n" + "\"Good\" - папка для обработаных изображений. \n" + "\"Загрузить\" - загрузить изображения с сайта в папку Bad. \n" + "\"Обработать\" - восстановить порядок в изображениях и положить в папку Good.\n" + "\"Purge\" - удалить папку \"Bad\". Может потребовать подождать некоторое время.\n" + "===============================================================\n" ); SrcTextBox.Text = System.AppDomain.CurrentDomain.BaseDirectory + "Bad\\"; BadDirectory = SrcTextBox.Text; OutTextBox.Text = System.AppDomain.CurrentDomain.BaseDirectory + "Good\\"; //GoodDirectory = OutTextBox.Text; if (new DirectoryInfo(BadDirectory).Exists) { PurgeButton.Visibility = Visibility.Visible; } }
private void OpenFileButton_Click(object sender, RoutedEventArgs e) { var openFileDialog = new OpenFileDialog { Filter = "txt files (*.txt)|*.txt|All files (*.*)|*.*", FilterIndex = 0 }; if (openFileDialog.ShowDialog() == true) { string[] fileContent = null; try { fileContent = File.ReadAllLines(openFileDialog.FileName); if (fileContent != null && fileContent.Any()) { FeatureClasses = GetFeatureClasses(fileContent); foreach (var featureClass in FeatureClasses) { if (featureClass.Features.Count < 10 && featureClass.Samples.Count < 10) { ResultsTextBox.AppendText($"{Environment.NewLine}{featureClass.ToString()}"); } else { ResultsTextBox.AppendText($"{Environment.NewLine}{featureClass.Name} class loaded"); } } } } catch (Exception) { ResultsTextBox.AppendText($"{Environment.NewLine} File {openFileDialog.FileName} is broken or of not supported format."); } } }
private void button6_Click(object sender, EventArgs e) { ResultsTextBox.Clear(); using (SqlConnection connection = new SqlConnection(connectOne)) { try { SqlCommand command = new SqlCommand(queryString, connection); command.CommandType = CommandType.StoredProcedure; command.CommandText = "SalesByCategory"; command.Parameters.Add("@CategoryName", SqlDbType.VarChar, 80).Value = CategoryNameTextBox.Text; command.Parameters.Add("@OrdYear", SqlDbType.Int).Value = OrdYearTextBox.Text; command.Connection.Open(); SqlDataReader reader = command.ExecuteReader(); StringBuilder results = new StringBuilder(); while (reader.Read()) { for (int i = 0; i < reader.FieldCount; i++) { results.Append(reader[i].ToString() + "\t"); } results.Append(Environment.NewLine); } ResultsTextBox.Text = results.ToString(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { connection.Close(); } } }
public void WriteLine(string str) { ResultsTextBox.AppendLine(str); }
private async void solveBtn_Click(object sender, EventArgs e) { solveBtn.Enabled = false; solveBtn.Text = "Solving..."; TOTAL_SOLUTIONS = 0; ResultsTextBox.Clear(); #region TEST COLLECTION: //short[,] A = new short[,] //{ // { 1, 1, 1 }, // { 1, 0, 1 } //};//4 Distinct //short[,] B = new short[,] //{ // { 0, 1 }, // { 0, 1 }, // { 1, 1 }, // { 0, 1 } //};//8 Distinct //short[,] C = new short[,] //{ // { 1 }, // { 1 }, //};//2 Distinct //short[,] D = new short[,] //{ // { 1, 0 }, // { 1, 0 }, // { 1, 1 } //};//8 Distinct //var sm = new ShapeMan(new List<Shape> { new Shape(A), new Shape(B), new Shape(C), new Shape(D) }); //foreach (var item in sm.ReadyShapesLists) // await new Solver(item, this).TrySolve(); //if(TOTAL_SOLUTIONS == 0) // WriteLine("No Possible Solution!"); #endregion if (await ReadShapes()) { ShapeMan sm = new ShapeMan(shapes); List <Task> tasks = new List <Task>(sm.ReadyShapesLists.Count); foreach (var item in sm.ReadyShapesLists) { tasks.Add(new Solver(item, this).TrySolve()); //auto writes } var sw = new Stopwatch(); #region Solving Parallel sw.Start(); Thread.BeginThreadAffinity(); Parallel.ForEach(tasks, task => task.Start()); Thread.EndThreadAffinity(); await Task.WhenAll(tasks); sw.Stop(); #endregion if (TOTAL_SOLUTIONS == 0) { WriteLine(string.Format("No Possible Solution!, Time Elapsed: {0}s.", (sw.ElapsedMilliseconds / 1000.0).ToString())); } else { WriteLine(string.Format("Total Possible Solutions : {0}, Time Elapsed: {1}s.", TOTAL_SOLUTIONS.ToString(), (sw.ElapsedMilliseconds / 1000.0).ToString())); } } else { WriteLine("Cannot Read Shapes!,"); WriteLine("Please Check & Format Input Correctly."); } solveBtn.Text = "Solve"; solveBtn.Enabled = true; }