public ActionResult Edit([Bind(Include = "Id,Department,Designation")] VmDepartmentDesignation vmDepartmentDesignation)
{
if (ModelState.IsValid)
{
db.Entry(vmDepartmentDesignation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(vmDepartmentDesignation));
}
public ActionResult Delete(VmDepartmentDesignation vm)
{
using (BusManagementContext db = new BusManagementContext())
{
var DepartmentDelete = db.tblDepartments.First(d => d.Id == vm.Id);
var DesignationDelete = db.tblDesignations.First(dg => dg.DepartmentID == vm.Id);
db.tblDepartments.Remove(DepartmentDelete);
db.tblDesignations.Remove(DesignationDelete);
db.SaveChanges();
return(View(vm));
}
}
// GET: VmDepartmentDesignations/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
VmDepartmentDesignation vmDepartmentDesignation = db.VmDepartmentDesignations.Find(id);
if (vmDepartmentDesignation == null)
{
return(HttpNotFound());
}
return(View(vmDepartmentDesignation));
}
public ActionResult Create(VmDepartmentDesignation vm)
{
if (ModelState.IsValid)
{
tblDepartment d = new tblDepartment();
d.Department = vm.Department;
db.tblDepartments.Add(d);
db.SaveChanges();
tblDesignation dg = new tblDesignation();
dg.Designation = vm.Designation;
dg.DepartmentID = d.Id;
db.tblDesignations.Add(dg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View());
}
public ActionResult Index()
{
using (BusManagementContext db = new BusManagementContext())
{
List <VmDepartmentDesignation> vmList = new List <VmDepartmentDesignation>();
var DbCollection = (from d in db.tblDepartments
join dg in db.tblDesignations on d.Id equals dg.DepartmentID
select new { d.Department, dg.Designation }
).ToList();
foreach (var vc in DbCollection)
{
VmDepartmentDesignation v = new VmDepartmentDesignation();
v.Department = vc.Department;
v.Designation = vc.Designation;
vmList.Add(v);
}
return(View(vmList));
}
}
// GET: VmDepartmentDesignations/Create
public ActionResult Create()
{
VmDepartmentDesignation v = new VmDepartmentDesignation();
return(View(v));
}
