public void ChangeDataTimeTest()
{
IPlaceRepository plRep = DataGenerator.GetPlaceRepositoryMock();
MeetingRepository mr = new MeetingRepository(plRep);
Meeting meet = new Meeting() {
idMeet = 1,
place = 1,
dateMeet = new DateTime(),
};
mr.ChangeDateTime(meet, new DateTime());
}
public void Create(Meeting meeting)
{
logger.Log(LogLevel.Info, $"Start creating mmeting with id = {meeting.idMeet}");
if(meeting == null) {
logger.Log(LogLevel.Error, $"Can't create meeting, because it is null");
throw new ArgumentNullException();
}
if (!(placeRep.Exist(meeting.place) )) {
logger.Log(LogLevel.Error, $"Can't create meeting, because place = {meeting.place} not exist!");
throw new ArgumentException("This place not exist!");
}
using(var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DevSchoolDB"].ConnectionString)) {
connection.Open();
using(SqlCommand command = connection.CreateCommand()) {
command.CommandText = "insert into [dbo].[Meeting] (place, dateMeet) values (@place, @dateMeet)";
//command.Parameters.AddWithValue("@idMeet", meeting.idMeet);
command.Parameters.AddWithValue("@place", meeting.place);
command.Parameters.AddWithValue("@dateMeet", meeting.dateMeet);
command.ExecuteNonQuery();
logger.Log(LogLevel.Info, $"End creating mmeting with id = {meeting.idMeet}");
}
}
}
public void ChangeDateTime(Meeting meeting, DateTime date)
{
logger.Log(LogLevel.Info, $"Start change date to meeting with id = {meeting.idMeet} to date = {date}");
if(date == null) {
logger.Log(LogLevel.Error, $"Can't change date to meeting with id = {meeting.idMeet} because date is null");
throw new ArgumentNullException();
}
if(!(placeRep.Exist(meeting.place) )) {
logger.Log(LogLevel.Error, $"Can't change date to meeting with id = {meeting.idMeet} because place = {meeting.place} not exist");
throw new ArgumentException("This place not exist!");
}
using(SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DevSchoolDB"].ConnectionString)) {
connection.Open();
using(SqlCommand command = connection.CreateCommand()) {
command.CommandText = "update [dbo].[Meeting] set dateMeet = @dateMeet where idMeet = @idMeet and place = @place";
command.Parameters.AddWithValue("@dateMeet", date.ToString("yyyy-MM-dd HH:mm:ss"));
command.Parameters.AddWithValue("@idMeet", meeting.idMeet);
command.Parameters.AddWithValue("@place", meeting.place);
command.ExecuteNonQuery();
}
}
logger.Log(LogLevel.Info, $"End change date to meeting with id = {meeting.idMeet} to date = {date}");
}
