public JsonResult GetData() { using (var dbContext = new TraineeEntities()) { List <UserDetail> userDetails = dbContext.UserDetails.Where(x => x.IsActive == true).ToList(); List <CarDetail> carDetails = dbContext.CarDetails.ToList(); List <newModel> userViewModels = new List <newModel>(); foreach (var user in userDetails) { var data = new newModel { UserId = user.UserId, FullName = user.FullName, UserEmail = user.UserEmail, CivilIdNumber = user.CivilIdNumber, }; var cardetails = string.Join(",", carDetails.Where(x => x.UserId == user.UserId).Select(y => y.CarLicense).ToList()); data.CarLicense = cardetails; userViewModels.Add(data); } userViewModels = userViewModels.Where(x => x.CarLicense != "").ToList(); return(Json(new { data = userViewModels }, JsonRequestBehavior.AllowGet)); } }
public bool New(newModel model) { return(true); }