public class DataAccess : IDisposable
    {
        private SQLiteConnection _connection;

        public DataAccess(ISQLitePlatform platform,string path)
        {

            _connection =new SQLiteConnection(platform,path);
            if(!Path.GetFileName(path).Contains("Users.db3"))
            _connection.CreateTable<UserModel>();
           List<SQLiteConnection.ColumnInfo> temp= _connection.GetTableInfo("User");
			//do sprawdzania czy dodany nowy user
            var users = from user in _connection.Table<UserModel>()
                        select user;
            UserModel uu = new UserModel();
            uu.Password = "pass";
            uu.Username = "owy";
            _connection.Insert(uu);
        }
        public void InsertUser(UserModel user)
        {

            _connection.Insert(user);
        }
        public void UpdateUser(UserModel user)
        {
            _connection.Update(user);
        }
        public void DeleteUser(UserModel user)
        {
            _connection.Delete(user);
        }

        public bool GetUser(UserModel logedUser)
        {

            UserModel user=_connection.Table<UserModel>().First(u => u.Password == logedUser.Password && u.Username == logedUser.Username);
            return user != null;
        }


        public UserModel GetUser(int id)
        {
            return _connection.Table<UserModel>().First(user =>user.UserId==id );

        }

        public List<UserModel> GetUsers()
        {
            return _connection.Table<UserModel>().ToList();
        }
        public void Dispose()
        {
            _connection.Dispose();
        }
    }