public Data.Model.Request GetByID(int id) { var x = _context.Requests.Include(r => r.User).ThenInclude(r => r.CarModel).Where(r => r.RequestID == id).SingleOrDefault(); var model = new Data.Model.Request() { RequestID = x.RequestID, DateOfRequest = x.DateOfRequest, Date = x.DateOfRequest.Day + "." + x.DateOfRequest.Month + "." + x.DateOfRequest.Year, UserID = x.UserID, UserNameLastName = x.User.FirstName + " " + x.User.LastName, UserCar = x.User.CarModel.CarModelName, CarServiceID = x.CarServiceID, StatusID = x.RequestStatusID, }; var ServicesList = _context.requestServices.Include(s => s.Service).Where(s => s.RequestID == x.RequestID).ToList(); model.ListOfRequestedServices = new List <string>(); foreach (var s in ServicesList) { model.ListOfRequestedServices.Add(s.Service.ServiceName); } return(model); }
public List <Data.Model.Request> Get(RequestSearch request) { var list = _context.Requests.Include(r => r.User).ThenInclude(r => r.CarModel).Where(r => r.RequestStatusID == 1 && request.carserviceID == r.CarServiceID).OrderBy(r => r.DateOfRequest).ToList(); var modelList = new List <Data.Model.Request>(); foreach (var x in list) { var model = new Data.Model.Request() { RequestID = x.RequestID, DateOfRequest = x.DateOfRequest, Date = x.DateOfRequest.Day + "." + x.DateOfRequest.Month + "." + x.DateOfRequest.Year, UserID = x.UserID, UserNameLastName = x.User.FirstName + " " + x.User.LastName, UserCar = x.User.CarModel.CarModelName, CarServiceID = x.CarServiceID, StatusID = x.RequestStatusID, }; var ServicesList = _context.requestServices.Include(s => s.Service).Where(s => s.RequestID == x.RequestID).ToList(); model.ListOfRequestedServices = new List <string>(); foreach (var s in ServicesList) { model.ListOfRequestedServices.Add(s.Service.ServiceName); } modelList.Add(model); } return(modelList); }
public Data.Model.Request Insert(RequestUpsert request) { var entity = _mapper.Map <Database.Request>(request); _context.Requests.Add(entity); _context.SaveChanges(); var x = _context.Requests.Include(r => r.User).ThenInclude(r => r.CarModel).Where(r => r.RequestID == entity.RequestID).SingleOrDefault(); foreach (var o in request._selectedServicesList) { _context.requestServices.Add(new Database.RequestServices() { RequestID = x.RequestID, ServiceID = o.ServiceID }); _context.SaveChanges(); } var model = new Data.Model.Request() { RequestID = x.RequestID, DateOfRequest = x.DateOfRequest, Date = x.DateOfRequest.Day + "." + x.DateOfRequest.Month + "." + x.DateOfRequest.Year, UserID = x.UserID, UserNameLastName = x.User.FirstName + " " + x.User.LastName, UserCar = x.User.CarModel.CarModelName, CarServiceID = x.CarServiceID, StatusID = x.RequestStatusID, }; var ServicesList = _context.requestServices.Include(s => s.Service).Where(s => s.RequestID == x.RequestID).ToList(); model.ListOfRequestedServices = new List <string>(); foreach (var s in ServicesList) { model.ListOfRequestedServices.Add(s.Service.ServiceName); } return(model); }