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