public static LABStudy GetLatestLABStudyByIdCustomerProspect(Guid idCustomerProspect, LABStudy.StatusEnum status)
{
using (UpsilabEntities context = new UpsilabEntities())
{
string statusEnum = status.ToString();
return context.LABStudy.Where(study => study.idCustomer == idCustomerProspect && study.Status.Equals(statusEnum))
.OrderByDescending(study => study.DateUpdated)
.FirstOrDefault();
var CompletedLABQuery = ComletedLabCompiledQuery.Invoke(context, new CompletedLabStudyByIdCustomerProspect
{
idCustomer = idCustomerProspect,
clabcompletedStatus = LABStudy.StatusEnum.Completed.ToString(),
clabsentToCoffreFort = LABStudy.StatusEnum.SentToCoffreFort.ToString()
});
return CompletedLABQuery.AsEnumerable().FirstOrDefault();
}
}
