//return last message from single user
protected Message ReturnLastMessages(string yourId, string reciverId)
{
messageDbContext = new MessageDbContext();
message = new Message();
try
{
var result = (from r in messageDbContext.Messages
where r.messagSenderID == yourId && r.messageRecierID == reciverId
select r).ToList();
if (result.Count > 0)
{
var resutLast = (from r in result
select r).Last();
message.messagSenderID = resutLast.messagSenderID;
message.messageRecierID = resutLast.messageRecierID;
message.messages = resutLast.messages;
}
}
catch (Exception ex)
{
errMessages = ex.Message;
}
return(message);
}
//return all message from sing user
protected List <Message> ReturnMessages(string yourId, string reciverId)
{
messagesList = new List <Message>();
messageDbContext = new MessageDbContext();
try
{
var result = (from r in messageDbContext.Messages
where r.messagSenderID == yourId && r.messageRecierID == reciverId
select r).ToList();
if (result.Count > 0)
{
foreach (Message mes in result)
{
message = new Message();
message.messagSenderID = mes.messagSenderID;
message.messageRecierID = mes.messageRecierID;
message.messages = mes.messages;
message.messageDateTime = mes.messageDateTime;
messagesList.Add(message);
}
}
}
catch (Exception ex)
{
errMessages = ex.Message;
}
return(messagesList);
}
public MessageRepositoryShould()
{
var options = new DbContextOptionsBuilder <MessageDbContext>().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
messageDbContext = new MessageDbContext(options);
repository = new MessageRepository(messageDbContext);
}
public DataService(
GameDbContext games,
MessageDbContext messages)
{
this.games = games;
this.messages = messages;
}
public AuthService(
UserDbContext userDatabase,
MessageDbContext messageDatabase,
IQueueSenderService queueSender)
{
this.userDatabase = userDatabase;
this.messageDatabase = messageDatabase;
this.queueSender = queueSender;
}
//return all reciverId
protected string[] ReturnReciverIDs()
{
messageDbContext = new MessageDbContext();
message = new Message();
var resultSenderID = (from r in messageDbContext.Messages
select r.messageRecierID).Distinct().ToArray();
return(resultSenderID);
}
public MessagesController(
MessageDbContext context,
TestWebApiContext testWebApiContext,
UserManager <TestWebApiUser> userManager,
SignInManager <TestWebApiUser> signInManager
)
{
_context = context;
_testWebApiContext = testWebApiContext;
_userManager = userManager;
_signInManager = signInManager;
}
public int WriteToPriorityTable(List <MessagePrioritiesModel> senders)
{
int count = 0;
using (var db = new MessageDbContext())
{
foreach (MessagePrioritiesModel sender in senders)
{
db.MessagePrioritiesModels.Add(sender);
}
count = db.SaveChanges();
}
return(count);
}
public int WriteToMessagesTable(List <Message> inbox)
{
int count = 0;
using (var db = new MessageDbContext())
{
foreach (Message message in inbox)
{
var messageModel = new MessagesModel()
{
messageId = message.Id,
internalDate = (long)message.InternalDate
};
db.MessagesModels.Add(messageModel);
}
count = db.SaveChanges();
}
return(count);
}
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, MessageDbContext dbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
dbContext.Database.EnsureDeleted();
dbContext.Database.EnsureCreated();
}
app.UseSwaggerWithVersions();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
endpoints.MapHealthCheckWithVersion("/health");
});
app.UseSubscriptions();
app.UseMiddleware <LogContextMiddleware>();
}
//Insert message single reciver
protected bool InsertMessages(Message mes)
{
messageDbContext = new MessageDbContext();
try
{
messageDbContext.Messages.Add(mes);
int count = messageDbContext.SaveChanges();
if (count == 1)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
string erMessage = ex.Message;
return(false);
}
}
public DbSetup(WebApplicationFactory <Startup> factory)
{
// This fetches the same single lifetime instantiation used by Controller classes
_dbContext = factory.Services.GetRequiredService <MessageDbContext>();
// Seed in-memory database with some data needed for tests
var message1 = new Message
{
Id = 1,
Content = "Cool Message 1",
};
_dbContext.Messages.Add(message1);
var message2 = new Message
{
Id = 2,
Content = "Fun Message 2",
};
_dbContext.Messages.Add(message2);
_dbContext.SaveChanges();
}
public UsersController(MessageDbContext context, IOptions <JwtSettings> options)
{
this.context = context;
this.jwtSettings = options;
}
public DataController(MessageDbContext context)
{
_context = context;
}
public MessageRepository(MessageDbContext dbContext) => this.dbContext = dbContext;
public MessagesController(MessageDbContext context)
{
this.context = context;
}
public InvitationService(MessageDbContext ctx)
{
_messageDbContext = ctx;
}
public MessageService()
{
_context = new MessageDbContext();
}
public UsersController(MessageDbContext context, IOptions <JwtSettings> jwtSettings)
{
this.context = context;
this.jwtSettings = jwtSettings.Value;
}
public MessagingController(MessageDbContext context)
{
_context = context;
}
public MessageRepository(MessageDbContext dbContext)
{
_context = dbContext;
}
public CommentsWidgetService(IWidgetBasePartService widgetBasePartService, IApplicationContext applicationContext, MessageDbContext dbContext, ICommentsService commentsService) : base(widgetBasePartService, applicationContext, dbContext)
{
_commentsService = commentsService;
}
public MessageController(MessageDbContext dbContext)
{
_dbContext = dbContext;
}
public UserService(MessageDbContext ctx)
{
_messageDbContext = ctx;
}
public CommentsService(IApplicationContext applicationContext, MessageDbContext dbContext) : base(applicationContext, dbContext)
{
}
public MessageService(MessageDbContext context)
{
this.context = context;
}
