// 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));
        }
Esempio n. 2
0
        // GET: Common/Calls/Create
        public ActionResult Create(int?contactid, int?projectid)
        {
            BOL.Repository.CommonRepository repo = new BOL.Repository.CommonRepository();
            if (projectid.HasValue)
            {
                contactid = repo.GetContactIdByProjectID(projectid.Value);
            }

            ViewBag.Contacts  = new SelectList(db.GetContactsBySiteCoID(siteusercompanyid), "ViewID", "Customer", contactid);
            ViewBag.Purpose   = new SelectList(db.CoCallPurposes.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.CallPurposeOrder), "CallPurposeID", "PurposeName");
            ViewBag.Resources = new SelectList(db.SiteUsers.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.UserDisplayName), "SiteUserID", "UserDisplayName", siteuserid);
            ViewBag.Status    = new SelectList(repo.GetActivityStatus(siteusercompanyid), "StatusID", "StatusName");

            var model = new Models.CallModels.NewCall();

            var contactData = FetchContactData(contactid ?? 0);

            model.Phone  = contactData.Item1;
            model.Mobile = contactData.Item2;
            ViewBag.Jobs = new SelectList(contactData.Item3.Select(p => new { p.ViewID, p.Project }), "ViewID", "Project", projectid);
            ViewBag.SelectedContactID = contactid;

            return(View(model));
        }
        public ActionResult Create(int?contactid, int?projectid)
        {
            if (projectid.HasValue)
            {
                BOL.Repository.CommonRepository repo = new BOL.Repository.CommonRepository();
                contactid = repo.GetContactIdByProjectID(projectid.Value);
            }

            ViewBag.Contacts         = new SelectList(db.GetContactsBySiteCoID(siteusercompanyid), "ViewID", "Customer", contactid);
            ViewBag.Creator          = new SelectList(db.SiteUsers.Where(p => p.SiteCoID == siteusercompanyid).OrderBy(p => p.UserDisplayName), "SiteUserID", "UserDisplayName", siteuserid);
            ViewBag.IsFieldsReadOnly = false;

            var model = new Models.NoteModels.NewNote()
            {
                Date = DateTime.Now
            };

            var contactData = FetchContactData(contactid ?? 0);

            ViewBag.Jobs = new SelectList(contactData.Item1.Select(p => new { p.ViewID, p.Project }), "ViewID", "Project", projectid);
            ViewBag.SelectedContactID = contactid;

            return(View(model));
        }
        public async Task <ActionResult> Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }

            var jobInfo = db.GetProjectInfoByProjectID(id).FirstOrDefault();

            if (jobInfo == null)
            {
                return(HttpNotFound());
            }
            var job = db.ProjectInfo.Where(x => x.ProjectID == id).FirstOrDefault();

            if (job != null)
            {
                if (!string.IsNullOrEmpty(job.AcctJobID))
                {
                    ViewBag.IsSynced = true;
                }
            }
            ViewBag.id = id;
            // ViewBag.Activities = db.GetProjectInfoActivitiesByProjectID(id).ToList();
            //ViewBag.ProjectContacts = db.GetProjectContactsByProjectID(id).ToList();
            //ViewBag.Parts = db.GetJobInfoPartsByProjectID(id).ToList();
            //ViewBag.Cor = db.GetProjectCorByProjectID(id).ToList();
            //ViewBag.Work = db.GetProjectWorkByProjectID(id).ToList();
            // ViewBag.PunchList = db.GetProjectPunchListByProjectID(id).ToList();
            ViewBag.Milestones = db.GetProjectMilestonesListByProjectID(id).ToList();
            //ViewBag.Por = db.GetProjectPorListByProjectID(id).ToList();
            //ViewBag.Deliviries = db.GetProjectDeliveryListByProjectID(id).ToList();
            //ViewBag.Sales = db.GetProjectSoByProjectID(id).ToList();
            ViewBag.Contacts      = new SelectList(db.GetContactsBySiteCoID(siteusercompanyid).ToList(), nameof(GetContactsBySiteCoID_Result.ViewID), nameof(GetContactsBySiteCoID_Result.Customer));
            ViewBag.Relationships = new SelectList(repo.GetProjectRelationshipsBySiteCoID(siteusercompanyid).ToList(), nameof(CoProjectRelationships.RelationshipID), nameof(CoProjectRelationships.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(jobInfo));
        }