public async Task <IActionResult> Create([Bind("Id,Text,CreatedAt")] Message message)
{
if (ModelState.IsValid)
{
_context.Add(message);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(message));
}
public async Task <login> AddUserAsync(login info)
{
_context.Add(info);
try
{
await _context.SaveChangesAsync();
}
catch (System.Exception exp)
{
_Logger.LogError($"Erro in {nameof(AddUserAsync)}: " + exp.Message);
}
return(info);
}
public async Task <Messages> AddMsgAsync(Messages data)
{
_context.Add(data);
try
{
await _context.SaveChangesAsync();
}
catch (System.Exception exp)
{
_Logger.LogError($"Error in {nameof(AddMsgAsync)}:" + exp.Message);
}
return(data);
}
public async Task <Message> Handle(Command request, CancellationToken cancellationToken)
{
var user = await _context.Users.FirstOrDefaultAsync(x => x.Id == request.UserId);
var channel = await _context.Channels.FirstOrDefaultAsync(x => x.Id == request.ChannelId);
var message = new Message
{
Id = request.Id,
Text = request.Text,
User = user,
Channel = channel,
CreatedAt = request.CreatedAt
};
_context.Messages.Add(message);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(message);
}
throw new Exception("Problem saving message");
}
public async void setConnectId(string Name)
{
data = await _service.login.SingleOrDefaultAsync(c => c.Name == Name);
data.ConnectionId = Context.ConnectionId;
_service.login.Attach(data);
_service.Entry(data).State = EntityState.Modified;
_service.SaveChangesAsync();
}
public async Task <int> SaveFilePathToDb(string filePath)
{
var storedFile = new StoredFile
{
FilePath = filePath
};
await _context.StoredFiles.AddAsync(storedFile);
await _context.SaveChangesAsync();
return(_context.StoredFiles.Count());
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var user = await _context.Users.FindAsync(request.Id);
if (user == null)
{
throw new Exception("Cannot find user");
}
_context.Remove(user);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var channel = await _context.Channels.FindAsync(request.Id);
if (channel == null)
{
throw new Exception("Could not find Channel");
}
channel.Name = request.Name ?? channel.Name;
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var message = await _context.Messages.FindAsync(request.Id);
if (message == null)
{
throw new Exception("Could not find message");
}
message.Text = request.Text ?? message.Text;
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <IActionResult> StoreFile([FromBody] StoreFileModel model)
{
try
{
var storedFile = new StoredFile
{
FilePath = model.filePath
};
_context.Conversations.Where(c => c.Id == model.ConversationId).FirstOrDefault()?.Files.Add(storedFile);
await _context.SaveChangesAsync();
_logger.LogInformation($"The File {Path.GetFileName(model.filePath)} of conversation {model.ConversationId} is stored");
return(Ok("FileStored"));
}
catch (Exception e)
{
_logger.LogError($"The File {Path.GetFileName(model.filePath)} of conversation {model.ConversationId} couldn't be stored: {e.Message}");
return(StatusCode(500, $"Internal server error: {e}"));
}
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var channel = new Channel
{
Id = request.Id,
Name = request.Name,
CreatedAt = request.CreatedAt
};
_context.Channels.Add(channel);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var user = await _context.Users.FindAsync(request.Id);
if (user == null)
{
throw new Exception("Could not find User");
}
user.Name = request.Name ?? user.Name;
user.Email = request.Email ?? user.Email;
user.Password = request.Password ?? user.Password;
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving changes");
}
public async Task <Unit> Handle(Command request, CancellationToken cancellationToken)
{
var user = new User
{
Id = request.Id,
Username = request.Username,
CreatedOn = request.CreatedOn,
Email = request.Email,
Name = request.Name,
Avatar = request.Avatar,
Password = request.Password
};
_context.Users.Add(user);
var success = await _context.SaveChangesAsync() > 0;
if (success)
{
return(Unit.Value);
}
throw new Exception("Problem saving User");
}
public async ValueTask DisposeAsync()
{
await _context.SaveChangesAsync();
}