public List <listcustomechart> PerVideoCount(WordType wt, LeapKinnectType lk) { return(_video.Include(x => x.Words)//.Include(x => x.User) .Where(x => x.Words.WordType == wt && x.LeapKinnectType == lk) .GroupBy(x => x.Words.Name) .Select(c => new listcustomechart { wordname = c.Key, count = c.Count() //g.Select(m => m.Name).Count() }).ToList()); /*return _word.Include(x => x.Languages)//.Include(x => x.User) * .Where(x => x.WordType == wt) * .GroupBy(x => x.Name) * .Select(c => new listcustomechart * { * wordname = c.Key, * count = c.Count()//g.Select(m => m.Name).Count() * }).ToList();*/ //var results = (from v in _video // join w in _word on v.Words.word_id equals w.word_id // where v.Words.WordType == wt // group w by w.Name into g // select new listcustomechart // { // wordname = g.Key, // count = g.Select(m => m.Name).Count() // }).ToList(); //return results; //return (from v in _video join w in _word on v.Words.word_id equals w.word_id where v.Words.WordType == wt select v).Count(); //return _word.Count(x => x.WordType == wt); }
public int VideoCount(WordType wt, LeapKinnectType lk) { return((from v in _video join w in _word on v.Words.word_id equals w.word_id where v.Words.WordType == wt && v.LeapKinnectType == lk select v).Count()); //return _word.Count(x => x.WordType == wt); }
public List <listcustomechart> PerVideoPartCount8(LeapKinnectType mlk) { return(word.PerVideoCount(WordType.Arbitrary_Sentences, mlk)); }
public List <listcustomechart> PerVideoPartCount7(LeapKinnectType mlk) { return(word.PerVideoCount(WordType.Sentences_By_Signs, mlk)); }
public List <listcustomechart> PerVideoPartCount5(LeapKinnectType mlk) { return(word.PerVideoCount(WordType.Words_By_Letters, mlk)); }
public List <listcustomechart> PerVideoPartCount2(LeapKinnectType mlk) { return(word.PerVideoCount(WordType.Numberslarger10, mlk)); }
public int VideoCount8(LeapKinnectType mlk) { return(word.VideoCount(WordType.Arbitrary_Sentences, mlk)); }
public int VideoCount7(LeapKinnectType mlk) { return(word.VideoCount(WordType.Sentences_By_Signs, mlk)); }
public int VideoCount5(LeapKinnectType mlk) { return(word.VideoCount(WordType.Words_By_Letters, mlk)); }
public int VideoCount4(LeapKinnectType mlk) { return(word.VideoCount(WordType.Words_By_Signs, mlk)); }
public int VideoCount2(LeapKinnectType mlk) { return(word.VideoCount(WordType.Numberslarger10, mlk)); }
public int VideoCount1(LeapKinnectType mlk) { return(word.VideoCount(WordType.Numberslitle10, mlk)); }
public WordVideoVM(VideoModel model, int videostyp, int?word_id, LeapKinnectType thisleaporkin, IUnitOfWork uw) { Contract.Requires(model != null); _uow = uw; videotype = videostyp; VideoInfo = model; video = new VideoService(_uow); word = new WordsService(_uow); option = new OptionService(_uow); user = new UserService(_uow); listitem = new ListItems(); wordid = word_id; //AllLanguages = GetAllLanguages(); //allWordTypes = listitem.GetWordType(); app = option.GetAll(); lk = thisleaporkin; //app.FileUrl = "c:"; RefreshProducts(); chatmodel = new MSChartVM(); //chatmodel.BarChart(); charttest = chatmodel.BarSeriesCollection;// PerVideoPartCount(); if (model != null /* && UtilityClass.CheckIntHasValue(model.video_id)*/) { //wordType = model.Words.WordType; //elang = model.Words.Languages; //Name = model.Words.Name; eword = model.Words; if (!string.IsNullOrEmpty(model.KinnectFilePath) && videotype == 1) { //euser = model.User; //if (model.User_id.HasValue) // User_id = model.User_id.Value; _attachPicture = new Uri(app.FileUrl + @"\" + model.KinnectFilePath);//UtilityClass.ByteToStream(app.FileUrl + model.FilePath); selectedpic = model.KinnectFilePath; prevpic = model.KinnectFilePath; } else if (!string.IsNullOrEmpty(model.LeapFilePath) && videotype != 1) { //euser = model.User; //if (model.User_id.HasValue) // User_id = model.User_id.Value; _attachPicture = new Uri(app.FileUrl + @"\" + model.LeapFilePath);//UtilityClass.ByteToStream(app.FileUrl + model.FilePath); selectedpic = model.LeapFilePath; prevpic = model.LeapFilePath; } } ConfigureValidationRules(); Validator.ResultChanged += OnValidationResultChanged; }
public ObservableCollection <VideoModel> GetWords(int start, int itemCount, string sortColumn, bool ascending, out int totalItems, int?wordid, LeapKinnectType lk) { //using (var context = new MyDbContext()) //{ IList <VideoModel> allpats = ((wordid.HasValue)?_video.Include(x => x.User) .Include(x => x.Words) .Where(x => x.word_id == wordid.Value && x.LeapKinnectType == lk) .Select(c => new VideoModel { video_id = c.video_id, KinnectFilePath = c.KinnectFilePath, LeapFilePath = c.LeapFilePath, User_id = c.User_id.Value, User = c.User, Words = c.Words, word_id = c.word_id }).ToList(): _video.Include(x => x.User) .Include(x => x.Words) .Where(x => x.LeapKinnectType == lk) .Select(c => new VideoModel { video_id = c.video_id, KinnectFilePath = c.KinnectFilePath, LeapFilePath = c.LeapFilePath, User_id = c.User_id.Value, User = c.User, Words = c.Words, word_id = c.word_id }).ToList()); totalItems = allpats.Count; ObservableCollection <VideoModel> sortedProducts = new ObservableCollection <VideoModel>(); // Sort the products. In reality, the items should be stored in a database and // use SQL statements for sorting and querying items. switch (sortColumn) { case ("video_id"): sortedProducts = new ObservableCollection <VideoModel> ( from p in allpats orderby p.video_id select p ); break; } sortedProducts = ascending ? sortedProducts : new ObservableCollection <VideoModel>(sortedProducts.Reverse()); ObservableCollection <VideoModel> filteredProducts = new ObservableCollection <VideoModel>(); for (int i = start; i < start + itemCount && i < totalItems; i++) { filteredProducts.Add(sortedProducts[i]); } return(filteredProducts); //} }