private string CheckPassword(string username)
{
try
{
DataSet ds = ExecuteQuery("Select * from users where username='******'");
if (ds.Tables[0].Rows.Count != 1)
{
return null;
}
else
{
Users u = new Users(ds.Tables[0].Rows[0]);
return u._password;
}
}
catch (Exception e)
{
string s = e.ToString();
return null;
}
}
private void button2_Click(object sender, EventArgs e)
{
label8.Text = "";
label4.Text = "";
if (listBox1.Items.Count > 0)
{
button2.Enabled = true;
if (textBox1.Text.Trim() == "" && textBox2.Text.Trim() == "" && textBox3.Text.Trim() == "")
{
label5.Text = "Insert the playlist name!";
label5.Visible = true;
label6.Text = "Insert the user name!";
label6.Visible = true;
label7.Text = "Insert the location of user!";
label7.Visible = true;
}
else if (textBox1.Text.Trim() == "" && textBox2.Text.Trim() == "")
{
label5.Text = "Insert the playlist name!";
label5.Visible = true;
label6.Text = "Insert the user name!";
label6.Visible = true;
label7.Visible = false;
}
else if (textBox2.Text.Trim() == "" && textBox3.Text.Trim() == "")
{
label6.Text = "Insert the user name!";
label6.Visible = true;
label7.Text = "Insert the location of user!";
label7.Visible = true;
label5.Visible = false;
}
else if (textBox1.Text.Trim() == "" && textBox3.Text.Trim() == "")
{
label5.Text = "Insert the playlist name!";
label5.Visible = true;
label7.Text = "Insert the location of user!";
label7.Visible = true;
label6.Visible = false;
}
else if (textBox1.Text.Trim() == "")
{
label5.Text = "Insert the playlist name!";
label5.Visible = true;
label7.Visible = false;
label6.Visible = false;
}
else if (textBox2.Text.Trim() == "")
{
label6.Text = "Insert the user name!";
label6.Visible = true;
label7.Visible = false;
label5.Visible = false;
}
else if (textBox3.Text.Trim() == "")
{
label7.Text = "Insert the location of user!";
label7.Visible = true;
label6.Visible = false;
label5.Visible = false;
}
else
{
int g = iRadioDei_WindowsApp.Playlist.CheckPlaylistByUsername(textBox2.Text);
if (g == -99)
{
label8.Text = "An error occurred while inserting the playlist. Try again later!";
label8.Visible = true;
}
else if (g == -1)
{
label4.Text = "You already have a playlist created this week!";
label4.Visible = true;
}
else
{
label7.Visible = false;
label6.Visible = false;
label5.Visible = false;
Users usr = new Users();
string iduser = usr.checkUser(textBox2.Text, textBox3.Text);
iRadioDei_WindowsApp.pt.ipp.isep.dei.wvm036.MusicPreferences_Service proxy = new
iRadioDei_WindowsApp.pt.ipp.isep.dei.wvm036.MusicPreferences_Service();
string location = iRadioDei_WindowsApp.Users.GetLocationByUsername(textBox2.Text);
if (iduser != "")
{
Playlist pl = new Playlist();
int idpl = pl.CreatePlaylist(textBox1.Text, textBox2.Text);
if (idpl == -99)
{
label8.Text = "An error occurred while inserting the playlist. Try again later!";
label8.Visible = true;
}
else
{
Music m = new Music();
string[] mus = new string[listBox1.Items.Count];
for (int i = 0; i < listBox1.Items.Count; i++)
{
mus[i] = listBox1.Items[i].ToString();
int id_music = m.GetIdMusicByName(listBox1.Items[i].ToString());
if (id_music == -99)
{
label8.Text = "An error occurred while inserting the playlist. Try again later!";
label8.Visible = true;
}
else
{
int q = pl.SavePlaylistMusic(id_music, idpl);
if (q == -99)
{
label8.Text = "An error occurred while inserting the playlist. Try again later!";
label8.Visible = true;
}
}
}
int f1 = iRadioDei_WindowsApp.Playlist.insertVote(idpl);
if (f1 == -99)
{
label8.Text = "An error occurred while inserting the playlist. Try again later.";
label8.Visible = true;
}
if (location != null)
{
proxy.getDadosiRadioDei(textBox1.Text, mus, location);
}
label8.Text = "Playlist created successfully!";
listBox1.Items.Clear();
textBox1.Text = ""; textBox2.Text = ""; textBox3.Text = "";
label4.Text = "";
}
}
else
{
label8.Text = "Doesn't exist a user with this name and location!";
}
}
}
}
else
{
label8.Text = "You need to add at least one music!";
}
}