public static int GetFotoCount(int AlbumID)
{
DataSetVepAdminTableAdapters.PhotosTableAdapter taAlb = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
DataTable dtFoto = taAlb.GetFotoByAlbumID(AlbumID);
return(dtFoto.Rows.Count);
}
//ritorna l'elenco delle foto ordinate per posizione nell'album
public static DataTable GetPhotosByPos(int AlbumID)
{
DataSetVepAdminTableAdapters.PhotosTableAdapter taPhotos = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
DataTable dtPhotos = taPhotos.GetPhotosByPos(AlbumID);
return(dtPhotos);
}
protected void AggiungiFoto(object sender, EventArgs e)
{
int AlbumID = int.Parse((string)Request.QueryString["AlbumID"]);
string caption = PhotoCaption.Text;
byte[] photoBytes = PhotoFile.FileBytes;
DataSetVepAdminTableAdapters.PhotosTableAdapter taphotos = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
DataTable dtphotos = taphotos.GetFotoByAlbumID(AlbumID);
int ordine = dtphotos.Rows.Count + 1;
PhotoManager.AddPhoto(AlbumID, caption, photoBytes, ordine);
}
//GetPhotoSliderHome
public static DataTable GetPhotoSliderHome()
{
var taAlbum = new DataSetVepAdminTableAdapters.AlbumsTableAdapter();
DataTable dtAlbum = taAlbum.GetAlbumByCaption("HOME");
var taPhotos = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
if (dtAlbum.Rows.Count == 0)
{
return(null);
}
DataTable dtPhotos = taPhotos.GetPhotosByPos(int.Parse(dtAlbum.Rows[0]["AlbumID"].ToString()));
return(dtPhotos);
}
protected void ButtonUploadFoto_Click(object sender, EventArgs e)
{
if (!_isRefresh)
{
int AlbumID = int.Parse((string)Request.QueryString["AlbumID"]);
string caption = PhotoCaption.Text;
byte[] photoBytes = PhotoFile.FileBytes;
//devo recuperare tutte le foto dell'album per trovare la prima posizione disponibile
DataSetVepAdminTableAdapters.PhotosTableAdapter taPhotos = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
DataTable dtPhotos = taPhotos.GetFotoByAlbumID(AlbumID);
int ordine = dtPhotos.Rows.Count + 1;
PhotoManager.AddPhoto(AlbumID, caption, photoBytes, ordine);
lvFoto.DataBind();
btnChangePos.Visible = true;
}
}
protected void change_pos(object sender, EventArgs e)
{
string strarrPos = hdfArrPos.Value;
string albId = Request.QueryString["AlbumID"];
string[] splitted = strarrPos.Split(new string[] { "&" }, StringSplitOptions.RemoveEmptyEntries);
DataSetVepAdminTableAdapters.PhotosTableAdapter taPhoto = new DataSetVepAdminTableAdapters.PhotosTableAdapter();
DataTable dtPhotos = taPhoto.GetFotoByAlbumID(int.Parse(albId));
for (int i = 0; i < splitted.Length; i++)
{
int PhotoId = 0;
for (int j = 0; j < dtPhotos.Rows.Count; j++)
{
if (dtPhotos.Rows[j]["ordine"].ToString() == splitted[i].ToString())
{
PhotoId = int.Parse(dtPhotos.Rows[j]["PhotoID"].ToString());
int ret = taPhoto.UpdateOrdineFoto(i + 1, PhotoId);
}
}
}
lvFoto.DataBind();
}
