using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
using System.Data;
using System.Text.RegularExpressions;

namespace UpdatePhoto
{
    public partial class Upload : System.Web.UI.Page
    {
        public string site;
        public string prevSite;
        public string page;
        public string prevPage;
        public string subPage;
        public string prevSubPage;
        public string prevUrl;
        public string groupName;
        public string mediaDesc;
        public int mediaIdentifier;
        public string action;

        public OleDbConnection conn;
        public DataSet ds;
        public OleDbDataAdapter adapter = new OleDbDataAdapter();

        protected void Page_Load(object sender, EventArgs e)
        {
            site = Request.QueryString["site"];
            page = Request.QueryString["page"];
            subPage = Request.QueryString["subPage"];
            action = Request.QueryString["action"];
            mediaIdentifier = Convert.ToInt32(Request.QueryString["index"]);

            if (IsPostBack)
            {
                prevUrl = Request.UrlReferrer.PathAndQuery.ToString();
                btnSubmit.PostBackUrl = prevUrl;

                List<MediaData> selectMedia = null;

                //get Media from Database via getMediaFromDb Method
                selectMedia = getMediaFromDb(site, page, subPage);

                string lastGroupName = selectMedia[0].GroupName;
                groupName = selectMedia[0].GroupName;

                divWriteMedia.InnerHtml = "";

                divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "<fieldset><legend><b>" + groupName + "</b></legend>";
                for (int i = 0; i < selectMedia.Count; i++)
                {
                    groupName = selectMedia[i].GroupName;

                    if (selectMedia[i].GroupName == lastGroupName)
                    {
                        if (selectMedia[i].MediaType == MediaType.Photo)
                        {
                            int index = selectMedia[i].FileInfoList[0].IndexOfFile;
                            string fileExtension = selectMedia[i].FileInfoList[0].FileExtension;

                            divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "<img class='product' src='pictures/" + index + fileExtension + "' width='60'>";
                            divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "<a href='updatePhoto.aspx?site=" + site + "&page=" + page + "&subPage=" + subPage + "&action=delete&index=" + index + "'><img class='stacked' src='images/delete.jpg' border='0' alt='Click to Delete'></a>";
                            divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "<a href='updatePhoto.aspx?site=" + site + "&page=" + page + "&subPage=" + subPage + "&action=edit&index=" + index + "'><img class='stacked' src='images/edit.jpg' border='0' alt='Click to Edit'></a>";
                        }
                        groupName = lastGroupName;
                    }
                    else
                    {
                        divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "</fieldset>";
                        lastGroupName = selectMedia[i].GroupName;
                        i--;
                        divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "<fieldset><legend><b>" + groupName + "</b></legend>";
                    }
                }
                //write end of fieldset once last group is done
                divWriteMedia.InnerHtml = divWriteMedia.InnerHtml + "</fieldset>";
            }
            else
            {
                lblStatus.Text = "Upload a File";
            }

        }

        protected void btnSubmit_Click(object sender, EventArgs e)
        {
            if (file1.HasFile)
            {
                string filepath = file1.PostedFile.FileName;
                string pat = @"\\(?:.+)\\(.+)\.(.+)";
                Regex r = new Regex(pat);
                //run
                Match m = r.Match(filepath);
                string file_ext = m.Groups[2].Captures[0].ToString();
                string filename = m.Groups[1].Captures[0].ToString();
                string file = filename + "." + file_ext;

                //set mediaIdentifier equal to lastIndex in Database


                //save the file to the server
                file1.PostedFile.SaveAs(Server.MapPath(".\\uploads\\") + file);
                lblStatus.Text = "File Saved to: " + Server.MapPath(".\\uploads\\") + file;
            }
        }

        public List<MediaData> getMediaFromDb(string site, string page, string subPage)
        {
            List<MediaData> mediaList = new List<MediaData>();
            List<IndividualFileInfo> fileDetailsList = new List<IndividualFileInfo>();
            MediaData mediaInformation = new MediaData();
            IndividualFileInfo mediaFileInformation = new IndividualFileInfo();

            OleDbDataReader drMedia = null;
            string dbPath = Server.MapPath(".\\database\\tpk_db.mdb");
            OleDbConnection conn = new OleDbConnection();

            conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + dbPath;
            conn.Open();

            OleDbCommand cmd = new OleDbCommand();
            OleDbCommand cmdGroups = new OleDbCommand();
            cmd.Connection = conn;

            site = "Custom";
            page = "Invitations";
            subPage = "Parties";

            cmd.CommandText = string.Format("SELECT * FROM tblMedia WHERE site ='{0}' AND page='{1}' AND subPage='{2}'", site, page, subPage);
            drMedia = cmd.ExecuteReader();

            while (drMedia.Read())
            {
                string groupNameSelection = mediaInformation.GroupName = drMedia["grpName"].ToString();

                int fileIndexSelection = mediaFileInformation.IndexOfFile = Convert.ToInt32(drMedia["index"]);
                string fileNameSelection = mediaFileInformation.FileName = drMedia["filename"].ToString();
                string fileExtensionSelection = mediaFileInformation.FileExtension = drMedia["extName"].ToString();
                string fileDescriptionSelection = mediaFileInformation.FileDescription = drMedia["description"].ToString();

                fileDetailsList = mediaInformation.FileInfoList = new List<IndividualFileInfo>();
                fileDetailsList.Add(mediaFileInformation);

                string mediaDataRaw = Convert.ToString(drMedia["type"]);
                mediaInformation.MediaType = (MediaType)Enum.Parse(typeof(MediaType), mediaDataRaw, true);

                mediaList.Add(mediaInformation);
            }

            mediaList.Sort(delegate(MediaData m1, MediaData m2) { return m1.GroupName.CompareTo(m2.GroupName); });

            return mediaList;
        }
    }

    public struct MediaData
    {
        private string groupName;
        private MediaType mediaType;
        private List<IndividualFileInfo> fileInfoList;

        public MediaType MediaType
        {
            get
            {
                return mediaType;
            }

            set
            {
                mediaType = value;
            }
        }

        public string GroupName
        {
            get
            {
                return groupName;
            }

            set
            {
                groupName = value;
            }
        }

        public List<IndividualFileInfo> FileInfoList
        {
            get
            {
                return fileInfoList;
            }

            set
            {
                fileInfoList = value;
            }
        }
    }

    public struct IndividualFileInfo
    {
        private int indexOfFile;
        private string fileName;
        private string fileExtension;
        private string fileDescription;

        public int IndexOfFile
        {
            get
            {
                return indexOfFile;
            }

            set
            {
                indexOfFile = value;
            }
        }

        public string FileName
        {
            get
            {
                return fileName;
            }

            set
            {
                fileName = value;
            }
        }

        public string FileExtension
        {
            get
            {
                return fileExtension;
            }

            set
            {
                fileExtension = value;
            }
        }

        public string FileDescription
        {
            get
            {
                return fileDescription;
            }

            set
            {
                fileDescription = value;
            }
        }
    }

    public enum MediaType
    {
        Photo,
        Video,
        Audio
    }
}