public SchedulingEntity[] GetSchedulingCompany(int companyId, int schedulingId = 0) { List <SchedulingEntity> arrayOfSchedulingEntity = new List <SchedulingEntity>(); using (Petz_dbEntities db = new Petz_dbEntities()) { var petScheduling = (from s in db.petz_Pet_Scheduling join a in db.petz_Company_Address on s.company_address_id equals a.company_address_id where a.company_id == companyId && s.scheduling_date_start >= _filterStart && s.scheduling_date_start <= _filterEnd && s.scheduling_id == (schedulingId == 0 ? s.scheduling_id : schedulingId) select new { s.scheduling_id, s.scheduling_comments, s.scheduling_date_start, s.scheduling_date_end, s.pet_id, s.client_id, a.company_id, a.address_id, s.service_id, s.employees_id, s.status_id } ).ToArray(); foreach (var ps in petScheduling) { SchedulingEntity entity = new SchedulingEntity { Id = ps.scheduling_id, CompanyId = ps.company_id, Comments = ps.scheduling_comments, DateStart = ps.scheduling_date_start, DateEnd = ps.scheduling_date_end, AddressId = ps.address_id, Address = _addressController.GetAddress(ps.address_id), Pet = _petController.GetPet(ps.pet_id), Client = _clientController.GetClient(ps.client_id), Status = _statusController.GetStatusCompany(ps.company_id, ps.status_id), Company = _companyController.GetCompany(ps.company_id) }; if (ps.service_id.HasValue) { entity.Service = _serviceController.GetService(ps.service_id.Value); } if (ps.employees_id.HasValue) { entity.Employee = _companyController.GetEmployees(ps.employees_id.Value); } arrayOfSchedulingEntity.Add(entity); } } return(arrayOfSchedulingEntity.ToArray()); }
public ClientEntity[] GetCompanyClient(int id, int clientId = 0) { List <ClientEntity> arrayOfClientEntity = new List <ClientEntity>(); ClientsController controller = new ClientsController(); Petz_dbEntities db = new Petz_dbEntities(); int[] idsByService = (from s in db.petz_Pet_Scheduling join a in db.petz_Company_Address on s.company_address_id equals a.company_address_id where a.company_id == id && s.date_delete == null && s.client_id == (clientId <= 0 ? s.client_id : clientId) select s.client_id) .Distinct() .ToArray(); int[] idsByFavorite = db.petz_Client_Company .Where(x => x.company_id == id && x.client_id == (clientId <= 0 ? x.client_id : clientId)) .Select(x => x.client_id) .Distinct() .ToArray(); int[] ids = idsByService.Concat(idsByFavorite) .Distinct() .ToArray(); foreach (int i in ids) { arrayOfClientEntity.Add(controller.GetClient(i)); } return(arrayOfClientEntity.ToArray()); }
public RatingHistoric[] GetPetRatingHistoric(int id) { ClientsController controller = new ClientsController(); return(GetPetRating(id) .Select(x => new RatingHistoric() { Comments = x.Comments, Date = x.Date, Id = x.Id, InsertByName = controller.GetClient(x.InsertByClientId).Name, RatingValue = x.RatingValue }).ToArray()); }
public ClientEntity GetClient(int id) { ClientsController controller = new ClientsController(); return(controller.GetClient(id)); }