0 Replies - 480 Views - Last Post: 30 September 2016 - 05:21 AM

#1 ahmedba  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 141
  • Joined: 24-January 14

remove selected course from table EmployeeCourse when click save butto

Posted 30 September 2016 - 05:21 AM

Needs

Remove courses from EmployeeCourse table and jquery view when click save button if i remove course

code

in view

 $("#tb").on("click", ".r", function () {

        what i write here to remove in jquery client side
                 });
     [HttpPost]
            public ActionResult Edit(Cusomemp2 custom)
            {
what i write here to remove from EmployeeCourse table server side

            return View();
            }

Details

IF i have 3 courses for employee Michel(interface as following)

c# remove button

SQL remove button

asp.net remove button

save button

I need when click remove button for SQL course remove it by jquery from client side then when click save button remove it from EmployeeCourse table(server side)

i use this model

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


    }

and when i need to retrieve courses for employee from EmployeeCourse table in

edit view i use this code below

var index = 0;
    $.ajax({
                    url: "/Employeedata/getcoursesbyempid",
                    data:{x:$("#hid").val()},
                    success: function (res) {
                        $.each(res, function (i, e) {


                            $("#tb").append("<tr><td><input type = 'hidden' name='empcourses[" + index + "].CourseId' value='" + e.Id + "'/></td><td>" + e.CourseName + "</td><td><input type='button' value='remove' class='r'/></td></tr>")



                            index++;
                        });
                    }

                })

function retrieve data in controller

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

so that i need after retrieve data in edit view

remove course by jquery if i remove SQL course

then remove the SQ course from database in table EmployeeCourse

how i do that by code jquery and c# controller


EmployeeCourse table have three fields ( Id,CourseId,EmployeeId )

Course Table have ( Id,CourseName )

Employee Table have ( Id,Name )

Is This A Good Question/Topic? 0
  • +

Page 1 of 1