Post
Ask Question
ahmed salah

ahmed salah

  • NA
  • 530
  • 148.8k

Selected District not retrieved for employee in edit view ge

Aug 28 2016 8:50 AM
 
in image above show what i need
I have three drop down list Country,City,District
three drop down list cascade each other
meaning select country fill City and select City fill District in edit or create both
in edit view i can get value selected previous for country and city for employee i need to edit
but District cannot get selected value for employee i need to edit

  2. in Edit view (get)  
  3.   
  4. @model WebCourse.Models.Customemployee2  
  5. @{  
  6.     Layout = null;  
  7. }  
  8.   
  9. <!DOCTYPE html>  
  10.   
  11. <html>  
  12. <head>  
  13.     <meta name="viewport" content="width=device-width" />  
  14.     <title>Edit</title>  
  15.     <script src="~/scripts/jquery-1.10.2.js"></script>  
  16.     <script>  
  17.         $(function () {  
  18.             $("#CountryId").change(function () {  
  19.                 $("#citylist").empty();  
  20.              //  alert("error");  
  21.                 var x = $(this).val();  
  22.                 $.ajax({  
  23.                     url: "/empcourse/getcitybyid",  
  24.                     data: { id: x },  
  25.                     success:function(res)  
  26.                     {  
  27.                         $.each(res, function (i, e) {  
  28.                             if (e.Id == $("#cityidhidden").val())  
  29.                             {  
  30.                                 $("#citylist").append("<option selected value='" + e.Id + "'>" + e.CityName + "<option>")  
  31.                             }  
  32.                             else  
  33.                             {  
  34.                                 $("#citylist").append("<option value='" + e.Id + "'>" + e.CityName + "<option>")  
  35.                             }  
  36.                              
  37.   
  38.                         });  
  39.                     }  
  40.                 });  
  41.   
  42.   
  43.             });  
  44.             $("#CountryId").change();  
  45.             $("#citylist").change(function () {  
  46.                 $("#districtlist").empty();  
  47.                 // alert("error");  
  48.                 var y = $(this).val();  
  49.                 $.ajax({  
  50.                     url: "/empcourse/getdistrictbyid",  
  51.                     data: { id: y },  
  52.                     success: function (res) {  
  53.                         $.each(res, function (i, e) {  
  54.                             if (e.Id == $("#disthidden").val()) {  
  55.                                 $("#districtlist").append("<option selected value='" + e.Id + "'>" + e.DistrictName + "<option>")  
  56.                             }  
  57.                             else  
  58.                             {  
  59.                                 $("#districtlist").append("<option value='" + e.Id + "'>" + e.DistrictName + "<option>")  
  60.   
  61.                             }  
  62.   
  63.                         });  
  64.                     }  
  65.                 });  
  66.   
  67.   
  68.             });  
  69.              
  70.             $("#citylist").change();  
  71.         });  
  72.         </script>  
  73. </head>  
  74. <body>  
  75.     <div>  
  76.         @using (Html.BeginForm())  
  77.         {  
  78.             <div>  
  79.                 <input type="hidden" value="@ViewBag.Cityid" id="cityidhidden" />  
  80.                 <input type="hidden" value="@ViewBag.dist" id="disthidden" />  
  81.                 Name:@Html.TextBoxFor(a => a.Name)  
  82.                 <br />  
  83.                 Country:@Html.DropDownList("CountryId")  
  84.                 <br />  
  85.                 City:<select id="citylist" name="CityId"></select>  
  86.                 <br />  
  87.                 District:<select id="districtlist" name="DistrictId"></select>  
  88.                 <br />  
  89.                 <input type="submit" />  
  90.             </div>  
  91.         }  
  92.   
  93.     </div>  
  94. </body>  
  95. </html>  
  96. in Edit function in controller empcourse  
  97.   
  98.  public class empcourseController : Controller  
  99.     {  
  100.         mycourseEntities db = new mycourseEntities();  
  101.   
  102.         // GET: empcourse  
  103.          
  104.         public ActionResult Edit(int id)  
  105.         {  
  106.             Employee old = db.Employees.Find(id);  
  107.             if (old != null)  
  108.             {  
  109. // country and city working  
  110. //district not working  
  111.                 int countryid = old.Destrict.City.Country.Id;  
  112.                 var vm = new Customemployee2();  
  113.                 vm.Name = old.Name;  
  114.                 ViewBag.CountryId = new SelectList(db.Countries.ToList(), "Id", "CountryName",countryid);  
  115.                 ViewBag.Cityid = old.Destrict.City.Id;  
  116.                 ViewBag.dist = old.DistrictId;  
  117.                 return View(vm);  
  118.             }  
  119. //getcitybyid retrieve city it call in ajax in jquery and it working  
  120.         public JsonResult getcitybyid(int id)  
  121.         {  
  122.             db.Configuration.ProxyCreationEnabled = false;  
  123.             return Json(db.Cities.Where(a => a.CountryId == id), JsonRequestBehavior.AllowGet);  
  124.         }  
  125. //getdistrictbyid retrieve district it call in ajax in jquery and it working  
  126.         public JsonResult getdistrictbyid(int id)  
  127.         {  
  128.             db.Configuration.ProxyCreationEnabled = false;  
  129.             return Json(db.Destricts.Where(a => a.CityId == id), JsonRequestBehavior.AllowGet);  
  130.         }  
  131.            
  132.         }  
  133. in model Customemployee2  
  134.   
  135.  public class Customemployee2  
  136.     {  
  137.         public string Name { get; set; }  
  138.         public int  DistrictId { get; set; }  
  139.   
  140.     }  
  141. }  

Answers (6)