protected void Page_Load(object sender, EventArgs e) { var result = from x in Employee.GetAllEmployees() from d in Departmen.GetAllDepartments() select new { x, d }; foreach (var r in result) { Response.Write(r.x.Name + "-" + r.d.Name + "<br/>"); } Response.Write("<hr/>"); var results = Employee.GetAllEmployees().SelectMany(x => Departmen.GetAllDepartments(), (x, d) => new { x, d }); foreach (var r in results) { Response.Write(r.x.Name + "-" + r.d.Name + "<br/>"); } Response.Write("<hr/>"); var res = Employee.GetAllEmployees().Join(Departmen.GetAllDepartments(), x => true, d => true, (x, d) => new { x, d }); foreach (var r in res) { Response.Write(r.x.Name + "-" + r.d.Name + "<br/>"); } }
protected void Page_Load(object sender, EventArgs e) { var result = Employee.GetAllEmployees().Join( Departmen.GetAllDepartments(), x => x.DepartmentID, d => d.ID, (employee, department) => new { DepartmentName = department.Name, EmployeeName = employee.Name }); foreach (var r in result) { Response.Write(r.EmployeeName + "-" + r.DepartmentName + "<br/>"); } Response.Write("<hr /> SQl like <br/>"); var resultSql = from x in Employee.GetAllEmployees() join d in Departmen.GetAllDepartments() on x.DepartmentID equals d.ID select new { EmployeeName = x.Name, DepartmentName = d.Name }; foreach (var r in resultSql) { Response.Write(r.EmployeeName + "-" + r.DepartmentName + "<br/>"); } }
public ActionResult DepartmanCreate(Departmen model) { System.Diagnostics.Debug.WriteLine("aa--" + model.DepartmanAdi + "--"); if (Session["LogonAdmin"] == null) { TempData["resultInfo"] = "Oturum süreniz dolmuştur. Lütfen Oturum Açıp Tekrar Deneyiniz!"; return(RedirectToAction("Login", "Action")); } if (model.DepartmanAdi != "") { if (context.Departmen.Any(x => x.DepartmanAdi == model.DepartmanAdi)) { TempData["resultInfo"] = "Aynı isimde bölüm var!"; return(View()); } try { context.Entry <Database.Departmen>(model).State = System.Data.Entity.EntityState.Added; TempData["resultInfo"] = model.DepartmanAdi + " departmanı eklendi."; context.SaveChanges(); } catch (Exception ex) { TempData["resultInfo"] = ex.Message; } return(RedirectToAction("DepartmentControl", "PublicUI")); } else { TempData["resultInfo"] = "Departman Adı Giriniz!"; return(RedirectToAction("DepartmentControl", "PublicUI")); } }
public ActionResult DeleteConfirmed(int id) { Departmen departmen = db.Departmens.Find(id); db.Departmens.Remove(departmen); db.SaveChanges(); return(RedirectToAction("Index")); }
// POST: api/Departmen public void Post(Departmen sub) { if (ModelState.IsValid) { db.Departmens.Add(sub); db.SaveChanges(); } }
public ActionResult Edit([Bind(Include = "ID,Name,City")] Departmen departmen) { if (ModelState.IsValid) { db.Entry(departmen).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(departmen)); }
public ActionResult Create([Bind(Include = "ID,Name,City")] Departmen departmen) { if (ModelState.IsValid) { db.Departmens.Add(departmen); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(departmen)); }
public ActionResult DepartmanCreate() { if (Session["LogonAdmin"] != null) { Departmen model = new Departmen(); return(View(model)); } else { return(RedirectToAction("Index", "PublicUI")); } }
// GET: MVCDepartmen/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Departmen departmen = db.Departmens.Find(id); if (departmen == null) { return(HttpNotFound()); } return(View(departmen)); }
// PUT: api/Departmen/id public void Put(Departmen sub) { if (ModelState.IsValid) { db.Entry(sub).State = EntityState.Modified; try { db.SaveChanges(); } catch (Exception) { throw; } } }
// DELETE: api/Departmen/id public void Delete(int id) { Departmen dlt = db.Departmens.Find(id); if (dlt != null) { try { db.Departmens.Remove(dlt); db.SaveChanges(); } catch (Exception) { throw; } } }
protected void Page_Load(object sender, EventArgs e) { var EmployeeByDepartment = Departmen.GetAllDepartments() .GroupJoin(Employee.GetAllEmployees(), d => d.ID, x => x.DepartmentID, (department, employees) => new { Department = department, Employees = employees }); foreach (var department in EmployeeByDepartment) { Response.Write(department.Department.Name + "<Br/>"); foreach (var emp in department.Employees) { Response.Write(" " + emp.Name + "<br/>"); } Response.Write("<br/>"); } Response.Write("<hr/> Sql like<br/>"); var EmployeeByDepartmentSQl = from d in Departmen.GetAllDepartments() join x in Employee.GetAllEmployees() on d.ID equals x.DepartmentID into eGroup select new { department = d, Employees = eGroup }; foreach (var department in EmployeeByDepartmentSQl) { Response.Write(department.department.Name + "<Br/>"); foreach (var emp in department.Employees) { Response.Write(" " + emp.Name + "<br/>"); } Response.Write("<br/>"); } }
protected void Page_Load(object sender, EventArgs e) { var result = from x in Employee.GetAllEmployees() join d in Departmen.GetAllDepartments() on x.DepartmentID equals d.ID into eGroup from d in eGroup.DefaultIfEmpty() select new { EmployeeName = x.Name, DepartmentName = d == null?"No Departement": d.Name }; foreach (var r in result) { Response.Write(r.EmployeeName + "-" + r.DepartmentName + "<br/>"); } Response.Write("<hr />"); var results = Employee.GetAllEmployees() .GroupJoin(Departmen.GetAllDepartments(), x => x.DepartmentID, d => d.ID, (emp, deps) => new { emp, deps }) .SelectMany(z => z.deps.DefaultIfEmpty(), (a, b) => new { EmployeeName = a.emp.Name, DepartmentName = b == null?"No Department":b.Name }); foreach (var r in results) { Response.Write(r.EmployeeName + "-" + r.DepartmentName + "<br/>"); } }