public List <Model.Group> GetGroupList() { using (keyCont = new KeynerContext()) { return(keyCont.GroupSet.ToList()); } }
private void GetCurrentTest(int id) { using (context = new KeynerContext()) { currentTest = context.TestSet.Find(id); } }
public BitmapImage GetMonster(int id_user, int mood) { BitmapImage im = new BitmapImage(); User user; MonsterLevel currentMonster; using (context = new KeynerContext()) { user = context.UserSet.Find(id_user); currentMonster = context.MonsterLevelSet.Where(m => m.Id_Monster == user.Id_Monster).ToList()[0]; } switch (mood) { case 1: return(ImageConvert.Convert(currentMonster.HappyImage)); case 2: return(ImageConvert.Convert(currentMonster.NeutralImage)); case 3: return(ImageConvert.Convert(currentMonster.ReadyImage)); case 4: return(ImageConvert.Convert(currentMonster.SadImage)); default: return(ImageConvert.Convert(currentMonster.NeutralImage)); } }
///якщо тест вже існує апдейтимо його статистику public void UpdateStatisctic(int id_user, int time, int mistakes, int mark, bool is_passed) { Statistic statistic; using (context = new KeynerContext()) { statistic = context.StatisticSet.Where(s => s.Id_User == id_user && s.Id_Test == currentTest.Id).ToList()[0]; if (!statistic.IsPassed && is_passed) { //якщо тест був не пройденний і ми його пройшли statistic.IsPassed = is_passed; statistic.Time = time; statistic.Mark = mark; statistic.CountMistakes = mistakes; context.SaveChanges(); BesTime(time); SetUserMoney(id_user, mark); } else if (time <= statistic.Time && mistakes <= statistic.CountMistakes && mark >= statistic.Mark) { statistic.Time = time; statistic.Mark = mark; statistic.CountMistakes = mistakes; context.SaveChanges(); ///найкращий час в пройденому тесті if (is_passed) { BesTime(time); } } } }
private void SetUserMoney(int id_us, int mark) { using (context = new KeynerContext()) { User user = context.UserSet.Find(id_us); user.Money += GetMoney(mark); context.SaveChanges(); } }
///найкращий час в тесті private void BesTime(int time) { if (currentTest.BestTime > time || currentTest.BestTime == 0) { using (context = new KeynerContext()) { context.TestSet.Where(t => t.Id == currentTest.Id).First().BestTime = time; context.SaveChanges(); } } }
//setting first user monster private void MakeFirstPurchase(int id_user, int id_monster) { using (keyCont = new KeynerContext()) { Model.Purchase purchase = new Purchase(); purchase.Id_Monster = id_monster; purchase.Id_User = id_user; keyCont.PurchaseSet.Add(purchase); keyCont.SaveChanges(); } }
public bool CheckName(string name) { using (keyCont = new KeynerContext()) { foreach (var item in keyCont.UserSet.ToList()) { if (item.Name == name) { return(true); } } return(false); } }
public bool GetPass(int id, string p) { using (keyCont = new KeynerContext()) { Model.User user = keyCont.UserSet.Find(id); if (user.Password == p) { return(true); } else { return(false); } } }
public int GetSpeed(int id_user, int finishTime) { int time = finishTime; int count = 1; List <Statistic> statistic; using (context = new KeynerContext()) { statistic = context.StatisticSet.Where(s => s.Id_User == id_user && s.Id_Test == currentTest.Id).ToList(); } foreach (var item in statistic) { time += item.Time; count++; } return(time / count); }
public int GetIdUser(string name, string pass) { using (keyCont = new KeynerContext()) { foreach (var item in keyCont.UserSet) { if (item.Name == name) { if (item.Password == pass) { return(item.Id); } } } return(0); } }
public string GetText() { collection.Clear(); using (context = new KeynerContext()) { text = currentTest.Text; } //RepeatCount = 3; //for (int i = 0; i < RepeatCount; i++) //{ for (int j = 0; j < text.Length; j++) { collection.Add(text[j]); } //} return(text); }
///finishTime!!!! ще не проходили тест - створюємо статистику public void FillNewStatistic(int id_user, int time, bool is_passed, int mistakes, int mark) { Statistic statistic = new Statistic(); statistic.Id_User = id_user; statistic.Id_Test = currentTest.Id; statistic.Time = time; statistic.Mark = mark; statistic.IsPassed = is_passed; statistic.CountMistakes = mistakes; ///найкращий час в пройденому тесті if (is_passed) { BesTime(time); SetUserMoney(id_user, mark); } using (context = new KeynerContext()) { context.StatisticSet.Add(statistic); context.SaveChanges(); } }
public void AddUser(string name, string pass, int group) { using (keyCont = new KeynerContext()) { User user = new User(); user.Name = name; user.Password = pass; user.Id_Group = group; user.Id_Monster = keyCont.MonsterSet.Where(m => m.Name == "Monster1").ToList()[0].Id; user.Money = 500; keyCont.UserSet.Add(user); //Purchase purchase = new Purchase(); //purchase.Id_Monster = user.Id_Monster; //purchase.Id_User = user.Id; //keyCont.PurchaseSet.Add(purchase); keyCont.SaveChanges(); MakeFirstPurchase(user.Id, user.Id_Monster); } }