/*EVENTS
* AUTO-GENERATED EVENTS
*/
#region Delete Event
/*
* Pulls the item from the SelectedItem property inside of listbox
* then removes the item from the db & then also the listbox
*/
private void Delete_Click(object sender, RoutedEventArgs e)
{
var item = listbox.SelectedItem as Movie;
SQLToolbox.RemoveMovie(item);
movies.Remove(item);
}
private void Reset_Click(object sender, RoutedEventArgs e)
{
UserModel reset = (UserModel)UserList.SelectedItem;
reset.Password = SQLToolbox.ResetPassword(reset);
MainViewModel.UserList.Remove(reset);
MainViewModel.UserList.Add(reset);
}
/*CONSTRUCTOR
* Here we fill our 'movies' list upon startup of the program via our SQLToolbox
*/
public MainWindow()
{
InitializeComponent();
this.DataContext = this;
foreach (var movie in SQLToolbox.GetMovieData())
{
movies.Add(movie);
}
;
}
/*
* Creates a new Movie with the values inside of the textboxes
* then adds the item to the db & then also the listbox
*/
private void Create_Click(object sender, RoutedEventArgs e)
{
Movie newItem = new Movie();
newItem.Thumbnail = Thumbnail.Text;
newItem.Title = title.Text;
newItem.Rating = double.Parse(Rating.Text.Replace('.', ','));
newItem.Genre = Genre.Text;
newItem.Runtime = int.Parse(RunTime.Text);
newItem.Price = double.Parse(Price.Text.Replace('.', ','));
newItem.ReleaseDate = ReleaseDate.Text;
SQLToolbox.CreateMovie(newItem);
movies.Add(newItem);
}
private void Login_Click(object sender, RoutedEventArgs e)
{
UserModel user = SQLToolbox.Login(Username.Text, Password.Password);
if (user.Type != 0)
{
DashboardWindow dashboard = new DashboardWindow(user);
dashboard.Show();
this.Close();
}
else
{
MessageBox.Show("Invalid username or password.");
}
}
/*
* Creates a new Movie with the values inside of the textboxes
* then adds the item to the db & then also the listbox
*/
private void Save_Click(object sender, RoutedEventArgs e)
{
var item = listbox.SelectedItem as Movie;
item.Thumbnail = Thumbnail.Text;
item.Title = title.Text;
item.Rating = double.Parse(Rating.Text.Replace('.', ','));
item.Genre = Genre.Text;
item.Runtime = int.Parse(RunTime.Text);
item.Price = double.Parse(Price.Text.Replace('.', ','));
item.ReleaseDate = ReleaseDate.Text;
SQLToolbox.UpdateMovie(item);
movies.Remove(movies.FirstOrDefault(x => x.Id == item.Id));
movies.Add(item);
}
public void Update_Click(object sender, RoutedEventArgs e)
{
UserModel updatedUser = (UserModel)UserList.SelectedItem;
try
{
updatedUser.Username = usernameBox.Text;
updatedUser.Password = passwordBox.Text;
updatedUser.Type = byte.Parse(typeBox.Text);
SQLToolbox.UpdateUser(updatedUser);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
UserList.Items.Refresh();
}
public void Create_Click(object sender, RoutedEventArgs e)
{
UserModel newUser = new UserModel();
try
{
newUser.Username = usernameBox.Text;
newUser.Password = passwordBox.Text;
newUser.Type = byte.Parse(typeBox.Text);
SQLToolbox.CreateUser(newUser);
MainViewModel.UserList.Add(SQLToolbox.ReturnIDUser(newUser));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Update_Click(object sender, RoutedEventArgs e)
{
GeoDataModel updatedData = (GeoDataModel)GeoDataList.SelectedItem;
try
{
updatedData.PostalCode = int.Parse(PostalCodeBox.Text);
updatedData.City = CityBox.Text;
updatedData.Population = int.Parse(PopulationBox.Text);
updatedData.Temperature = double.Parse(TemperatureBox.Text);
SQLToolbox.UpdateGeoData(updatedData);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
GeoDataList.Items.Refresh();
}
public void Create_Click(object sender, RoutedEventArgs e)
{
GeoDataModel geoData = new GeoDataModel();
try
{
geoData.PostalCode = int.Parse(PostalCodeBox.Text);
geoData.City = CityBox.Text;
geoData.Population = int.Parse(PopulationBox.Text);
geoData.Temperature = double.Parse(TemperatureBox.Text);
SQLToolbox.CreateGeoData(geoData);
MainViewModel.GeoDataList.Add(SQLToolbox.ReturnIDGeo(geoData));
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public void Delete_Click(object sender, RoutedEventArgs e)
{
SQLToolbox.DeleteUser((UserModel)UserList.SelectedItem);
MainViewModel.UserList.Remove((UserModel)UserList.SelectedItem);
}
// GET: Movie
public ActionResult Movies()
{
SQLToolbox.GetMovieData(); // imports data from database
ViewBag.MovieListClass = MovieListClass.MovieList; // attaches the MovieList to the View
return(View());
}
public void Delete_Click(object sender, RoutedEventArgs e)
{
SQLToolbox.DeleteGeoData((GeoDataModel)GeoDataList.SelectedItem);
MainViewModel.GeoDataList.Remove((GeoDataModel)GeoDataList.SelectedItem);
}
