public User getUserByUserName(string username)
    {
        DataSet ds = new DataSet();
        try
        {
            mConnection.Open();

            string mSql = "SELECT * FROM Users WHERE UserName = '" + username + "'";
            OleDbCommand mCommand = new OleDbCommand(mSql, mConnection);
            OleDbDataAdapter mAdapter = new OleDbDataAdapter();
            mAdapter.SelectCommand = mCommand;
            mAdapter.Fill(ds);
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            mConnection.Close();
        }

        if (ds.Tables[0].Rows.Count != 0)
        {
            DataRow drc = ds.Tables[0].Rows[0];
            User u = new User();
            u.Id = Convert.ToInt32(drc[0]);
            u.Name = drc[1].ToString();
            u.FirstName = drc[2].ToString();
            u.LastName = drc[3].ToString();
            u.IsraeliId = drc[4].ToString();
            u.BirthDate = Convert.ToDateTime(drc[5]);
            u.Street = drc[6].ToString();
            u.HouseNumber = Convert.ToInt32(drc[7]);
            u.City = Convert.ToInt32(drc[8]);
            u.ZipCode = Convert.ToInt32(drc[9]);
            u.PhoneNumberAreaCode = Convert.ToInt32(drc[10]);
            u.PhoneNumber = drc[11].ToString();
            u.MobilePhoneNumberAreaCode = Convert.ToInt32(drc[12]);
            u.MobilePhoneNumber = drc[13].ToString();
            u.Email = drc[14].ToString();
            u.Password = drc[15].ToString();
            u.Admin = Convert.ToBoolean(drc[16]);
            u.Banned = Convert.ToBoolean(drc[17]);

            return u;
        }
        return null;
    }