2 Replies - 642 Views - Last Post: 22 September 2016 - 01:56 PM

#1 ahmedba  Icon User is offline

  • D.I.C Head

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

How to map index using jquery to repair indexes when remove

Posted 17 September 2016 - 05:40 PM

Problem
when remove any course from table list html his position in center or first it make problem

in index in database

Details

IF I have list of courses as following :

Delphi

Flash

Photoshop

IF I remove flash by JQUERY remove button then click save button

it delete flash and Photoshop

because there are wrong in delete courses by using remove function in jquery

if i remove php it is working without any problem because it is last item

suggestion

using map function when remove but how to do that

if there are any solution for that without using map no problem

i use model as following


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

i use for edit httppost


var result = db.Employees
             .Where(p => p.Id == custom.Id)
             .Include(c => c.EmployeeCourses)
             .FirstOrDefault();
        if (custom.empcourses.Any())
        {
            foreach (var ec in result.EmployeeCourses.ToList())//to remove existing EmployeeCourses
            {
                db.EmployeeCourses.Remove(ec);
                db.SaveChanges();
 
            }
        }
 
        result.EmployeeCourses = custom.empcourses;
     db.SaveChanges();




in model view my code as following by jquery

actually i need to modify code below using map function if there are any function do that never mind


$(function () {
           //add courses using drop down
            var index = 0;
            $("#CourseId").change(function () {
 
                var id = $(this).val();
                var txt = $("#CourseId option:selected").text();
 
               $("#tb").append("<tr><td><input type = 'hidden' name='empcourses[" + index + "].CourseId' value='" + id + "'/></td><td>" + txt + "</td><td><input type='button' value='remove' class='r'</td></tr>")
 
                index++;
 
            });
            $("#tb").on("click", ".r", function () {
              // remove function
                $(this).parent().parent().remove();
 
                $(this).parent().prev().prev().remove();
             });
 
// retrieve data in edit view using ajax
            $.ajax({
                url: "/Employee/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++;
                    });
                }
 
            })
        });



see image below to know what i need


What I have tried:

Attached image(s)

  • Attached Image


Is This A Good Question/Topic? 0
  • +

Replies To: How to map index using jquery to repair indexes when remove

#2 ahmedba  Icon User is offline

  • D.I.C Head

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

Re: How to map index using jquery to repair indexes when remove

Posted 18 September 2016 - 09:39 AM

can any one help me in that if possible
Was This Post Helpful? 0
  • +
  • -

#3 ahmedba  Icon User is offline

  • D.I.C Head

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

Re: How to map index using jquery to repair indexes when remove

Posted 22 September 2016 - 01:56 PM

I get error {"An error occurred while updating the entries. See the inner exception for details."}

details

The INSERT statement conflicted with the FOREIGN KEY constraint

\"FK_EmployeeCourse_Course\". The conflict occurred in database \"mycourse\",

table \"dbo.Course\", column 'Id'.\r\nThe statement has been terminated."}
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1