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/>");
}
}
