// GET: Submissions/Create
//public IActionResult Create(int id)
public ViewResult Create(int id)
{
ViewBag.Title = "Submission Page";
ViewBag.Header = "Add Submission Details";
var referral = _context.Referral
.Include(s => s.ReferralGender)
.Include(s => s.ReferralLocalAuthority)
.Where(i => i.ReferralId == id).Single();
var submission = new Submission();
var servicesList = _context.Service
.OrderBy(s => s.ServiceName)
.ToList();
var regionsList = _context.Region.ToList();
List <Region> RegionsList = new List <Region>();
foreach (var item in regionsList)
{
var Regionexists = (from a in _context.Service
.Where(s => s.ServiceRegionId == item.RegionId)
select new { a.ServiceRegionId }).FirstOrDefault();
if (Regionexists != null)
{
RegionsList.Add(item);
}
}
//Creating the ViewModel
SubmissionIndexData submissionIndexData = new SubmissionIndexData()
{
MVReferralId = referral.ReferralId,
MVReferralName = referral.ReferralName,
MVGender = referral.ReferralGender.GenderName,
MVAge = referral.ReferralAge,
MVLocalAuthority = referral.ReferralLocalAuthority.LocalAuthorityName,
MVDateReceived = referral.ReferralReceivedDate,
Submission = submission,
Services = servicesList,
regions = RegionsList
};
ViewData["Services.ServiceId"] = new SelectList(servicesList, "ServiceId", "ServiceName");
return(View(submissionIndexData));
}
public IActionResult Create(Submission submission, SubmissionIndexData submissionIndexData)
{
if (ModelState.IsValid)
{
//int count = submissionIndexData.Submission.IsChecked.Count;
if (submissionIndexData.Submission != null)
{
int count = submissionIndexData.Submission.IsChecked.Count;
// string result = string.Join(",", submissionIndexData.Submission.IsChecked);
string result = string.Join(",", submissionIndexData.Submission.IsChecked);
var subrefid = submissionIndexData.MVReferralId;
for (int i = 0; i < count; i++)
{
var submissions = new Submission[]
{
new Submission {
SubmissionReferralId = subrefid, SubmissionServiceId = Int32.Parse(submissionIndexData.Submission.IsChecked[i])
}
};
foreach (Submission s in submissions)
{
try
{
//set initial status of submission to 'Under Consideration by Service //
s.SubmissionStatusId = 8;
_context.Submission.Add(s);
}
catch (Exception)
{
throw;
}
}
}
_context.SaveChanges();
}
return(RedirectToAction("Index", "Referrals"));
}
else
{
return(RedirectToAction("Index", "Referrals"));
}
}
