// 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)); }
// 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)); }