private static int GetId() { bool IsIdExists(int id) { using (var db = new PutBoxSqlModel()) { return(db.FileDatas.Any(x => x.id == id) || db.FolderDatas.Any(x => x.id == id) || db.UserDatas.Any(x => x.id == id)); } } using (var db = new PutBoxSqlModel()) { var size = db.UserDatas.Count() + db.FileDatas.Count() + db.FolderDatas.Count(); while (true) { var tmpId = new Random().Next(0, size + 1); if (!IsIdExists(tmpId)) { return(tmpId); } } } }
public string GetPath(UserInfo user) { using (var db = new PutBoxSqlModel()) { var tmpPassword = user.Password.GetHashCode().ToString(); return(db.UserDatas.First(x => x.email == user.Email && x.password == tmpPassword).path); } }
public bool Login(UserInfo user) { using (var db = new PutBoxSqlModel()) { var tmpPassword = user.Password.GetHashCode().ToString(); return(db.UserDatas.Any(x => x.email == user.Email && x.password == tmpPassword)); } }
public bool Register(string email, string password) { using (var db = new PutBoxSqlModel()) { if (db.UserDatas.Any(x => x.email == email)) { return(false); } var tmpId = GetId(); db.UserDatas.Add(new UserData() { email = email, password = password.GetHashCode().ToString(), id = tmpId, path = $@"/{tmpId}" }); db.SaveChanges(); } return(true); }