public runopolyuser Post(runopolyuser user) { user.lastlogindate = DateTime.Now; long id = connector.UserAdd(user); var returnuser = connector.UserGet(id); if (returnuser == null) throw new HttpResponseException(HttpStatusCode.NotFound); return returnuser; }
public runopolyuser UpdateUser(runopolyuser user) { var _user = connector.UserGet(user.id); if (_user == null) throw new HttpResponseException(HttpStatusCode.NotFound); connector.UserUpdate(user); var returnuser = connector.UserGet(user.id); if (returnuser == null) throw new HttpResponseException(HttpStatusCode.NotFound); return returnuser; }
public bool UserUpdate(runopolyuser user) { try { conn.Open(); string strSQL = "UPDATE runopoly_users SET " + "nick_name = " + "'" + user.nick_name + "', " + "first_name = " + "'" + user.first_name + "', " + "last_name = " + "'" + user.last_name + "', " + "gender = " + "'" + user.gender + "', " + "email = " + "'" + user.email + "', " + "LastLoginDate = '" + toMySQLDateTime(DateTime.Now) + "' " + "WHERE id = '" + user.id.ToString() + "'"; OdbcCommand myCommand = new OdbcCommand(strSQL, conn); bool retVal = (1 == myCommand.ExecuteNonQuery()); return retVal; } catch { return false; } finally { conn.Close(); } }
public runopolyuser UserGet(long id) { runopolyuser returnUser = null; try { string strSQL0 = "SELECT * from runopoly_users WHERE id = " + id.ToString(); OdbcCommand myCommand0 = new OdbcCommand(strSQL0, conn); conn.Open(); OdbcDataReader myReader0 = myCommand0.ExecuteReader(); while (myReader0.Read()) { returnUser = new runopolyuser(); returnUser.id = Int32.Parse(myReader0.GetValue(myReader0.GetOrdinal("id")).ToString()); returnUser.nick_name = myReader0.GetValue(myReader0.GetOrdinal("nick_name")).ToString(); returnUser.first_name = myReader0.GetValue(myReader0.GetOrdinal("first_name")).ToString(); returnUser.last_name = myReader0.GetValue(myReader0.GetOrdinal("last_name")).ToString(); returnUser.gender = myReader0.GetValue(myReader0.GetOrdinal("gender")).ToString(); returnUser.email = myReader0.GetValue(myReader0.GetOrdinal("email")).ToString(); returnUser.lastlogindate = myReader0.GetDateTime(myReader0.GetOrdinal("lastlogindate")); } myReader0.Close(); conn.Close(); return returnUser; } catch { return null; } }
public long UserAdd(runopolyuser user) { long id = 0; try { conn.Open(); string strSQL = "INSERT INTO runopoly_users (nick_name, first_name, last_name, gender, email,lastlogindate) VALUES (" + "'" + user.nick_name + "', " + "'" + user.first_name + "', " + "'" + user.last_name + "', " + "'" + user.gender + "', " + "'" + user.email + "', " + "'" + toMySQLDateTime(user.lastlogindate) + "')"; OdbcCommand myCommand = new OdbcCommand(strSQL, conn); myCommand.ExecuteNonQuery(); myCommand.CommandText = "SELECT LAST_INSERT_ID()"; IDataReader reader = myCommand.ExecuteReader(); if (reader != null && reader.Read()) id = reader.GetInt64(0); return id; } catch { return 0; } finally { conn.Close(); } }
public runopolyuser updateuser(long id, runopolyuser _user) { var user = connector.UserGet(id); if (user == null) throw new HttpResponseException(HttpStatusCode.NotFound); connector.UserUpdate(_user); return user; }