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