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