// 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)); }
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)); }
public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } var corInfo = db.GetCorInfoByCorID(id).FirstOrDefault(); var cor = db.ProjectCor.Where(p => p.CorID == id).FirstOrDefault(); if (corInfo == null || cor == null) { return(HttpNotFound()); } ViewBag.Scope = cor.Reason; ViewBag.Additions = db.GetCorInfoPartsAddedByCorID(id).ToList(); ViewBag.Removals = db.GetCorInfoPartsRemovedByCorID(id).ToList(); int projectId = cor.ProjectID.HasValue ? cor.ProjectID.Value : 0; ViewBag.ProjectID = projectId; ViewBag.IsApproved = cor.Approved; var ProjectInfo = db.GetProjectInfoByProjectID(projectId).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 == projectId).FirstOrDefault() != null) { List <ProjectFilesBOL> files = new List <ProjectFilesBOL>(); foreach (var ProjectFile in db.ProjectFiles.Where(s => s.ProjectID == projectId)) { ProjectFilesBOL mt = new ProjectFilesBOL(); mt.Name = ProjectFile.File; mt.FilePath = "files/" + siteusercompanyid + "/" + projectId + "/" + 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(corInfo)); }