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