private static CaseReport RetrieveCaseReportByDocket(Guid docketNumber)
{
using (var db = new CriminalsContext())
{
return(db.CaseReports.First(x => x.DocketNumber == docketNumber));
}
}
private static CaseReport RetrieveCaseReportByTitle(Guid uniqueIdentifier)
{
using (var db = new CriminalsContext())
{
return(db.CaseReports.First(x => x.Title.Contains(uniqueIdentifier.ToString())));
}
}
private CaseReport GetCaseReport(Guid docketNumber)
{
using (var db = new CriminalsContext())
{
return(db.CaseReports.FirstOrDefault(x => x.DocketNumber == docketNumber));
}
}
private CaseReport GetCaseReportFromDatabase(string title)
{
using (var db = new CriminalsContext())
{
return(db.CaseReports.First(x => x.Title == title));
}
}
private void SaveCaseReport(CaseReport report)
{
using (var db = new CriminalsContext())
{
db.CaseReports.Add(report);
db.SaveChanges();
}
}
public void GivenNoCaseReportsExist()
{
using (var db = new CriminalsContext())
{
db.CaseReports.RemoveRange();
db.SaveChanges();
}
}
public void ThenDeletesCaseReport()
{
using (var db = new CriminalsContext())
{
var caseReport = db.CaseReports.FirstOrDefault(x => x.DocketNumber == _docketNumber);
Assert.AreEqual(caseReport, null);
}
}
public void Execute()
{
using (var db = new CriminalsContext())
{
var caseReport = db.CaseReports.FirstOrDefault(x => x.DocketNumber == _docketNumber);
db.CaseReports.Remove(caseReport);
db.SaveChanges();
}
}
public CaseReportViewModel Execute()
{
using (var db = new CriminalsContext())
{
return(db.CaseReports.Select(x => new CaseReportViewModel
{
DocketNumber = x.DocketNumber,
Title = x.Title,
Description = x.Description,
OpenDate = x.OpenDate
}).FirstOrDefault(x => x.DocketNumber == _docketNumber));
}
}
public void GivenCaseReportInDatabase()
{
_caseReport = new CaseReport
{
DocketNumber = _docketNumber,
Title = "Saved Case Report Title",
Description = "Saved Report Description",
OpenDate = DateTime.Now
};
using (var db = new CriminalsContext())
{
db.CaseReports.Add(_caseReport);
db.SaveChanges();
}
}
private static void SavedCaseReport(Guid docketNumber)
{
using (var db = new CriminalsContext())
{
var caseReport = new CaseReport
{
DocketNumber = docketNumber,
Title = $"Test Title {docketNumber}",
Description = $"Test Description {docketNumber}",
OpenDate = DateTime.Now
};
db.CaseReports.Add(caseReport);
db.SaveChanges();
}
}
public void GivenCaseReportExistsInDatabase()
{
using (var db = new CriminalsContext())
{
var caseReport = new CaseReport
{
DocketNumber = _docketNumber,
Title = "Jessie James Report",
Description = "Jessie James broke out of prison.",
OpenDate = DateTime.Now
};
db.CaseReports.Add(caseReport);
db.SaveChanges();
}
}
public CaseReportViewModel Execute()
{
using (var context = new CriminalsContext())
{
var dbCaseReport = new CaseReport
{
DocketNumber = Guid.NewGuid(),
Title = _caseReport.Title,
Description = _caseReport.Description,
OpenDate = DateTime.Now
};
context.CaseReports.Add(dbCaseReport);
context.SaveChanges();
}
return(_caseReport);
}
