how to loop through hidden courses and remove from database

In my code i need to loop through hidden courses in jquery then remove it from employee course table in database sql in edit httppost under save button

see green font in place of my code i need

[HttpPost]
public ActionResult Edit(Cusomemp2 custom)
{
var result = db.Employees
.Where(p => p.Id == custom.Id)
.Include(c => c.EmployeeCourses)
.FirstOrDefault();
if (custom.empcourses.Any())
{
//here i need to loop through data and remove hidden courses
}
result.Name = custom.Name;
result.EmployeeCourses = custom.empcourses;
db.SaveChanges();
return View();
}

i use following model Cusomemp2 to represent data

public class Cusomemp2
{
public int Id { get; set; }
public List empcourses { get; set; }
}

in edit view model my code as following

@model StudentCourses.Models.Cusomemp2
@{
Layout = null;
}
"viewport" content="width=device-width" />
Edit
"~/scripts/jquery-1.10.2.js">
@using (Html.BeginForm())
{
"hidden" value="@ViewBag.hid" id="hid" />
Name: @Html.TextBoxFor(a => a.Name)
Courses:@Html.DropDownList("CourseId")
"tb">
"submit" value="save" />

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

ahmed salah10y ago
after remove c++ by jquery button remove then click save it give me null exception error
as image below attached with my message
Pradeep Shet10y ago
hi,
I hope this answers your question
public ActionResult Edit(Cusomemp2 custom)
{

var result = db.Employees
.Where(p => p.Id == custom.Id)
.Include(c => c.EmployeeCourses)
.FirstOrDefault();
if (custom.empcourses.Any())
{
foreach(var e in custom.empcourses)
{
var course = db.EmployeeCourses.Where(x=>x.CourseId == e.CourseId).FirstOrDefault();
db.EmployeeCourses.Delete(course);
}
db.SaveChanges();
}

result.Name = custom.Name;

result.EmployeeCourses = custom.empcourses;
db.SaveChanges();

return View();
}