public async Task <bool> Insert(ProjectProposal projectProposal) { try { var company = await _context.Companies .FirstOrDefaultAsync(x => x.CompanyID == projectProposal.Company.CompanyID); if (company == null) { return(false); } projectProposal.Company = company; if (projectProposal.ExternalMentor.MentorID != 0) { var externalMentor = await _context.ExternalMentors.Include(c => c.Contacts) .Where(x => x.CompanyID == projectProposal.ExternalMentor.CompanyID && x.MentorID == projectProposal.ExternalMentor.MentorID).FirstOrDefaultAsync(); var exMen = projectProposal.ExternalMentor; if (externalMentor != null) { projectProposal.ExternalMentor = externalMentor; } foreach (var contact in exMen.Contacts) { if (contact.SerialNumber == 0) { projectProposal.ExternalMentor.Contacts.Add(contact); } } } foreach (var subj in projectProposal.Subjects) { var pom = await _context.ScientificAreas .FirstOrDefaultAsync(x => x.ScientificAreaID == subj.ScientificArea.ScientificAreaID); if (pom == null) { return(false); } subj.ScientificArea = pom; } projectProposal.ProposalDate = DateTime.Now; await _context.ProjectProposals.AddAsync(projectProposal); await _context.SaveChangesAsync(); return(true); } catch (Exception ex) { Debug.WriteLine(">>>>>>>> " + ex.Message); return(false); } }
public IActionResult Detail(Guid id) { ProjectProposal q = null; if (id != Guid.Empty) { q = _context.ProjectProposal.FirstOrDefault(x => x.Id == id); } if (q == null) { q = new ProjectProposal(); q.Id = Guid.NewGuid(); } return(View(q)); }
public async Task <Company> GetByProjectProposalId(long projectProposalId) { try { ProjectProposal proposal = await context.Set <ProjectProposal>().Include(x => x.Company).FirstOrDefaultAsync(x => x.ProjectProposalID == projectProposalId); return(await context.Set <Company>() .Include(x => x.Contacts) .Include(x => x.Locations) .Include(x => x.Mentors) .FirstOrDefaultAsync(x => x.CompanyID == proposal.Company.CompanyID)); } catch (Exception ex) { Debug.WriteLine(">>>> " + ex.Message); return(null); } }
public IActionResult ProposalPost(ProjectProposal model) { if (ModelState.IsValid) { ProjectProposal entity = new ProjectProposal { ProjectExplanation = model.ProjectExplanation, ProjectName = model.ProjectName, SenderDate = model.SenderDate, SenderMail = model.SenderMail, SenderName = model.SenderName, SenderSurname = model.SenderSurname }; _context.ProjectProposal.Add(entity); _context.SaveChanges(); _sysFunction.SendSmsAdmins($"Yeni Proje Önerisi: Proje Name:{entity.ProjectName},\n {entity.SenderName} {entity.SenderSurname} {entity.SenderMail}"); return(RedirectToAction("ContactOk", "Contact")); } return(View(model)); }