private void Image_MouseDown(object sender, MouseButtonEventArgs e)
{
ButtonPressed = true;
/// delete from database and update list
if (fromControl == (int)ControlTypes.UserPanel)
{
UserControl uc = ((((this.Parent as Grid).Parent as Grid).Parent as Grid).Parent as UserControl);
UserPanel up = (uc as UserPanel);
CustomMessageBox cmb = new CustomMessageBox((int)MessageBoxColorTypes.yellow, "Sunteti sigur ca doriti sa stergeti acest anunt?", up, MessageBoxButton.YesNo);
if (cmb.ShowDialog() == true)
{
if (ad.DeleteFromDataBase())
{
up.ads.RemoveAt(up.ads.FindIndex(x => x == adID));
up.ResetAds();
DeleteImages();
cmb = new CustomMessageBox((int)MessageBoxColorTypes.green, "Anuntul a fost sters cu succes!", up, MessageBoxButton.OK);
cmb.ShowDialog();
}
else
{
cmb = new CustomMessageBox((int)MessageBoxColorTypes.red, "A aparut o eroare, daca problema persista va rugam sa contactati un administrator!", up, MessageBoxButton.OK);
cmb.ShowDialog();
}
}
}
else if (fromControl == (int)ControlTypes.AdvertisementsPage)
{
UserControl uc = (((this.Parent as Grid).Parent as Grid).Parent as UserControl);
AdvertisementsPage ac = (uc as AdvertisementsPage);
CustomMessageBox cmb = new CustomMessageBox((int)MessageBoxColorTypes.yellow, "Sunteti sigur ca doriti sa stergeti acest anunt?", ac, MessageBoxButton.YesNo);
if (cmb.ShowDialog() == true)
{
if (ad.DeleteFromDataBase())
{
ac.adIds.RemoveAt(ac.adIds.FindIndex(x => x == adID));
ac.ResetAds();
DeleteImages();
cmb = new CustomMessageBox((int)MessageBoxColorTypes.green, "Anuntul a fost sters cu succes!", uc, MessageBoxButton.OK);
cmb.ShowDialog();
}
else
{
cmb = new CustomMessageBox((int)MessageBoxColorTypes.red, "A aparut o eroare, daca problema persista va rugam sa contactati un administrator!", uc, MessageBoxButton.OK);
cmb.ShowDialog();
}
}
}
}
private void Favorite_MouseDown(object sender, MouseButtonEventArgs e)
{
ButtonPressed = true;
if (isFav)
{
/// delete from database
try
{
Variables.conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "delete from anunturi_favorite where idUtilizator = @idUtilizator and idAnunt = @idAnunt";
cmd.Connection = Variables.conn;
cmd.Parameters.AddWithValue("idUtilizator", ConnectedUser.id);
cmd.Parameters.AddWithValue("idAnunt", adID);
if (cmd.ExecuteNonQuery() != 0)
{
Variables.conn.Close();
if (fromControl == (int)ControlTypes.AdvertisementsPage)
{
UserControl uc = ((this.Parent as Grid).Parent as Grid).Parent as UserControl;
AdvertisementsPage ap = uc as AdvertisementsPage;
if (ap.cmbCats.SelectedIndex == (int)Categories.Favorite && ConnectedUser.loggedIn)
{
ap.adIds.RemoveAt(ap.adIds.FindIndex(x => x == adID));
ap.ResetAds();
}
}
Favorite.Source = (Resources["NotFavorite"] as ImageSource);
isFav = false;
}
}
catch
{
if (Variables.conn.State == System.Data.ConnectionState.Open)
{
Variables.conn.Close();
}
}
}
else
{
/// isert into database
try
{
Variables.conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "insert into anunturi_favorite (idUtilizator, idAnunt) values (@idUtilizator, @idAnunt)";
cmd.Connection = Variables.conn;
cmd.Parameters.AddWithValue("idUtilizator", ConnectedUser.id);
cmd.Parameters.AddWithValue("idAnunt", adID);
if (cmd.ExecuteNonQuery() != 0)
{
Variables.conn.Close();
isFav = true;
Favorite.Source = (Resources["Favorite"] as ImageSource);
}
}
catch (Exception ex)
{
if (Variables.conn.State == System.Data.ConnectionState.Open)
{
Variables.conn.Close();
}
}
}
}