Part 16- Delete operation in ASP.NET MVC using JQuery and Bootstrap popup (Modal)

[@ArabicSaed]

I like your way of teaching .... you are a superman

[@aapkanigam]

+Saed Jomaa thanks keep learning and sharing

[@d.choudhary2705]

hi Ashish first of all congratulations to you for nice work. God bless. I request you to please upload more and more videos based on real time project example and try to clear MVC, jquery, LINQ, EF concept. your way of teaching very very good. please carry on. now our aspectation from you more. really appreciate your work.

[@aapkanigam]

+Dinesh Kumar thanks Dinesh ..keep learning and sharing

[@d.choudhary2705]

Technotips - Ashish I am waiting your more videos on MVC , jquery. please upload ASAP. I'm saying thanks bottom of my heart. I hope soon you'll upload.

[@aapkanigam]

+Dinesh Kumar Sure...

[@kirankumari-nz8lr]

Wonderful video and so easy explaination .Thanks for giving such example. previously I was deleting the complete row it was deleted successfully but in my case the table was not having any relationship with other table.Should we need that extra column for handling such issue?

[@aapkanigam]

+kiran kumari Your welcome ! Yes we need to add one more extra column .We can delete the table row in case of dependencies. It will give an exception. Keep learning anf sharing ..

[@tejaratahan949]

Dear Ashish Wait you for AspNet Core MVC! All things GREATE!!!

[@mohamadahmad7600]

hi Ashish congratulations to you for Very Good work. I WISH YOU MAKE more videos based on real time project example and try to clear MVC, jquery, LINQ, EF concept. your way of teaching very very good THANK YOU VERY VERY MUCH

[@aapkanigam]

+asd asdf Thanks asd! If u find this useful then please share this among your friends.

[@xhonb3436]

The specified type member 'IsDeleted' is not supported in LINQ to Entities. why this problem occurs? Thank u if u reply.

[@iggzyiggzy]

Hi, great tutorials, thx for all of them :D . Q: Why don't you just pass list to View in Index method ? Like = return View(listEmp)

[@aapkanigam]

Thanks🤗

[@Mudassariqbal884]

Have you given any tutorial of data migration in code first approach? actually i doing practice using code first approach so if you didn't give any tutorial please recommend me any tutorial which is best! Thanx!

[@anshulbansal9059]

Hey Ashish, just want to know one thing. why did you used this "Select(x => new employee { employee_id = x.employee_id, employee_name = x.employee_name, department_id = x.department_id })"? When I was using this then i was getting an exception and when i removed it, program ran. Is there any reason for this?

[@kaushikbhadani4227]

Very very nice Ashish.!!

[@aapkanigam]

+kaushik bhadani thank you!

[@vastro7343]

nice work, thanks for sharing, really useful!!!!!

[@FiazAhmad-jd5sq]

excelent explanation sir !

[@aapkanigam]

+Fiaz Ahmad thanks..keep learning and sharing

[@haroonniaz7148]

Dear sir ,in databse empoyee table you add Isdeleted column which datatype is given to IsDeleted coulmn?

[@aapkanigam]

+Haroon Niaz boolean (bit) type.

[@haroonniaz7148]

(x => x.IsDeleted == false && x.EmployeeId=EmployeeId); is still show error && operator canot applied on bool and int

[@haroonniaz7148]

thanks sir error remove and code execute

[@kiranallam3583]

Good tutorial Ashish, while I am debugging ,I am not able to find the EmployeeId in the DeleteEmployee method parameter

[@aapkanigam]

Thanks.. You need to make sure whether you are getting employeeId while rendering data or not

[@kiranallam3583]

yes I am getting the id in view but it is not passed to JSON method and one more thing while I am deleting the element, it is going to be deleted. as soon as i was refreshing the page same element is coming back in the view

[@aapkanigam]

Then you should check your jquery code how are you passing the ID in ajax call. Make sure the name of Id key should be exactly matches with the method's parameter name in your controller.

[@kiranallam3583]

Ok Ashish Thank you

[@sarangbhople403]

Hey Ashish, Nice Video Even helpful to me in My Live Project.

[@AlmostDead]

what is MVCTutorialEntities? can't find where its declared anywhere...

[@badripn]

Hi Ashish. The ajax call in the script tag fails and as a result the modal window doesn't closes and the data is not getting removed. Can you pls. suggest. I am a newbie.

[@aliraza66-h1b]

great work dear.....

[@aapkanigam]

+Ali Raza thanku very much!

[@navzme]

Thanks for awesome video

[@kuldeepkumar-en1fk]

Sir, Why you have used JSON. Please Explain

[@aapkanigam]

+kuldeep kumar where?

[@kuldeepkumar-en1fk]

sir you have used "Jsonresult". please Explain.

[@aapkanigam]

+kuldeep kumar oh..this will give you data into JSON format..and this data will be received into ajax response.

[@kuldeepkumar-en1fk]

thank you sir

[@zahidulemon5058]

sir why i use JsonResult ,return Json(result, JsonRequestBehavior.AllowGet) etc. can you please explain why we use Json for delete operation.

[@aapkanigam]

+Zahidul Emon through jquery when you select type as json the all request and response will be sent or recieved in json format.

