public bool Update
(MeetingAttachment attachment, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
try
{
dbConnection.Open();
string updateQuery = $@"UPDATE [{schema}].[MeetingAttachment]
SET ReferanceId = @ReferanceId,
FileName = @FileName,
MeetingAttendeeId = @MeetingAttendeeId,
Date = @Date
WHERE Id = @Id";
var instance = dbConnection.Execute(updateQuery, new
{
attachment.Id,
attachment.ReferanceId,
attachment.FileName,
attachment.MeetingAttendeeId,
attachment.Date
});
return(instance == 1);
}
catch (Exception e)
{
Console.WriteLine(e);
return(false);
}
}
}
public (bool condition, string message) Update
(MeetingAttachment attachment, AuthRestModel user)
{
var instanceConnectionString = _applicationSetting.CreateConnectionString(_applicationSetting.Server,
_applicationSetting.Catalogue, user.InstanceId, _applicationSetting.GetInstancePassword(user.InstanceId));
var result = _meetingAttachmentRepository.Update(attachment, user.InstanceId, instanceConnectionString);
if (result)
{
return(true, "Success");
}
return(false, "Something went wrong");
}
public bool Add
(MeetingAttachment attachment, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
try
{
dbConnection.Open();
string insertSql = $@"insert into [{schema}].[MeetingAttachment](
[Id]
,[ReferanceId]
,[FileName]
,[MeetingAttendeeId]
,[Date]
,[FileData]
)
values(
@Id
,@ReferanceId
,@FileName
,@MeetingAttendeeId
,@Date
,@FileData
)";
var instance = dbConnection.Execute(insertSql, new
{
attachment.Id,
attachment.ReferanceId,
attachment.FileName,
attachment.MeetingAttendeeId,
attachment.Date,
attachment.FileData
});
return(instance == 1);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
return(false);
}
}
}
public ActionResult Post(List <IFormFile> files)
{
if (string.IsNullOrEmpty(HttpContext.Request.Query["id"].ToString()))
{
return(StatusCode(404, "Please provide a referenceId"));
}
long size = files.Sum(f => f.Length);
string meetingId = HttpContext.Request.Query["id"].ToString();
var userInfo = User.ToRest(); //Request.ExtractAuth(User, _authenticationService);
// full path to file in temp location
var filePath = Path.GetTempFileName();
foreach (var formFile in Request.Form.Files)
{
if (formFile.Length <= 0)
{
continue;
}
using (var ms = new MemoryStream())
{
formFile.CopyTo(ms);
var fileBytes = ms.ToArray();
//string file = Convert.ToBase64String(fileBytes);
var meetingFile = new MeetingAttachment
{
Date = DateTime.UtcNow,
FileData = fileBytes,
FileName = formFile.FileName,
Id = Guid.NewGuid(),
MeetingAttendeeId = userInfo.Sub,
ReferanceId = Guid.Parse(meetingId)
};
var meetingAttachmentResult = _meetingAttachmentService.Add(meetingFile, userInfo);
}
}
// process uploaded files
// Don't rely on or trust the FileName property without validation.
return(Ok(new { count = files.Count, size, filePath }));
}
public MeetingAttachment Put([FromBody] MeetingAttachment attachment)
{
var userInfo = Request.ExtractAuth(User, _authenticationService);
return(new MeetingAttachment());
}
