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.
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.
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?
+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 ..
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
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?
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!
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.
+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
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
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.
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?
'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?
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
+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 .
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.
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.
I like your way of teaching .... you are a superman
+Saed Jomaa thanks keep learning and sharing
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.
+Dinesh Kumar thanks Dinesh ..keep learning and sharing
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.
+Dinesh Kumar Sure...
Dear Ashish
Wait you for AspNet Core MVC!
All things GREATE!!!
Very very nice Ashish.!!
+kaushik bhadani thank you!
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?
+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 ..
nice work, thanks for sharing, really useful!!!!!
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
+asd asdf Thanks asd! If u find this useful then please share this among your friends.
The specified type member 'IsDeleted' is not supported in LINQ to Entities.
why this problem occurs?
Thank u if u reply.
excelent explanation sir !
+Fiaz Ahmad thanks..keep learning and sharing
great work dear.....
+Ali Raza thanku very much!
Thanks for awesome video
Hey Ashish, Nice Video Even helpful to me in My Live Project.
i love this tutoria
what is MVCTutorialEntities? can't find where its declared anywhere...
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)
Thanks🤗
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?
its not work for me. my modal just flashes not stop to get click on yes or no button
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!
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.
thanks
your articles very helpfully :)
+Ghadeer Boland thanku
When I delete the row. It is only gone if a refresh the page. How can I solve this, please help!
Dear sir ,in databse empoyee table you add Isdeleted column which datatype is given to IsDeleted coulmn?
+Haroon Niaz boolean (bit) type.
(x => x.IsDeleted == false && x.EmployeeId=EmployeeId); is still show error && operator canot applied on
bool and int
thanks sir error remove and code execute
Great
Thanks sir!
How would we show in the modal, what record is going to be deleted? Do we need a partial view for that?
+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
Good tutorial Ashish, while I am debugging ,I am not able to find the EmployeeId in the DeleteEmployee method parameter
Thanks.. You need to make sure whether you are getting employeeId while rendering data or not
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
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.
Ok Ashish Thank you
What is the query you use to start 0 the column is delete?
+Jose Angel You can watch part 26 for this..
Thank you :)
why use json result on delete method why not action result ?
because it gives a data in JSON format that why use this JSON result
sir why i use JsonResult ,return Json(result, JsonRequestBehavior.AllowGet) etc. can you please explain why we use Json for delete operation.
+Zahidul Emon through jquery when you select type as json the all request and response will be sent or recieved in json format.
What is data type of IsDeleted in Sqlserver?
Choose bit in sql
Your CODE BELOW LINk is not working? why Sir?
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?
Sir, Why you have used JSON. Please Explain
+kuldeep kumar where?
sir you have used "Jsonresult". please Explain.
+kuldeep kumar oh..this will give you data into JSON format..and this data will be received into ajax response.
thank you sir
Hallo sir
What is data type you used on Isdelete column ?
Bit in sql and boolean in c#
@@aapkanigam thanks you so much sir
'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?
Dear Sir,
Great video, but How can insert multiple data at a time. Please help me?
+Lutfor Rahman multiple datetime means..? use DateTime.Now for current date time
Dear Sir,
I didn't mean datetime. I just said that how to insert multiple DATA at once using ajax.
+Lutfor Rahman Just use $.each function to send data one by one ..or create object of data and send to ajax
Thank you very much.
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
+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 .
+Faizan Raza No, this is just the list which will contains list of DepartmentId and its Name .
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.
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.
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
+Mohit Gangwar try to debug using inspect element in your browser . You will see some error.
Uncaught ReferenceError: ConfirmDelete is not defined
at HTMLAnchorElement.onclick
i AM GETTING THIS ERROR PLS ANY SOLUTION WHY IT IS ?
+Sheshmani Pandey Sam Make sure to create that method in script tag
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
+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(); } }) }
Event_details evnt=db.Event_details.SingleOrDefault(×=>x.IsDeleted==false && x.E_id== E_id); IsDeleted is error pls help me sir
Loved it ! shake that boodystrap !
+johan Van Wambeke Thanks