public List <Models.Domain.Files.File> GetAllPhotosById(int mealId, int userId)
{
List <Models.Domain.Files.File> files = null;
Action <SqlParameterCollection> inputParamDelegate = delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@MealId", mealId);
paramCollection.AddWithValue("@UserId", userId);
};
Action <IDataReader, short> singleRecMapper = delegate(IDataReader reader, short set)
{
Models.Domain.Files.File mealPhoto = new Models.Domain.Files.File();
if (files == null)
{
files = new List <Models.Domain.Files.File>();
}
int startingIndex = 0;
mealPhoto.Id = reader.GetSafeInt32(startingIndex++);
mealPhoto.UserId = reader.GetSafeInt32(startingIndex++);
mealPhoto.FileName = reader.GetSafeString(startingIndex++);
mealPhoto.FileTypeId = reader.GetSafeInt32(startingIndex++);
mealPhoto.DateAdded = reader.GetDateTime(startingIndex++);
mealPhoto.DateModified = reader.GetDateTime(startingIndex++);
files.Add(mealPhoto);
};
_dataProvider.ExecuteCmd("dbo.MealPhotos_Files_SelectByMealId", inputParamDelegate, singleRecMapper);
return(files);
}
public List <Models.Domain.Files.File> GetFiles(List <int> ids)
{
List <Models.Domain.Files.File> files = null;
Action <SqlParameterCollection> inputParamDelegate = delegate(SqlParameterCollection paramCollection)
{
SqlParameter fileIds = new SqlParameter("@Ids", SqlDbType.Structured);
if (ids != null && ids.Any())
{
IntIdTable idsTable = new IntIdTable(ids);
fileIds.Value = idsTable;
}
paramCollection.Add(fileIds);
};
Action <IDataReader, short> singleRecMapper = delegate(IDataReader reader, short set)
{
Models.Domain.Files.File filesList = new Models.Domain.Files.File();
if (files == null)
{
files = new List <Models.Domain.Files.File>();
}
int startingIndex = 0;
filesList.Id = reader.GetSafeInt32(startingIndex++);
filesList.UserId = reader.GetSafeInt32(startingIndex++);
filesList.FileName = reader.GetSafeString(startingIndex++);
filesList.FileTypeId = reader.GetSafeInt32(startingIndex++);
filesList.DateAdded = reader.GetDateTime(startingIndex++);
filesList.DateModified = reader.GetDateTime(startingIndex++);
files.Add(filesList);
};
_dataProvider.ExecuteCmd("dbo.Files_SelectByMultiIds", inputParamDelegate, singleRecMapper);
return(files);
}
