public ActionResult Report(int id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Audits audit = db.Audits.Find(id); if (audit != null) { var auditReportViewModel = new AuditReportViewModel(); auditReportViewModel.Audit = audit; auditReportViewModel.AuditReports = db.AuditReport.ToList(); auditReportViewModel.Id = id; auditReportViewModel.MyResults = db.AuditReportResults.Where(r => r.AuditId == id).ToList(); if (audit.PerformedDate == null || auditReportViewModel.MyResults.Count == 0) { for (int i = 0; i < auditReportViewModel.AuditReports.Count; i++) { auditReportViewModel.MyResults.Add(new AuditReportResults() { AuditId = id, AuditReportId = auditReportViewModel.AuditReports[i].Id }); } } return(View(auditReportViewModel)); } return(new HttpStatusCodeResult(HttpStatusCode.NotFound)); }
public frmForm2(UserInformation userInfo) { InitializeComponent(); AuditReportViewModel vm = new AuditReportViewModel(userInfo); this.DataContext = vm; this.Closing += vm.CloseMethodWindow; }
public ActionResult Report(AuditReportViewModel viewModel) { Audits audit = db.Audits.Find(viewModel.Id); audit.PerformedDate = DateTime.Now; db.Entry(audit).State = EntityState.Modified; var listResults = db.AuditReportResults.Where(r => r.AuditId == viewModel.Id); db.AuditReportResults.RemoveRange(listResults); // Remove old values db.SaveChanges(); db.AuditReportResults.AddRange(viewModel.MyResults); // Insert new values db.SaveChanges(); return(RedirectToAction("Index")); }
public AuditReportViewModel GetAuditReport(int Auditid, int Userid, int OrganizationId) { DbDataReader reader = null; AuditReportViewModel model = new AuditReportViewModel(); var AuditSubjectReviewList = new List<AuditReportSubjectReviewViewModel>(); var AuditReportSubjectQuestionResponseList = new List<AuditReportSubjectQuestionResponse>(); try { RepositoryContext.Database.Initialize(force: false); var cmd = RepositoryContext.Database.Connection.CreateCommand(); cmd.CommandText = "SP_GetAuditReport"; cmd.CommandType = System.Data.CommandType.StoredProcedure; SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@Auditid"; parm1.Value = Auditid; parm1.SqlDbType = SqlDbType.Int; SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@OrganizationId"; parm2.Value = OrganizationId; parm2.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(parm1); cmd.Parameters.Add(parm2); if (RepositoryContext.Database.Connection.State == ConnectionState.Closed) { RepositoryContext.Database.Connection.Open(); } reader = cmd.ExecuteReader(); model.AuditReport = (from n in ((IObjectContextAdapter)RepositoryContext) .ObjectContext.Translate<AuditReport>(reader) select n).FirstOrDefault(); reader.NextResult(); model.AuditReport.AuditReportSubjectList = (from n in ((IObjectContextAdapter)RepositoryContext) .ObjectContext.Translate<AuditReportSubject>(reader) select n).ToList(); reader.NextResult(); AuditSubjectReviewList = (from n in ((IObjectContextAdapter)RepositoryContext) .ObjectContext.Translate<AuditReportSubjectReviewViewModel>(reader) select n).ToList(); reader.NextResult(); AuditReportSubjectQuestionResponseList = (from n in ((IObjectContextAdapter)RepositoryContext) .ObjectContext.Translate<AuditReportSubjectQuestionResponse>(reader) select n).ToList(); foreach (var arsub in model.AuditReport.AuditReportSubjectList) { arsub.AuditSubjectReviewList = AuditSubjectReviewList.Where(x => x.SubjectID == arsub.AuditSubjectID).ToList(); arsub.AuditReportSubjectQuestionResponseList = AuditReportSubjectQuestionResponseList.Where(x => x.SubjectID == arsub.AuditSubjectID).ToList(); } } finally { if (reader != null) { if (!reader.IsClosed) { reader.Close(); } } if (RepositoryContext.Database.Connection.State == ConnectionState.Open) { RepositoryContext.Database.Connection.Close(); RepositoryContext.Database.Connection.Dispose(); } } return model; }