// [Authority(authority =CAauthority.restaurant)] public ActionResult RestaurantCreate() { //var SelectPV = db.CanadaPV.GroupBy(c => c.pvId).Select(g => g.FirstOrDefault()).ToList(); //int Province = SelectPV.FirstOrDefault().pvId; //var SelectCity = db.CanadaCities.Where(c => c.pvId == Province).ToList(); List <SelectListItem> PV = new List <SelectListItem>(); PV.AddRange(db.CanadaPV.Select(x => new SelectListItem { Text = x.province, Value = x.pvId.ToString() }).ToList()); string Province = PV.FirstOrDefault().Value; List <SelectListItem> CT = new List <SelectListItem>(); CT.AddRange(db.CanadaCities.Where(c => c.pvId.ToString() == Province).Select(x => new SelectListItem { Text = x.city, Value = x.cityId.ToString() }).ToList()); var vm = new vRestaurantVM { cId = (int)Session[CDictionary.SK_LOGINED_USER_ID], province = PV, city = CT }; return(View(vm)); }
public ActionResult RestaurantCreate(vRestaurantVM vm) { if (ModelState.IsValid) { var user = db.Customer.FirstOrDefault(c => c.cId == vm.cId); //get authority user.cAuthority = CAauthority.restaurant.GetHashCode(); db.Restaurant.Add(new Restaurant { cId = vm.cId, province = vm.RProvince, city = vm.RCity, }); db.SaveChanges(); return(RedirectToAction("ProductCreate", "Product")); } else { List <SelectListItem> PV = new List <SelectListItem>(); PV.AddRange(db.CanadaPV.Select(x => new SelectListItem { Text = x.province, Value = x.pvId.ToString() }).ToList()); string Province = PV.FirstOrDefault().Value; List <SelectListItem> CT = new List <SelectListItem>(); CT.AddRange(db.CanadaCities.Where(c => c.pvId.ToString() == Province).Select(x => new SelectListItem { Text = x.city, Value = x.cityId.ToString() }).ToList()); PV.First(x => x.Value == vm.RProvince); vm.province = PV; CT.First(x => x.Value == vm.RCity); vm.city = CT; } return(View(vm)); }