public void UploadAttachment(Model.FileAsset file) { if (file.type == (int)FileAssetType.image) { var file_data = getAppropriateThumbnail(file); if (file_data == null) { log4net.LogManager.GetLogger(GetType()).WarnFormat("!STRANGE! file does not exist: {0}, {1}", file.file_id, file.saved_path); return; } postServiceClass.attachments_upload(file_data, CloudService.SessionToken, Settings.Default.GroupId, file.file_name, "", "", "image", "medium", file.file_id.ToString(), null, CloudService.APIKey, file.event_time); } else { var file_data = getVideoThumbnail(file); if (file_data == null) { log4net.LogManager.GetLogger(GetType()).WarnFormat("{1} seems not a valid video... {0}", file.file_id, file.saved_path); return; } postServiceClass.attachments_upload(file_data, CloudService.SessionToken, Settings.Default.GroupId, file.file_name + ".mp4", "", "", "video", "medium", file.file_id.ToString(), null, CloudService.APIKey, file.event_time); } }
public void UpdateFileOnCloud(Model.FileAsset file) { using (var db = new SQLiteConnection(MyDbContext.ConnectionString)) { db.Open(); using (var cmd = db.CreateCommand()) { cmd.CommandText = "update [Files] set on_cloud = 1 where file_id = @file"; cmd.Parameters.Add(new SQLiteParameter("@file", file.file_id)); cmd.ExecuteNonQuery(); } } }
public void SaveFileRecord(Model.FileAsset file) { var pendingFile = new PendingFile { file_id = file.file_id, file_name = file.file_name, file_path = file.file_path, file_size = file.file_size, deleted = file.deleted, device_id = file.device_id, event_time = file.event_time, saved_path = file.saved_path, seq = file.seq, thumb_ready = file.thumb_ready, type = file.type }; using (var db = new MyDbContext()) { db.Object.PendingFiles.Add(pendingFile); db.Object.SaveChanges(); } }