public void Add_ShouldAdd_Discipline()
{
var addedDiscipline = new DisciplineCreateModel()
{
DisciplineName = "NewDiscipline", ProfessorName = "Professore", SemesterId = 1
};
var affectedRows = this.repository.Add(addedDiscipline);
Assert.Equal(1, affectedRows);
long count = 0;
using (var connection = this.ApplicationDbContext.Connection)
{
var statement = $"SELECT COUNT(*) as Count FROM {this.DisciplineTableName};";
var command = new MySqlCommand(statement, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
count = (long)reader["Count"];
}
reader.Close();
}
Assert.Equal(13, count);
}
public int Add(DisciplineCreateModel discipline)
{
var affectedRows = 0;
using (var connection = this.Context.Connection)
{
var statement = $"INSERT INTO {disciplineTableName} (`DisciplineName`,`ProfessorName`,`SemesterId`) VALUES (@DisciplineName, @ProfessorName, @SemesterId);";
var command = new MySqlCommand(statement, connection);
command.Parameters.AddWithValue("DisciplineName", discipline.DisciplineName);
command.Parameters.AddWithValue("ProfessorName", discipline.ProfessorName);
command.Parameters.AddWithValue("SemesterId", discipline.SemesterId);
try
{
connection.Open();
affectedRows = command.ExecuteNonQuery();
}
catch (Exception ex)
{
this.Log(this.GetExceptionText(ex));
}
}
return(affectedRows);
}
public IActionResult Post([FromBody] DisciplineCreateModel model)
{
if (!this.Validator.ValidateObject(model) ||
!this.Validator.ValidateRequiredStringProperty(model.DisciplineName) ||
!this.Validator.ValidateRequiredStringProperty(model.ProfessorName) ||
!this.Validator.ValidateId(model.SemesterId))
{
return(BadRequest(new { message = "Bad parameters passed!" }));
}
this.disciplineService.Create(model);
return(Ok(new { message = "Successfully updated." }));
}
public void Add_ShouldAdd_CorrectDiscipline()
{
var addedDiscipline = new DisciplineCreateModel()
{
DisciplineName = "NewDiscipline", ProfessorName = "Professore", SemesterId = 1
};
var affectedRows = this.repository.Add(addedDiscipline);
Assert.Equal(1, affectedRows);
var dbDiscipline = new Discipline();
using (var connection = this.ApplicationDbContext.Connection)
{
var statement = $"SELECT * FROM {this.DisciplineTableName} WHERE Id = 13";
var command = new MySqlCommand(statement, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
dbDiscipline.Id = (int)reader["Id"];
dbDiscipline.DisciplineName = reader["DisciplineName"].ToString();
dbDiscipline.ProfessorName = reader["ProfessorName"].ToString();
dbDiscipline.SemesterId = (int)reader["SemesterId"];
}
reader.Close();
}
Assert.Equal(13, dbDiscipline.Id);
Assert.Equal(addedDiscipline.DisciplineName, dbDiscipline.DisciplineName);
Assert.Equal(addedDiscipline.ProfessorName, dbDiscipline.ProfessorName);
Assert.Equal(addedDiscipline.SemesterId, dbDiscipline.SemesterId);
}
public int Create(DisciplineCreateModel model)
{
var affectedRows = this.repository.Add(model);
return(affectedRows);
}
