public async Task DeleteSlideShowAsync(SlideShowDetails slideShowDetails)
{
if (_dbConnection != null)
{
try
{
var allSlides = from slide in _dbConnection.Table <SlideShowDetails>() where slide.Id == slideShowDetails.Id select slide;
foreach (var slide in await allSlides.ToListAsync())
{
await _dbConnection.DeleteAsync(slide);
}
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
else
{
Debug.WriteLine("failed to get sqlite connection");
}
}
public async Task AddSubSlideShowAsync(string slideShowId, Slidedetail subSlide)
{
if (_dbConnection != null)
{
try
{
var allSlides = from slideShow in _dbConnection.Table <SlideShowDetails>() where slideShow.Id == slideShowId select slideShow;
if (allSlides != null && await allSlides.CountAsync() >= 1)
{
SlideShowDetails tempArticle = await allSlides.FirstOrDefaultAsync();
if (tempArticle.SlideDetails.Find(o => o.ImageUrl == subSlide.ImageUrl) == null)
{
tempArticle.SlideDetails.Add(subSlide);
}
else
{
tempArticle.SlideDetails.Find(o => o.ImageUrl == subSlide.ImageUrl).ImageDescription = subSlide.ImageDescription;
}
await _dbConnection.UpdateAsync(tempArticle);
}
else
{
//await _dbConnection.InsertAsync(slideShowDetails);
}
}
catch (Exception e)
{
Debug.WriteLine(e.ToString());
}
}
else
{
Debug.WriteLine("failed to get sqlite connection");
}
}
