public Messenger(IConfiguration config, JobConfigRepo jobRepo, MessageRepo msgRepo, ExecutionRepo execRepo, SmtpConfigRepo smtpConfigRepo)
{
_config = config;
_jobRepo = jobRepo;
_msgRepo = msgRepo;
_execRepo = execRepo;
_smtpConfigRepo = smtpConfigRepo;
_sqlClient = new SQLClientAdo();
string configToExecute = _config["ExecuteOptions:JobName"];
string smtpConfigName = _config["ExecuteOptions:SmtpConfigName"];
var jobConfig = _jobRepo.GetByJobName(configToExecute);
var smtpConfig = _smtpConfigRepo.GetByConfigName(smtpConfigName);
//Create execution object to run job
Execution = new Execution()
{
SysUser = _config["ExecuteOptions:Caller"],
StartTime = DateTime.Now,
JobConfig = jobConfig,
SmtpConfig = smtpConfig
};
_emailSender = new EmailSender(Execution.SmtpConfig);
}
public void update_a_message()
{
//Create message
Connection one = new Connection();
MessageRepo repo = new MessageRepo(new Connection(), new ReactionRepo(new Connection()));
MessageModel message = new MessageModel();
message.message = "testmessage";
message.subject = "subject";
message.forum = "1";
message.software = "1";
int id = repo.store(message, 1);
message.id = id;
//Give message a new name
message.message = "new name!";
repo.update(message);
one.Connect();
SqlCommand sqlCommand = new SqlCommand("select * from message where message = 'new name!'", one.getConnection());
SqlDataReader reader = sqlCommand.ExecuteReader();
Assert.AreEqual(true, reader.HasRows);
one.disConnect();
repo.destroy(id);
}
public void GetMessages_return_correct_message()
{
//arrange
var list = new List <Message>
{
new Message()
{
CreatedAt = DateTime.Now - TimeSpan.FromDays(1), Text = "test1"
},
new Message()
{
CreatedAt = DateTime.Now, Text = "test2"
}
};
_serv.Setup(x => x.GetMessages()).Returns(list);
//act
MessageRepo repo = new MessageRepo(_serv.Object);
var res = repo.GetMessages();
//assert
_serv.Verify(f => f.GetMessages(), Times.Once());
Assert.AreEqual(list.Count, res.Count);
}
public ResponseModel DeleteMessage(long?id)
{
if (id == null)
{
return new ResponseModel()
{
success = false,
message = "Silinecek message id yollanamadı"
}
}
;
try
{
var silinecek = new MessageRepo().GetById(id.Value);
new MessageRepo().Delete(silinecek);
return(new ResponseModel()
{
success = true,
message = $"{silinecek.Content} mesaji silindi"
});
}
catch (Exception ex)
{
return(new ResponseModel()
{
success = false,
message = $"Veritabanı bağlantı sorunu: {ex.Message}"
});
}
}
}
public ResponseModel GetAllMessages()
{
try
{
var model = new MessageRepo().GetAll().Select(x => new
{
x.Id,
x.Content,
x.Level,
x.MessageDate,
x.SendBy,
x.SentTo
}).ToList();
return(new ResponseModel()
{
success = true,
data = model
});
}
catch (Exception ex)
{
return(new ResponseModel()
{
success = false,
message = $"Veritabanı bağlantı sorunu: {ex.Message}"
});
}
}
public async Task Should_create_message_in_database()
{
//Arrange
string dbName = Guid.NewGuid().ToString();
DbContextOptions <MessageContext> options =
new DbContextOptionsBuilder <MessageContext>().UseInMemoryDatabase(dbName).Options;
await using var context = new MessageContext(options);
IMessageRepo messageRepo = new MessageRepo(context);
var message = new MessageModel
{
Id = 1,
Data = 1
};
//Act
var thread = new Thread(() => messageRepo.Save(message));
thread.Start();
var savedMessage = messageRepo.GetById(message.Id);
//Assert
savedMessage.Should().NotBeNull();
savedMessage.Id.Should().Be(1);
}
public PartialViewResult GetMessages()
{
MessageRepo repo = new MessageRepo();
//call to repo to fetch all messages
var result = repo.GetAllMessages();
return PartialView("_MessageList", result);
}
public IHttpActionResult DeleteMessage([FromBody] JObject request)
{
Message msg = request.ToObject <Message>();
Repo <Message> messageRepo = new MessageRepo();
messageRepo.Delete(msg);
return(Ok());
}
public PartialViewResult GetMessages()
{
MessageRepo repo = new MessageRepo();
//call to repo to fetch all messages
var result = repo.GetAllMessages();
return(PartialView("_MessageList", result));
}
public RedirectToActionResult ContactPage(string messageSender,
string messageReceiver, string messageText)
{
message = new Message();
message.MessageSender = messageSender;
message.MessageReceiver = messageReceiver;
message.MessageText = messageText;
MessageRepo.AddMessage(message);
return(RedirectToAction("ContactPage"));
}
private void GetMessageFromDatabase(string code)
{
try
{
//Message = new MessageRepo(new MessageContext()).GetMessage(code, Server.Id);
throw new Exception();
}
catch
{
Message = new MessageRepo(new MessageContext()).GetDefaultMessage(code);
}
}
public void AddMessage_with_correct_message()
{
//arrange
string text = "test";
_serv.Setup(x => x.AddMessage(It.IsAny<String>()));
//act
MessageRepo repo = new MessageRepo(_serv.Object);
repo.AddMessage(text);
//assert
_serv.Verify(f => f.AddMessage(text), Times.Once());
}
public void store_and_delete_a_reaction()
{
Connection one = new Connection();
Connection two = new Connection();
ReactionRepo repo = new ReactionRepo(new Connection());
MessageRepo mRepo = new MessageRepo(new Connection(), new ReactionRepo(new Connection()));
//Create message that reaction will belong to
MessageModel message = new MessageModel();
message.message = "testmessage";
message.subject = "subject";
message.forum = "1";
message.software = "1";
int id = mRepo.store(message, 1);
//Create reaction
ReactionModel reaction = new ReactionModel();
reaction.message_id = id;
reaction.lastName = "lastname";
reaction.reaction = "reaction";
int idTwo = repo.store(reaction, 1);
reaction.id = idTwo;
one.Connect();
SqlCommand sqlCommand = new SqlCommand("select * from reaction where reaction = 'reaction'", one.getConnection());
SqlDataReader reader = sqlCommand.ExecuteReader();
Assert.AreEqual(true, reader.HasRows);
one.disConnect();
//Delete reaction
repo.destroy(id);
two.Connect();
SqlCommand sqlCommandTwo = new SqlCommand("select * from corporation where name = 'name' and email ='email' and zip = '3434-kj' and address = 'address'", two.getConnection());
SqlDataReader readerTwo = sqlCommandTwo.ExecuteReader();
Assert.AreEqual(false, readerTwo.HasRows);
one.disConnect();
}
public RepoRepo(Messenger messenger)
{
CFileRepo = new CFileRepo(messenger);
MessageRepo = new MessageRepo(messenger);
RelationshipRepo = new RelationshipRepo(messenger);
RoomRepo = new RoomRepo(messenger);
UserRepo = new UserRepo(messenger);
repos.Add(CFileRepo);
repos.Add(MessageRepo);
repos.Add(RelationshipRepo);
repos.Add(RoomRepo);
repos.Add(UserRepo);
}
public void AddMessage_with_correct_message()
{
//arrange
string text = "test";
_serv.Setup(x => x.AddMessage(It.IsAny <String>()));
//act
MessageRepo repo = new MessageRepo(_serv.Object);
repo.AddMessage(text);
//assert
_serv.Verify(f => f.AddMessage(text), Times.Once());
}
public void AddMessage_with_correct_message()
{
//arrange
string text = "test";
Message msg;
_add.Setup(x => x.AddMessage(It.IsAny <Message>()));
//act
MessageRepo repo = new MessageRepo(_add.Object, _get.Object);
repo.AddMessage(text);
//assert
_add.Verify(f => f.AddMessage(It.Is <Message>(m => m.Text == text)), Times.Once());
}
public void update_a_message()
{
Connection one = new Connection();
Connection two = new Connection();
ReactionRepo repo = new ReactionRepo(new Connection());
MessageRepo mRepo = new MessageRepo(new Connection(), new ReactionRepo(new Connection()));
//Create message that reaction will belong to
MessageModel message = new MessageModel();
message.message = "testmessage";
message.subject = "subject";
message.forum = "1";
message.software = "1";
int id = mRepo.store(message, 1);
//Create reaction
ReactionModel reaction = new ReactionModel();
reaction.message_id = id;
reaction.lastName = "lastname";
reaction.reaction = "reaction";
int idTwo = repo.store(reaction, 1);
reaction.id = idTwo;
//Give forum a new name
reaction.reaction = "new name!";
repo.update(reaction);
one.Connect();
SqlCommand sqlCommand = new SqlCommand("select * from reaction where reaction = 'new name!'", one.getConnection());
SqlDataReader reader = sqlCommand.ExecuteReader();
Assert.AreEqual(true, reader.HasRows);
one.disConnect();
repo.destroy(id);
}
public void GetMessages_return_correct_message()
{
//arrange
var list = new List<Message>
{
new Message() {CreatedAt = DateTime.Now - TimeSpan.FromDays(1), Text = "test1"},
new Message() {CreatedAt = DateTime.Now, Text = "test2"}
};
_serv.Setup(x => x.GetMessages()).Returns(list);
//act
MessageRepo repo = new MessageRepo(_serv.Object);
var res = repo.GetMessages();
//assert
_serv.Verify(f => f.GetMessages(), Times.Once());
Assert.AreEqual(list.Count, res.Count);
}
public HomeController()
{
if (MessageRepo.Messages.Count == 0)
{
message = new Message()
{
MessageSender = "John",
MessageReceiver = "Jane",
MessageText = "Hello"
};
MessageRepo.AddMessage(message);
}
if (UserDirectory.Users.Count == 0)
{
UserDirectory.AddUser(John);
UserDirectory.AddUser(Jane);
}
}
public Messenger(IConfiguration config, SyncConfigRepo configRepo, MessageRepo msgRepo, SyncExecutionRepo execRepo)
{
_config = config;
_syncConfigRepo = configRepo;
_msgRepo = msgRepo;
_execRepo = execRepo;
_sqlClient = new SQLClientAdo();
string configToExecute = _config["ExecuteOptions:JobName"];
string smtpConfigName = _config["ExecuteOptions:SmtpConfigName"];
var syncConfig = _syncConfigRepo.GetByConfigName(configToExecute);
//Create execution object to run job
Execution = new SyncExecution()
{
SysUser = _config["ExecuteOptions:Caller"],
StartTime = DateTime.Now,
Config = syncConfig
};
}
private static void SaveRequestToDb(Message message)
{
MessageRepo messageRepo = new MessageRepo();
messageRepo.addMessage(message);
}
public ActionResult Mesajlar()
{
var model = new MessageRepo().Queryable().Where(x => x.SendBy == HttpContext.User.Identity.GetUserId()).ToList();
return(View(model));
}
public MessageController()
{
_repo = new MessageRepo();
}
public MessageService(MessageRepo repo)
{
_repo = repo;
}
public CacheController(ApplicationDbContext context, IMemoryCache cache, MessageRepo repo)
{
_context = context;
_cache = cache;
_repo = repo;
}
