private void StoriesList_ItemClick(object sender, ItemClickEventArgs e)
{
var item = ((InstaReelFeed)e.ClickedItem);
GridViewItem itemAnimation = (GridViewItem)StoriesList.ContainerFromItem(item);
itemList = itemAnimation;
ConnectedAnimationService.GetForCurrentView().PrepareToAnimate("image", itemAnimation);
StoryFr.Navigate(typeof(StoryView.StoryViews), item);
}
void StoriesList_ItemClick(object sender, ItemClickEventArgs e)
{
SearchPage.GridAuto.Visibility = Visibility.Collapsed;
MainPage.Bar.Visibility = Visibility.Collapsed;
var item = ((InstaStory)e.ClickedItem);
var itemAnimation = (GridViewItem)StoriesList.ContainerFromItem(item);
itemList = itemAnimation;
ConnectedAnimationService.GetForCurrentView().PrepareToAnimate("image", itemAnimation);
StoryFr.Navigate(typeof(StoryView.StoryViews), item);
}
public HomeViewModel(List <Story> allStories)
: this()
{
foreach (Story story in allStories)
{
if (string.IsNullOrEmpty(story.ImgLink) == false)
{
string imageFullPath = Path.Combine(Constants.ImagesDirectory, story.ImgLink);
HomeStoriesViewModel item = new HomeStoriesViewModel(story);
item.ImgLink = imageFullPath;
StoriesList.Add(item);
}
}
}
internal StoriesList GetStoriesList()
{
StoriesList result = new StoriesList();
string sql = @"
select id,plot,upvotes,writer from dbo.stories a with(nolock) " ;
using (SqlCommand cmd = new SqlCommand(sql))
{
Sql u = new Sql();
DataSet ds = u.GetDataSet(cmd);
result.Stories = List.DataTableToList <Stories>(ds.Tables[0]);
}
return(result);
}
private StoriesList AddStories(IEnumerable <Story> stories)
{
StoriesList storiesList = new StoriesList();
List <StoriesSummary> storySummaries = new List <StoriesSummary>();
storiesList.available = stories.Count();
storiesList.returned = stories.Count();
storiesList.collectionURI = string.Empty;
foreach (var item in stories)
{
storySummaries.Add(new StoriesSummary()
{
resourceURI = item.ResourceUri, name = item.Title, type = item.Type
});
}
return(storiesList);
}
private void StoriesList_ItemClick(object sender, ItemClickEventArgs e)
{
var item = ((InstaReelFeed)e.ClickedItem);
if (item.User.UserName is "You")
{
if (item.Items.Count is 0)
{
PivotView.SelectedIndex = 0;
return;
}
}
GridViewItem itemAnimation = (GridViewItem)StoriesList.ContainerFromItem(item);
itemList = itemAnimation;
ConnectedAnimationService.GetForCurrentView().PrepareToAnimate("image", itemAnimation);
StoryFr.Navigate(typeof(StoryView.StoryViews), item);
MainPage.Bar.Visibility = Visibility.Collapsed;
}
internal StoriesList GetStoriesList(int PageIndex, int PageSize)
{
int start_row = PageIndex == 1 ? 1 : ((PageIndex - 1) * PageSize) + 1;
int end_row = PageIndex == 1 ? PageSize : start_row + PageSize - 1;
StoriesList result = new StoriesList();
string sql = @"
--declare
--@StartRow int = 1
--,@EndRow int = 10
--,@PageSize int = 1
select * from (
select row_number() OVER (ORDER BY id) as RowNo,
id,
plot,
upvotes,
writer
from dbo.stories a with(nolock)
) X
WHERE X.RowNo BETWEEN @StartRow AND @EndRow
--總頁數
SELECT ceiling(COUNT(1)*1.0/@PageSize) as PageCount
FROM dbo.stories with(nolock)
";
using (SqlCommand cmd = new SqlCommand(sql))
{
Sql u = new Sql();
cmd.Parameters.AddWithValue("@StartRow", start_row);
cmd.Parameters.AddWithValue("@EndRow", end_row);
cmd.Parameters.AddWithValue("@PageSize", PageSize);
DataSet ds = u.GetDataSet(cmd);
result.Stories = List.DataTableToList <Stories>(ds.Tables[0]);
}
return(result);
}
