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;
}
