public BenchmarkInsertMultiple()
{
_dbContext = new NorthwindEntities();
EntityFrameworkRawRepository = new EntityFrameworkRepository(_dbContext);
DapperRawSqlRepository = new DapperRepository(_connStr);
RawSqlRepository = new RawSqlRepository(_connStr);
RawSqlStoredProcedureRepository = new StoredProcedureRepository(_connStr);
//IMPORTANT STEP: BEFORE STARTING THE BENCHMARK - MAKE SURE THE TABLES ARE EMPTY FOR CONSISTENT RESULTS!!!
new DatabaseCleanup(_connStr).ClearInsertTables();
efList = new List <InsertTable>();
dtoList1 = new List <InsertTableDto>();
dtoList2 = new List <InsertTableDto>();
dtoList3 = new List <InsertTableDto>();
for (int i = 0; i < OBJECT_COUNT; i++)
{
efList.Add(InsertTableGenerator.NewEF(textLength));
dtoList1.Add(InsertTableGenerator.NewDTO(textLength));
dtoList2.Add(InsertTableGenerator.NewDTO(textLength));
dtoList3.Add(InsertTableGenerator.NewDTO(textLength));
}
}
public StoreProcedureGeneratorImpl(
StoreProcedureTemplateGenerator aTemplateGenerator,
StoredProcedureRepository aStoreProcedureGenerator
)
{
TemplateGenerator = aTemplateGenerator;
StoredProcedureRepository = aStoreProcedureGenerator;
}
//[TestCase]
public void TestCase1()
{
// Arrange
var repository = new StoredProcedureRepository();
// Act
// Assert
}
//[TestCase]
public void TestCase1()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
// Act
// Assert
}
public BenchmarkSelect()
{
_dbContext = new NorthwindEntities();
EntityFrameworkRawRepository = new EntityFrameworkRepository(_dbContext);
EntityFrameworkViewRepository = new ViewEntityFrameworkRepository(_dbContext);
DapperRawSqlRepository = new DapperRepository(_connStr);
RawSqlRepository = new RawSqlRepository(_connStr);
RawSqlStoredProcedureRepository = new StoredProcedureRepository(_connStr);
}
public void StoredProcedure_Multiple()
{
//arrange
var repo = new StoredProcedureRepository(_connStr);
//act
int rows = repo.InsertRows(dtos);
//assert
Assert.AreEqual(dtos.Count(), rows);
}
public void RawSqlStoredProcedure()
{
//arrange
IRepository <InvoiceDto, InsertTableDto> repo = new StoredProcedureRepository(_connStr);
//act
var results = repo.GetAll();
//assert
Assert.AreEqual(EXPECTED_COUNT, results.Count());
}
public IHttpActionResult GetProbationPeriodDetails(EmployeeDetails emp)
{
var response_from_stored_proc = StoredProcedureRepository.GetEmployeeDetails(emp.EmpID);
if (response_from_stored_proc == null)
{
return(NotFound());
}
var response = WebMethods.CreateServiceResponse(Enums.WebServiceStatus.Success, response_from_stored_proc);
return(Json(response));
}
public CustomerManager(UnitOfWork unitOfWork, StoredProcedureRepository storedProcedureRepository,
BasePerson basePerson)
{
_unitOfWork = unitOfWork;
_storedProcedureRepository = storedProcedureRepository;
_basePerson = basePerson;
UpdatedByPersonID = _basePerson.CurrentPersonID();
SourcePersonID = _basePerson.CurrentPersonID();
PersonRole = _basePerson.CurrentPersonRole();
}
public void StoredProcedure_Single()
{
//arrange
var repo = new StoredProcedureRepository(_connStr);
//act
int rows = repo.InsertRows(new List <InsertTableDto> {
single
});
//assert
Assert.AreEqual(1, rows);
}
public static string obtenerConsultorios()
{
try
{
var spr = new StoredProcedureRepository();
var consultorios = spr.ObtenerDetallesConsultorios().Select(c => new { c.IdConsultorio, c.NombreConsultorio, c.Planta, c.TipoConsultorio, c.UsuarioRegistro, FechaRegistro = c.FechaRegistro.ToString("dd/MM/yyyy"), Activo = c.Activo ? "Si" : "No" });
return(new JavaScriptSerializer().Serialize(consultorios));
}
catch (Exception ex)
{
Log.Error("[ System ] " + " [ Page ] " + "[ " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name.ToString() + " ] [ " + System.Reflection.MethodBase.GetCurrentMethod().Name.ToString() + " ] [ Fin ]", ex);
throw;
}
}
public void GetRankingsTotal_ExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var seasonID = 2017;
A.CallTo(() => dbContext.GetRankingsTotal(A <int> .Ignored)).Throws <Exception>();
// Act
ObjectResult <GetRankingsTotal_Result> result = null;
Assert.Throws <Exception>(() => result = result = repository.GetRankingsTotal(seasonID));
// Assert
Assert.IsNull(result);
}
public void GetLeagueSeasonTotals()
{
// Arrange
var repository = new StoredProcedureRepository();
var dbContext = A.Fake <ProFootballEntities>();
var leagueName = "League";
var seasonID = 2017;
A.CallTo(() => dbContext.GetLeagueSeasonTotals(A <string> .Ignored, A <int> .Ignored))
.Returns(A.Fake <ObjectResult <GetLeagueSeasonTotals_Result> >());
// Act
var result = repository.GetLeagueSeasonTotals(dbContext, leagueName, seasonID);
// Assert
A.CallTo(() => dbContext.GetLeagueSeasonTotals(leagueName, seasonID)).MustHaveHappenedOnceExactly();
Assert.IsInstanceOf <ObjectResult <GetLeagueSeasonTotals_Result> >(result);
}
public void GetSeasonStandings()
{
// Arrange
var repository = new StoredProcedureRepository();
var dbContext = A.Fake <ProFootballEntities>();
var seasonID = 2017;
var groupByDivision = false;
A.CallTo(() => dbContext.GetSeasonStandings(A <int> .Ignored, A <bool> .Ignored))
.Returns(A.Fake <ObjectResult <GetSeasonStandings_Result> >());
// Act
var result = repository.GetSeasonStandings(dbContext, seasonID, groupByDivision);
// Assert
A.CallTo(() => dbContext.GetSeasonStandings(seasonID, groupByDivision)).MustHaveHappenedOnceExactly();
Assert.IsInstanceOf <ObjectResult <GetSeasonStandings_Result> >(result);
}
public void GetRankingsTotal_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var seasonID = 2017;
var totalRankings = A.Fake <ObjectResult <GetRankingsTotal_Result> >();
A.CallTo(() => dbContext.GetRankingsTotal(A <int> .Ignored)).Returns(totalRankings);
// Act
var result = repository.GetRankingsTotal(seasonID);
// Assert
A.CallTo(() => dbContext.GetRankingsTotal(seasonID)).MustHaveHappenedOnceExactly();
Assert.AreSame(totalRankings, result);
}
public void GetTeamSeasonScheduleProfile()
{
// Arrange
var repository = new StoredProcedureRepository();
var dbContext = A.Fake <ProFootballEntities>();
var teamName = "Team";
var seasonID = 2017;
A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(A <string> .Ignored, A <int> .Ignored))
.Returns(A.Fake <ObjectResult <GetTeamSeasonScheduleProfile_Result> >());
// Act
var result = repository.GetTeamSeasonScheduleProfile(dbContext, teamName, seasonID);
// Assert
A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(teamName, seasonID))
.MustHaveHappenedOnceExactly();
Assert.IsInstanceOf <ObjectResult <GetTeamSeasonScheduleProfile_Result> >(result);
}
public void GetLeagueSeasonTotals_GenericExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var leagueName = "League";
var seasonID = 2017;
A.CallTo(() => dbContext.GetLeagueSeasonTotals(A <string> .Ignored, A <int> .Ignored))
.Throws <Exception>();
// Act
ObjectResult <GetLeagueSeasonTotals_Result> result = null;
Assert.Throws <Exception>(
() => { result = repository.GetLeagueSeasonTotals(leagueName, seasonID); });
// Assert
Assert.IsNull(result);
}
public void GetTeamSeasonScheduleAverages_InvalidOperationExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var teamName = "Team";
var seasonID = 2017;
A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(A <string> .Ignored, A <int> .Ignored))
.Throws <InvalidOperationException>();
// Act
ObjectResult <GetTeamSeasonScheduleAverages_Result> result = null;
Assert.Throws <InvalidOperationException>(
() => { result = repository.GetTeamSeasonScheduleAverages(teamName, seasonID); });
// Assert
Assert.IsNull(result);
}
public void GetSeasonStandingsForDivision_ExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var seasonID = 2017;
var divisionName = "Division";
A.CallTo(() => dbContext.GetSeasonStandingsForDivision(A <int> .Ignored, A <string> .Ignored))
.Throws <Exception>();
// Act
ObjectResult <GetSeasonStandingsForDivision_Result> result = null;
Assert.Throws <Exception>(
() => { result = repository.GetSeasonStandingsForDivision(seasonID, divisionName); });
// Assert
Assert.IsNull(result);
}
public void GetSeasonStandingsForDivision_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var seasonID = 2017;
var divisionName = "Division";
var standings = A.Fake <ObjectResult <GetSeasonStandingsForDivision_Result> >();
A.CallTo(() => dbContext.GetSeasonStandingsForDivision(A <int> .Ignored, A <string> .Ignored))
.Returns(standings);
// Act
var result = repository.GetSeasonStandingsForDivision(seasonID, divisionName);
// Assert
A.CallTo(() => dbContext.GetSeasonStandingsForDivision(seasonID, divisionName)).
MustHaveHappenedOnceExactly();
Assert.AreSame(standings, result);
}
public void GetTeamSeasonScheduleAverages_HappyPath()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var teamName = "Team";
var seasonID = 2017;
var teamSeasonScheduleAverages = A.Fake <ObjectResult <GetTeamSeasonScheduleAverages_Result> >();
A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(A <string> .Ignored, A <int> .Ignored))
.Returns(teamSeasonScheduleAverages);
// Act
var result = repository.GetTeamSeasonScheduleAverages(teamName, seasonID);
// Assert
A.CallTo(() => dbContext.GetTeamSeasonScheduleAverages(teamName, seasonID))
.MustHaveHappenedOnceExactly();
Assert.AreSame(teamSeasonScheduleAverages, result);
}
public void GetTeamSeasonScheduleProfile_ArgumentExceptionCaught_LogsAndRethrowsException()
{
// Arrange
var dbContext = A.Fake <ProFootballEntities>();
var repository = new StoredProcedureRepository(dbContext);
var teamName = "Team";
var seasonID = 2017;
A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(A <string> .Ignored, A <int> .Ignored))
.Throws <ArgumentException>();
// Act
ObjectResult <GetTeamSeasonScheduleProfile_Result> result = null;
Assert.Throws <ArgumentException>(
() => { result = repository.GetTeamSeasonScheduleProfile(teamName, seasonID); });
// Assert
A.CallTo(() => dbContext.GetTeamSeasonScheduleProfile(teamName, seasonID))
.MustHaveHappenedOnceExactly();
Assert.IsNull(result);
}
