public MediaViewModel GetItem(int itemId)
{
var item = new MediaViewModel();
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
var _item = (db.Table <Media>().Where(
c => c.Id == itemId)).Single();
item.Id = _item.Id;
item.Name = _item.Name;
item.CreationDate = _item.CreationDate;
item.VidOrPic = _item.VidOrPic;
}
return(item);
}
public ObservableCollection<MediaViewModel> GetItems()
{
items = new ObservableCollection<MediaViewModel>();
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
var query = db.Table<Media>().OrderBy(c => c.Id);
foreach (var _item in query)
{
var item = new MediaViewModel()
{
Id = _item.Id,
Name = _item.Name,
CreationDate = _item.CreationDate,
VidOrPic = _item.VidOrPic
};
items.Add(item);
}
}
return items;
}
public ObservableCollection <MediaViewModel> GetItems()
{
items = new ObservableCollection <MediaViewModel>();
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
var query = db.Table <Media>().OrderBy(c => c.Id);
foreach (var _item in query)
{
var item = new MediaViewModel()
{
Id = _item.Id,
Name = _item.Name,
CreationDate = _item.CreationDate,
VidOrPic = _item.VidOrPic
};
items.Add(item);
}
}
return(items);
}
public string SaveItem(MediaViewModel item)
{
string result = string.Empty;
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
try
{
var existingItem = (db.Table <Media>().Where(
c => c.Id == item.Id)).SingleOrDefault();
if (existingItem != null)
{
existingItem.Id = item.Id;
existingItem.Name = item.Name;
existingItem.VidOrPic = item.VidOrPic;
int success = db.Update(existingItem);
}
else
{
int success = db.Insert(new Media()
{
Id = item.Id,
Name = item.Name,
CreationDate = item.CreationDate,
VidOrPic = item.VidOrPic
});
}
result = "Success";
}
catch
{
result = "This item was not saved.";
}
}
return(result);
}
/// <summary>
/// Captures a single frame from the running webcam stream and executes the FaceDetector on the image. If successful calls SetupVisualization to display the results.
/// </summary>
/// <returns>Async Task object returning true if the capture was successful and false if an exception occurred.</returns>
private async Task<bool> TakeSnapshotAndFindFaces()
{
bool successful = true;
try
{
if (this.currentState != ScenarioState.Streaming)
{
return false;
}
// TODO : photo and video option.
if(videoOrPic)
{
captureFile = await folder.CreateFileAsync("timeline.mp4", CreationCollisionOption.GenerateUniqueName);
await mediaCapture.StartRecordToStorageFileAsync(MediaEncodingProfile.CreateMp4(VideoEncodingQuality.HD720p), captureFile);
//TODO : Link ViewModel
media = new MediaViewModel();
media.SaveItem(new MediaViewModel
{
Name = captureFile.DisplayName,
CreationDate = captureFile.DateCreated.DateTime,
VidOrPic = true
});
}
else
{
captureFile = await folder.CreateFileAsync("timeline.jpeg", CreationCollisionOption.GenerateUniqueName);
await mediaCapture.CapturePhotoToStorageFileAsync(ImageEncodingProperties.CreateJpeg(), captureFile);
//TODO : link ViewMOdel
media = new MediaViewModel();
media.SaveItem(new MediaViewModel
{
Name = captureFile.DisplayName,
CreationDate = captureFile.DateCreated.DateTime,
VidOrPic = false
});
}
// TODO
}
catch (Exception ex)
{
this.rootPage.NotifyUser(ex.ToString(), NotifyType.ErrorMessage);
successful = false;
}
return successful;
}
public string SaveItem(MediaViewModel item)
{
string result = string.Empty;
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
try
{
var existingItem = (db.Table<Media>().Where(
c => c.Id == item.Id)).SingleOrDefault();
if (existingItem != null)
{
existingItem.Id = item.Id;
existingItem.Name = item.Name;
existingItem.VidOrPic = item.VidOrPic;
int success = db.Update(existingItem);
}
else
{
int success = db.Insert(new Media()
{
Id = item.Id,
Name = item.Name,
CreationDate = item.CreationDate,
VidOrPic = item.VidOrPic
});
}
result = "Success";
}
catch
{
result = "This item was not saved.";
}
}
return result;
}
public MediaViewModel GetItem(int itemId)
{
var item = new MediaViewModel();
using (var db = new SQLiteConnection(App.SQLITE_PLATFORM, App.DB_PATH))
{
var _item = (db.Table<Media>().Where(
c => c.Id == itemId)).Single();
item.Id = _item.Id;
item.Name = _item.Name;
item.CreationDate = _item.CreationDate;
item.VidOrPic = _item.VidOrPic;
}
return item;
}
