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);
}
