public ResponseInfo <ResponsePictureList <string> > GetPicturesList(RequestPictureList data)
{
ResponseInfo <ResponsePictureList <string> > response = new ResponseInfo <ResponsePictureList <string> >();
ResponsePictureList <byte[]> resultDb = new ResponsePictureList <byte[]>();
try
{
response.ResponseData = new ResponsePictureList <string>();
resultDb.pictures = EPODDAL.GetPicturesList(data);
response.ResponseData.pictures = HelperUtil.GeneratePictureListBase64String(resultDb.pictures);
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public List <PictureList <byte[]> > GetPicturesList(RequestPictureList data)
{
List <PictureList <byte[]> > ResultSet = new List <PictureList <byte[]> >();
using (IDbConnection connection = GetOpenConnection())
{
try
{
string sql = @"SELECT A.TVPictureID,A.PictureID,B.PictureSequence,B.PictureName
FROM TruckVisualPictures A
INNER JOIN MasterPictures B ON A.PictureID = B.PictureID
WHERE a.JobOrderID = @JobOrderID
AND b.IsActive = 1
";
ResultSet = connection.Query <PictureList <byte[]> >(sql, new { JobOrderID = data.JobOrderID }).ToList();
}
catch (Exception ex)
{
throw ex;
}
}
return(ResultSet);
}
