public bool Signin(UserData user) { DemoBaseContext context = new DemoBaseContext(); bool illegal = false; string noThese = ");"; string name = user.UserName, word = user.Password, emai = user.Email; int count = context.UserData.ToList().Count; for (int i = 0; i < noThese.Length; i++) { if (name.Contains(noThese[i]) || word.Contains(noThese[i]) || emai.Contains(noThese[i])) { illegal = true; } name = name.Replace(noThese[i].ToString(), string.Empty); } if (illegal == false && UserExist(name, context) == false) { context.UserData.Add(user); } if (illegal || count <= context.UserData.Count()) { return(false); } else { return(true); } }
public List <UserData> Users() { DemoBaseContext context = new DemoBaseContext(); List <UserData> temps = context.UserData.OrderByDescending(x => x.UserName).Take(10).ToList(); return(temps); }
public List <BattleShip> Ships() { DemoBaseContext context = new DemoBaseContext(); List <BattleShip> temps = context.BattleShip.OrderByDescending(x => x.TimeValue).Take(10).ToList(); return(temps); }
public List <Temperature> temps() { DemoBaseContext context = new DemoBaseContext(); List <Temperature> temps = context.Temperature.OrderByDescending(x => x.TimeValue).Take(10).ToList(); return(temps); }
public int SaveTemps(Temperature data) { DemoBaseContext context = new DemoBaseContext(); context.Temperature.Add(data); context.SaveChanges(); int count = context.Temperature.ToList().Count; return(count); }
private bool UserExist(string userName, DemoBaseContext context) { bool exists = false; int amount = context.UserData. Where(UserData => UserData.UserName == userName).Count(); if (amount != 0) { exists = true; } return(exists); }
//[Consumes("application/json")] public int Login(UserData user) { string noThese = ");"; string name = user.UserName; string word = user.Password; //string email = user.Email; for (int i = 0; i < noThese.Length; i++) { name = name.Replace(noThese[i].ToString(), string.Empty); word = word.Replace(noThese[i].ToString(), string.Empty); //email = email.Replace(noThese[i].ToString(), string.Empty); } /* */ DemoBaseContext context = new DemoBaseContext(); /* * List<UserData> datasa = context.UserData * .Where(x => x.UserName == name) * .Where(x => x.Password == word) * .ToList(); * List<UserData> datas = context.UserData.ToList(); * int amount = datas.Where(UserData => UserData.UserName == name) * .Where(UserData => UserData.Password == word).Count(); * .Where(x => x.Email == email) */ int amount = context.UserData .Where(x => x.UserName == name) .Where(x => x.Password == word) .ToList() .Count(); return(amount); /* * if (amount == 1) return true; * else return false; */ }
public int SaveShips(BattleShip data) { DemoBaseContext context = new DemoBaseContext(); List <BattleShip> battleShip = context.BattleShip.Where(x => x.UserId == data.UserId).ToList(); if (battleShip.Count() == 1) { battleShip[0].Score = data.Score; //context.SaveChanges(); } else { context.BattleShip.Add(data); } context.SaveChanges(); int count = context.BattleShip.ToList().Count; return(count); }