private void button2_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
string city = "New York";
List<School> schools = db.Schools.Where(s => s.City == city).ToList();
var sb = new StringBuilder();
foreach(var school in schools)
{
sb.Append(school.Name);
sb.Append(": ");
sb.Append(school.Pupils.Count);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
private void button3_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
int schoolId = 1;
List<Pupil> pupils = db.Pupils
.Where(p => p.SchoolId == schoolId)
.ToList();
var sb = new StringBuilder();
foreach(var pupil in pupils)
{
sb.Append(pupil.FirstName);
sb.Append(" ");
sb.Append(pupil.LastName);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
private void button4_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
string zipCode = "90210";
var pupils = db.Pupils
.Where(p => p.PostalZipCode == zipCode)
.Select(x => new {x.FirstName, x.LastName})
.ToList();
var sb = new StringBuilder();
foreach (var pupil in pupils)
{
sb.Append(pupil.FirstName);
sb.Append(" ");
sb.Append(pupil.LastName);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
private void button8_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
for (int i = 0; i < 2000; i++)
{
Pupil pupil = GetNewPupil();
db.Pupils.Add(pupil);
}
db.SaveChanges();
textBox_Output.Text = "Finished adding data";
}
}
private void button7_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
var model = new ResultsModel();
var rnd = new Random();
model.Page = rnd.Next(1, 1000);
model.ResultsPerPage = rnd.Next(10, 100);
var schools = db.Schools
.OrderBy(s => s.PostalZipCode)
.Skip(model.Page * model.ResultsPerPage)
.Take(model.ResultsPerPage)
.ToList();
var sb = new StringBuilder();
foreach (var school in schools)
{
sb.Append(school.Name);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
private void button6_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
//Search data as input by user
var searchModel = new Pupil
{
FirstName = "Ben",
LastName = null,
City = null,
PostalZipCode = null
};
List<Pupil> pupils = db.Pupils.Where(p =>
(searchModel.FirstName == null || p.FirstName == searchModel.FirstName)
&& (searchModel.LastName == null || p.LastName == searchModel.LastName)
&& (searchModel.City == null || p.LastName == searchModel.City)
&& (searchModel.PostalZipCode == null || p.PostalZipCode == searchModel.PostalZipCode)
)
.Take(100)
.ToList();
var sb = new StringBuilder();
foreach (var pupil in pupils)
{
sb.Append(pupil.FirstName);
sb.Append(" ");
sb.Append(pupil.LastName);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
private void button5_Click(object sender, EventArgs e)
{
PrintThatFetchingData();
using (var db = new EFSchoolSystemContext())
{
db.Database.CommandTimeout = 300;
string city = "New York";
var pupils = db.Pupils
.Where(p => p.City == city)
.OrderBy(p => p.LastName)
.Select(x => new { x.FirstName, x.LastName })
.ToList();
var sb = new StringBuilder();
foreach (var pupil in pupils)
{
sb.Append(pupil.FirstName);
sb.Append(" ");
sb.Append(pupil.LastName);
sb.Append(Environment.NewLine);
}
textBox_Output.Text = sb.ToString();
}
}
