how to remove courses store in ids in edit post controller

ahmed salah

10y918.NET

In edit http post i need to remove courses stored in ids variable

note i need remove courses selected not edit

in jquery i store values of removed courses in ids variable

suppose i removed photoshop and flash it will store value of 3,4 in ids variable

below code when click remove it save values of courses removed in variable ids as array

$("#tb").on("click", ".r", function () {
$(this).parent().parent().hide();
$(this).parent().prev().prev().find("input").addClass("remove");
var ids = [];
var i = 0;
$(".remove").each(function () {
ids[i] = $(this).val();
i++;
});
for (var k = 0; k < ids.length; k++) {
alert(ids[k]);
}
});

i show courses per employee from table EmployeeCourse in edit get as following

var index = 0;
$.ajax({
url: "/Employeedata/getcoursesbyempid",
data:{x:$("#hid").val()},
success: function (res) {
$.each(res, function (i, e) {
$("#tb").append(" + index + "].CourseId' value='" + e.Id + "'/>" + e.CourseName + "")
index++;
});
}
})
public JsonResult getcoursesbyempid(int x)
{
db.Configuration.ProxyCreationEnabled = false;
var data = db.EmployeeCourses.Where(a => a.EmployeeId == x).Join(db.Courses, a => a.CourseId, b => b.Id, (a, b) => new { Id = a.CourseId, CourseName = b.CourseName });
return Json(data, JsonRequestBehavior.AllowGet);
}

my mode using as following

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

when remove courses in edit HTTPPOST what i write here

[HttpPost]
public ActionResult Edit(Cusomemp2 custom)
{
//what i write to remove courses saved in ids from table EmployeeCourse
return View();
}

see image above for details

9 Replies

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

ahmed salah10y ago
can any one help me in solving this issue if possible
ahmed salah10y ago
can any one answer for me in this question if possible
ahmed salah10y ago
In which column you want to store comma-separated value for employee-course ids.
EmployeeCourse table in field CourseId and it is not comma separated every course represent one record
what are the values you are getting in Cusomemp2 object in your method.
empcourses and Id
if you need to add any modification to my model Cusomemp2 i can accept that
only i need to achieve this if possible
Manas Mohapatra10y ago
In which column you want to store comma-separated value for employee-course ids.
Secondly, what are the values you are getting in Cusomemp2 object in your method.
ahmed salah10y ago
can any one tell me how to solve that problem if possible
ahmed salah10y ago
1- Means if an employee subscribe 2 courses then it will have two records in EmployeeCourse table.
yes it will have two records in EmployeeCourse table
no comma separated it is two records
2-what are the values you are getting inEdit(Cusomemp2 custom)
it represent edit http post when i click in save button it must remove courses fromEmployeeCourse table
i need here to loop within courses removed then removed from EmployeeCourse table and save changes
Manas Mohapatra10y ago
For one employee, it will have multiple records, right?
Means if an employee subscribe 2 courses then it will have two records in EmployeeCourse table. But in your question it comma separated like 3,4.. please confirm.
Secondly, what are the values you are getting inEdit(Cusomemp2 custom)
ahmed salah10y ago
1. whenremovecoursesineditHTTPPOSTwhatiwritehere
2. [HttpPost]
3. publicActionResultEdit(Cusomemp2custom)
4. {
5. //whatiwritetoremovecoursessavedinidsfromtableEmployeeCourse
6. returnView();
7. }
problem in server side under edit HTTP POST when click save button
what i write to remove courses fromtable EmployeeCourse
in jquery no problem

Manas Mohapatra10y ago

Where is the problem now jquery side or server side??