public IEnumerable <CarIndexViewModel> Index()
{
try
{
using var db = new DEMOContext();
var v1 = db.Car.Include(x => x.Owner);
var sqlv1 = v1.ToQueryString();
var listv1 = v1.ToList();
var v2 = db.Car.Select(model => new CarIndexViewModel()
{
Id = model.Id,
OwnerName = model.Owner.Name,
Model = model.Model,
Year = model.Year,
Color = model.Color
});
var sqlv2 = v2.ToQueryString();
var listv2 = v2.ToList();
return(v2);
}
catch
{
throw;
}
}
public IEnumerable <UserIndexViewModel> Index()
{
try
{
using var db = new DEMOContext();
var v1 = db.User.Include(x => x.Car);
var sqlv1 = v1.ToQueryString();
var listv1 = v1.ToList();
var v2 = db.User.Select(model => new UserIndexViewModel()
{
Id = model.Id,
Name = model.Name,
Email = model.Email,
Cars = model.Car.Count
});
var sqlv2 = v2.ToQueryString();
var listv2 = v2.ToList();
return(listv2);
}
catch
{
throw;
}
}
public User Find(Guid id)
{
try
{
using var db = new DEMOContext();
return(db.User.Find(id));
}
catch
{
throw;
}
}
public bool Put(User model)
{
try
{
using var db = new DEMOContext();
db.User.Update(model);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public bool Post(Car model)
{
try
{
using var db = new DEMOContext();
db.Car.Add(model);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public IEnumerable <SelectItem> Select()
{
try
{
using var db = new DEMOContext();
return(db.User.Select(model => new SelectItem()
{
Value = model.Id.ToString(),
Text = model.Name
}).ToList());
}
catch
{
throw;
}
}
public CarDetailsViewModel Details(Guid id)
{
try
{
using var db = new DEMOContext();
return(db.Car.Where(x => x.Id == id).Select(model => new CarDetailsViewModel()
{
OwnerName = model.Owner.Name,
Model = model.Model,
Year = model.Year,
Color = model.Color
}).SingleOrDefault());
}
catch
{
throw;
}
}
public bool DeleteConfirmed(Guid id)
{
try
{
using var db = new DEMOContext();
var model = db.User.Find(id);
if (model == null)
{
return(false);
}
db.User.Remove(model);
db.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
public UserDetailsViewModel Details(Guid id)
{
try
{
using var db = new DEMOContext();
var v1 = db.User.Include(x => x.Car);
var sqlv1 = v1.ToQueryString();
var itemv1 = v1.FirstOrDefault(x => x.Id == id);
var v2 = db.User.Where(x => x.Id == id).Select(model => new UserDetailsViewModel()
{
Name = model.Name,
Email = model.Email,
Birthday = model.Birthday,
Cars = model.Car.Select(x => new UserDetailsViewModel.Car()
{
Model = x.Model,
Year = x.Year,
Color = x.Color
})
});
var sqlv2 = v2.ToQueryString();
var itemv2 = v2.SingleOrDefault();
return(itemv2);
}
catch
{
throw;
}
}
public DatingRepository(DEMOContext context)
{
_context = context;
}
public ValuesController(DEMOContext dbcontext)
{
db = dbcontext;
}
public Seed(DEMOContext context)
{
_context = context;
}
public ProductRepository(DEMOContext context)
{
this.context = context;
}
public AuthRepository(DEMOContext context)
{
_context = context;
}
