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 Button1_Click(object sender, EventArgs e)
 {
     var db = new DCDataContext();
     var res = db.Employee.Where(a => a.Address.Contains(TextBox1.Text));
     GridView1.DataSource = res;
     GridView1.DataBind();
 }
 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 DeleteLB_Click(object sender, EventArgs e)
 {
     var db = new DCDataContext();
     var empP = db.EmployeeProject.Single(a => a.Id == (int)DetailsView1.SelectedValue);
     db.EmployeeProject.DeleteOnSubmit(empP);
     db.SubmitChanges();
     Response.Redirect("EmployeesProjects.aspx");
 }
Beispiel #5
0
 protected void Button1_Click(object sender, EventArgs e)
 {
     var db = new DCDataContext();
     var arr = chars.Where(q => q >= startDDL.SelectedValue.ToCharArray()[0] && q <= endDDL.SelectedValue.ToCharArray()[0]).ToArray();
     var res = db.Employee.Where(q => arr.Contains(q.FirstName.ToUpper()[0])).OrderBy(a => a.FirstName).ToArray();
     GridView1.DataSource = res;
     GridView1.DataBind();
 }
Beispiel #6
0
 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 Button1_Click(object sender, EventArgs e)
 {
     if(!FileUpload1.HasFile)
         return;
     var db = new DCDataContext();
     db.Employee.Single(a => a.Id == int.Parse(DropDownList1.SelectedValue)).AvatarName = DropDownList1.SelectedValue + "_" + FileUpload1.FileName;
     db.SubmitChanges();
     FileUpload1.SaveAs(Directory.GetParent(HttpContext.Current.Request.PhysicalPath).FullName +  "/Avatars/" + DropDownList1.SelectedValue + "_" + FileUpload1.FileName);
     ScriptManager.RegisterStartupScript(this.Page, this.Page.GetType(), "key", "alert('Файл загружен!');", true);
 }
Beispiel #8
0
 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();
 }
Beispiel #9
0
 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 UpdateB_Click(object sender, EventArgs e)
 {
     var db = new DCDataContext();
     var empP = db.EmployeeProject.Single(a => a.Id == (int)DetailsView1.SelectedValue);
     empP.CountDaysWork = int.Parse(CountDaysWorkTB.Text);
     empP.OfficialSalary = int.Parse(OfficialSalaryTB.Text);
     empP.EmployeeId = int.Parse(EmployeesDDL.SelectedValue);
     empP.ProjectId = int.Parse(ProjectsDDL.SelectedValue);
     empP.PositionId = int.Parse(PositionsDDL.SelectedValue);
     db.SubmitChanges();
     Response.Redirect("EmployeesProjects.aspx");
 }
 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();
 }
Beispiel #12
0
 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();
 }
 protected void Button1_Click(object sender, EventArgs e)
 {
     var empP = new EmployeeProject()
                    {
                        CountDaysWork = int.Parse(CountDaysWorkTB.Text),
                        OfficialSalary = int.Parse(OfficialSalaryTB.Text),
                        EmployeeId = int.Parse(EmployeesDDL.SelectedValue),
                        ProjectId = int.Parse(ProjectsDDL.SelectedValue),
                        PositionId = int.Parse(PositionsDDL.SelectedValue),
                    };
     var db = new DCDataContext();
     db.EmployeeProject.InsertOnSubmit(empP);
     db.SubmitChanges();
     Response.Redirect("EmployeesProjects.aspx");
 }
 protected void UpdateLB_Click(object sender, EventArgs e)
 {
     Panel1.Visible = true;
     DetailsView1.Visible = false;
     var db = new DCDataContext();
     var empP = db.EmployeeProject.Single(a => a.Id == (int)DetailsView1.SelectedValue);
     EmployeesDDL.DataBind();
     EmployeesDDL.SelectedIndex =
         EmployeesDDL.Items.IndexOf(EmployeesDDL.Items.OfType<ListItem>().Single(a => a.Value == empP.EmployeeId.ToString()));
     PositionsDDL.DataBind();
     PositionsDDL.SelectedIndex =
         PositionsDDL.Items.IndexOf(PositionsDDL.Items.OfType<ListItem>().Single(a => a.Value == empP.PositionId.ToString()));
     ProjectsDDL.DataBind();
     ProjectsDDL.SelectedIndex =
         ProjectsDDL.Items.IndexOf(ProjectsDDL.Items.OfType<ListItem>().Single(a => a.Value == empP.ProjectId.ToString()));
     OfficialSalaryTB.Text = empP.OfficialSalary.ToString();
     CountDaysWorkTB.Text = empP.CountDaysWork.ToString();
     CreateB.Visible = false;
     UpdateB.Visible = true;
 }