public void AlteraNome(int salaId, string nome, string userId)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { SalaId = salaId, Nome = nome, UserId = userId };
sql.AlterData <string, dynamic>("dbo.spAlteraNomeSala", parameters, "WebAPIData");
}
public void AlteraCoordenadasSala(string salaId, double xcoord, double ycoord, string userId)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { SalaId = salaId, Xcoord = xcoord, Ycoord = ycoord, UserId = userId };
sql.AlterData <string, dynamic>("dbo.spAlteraCoordenadasSala", parameters, "WebAPIData");
}
public void AtualizaMusicaAtual(int salaId, int posicao)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { SalaId = salaId, Posicao = posicao };
sql.AlterData <int, dynamic>("dbo.spAlteraMusicaAtualSala", parameters, "WebAPIData");
}
public void AlteraPosicaoMusicaSala(int salaId, string uri, int posAtual, int posFinal, string userId)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { UserId = userId, SalaId = salaId, MusicaURI = uri, PosicaoAtual = posAtual, PosicaoFinal = posFinal };
sql.AlterData <string, dynamic>("dbo.spAlteraPosicaoMusicaSala", parameters, "WebAPIData");
}
public void AbreSala(int salaId, string userId)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { UserId = userId, SalaId = salaId };
sql.AlterData <Tuple <string, int>, dynamic>("dbo.spAbreSala", parameters, "WebAPIData");
}
public void AlteraPassword(int salaId, string password, string userId)
{
SqlDataAccess sql = new SqlDataAccess();
var parameters = new { SalaId = salaId, Password = password, UserId = userId };
sql.AlterData <string, dynamic>("dbo.spAlteraPasswordSala", parameters, "WebAPIData");
}