public void updateStatus(RemoteUser rUser)
{//Set status
this.connect();
SqlCeCommand cmd = this.conn.CreateCommand();
cmd.CommandText = "update " + TABLE_NAME + " set status='" + rUser.getStatus() + "' where username='******' and system='" + rUser.getSystemName() + "'";
cmd.ExecuteNonQuery();
this.disconnect();
}
public void addUser(RemoteUser rUser)
{
//add new user
this.connect();
SqlCeCommand cmd = this.conn.CreateCommand();
DateTime currentTime = DateTime.Now;
cmd.CommandText = "insert into " + TABLE_NAME + "(system,username,password,modified_date,status) values('" + rUser.getSystemName() + "','" + rUser.getUsername() + "','" + rUser.getPassword() + "','" + currentTime.ToString() + "','" + rUser.getStatus() + "')";
cmd.ExecuteNonQuery();
this.disconnect();
}
public void addUser(RemoteUser rUser)
{//add new user
this.connect();
SqlCeCommand cmd = this.conn.CreateCommand();
DateTime currentTime = DateTime.Now;
cmd.CommandText = "insert into " + TABLE_NAME + "(system,username,password,modified_date,status) values('" + rUser.getSystemName() + "','" + rUser.getUsername() + "','" + rUser.getPassword() + "','" + currentTime.ToString() + "','" + rUser.getStatus() + "')";
cmd.ExecuteNonQuery();
this.disconnect();
}
public void updateStatus(RemoteUser rUser)
{
//Set status
this.connect();
SqlCeCommand cmd = this.conn.CreateCommand();
cmd.CommandText = "update " + TABLE_NAME + " set status='" + rUser.getStatus() + "' where username='******' and system='" + rUser.getSystemName() + "'";
cmd.ExecuteNonQuery();
this.disconnect();
}