/// <summary>
/// Search the pictures for showing in the inspection report grid
/// </summary>
/// <param name="serviceOrderId">Service order id</param>
/// <param name="inspectionReportItemId">Inspection report id</param>
/// <returns>PictureGridModel</returns>
public static PictureGridModel SearchPictureGridInspectionReport(Guid serviceOrderId, Guid inspectionReportItemId)
{
PictureGridModel result = new PictureGridModel();
using (VestalisEntities context = new VestalisEntities())
{
//Retrieve the total number of pictures
result.PictureCount = context.Pictures.Where(data => data.ServiceOrderId == serviceOrderId
&& data.InspectionReportItemId == inspectionReportItemId && data.IsDeleted == false).Count();
//Get the pictures in a specific page
var tempResult = (from picture in context.Pictures
where picture.ServiceOrderId == serviceOrderId && picture.IsDeleted == false
&& picture.InspectionReportItemId == inspectionReportItemId
orderby picture.CreationDate
select new { picture.PictureId, picture.PictureFile }).Take(3).ToList();
//if exists data, the system makes the pagination
if (tempResult != null)
{
//set the paginated colletion
foreach (var tempPicture in tempResult)
{
PictureSearchModelItem pictureSearchModelItem = new PictureSearchModelItem();
pictureSearchModelItem.PictureId = tempPicture.PictureId;
Image pictureImage = ByteArrayToImage(tempPicture.PictureFile);
pictureSearchModelItem.SizeHeight = pictureImage.Height;
pictureSearchModelItem.SizeWidth = pictureImage.Width;
result.PictureList.Add(pictureSearchModelItem);
}
}
}
return result;
}
public DynamicDataRowValue()
{
Pictures = new PictureGridModel();
}
