public ActionResult Details(int id = 0)
{
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var inspectionQuery = (from ins in db.Inspections
join ext in db.InspectionExts on ins.ID equals ext.InspectionID
join ques in db.CompliantQuestions on ext.CompliantNo equals ques.CompliantNo.Value
where ins.ID == id && (ins.InspectionForm == ques.InspectionForm || ques.InspectionForm == "")
select new
{
Inspect = ins,
InspectExt = ext,
Compliants = ques
}
).ToList();
inspectionView.Inspections = db.Inspections.Find(id);
inspectionView.InspectionCompliantData = new List <InspectionCompliant>();
InspectionCompliant iComplaint = new InspectionCompliant();
for (int i = 0; i < inspectionQuery.Count(); i++)
{
iComplaint = new InspectionCompliant();
iComplaint.CompliantNo = int.Parse(inspectionQuery[i].Compliants.CompliantNo.ToString());
iComplaint.CompliantQues = inspectionQuery[i].Compliants.CompliantQues.ToString();
iComplaint.Compliant = inspectionQuery[i].InspectExt.Compliant.ToString();
iComplaint.Remarks = inspectionQuery[i].InspectExt.Remarks.ToString();
iComplaint.Severity = inspectionQuery[i].InspectExt.Severity.ToString();
iComplaint.Assignee = inspectionQuery[i].InspectExt.Assignee.ToString();
iComplaint.DueDate = inspectionQuery[i].InspectExt.DueDate.ToString();
iComplaint.LastModifiedBy = inspectionQuery[i].InspectExt.LastModifiedBy;
inspectionView.InspectionCompliantData.Add(iComplaint);
}
//if (inspection == null)
//{
// return HttpNotFound();
//}
List <AuditInspectionDetail> lstAuditInspectionViewModel = new List <AuditInspectionDetail>();
lstAuditInspectionViewModel = db.AuditInspectionDetails.Where(x => x.InspectionID == id).OrderByDescending(d => d.ModifiedDate).ToList();
inspectionView.InspectionAuditViewModels = lstAuditInspectionViewModel;
return(View(inspectionView));
}
public ActionResult Edit(int id = 0)
{
if (id == 0)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
var inspectionQuery = (from ins in db.Inspections
join ext in db.InspectionExts on ins.ID equals ext.InspectionID
join ques in db.CompliantQuestions on ext.CompliantNo equals ques.CompliantNo.Value
where ins.ID == id && (ins.InspectionForm == ques.InspectionForm || ques.InspectionForm == "")
select new
{
Inspect = ins,
InspectExt = ext,
Compliants = ques
}
).ToList();
inspectionView.Inspections = db.Inspections.Find(id);
inspectionView.InspectionCompliantData = new List <InspectionCompliant>();
InspectionCompliant iComplaint = new InspectionCompliant();
for (int i = 0; i < inspectionQuery.Count(); i++)
{
iComplaint = new InspectionCompliant();
iComplaint.InspectionCompliantID = inspectionQuery[i].InspectExt.ID;
iComplaint.CompliantNo = int.Parse(inspectionQuery[i].Compliants.CompliantNo.ToString());
iComplaint.CompliantQues = inspectionQuery[i].Compliants.CompliantQues.ToString();
iComplaint.Compliant = inspectionQuery[i].InspectExt.Compliant.ToString();
iComplaint.Remarks = inspectionQuery[i].InspectExt.Remarks.ToString();
iComplaint.Severity = inspectionQuery[i].InspectExt.Severity.ToString();
iComplaint.Assignee = inspectionQuery[i].InspectExt.Assignee.ToString();
iComplaint.DueDate = inspectionQuery[i].InspectExt.DueDate.ToString();
inspectionView.InspectionCompliantData.Add(iComplaint);
}
return(View(inspectionView));
}
