// GET: Pages/LeadInfo/Details/5
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            var leadInfo = db.GetLeadInfoByProjectId(id).FirstOrDefault();

            if (leadInfo == null)
            {
                return(HttpNotFound());
            }
            ViewBag.Activities      = db.GetActivitiesByProjectId(id);
            ViewBag.ProjectContacts = db.GetProjectContactsByProjectID(id);
            ViewBag.ContactId       = repo.GetContactIdByProjectID(id ?? 0);
            ViewBag.Contacts        = new SelectList(db.GetContactsBySiteCoID(siteusercompanyid).ToList(), "ViewID", "Customer");
            ViewBag.Relationships   = new SelectList(repo.GetProjectRelationshipsBySiteCoID(siteusercompanyid).ToList(), "RelationshipID", "Relationship");
            var ProjectInfo = db.GetProjectInfoByProjectID(id).FirstOrDefault();
            var dbx         = DropboxConnection();

            if (dbx != null)
            {
                var full = await dbx.Users.GetCurrentAccountAsync();

                var list = await dbx.Files.ListFolderAsync(string.Empty);

                foreach (var item in list.Entries.Where(i => i.IsFolder))
                {
                    if (item.Name == ProjectInfo.Project)
                    {
                        var sublist = await dbx.Files.ListFolderAsync("/" + item.Name);

                        ViewBag.FilesList = sublist.Entries.Where(i => i.IsFile).ToList();
                    }
                }
            }
            else
            {
                if (db.ProjectFiles.Where(s => s.ProjectID == id).FirstOrDefault() != null)
                {
                    List <ProjectFilesBOL> files = new List <ProjectFilesBOL>();
                    foreach (var ProjectFile in db.ProjectFiles.Where(s => s.ProjectID == id))
                    {
                        ProjectFilesBOL mt = new ProjectFilesBOL();
                        mt.Name           = ProjectFile.File;
                        mt.FilePath       = "files/" + siteusercompanyid + "/" + id + "/" + ProjectFile.File;
                        mt.FileId         = ProjectFile.ProjectFileID;
                        mt.ClientModified = ProjectFile.UploadedDateTime == null ? DateTime.Now : ProjectFile.UploadedDateTime.Value;
                        files.Add(mt);
                    }
                    if (files.Count > 0)
                    {
                        ViewBag.FilesList   = files;
                        ViewBag.LocalFolder = true;
                    }
                }
            }
            return(View(leadInfo));
        }