protected void Page_Load(object sender, EventArgs e)
{
var db = new DCDataContext();
var res = db.ExecuteQuery(typeof(string), "SELECT UPPER ( FirstName) FROM Employee", new object[0]);
ListBox1.DataSource = res;
ListBox1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var db = new DCDataContext();
var res = db.ExecuteQuery(typeof(string), "SELECT FirstName + ' ' + SUBSTRING(LastName,1,1) + '. ' + SUBSTRING(Patronymic,1,1) + '.' FROM Employee", new object[0]);
ListBox1.DataSource = res;
ListBox1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, Employee.Id, Project.Name, EmployeeProject.OfficialSalary * EmployeeProject.CountDaysWork /22 as Result
FROM Employee INNER JOIN
EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN
Project ON EmployeeProject.ProjectId = Project.Id";
var db = new DCDataContext();
db.ExecuteQuery<EmpRes>(query);
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var query =
@"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, SUM(EmployeeProject.OfficialSalary)AS SumTotal
FROM Employee INNER JOIN
EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId
group BY Employee.FirstName, Employee.LastName, Employee.Patronymic";
var db = new DCDataContext();
db.ExecuteQuery<string>(query);
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
var query = @"SELECT Project.Name, EmployeeProject.OfficialSalary
FROM Employee INNER JOIN
EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN
Project ON EmployeeProject.ProjectId = Project.Id
ORDER BY EmployeeProject.OfficialSalary";
var db = new DCDataContext();
db.ExecuteQuery<string>(query);
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
var query =
@"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, EmployeeProject.OfficialSalary, Project.Name
FROM EmployeeProject INNER JOIN
Employee ON EmployeeProject.EmployeeId = Employee.Id INNER JOIN
Project ON EmployeeProject.ProjectId = Project.Id
WHERE (EmployeeProject.OfficialSalary > {0})";
var db = new DCDataContext();
db.ExecuteQuery<EmpRes>(query, TextBox1.Text);
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
var query = @"SELECT Employee.FirstName, Employee.LastName, Employee.Patronymic, Employee.Id, Project.Name,
CAST(EmployeeProject.OfficialSalary * EmployeeProject.CountDaysWork AS float(2)) / 22 / {0} AS Result, Project.Id AS Expr1
FROM Employee INNER JOIN
EmployeeProject ON Employee.Id = EmployeeProject.EmployeeId INNER JOIN
Project ON EmployeeProject.ProjectId = Project.Id
WHERE (Project.Id = {1})";
var db = new DCDataContext();
db.ExecuteQuery<Salary.EmpRes>(query, DropDownList1.SelectedValue, TextBox1.Text);
GridView1.DataBind();
}