public String SyncUsers()
{
string selectQuery = "select * from arduino_db";
DataUser dataUser = new DataUser();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(selectQuery, connection);
adapter.Fill(table);
List <DataUser> usersTable = new List <DataUser>();
foreach (DataRow row in table.Rows)
{
usersTable.Add(new DataUser()
{
Id = Convert.ToInt16(row["id"]), Name = row["name"].ToString(), Pass = row["pass"].ToString()
});
}
return(ArduSerial.SerialJoinUsers("users", usersTable));
}
public String SyncProfiles()
{
string selectQuery = "select * from profiles";
DataProfile dataUser = new DataProfile();
DataTable table = new DataTable();
MySqlDataAdapter adapter = new MySqlDataAdapter(selectQuery, connection);
adapter.Fill(table);
List <DataProfile> profilesTable = new List <DataProfile>();
foreach (DataRow row in table.Rows)
{
profilesTable.Add(new DataProfile()
{
Id = Convert.ToInt16(row["id"]), Name = row["name"].ToString(), Delay = Convert.ToInt16(row["delay"]), HourStart = row["start"].ToString(), HourEnd = row["end"].ToString()
});
}
return(ArduSerial.SerialJoinProfiles("profiles", profilesTable));
}