public CompaniesEntity[] GetClientCompanies(int id)
{
if (id <= 0)
{
throw new ArgumentNullException("id", "ID is null");
}
CompaniesController controller = new CompaniesController();
using (Petz_dbEntities db = new Petz_dbEntities())
{
int[] company = db.petz_Client_Company
.Where(x => x.client_id == id)
.Select(x => x.company_id)
.ToArray();
List <CompaniesEntity> array = new List <CompaniesEntity>();
foreach (int c in company)
{
array.Add(controller.GetCompany(c));
}
return(array.ToArray());
}
}
public HistoricEntity[] GetPetHistoric(int id)
{
if (id <= 0)
{
throw new ArgumentNullException("id", "ID is null");
}
var arrayOfHistoricEntity = new List <HistoricEntity>();
CompaniesController companyController = new CompaniesController();
using (Petz_dbEntities db = new Petz_dbEntities())
{
var arrayHistoric = db.petz_Pet_Historic.Where(x => x.pet_id == id).ToArray();
foreach (var hist in arrayHistoric)
{
HistoricEntity entity = new HistoricEntity {
Comments = hist.history_comments
};
if (hist.history_date != null)
{
entity.Date = hist.history_date.Value;
}
entity.Id = hist.history_id;
entity.Employee = companyController.GetEmployees(hist.employees_id);
arrayOfHistoricEntity.Add(entity);
}
}
return(arrayOfHistoricEntity.ToArray());
}
