//Видалення
protected void Button5_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
var deps = (
from department in dbContext.Departments
where department.Name == "Support"
select department);
if (deps.Count() == 0)
{
return;
}
var dep = deps.First();
dbContext.Departments.DeleteOnSubmit(dep);
try
{
dbContext.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
GridView2.DataBind();
}
//тільки чоловіки
protected void Button1_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource =
from employee in dbContext.Employees
where employee.Gender == "Male"
orderby employee.Salary descending
select employee;
GridView1.DataBind();
}
//всі працівники та відділи
protected void Page_Load(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource =
dbContext.Employees;
GridView1.DataBind();
GridView2.DataSource =
dbContext.Departments;
GridView2.DataBind();
}
//Працівнити та професії
protected void Button2_Click(object sender, EventArgs e)
{
SampleDataContext dbContext = new SampleDataContext();
GridView1.DataSource =
from employee in dbContext.Employees
join department in dbContext.Departments on employee.DepartmentId equals department.ID
select new { employee.FirstName, employee.LastName,
department.Name,
department.Location };
GridView1.DataBind();
}
//Додати запис
protected void Button4_Click(object sender, EventArgs e)
{
using (SampleDataContext dbContext = new SampleDataContext())
{
Departments dep = new Departments();
dep.Location = "Ukraine";
dep.Name = "Support";
dbContext.Departments.InsertOnSubmit(dep);
try
{
dbContext.SubmitChanges();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
GridView2.DataBind();
}