public static PhotoAlbumBO PhotoAlbumDOtoBO(PhotoAlbumDO from)
{
PhotoAlbumBO to = new PhotoAlbumBO();
to.PhotoAlbumID = from.PhotoAlbumID;
to.PhotoID = from.PhotoID;
to.AlbumID = from.AlbumID;
return(to);
}
public List <PhotoAlbumDO> ReadAllJunctions()
{
List <PhotoAlbumDO> photoAlbumsList = new List <PhotoAlbumDO>();
SqlConnection connectionToSql = null;
SqlCommand storedProcedure = null;
try
{
connectionToSql = new SqlConnection(_connectionString);
storedProcedure = new SqlCommand("READ_ALL_JUNCTIONS", connectionToSql);
storedProcedure.CommandType = System.Data.CommandType.StoredProcedure;
connectionToSql.Open();
SqlDataReader sqlDataReader = storedProcedure.ExecuteReader();
while (sqlDataReader.Read())
{
PhotoAlbumDO photoAlbum = new PhotoAlbumDO();
photoAlbum.PhotoAlbumID = (long)sqlDataReader["PhotoAlbumID"];
photoAlbum.PhotoID = (int)sqlDataReader["PhotoID"];
photoAlbum.AlbumID = (int)sqlDataReader["AlbumID"];
photoAlbumsList.Add(photoAlbum);
}
}
catch (Exception ex)
{
LogFile.DataFile(ex: ex);
throw ex;
}
finally
{
if (connectionToSql != null)
{
connectionToSql.Close();
connectionToSql.Dispose();
}
}
return(photoAlbumsList);
}
