Exemple #1
0
 public static User getUserProperties()
 {
     DataRow row = DBHandler.getTable("SELECT * FROM UserProperties").Rows[0];
     User user = new User();
     user.Email = row["email"].ToString();
     user.UserId = row["userId"].ToString();
     user.Name = row["name"].ToString();
     user.Password = row["password"].ToString();
     user.SecurityCode = row["securityCode"].ToString();
     user.ImageId = row["imageId"].ToString();
     return user;
 }
Exemple #2
0
 //insert user's properties
 private Boolean setProperties(String name, String email,
                                 String password, String userId)
 {
     const string NOT_CONFIRMED = "not confirmed";
     //userId = userId.Substring(0, 32);
     User user = new User();
     user.Email = email;
     user.Name = name;
     user.Password = password;
     user.UserId = userId;
     user.SecurityCode = NOT_CONFIRMED;
     DBHandler.initDB();
     String result = LocalData.addUser(user);
     if (result == null)
     {
         //MessageBox.Show("in set");
         return true;
     }
     //
     else
     {
         //MessageBox.Show("SQL ERROR: " + result);
     }
     return true;
 }
        //creates a new user object
        private User createUser(string userName)
        {
            Utility myUtility = new Utility();
            User myUser = new User
            {
                UserName = myUtility.formatUpperCase(userName)
            };

            return myUser;
        }
Exemple #4
0
 public static string updateUser(User user)
 {
     StringBuilder sb = new StringBuilder();
     sb.Append("email='" + user.Email + "',");
     sb.Append("userId='" + user.UserId + "',");
     sb.Append("name='" + user.Name + "',");
     sb.Append("password='******',");
     sb.Append("securityCode='" + user.SecurityCode + "',");
     sb.Append("imageId='" + user.ImageId + "'");
     Console.WriteLine();
     Console.WriteLine();
     Console.WriteLine(sb);
     Console.WriteLine();
     return DBHandler.executeCmd("UPDATE UserProperties SET " + sb + " WHERE email='" + user.Email + "'");
 }
Exemple #5
0
 public static string deleteUser(User user)
 {
     return DBHandler.executeCmd("DELETE FROM UserProperties WHERE email='" + user.Email + "'");
 }
Exemple #6
0
 public static string addUser(User user)
 {
     return DBHandler.insert("INSERT INTO UserProperties(email , name , userId , password , securityCode) VALUES('" + user.Email + "' , '" + user.Name + "' , '" + user.UserId + "' ,'" + user.Password + "' , '" + user.SecurityCode + "')");
 }