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