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 RefreshResultsForm()
{
//MaintextBox.AppendText(grade.ToString());
// MaintextBox.AppendText("\r\n");
ResultsTextBox.Clear();
ResultsTextBox.AppendText($"TotalScore: {quiz.CorrectAnswers} / {quiz.NumberOfQuestions}");
}
/// <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;
}
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>
/// 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;
}
//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;
}
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);
}
/// <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 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 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 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();
}
}
}
private void SearchButton_Click(object sender, EventArgs e)
{
ResultsTextBox.Clear();
worker.RunWorkerAsync();
}
private void button2_Click(object sender, EventArgs e)
{
ResultsTextBox.Clear();
ResultsTextBox.Text = CommandOne(queryStringTwo, connectOne);
}
private void ClearButton_Click(object sender, EventArgs e)
{
ResultsTextBox.Clear();
}
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;
}