[@MrBobadil]

How would we show in the modal, what record is going to be deleted? Do we need a partial view for that?

[@aapkanigam]

+MrBobadil If you want to display simple message then you can use modal with hard coded message ..but if you want to show complete value of that record then you need partial view with bootstrap modal

[@lutforurc]

Dear Sir, Great video, but How can insert multiple data at a time. Please help me?

[@aapkanigam]

+Lutfor Rahman multiple datetime means..? use DateTime.Now for current date time

[@lutforurc]

Dear Sir, I didn't mean datetime. I just said that how to insert multiple DATA at once using ajax.

[@aapkanigam]

+Lutfor Rahman Just use $.each function to send data one by one ..or create object of data and send to ajax

[@lutforurc]

Thank you very much.

[@sonthanh2977]

i love this tutoria

[@ghadeerboland259]

thanks your articles very helpfully :)

[@aapkanigam]

+Ghadeer Boland thanku

[@carlosgabriel8568]

Hi, I'm using in my ajax succses "myModal".modal("hide") but after i complete my action(Add, Delete or edit) my moal dialog it's not closing, someone know's what's wrong?

[@wellington18m]

When I delete the row. It is only gone if a refresh the page. How can I solve this, please help!

[@jimboTTT]

Thanks sir!

[@duncanmcdonald5250]

If, like me, you wonder how to set up the "FK_Sites_Employee" key that Ashish uses, but has not explained how to create, I'd advise going to the blog for Tut 28 and grabbing the database creation SQL. The database SQL attached to this tutorial does not successfully set up the foreign key for me.

[@duncanmcdonald5250]

You will also need to update the entity framework to include the new "IsDeleted" field in the Employee table. So open the "MVCTutorialModel.edmx" in the "Models" folder, right click and select "Update Model From Database", Select the "Refresh" tab and click the "Finish" button. Now build the project again and the Employees class will have the new "IsDeleted" member. But your EmployeeViewModel will need to be manually updated to know about this field. Also, don't expect this tutorial to actually DELETE anything from the table, it just updates and uses the new flag.

[@narendarsingh4672]

Great

[@MrJos221]

What is the query you use to start 0 the column is delete?

[@aapkanigam]

+Jose Angel You can watch part 26 for this..

[@muhammadalwi4842]

Hallo sir What is data type you used on Isdelete column ?

[@aapkanigam]

Bit in sql and boolean in c#

[@muhammadalwi4842]

@@aapkanigam thanks you so much sir

[@xhonb3436]

'The specified type member 'IsDeleted' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.' why this problem occurs?

[@annuverma936]

why use json result on delete method why not action result ?

[@list5s]

because it gives a data in JSON format that why use this JSON result

[@mohammadfasih7752]

sir please explain little bit more this line...(viewBag.DepartmentList=new SelectList(List,"Departmentid","DepartmentName") what changes can i do if my table has no dependency with another tale

[@aapkanigam]

+Faizan Raza I have list of record in "List" in which I will have all columns.But here while taking it into ViewBag.DepartmentList I am taking list of two column only i.e. DepartmentName and DepartmentId .I will use this list to bind my Dropdown that needs only id and name. SelectList is like tag which contains Name and value .

[@aapkanigam]

+Faizan Raza No, this is just the list which will contains list of DepartmentId and its Name .

[@nabeelsiddiqui7612]

Your CODE BELOW LINk is not working? why Sir?

[@tayyabjatoi8644]

What is data type of IsDeleted in Sqlserver?

[@aapkanigam]

Choose bit in sql

[@kinkmas]

Thank you :)

[@asifjalal9260]

its not work for me. my modal just flashes not stop to get click on yes or no button

[@mohitgangwar1191]

The AJAX request is sent and it works. But, It works only for the first time, it doesnt work from second time onwards. please give the solution

[@aapkanigam]

+Mohit Gangwar try to debug using inspect element in your browser . You will see some error.

[@samzviews6315]

Uncaught ReferenceError: ConfirmDelete is not defined at HTMLAnchorElement.onclick i AM GETTING THIS ERROR PLS ANY SOLUTION WHY IT IS ?

[@aapkanigam]

+Sheshmani Pandey Sam Make sure to create that method in script tag

[@samzviews6315]

Technotips - Ashish i dint see any method in script tag in your video can u please send me in comment plss i am stucked there

[@aapkanigam]

+Sheshmani Pandey Sam var ConfirmDelete = function (EmployeeId) { $("#hiddenEmployeeId").val(EmployeeId); $("#myModal").modal('show'); } var DeleteEmployee = function () { $("#loaderDiv").show(); var empId = $("#hiddenEmployeeId").val(); $.ajax({ type: "POST", url: "/Test/DeleteEmployee", data: { EmployeeId: empId }, success: function (result) { $("#loaderDiv").hide(); $("#myModal").modal("hide"); $("#row_" + empId).remove(); } }) }

[@kartikeypavar6585]

Event_details evnt=db.Event_details.SingleOrDefault(×=>x.IsDeleted==false && x.E_id== E_id); IsDeleted is error pls help me sir

[@johanvanwambeke723]

Loved it ! shake that boodystrap !

[@aapkanigam]

+johan Van Wambeke Thanks