public ActionResult AddPrisoner(PrisonerViewModel model)
{
var list = _db.CategoriesOfCrimes.ToList();
ViewBag.KatList = new SelectList(list, "CategoryOfCrime_Id", "NameOfCategory");
if (ModelState.IsValid)
{
var prisoner = new Prisoners
{
PrisonerName = model.PrisonerName,
PrisonerSurname = model.PrisonerSurname,
Pesel = model.Pesel,
Sex = model.Sex
};
var wyrok = new Judgements
{
FK_Judgements_CategoriesOfCrimes_Id = model.CategoryOfCrime_Id,
FK_Judgements_Prisoners_Id = prisoner.Prisoner_Id,
TimeOfJudgement = model.Time,
StartDate = model.StartDate
};
_db.Prisoners.Add(prisoner);
_db.Judgements.Add(wyrok);
_db.SaveChanges();
return(RedirectToAction("AllocatePrisoner", new { id = prisoner.Prisoner_Id }));
}
return(View(model));
}
public IList <PrisonerViewModel> GetPrisoners(IQueryable <Admission> admissions)
{
var prisoners = new List <PrisonerViewModel>();
foreach (Admission admission in admissions)
{
var p = new PrisonerViewModel();
p.PrisonerId = admission.PrisonerId;
p.PrisonerNumber = admission.PrisonerNumber;
p.AdmissionId = admission.AdmissionId;
p.Name = admission.Prisoner.Name;
p.Parentage = admission.Prisoner.FatherOrHusbandName;
p.Category = admission.Prisoner.Category;
p.Status = admission.Prisoner.Status;
p.DateOfAdmission = admission.DateOfAdmission;
p.DateOfRelease = admission.DateOfRelease;
p.HealthOnAdmission = admission.HealthOnAdmission;
p.WeightOnAdmission = admission.WeightOnAdmission;
p.HealthOnRelease = admission.HealthOnRelease;
p.WeightOnRelease = admission.WeightOnRelease;
p.District = admission.Prisoner.PresentDistrict.Name;
var fir = admission.FIRs.Where(o => o.AdmissionId == p.AdmissionId).OrderByDescending(o => o.FIRDate).FirstOrDefault();
if (fir != null)
{
p.FIRs = fir.FIRNumber;
if (fir.PoliceStation != null)
{
p.PoliceStation = fir.PoliceStation.Name;
}
var section = fir.Sections.FirstOrDefault();
if (section != null)
{
p.UnderSections = section.Name;
}
}
var ch = db.CourtHearings.Where(o => o.AdmissionId == admission.AdmissionId).OrderByDescending(o => o.DateOfHearing).FirstOrDefault();
if (ch != null)
{
p.TrialCourt = ch.Court.Name;
p.DateOfHearing = ch.DateOfHearing;
}
var endDate = DateTime.Now;
if (p.DateOfRelease != null)
{
endDate = p.DateOfRelease.Value;
}
DateDifference period = new DateDifference(endDate, admission.DateOfAdmission);
p.Years = period.Years;
p.Months = period.Months;
p.Days = period.Days;
prisoners.Add(p);
}
return(prisoners);
}
