public ActionResult Create([Bind(Include = "GenreID,GenreName")] Genre genre)
{
if (ModelState.IsValid)
{
db.Genres.Add(genre);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(genre));
}
public ActionResult Create([Bind(Include = "CustomerID,CustomerName,CustomerPhone")] Customer customer)
{
if (ModelState.IsValid)
{
db.Customers.Add(customer);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(customer));
}
public ActionResult Create([Bind(Include = "RentalID,MovieID,CustomerID,RentalDate,DueDate,ReturnDate")] RentalRecord rentalRecord)
{
if (ModelState.IsValid)
{
db.RentalRecords.Add(rentalRecord);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MovieID = new SelectList(db.Movies, "MovieID", "MovieName", rentalRecord.MovieID);
return(View(rentalRecord));
}
public ActionResult Create([Bind(Include = "MovieID,MovieName,MovieDescription,MovieGenre")] Movie movie)
{
if (ModelState.IsValid)
{
db.Movies.Add(movie);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MovieGenre = new SelectList(db.Genres, "GenreID", "GenreName", movie.MovieGenre);
return(View(movie));
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
Employee selected = (Employee)EmployeeList.SelectedItem;
if (selected != null)
{
using (var context = new MovieRentalEntities())
{
if (MessageBox.Show("Are you sure you want to delete " + selected.FirstName + " " + selected.LastName + "?", "Delete Employee", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
// Remove all references to the movie
var employee = context.Employees.Where(emp => emp.SIN == selected.SIN).Single();
context.Employees.Remove(employee);
var orders = context.Orders.Where(o => o.SIN == selected.SIN);
foreach (Order order in orders)
{
order.SIN = null;
}
context.SaveChanges();
MessageBox.Show(selected.FirstName + " " + selected.LastName + " deleted");
}
else
{
return;
}
}
}
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
using (var context = new MovieRentalEntities())
{
Customer customer = new Customer();
{
customer.FirstName = FirstNameBox.Text;
customer.LastName = LastNameBox.Text;
customer.Address = AddressBox.Text;
customer.City = CityBox.Text;
customer.Province = ProvinceBox.Text;
customer.PostalCode = PostalCodeBox.Text;
customer.Phone = PhoneNumberBox.Text;
customer.Email = EmailBox.Text;
customer.CreditCard = CreditCardBox.Text;
customer.Username = UsernameBox.Text;
customer.Password = PasswordBox.Password;
customer.Rating = 0;
customer.CreationDate = DateTime.Today;
int value = int.Parse(AccountTypeBox.Text);
customer.AccountType = value;
PasswordBox.PasswordChar = '•';
}
context.Customers.Add(customer);
context.SaveChanges();
MessageBox.Show("Customer added");
}
}
private void Approve_Click(object sender, RoutedEventArgs e)
{
Order current = (Order)OrderList.SelectedItem;
using (var context = new MovieRentalEntities())
{
var order = context.Orders.Include("Movie").SingleOrDefault(o => o.OrderID == current.OrderID);
if (order != null)
{
order.SIN = employee.SIN;
order.RentalDate = System.DateTime.Today;
order.ExpectedReturn = System.DateTime.Today.AddMonths(1);
order.Movie.NumberOfCopies--;
context.SaveChanges();
MessageBox.Show("Order has been approved");
// Refresh order list
OrderList.ItemsSource = null;
OrderList.ItemsSource = GetOrders();
OrderInfo.ItemsSource = null;
}
}
}
// TODO: Tab indices
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
using (var context = new MovieRentalEntities())
{
var customer = context.Customers.SingleOrDefault(c => c.AccountNumber == this.customer.AccountNumber);
if (customer != null)
{
if (!string.IsNullOrWhiteSpace(FirstNameBox.Text))
{
customer.FirstName = FirstNameBox.Text;
}
if (!string.IsNullOrWhiteSpace(LastNameBox.Text))
{
customer.LastName = LastNameBox.Text;
}
if (!string.IsNullOrWhiteSpace(AddressBox.Text))
{
customer.Address = AddressBox.Text;
}
if (!string.IsNullOrWhiteSpace(CityBox.Text))
{
customer.City = CityBox.Text;
}
if (!string.IsNullOrWhiteSpace(ProvinceBox.Text))
{
customer.Province = ProvinceBox.Text;
}
if (!string.IsNullOrWhiteSpace(PostalCodeBox.Text))
{
customer.PostalCode = PostalCodeBox.Text;
}
if (!string.IsNullOrWhiteSpace(PhoneNumberBox.Text))
{
customer.Phone = PhoneNumberBox.Text;
}
if (!string.IsNullOrWhiteSpace(EmailBox.Text))
{
customer.Email = EmailBox.Text;
}
if (!string.IsNullOrWhiteSpace(UsernameBox.Text))
{
customer.Username = UsernameBox.Text;
}
if (!string.IsNullOrWhiteSpace(PasswordBox.Password) && PasswordBox.Password == ConfirmBox.Password)
{
customer.Password = PasswordBox.Password;
}
context.SaveChanges();
MessageBox.Show("Changes saved");
}
}
}
private void ReturnButton_Click(object sender, RoutedEventArgs e)
{
OrderView current = (OrderView)OrderList.SelectedItem;
using (var context = new MovieRentalEntities())
{
var order = context.Orders.Include("Movie").SingleOrDefault(o => o.OrderID == current.OrderID);
order.ActualReturn = DateTime.Today;
order.Movie.NumberOfCopies++;
context.SaveChanges();
MessageBox.Show("Movie has been returned");
}
}
private void Add_Click(object sender, RoutedEventArgs e)
{
using (var context = new MovieRentalEntities())
{
if (PasswordBox.Password == ConfirmBox.Password)
{
try
{
string position = AccountType.SelectedItem.ToString();
int type;
if (position == "Employee")
{
type = 1;
}
else
{
type = 0;
}
Employee employee = new Employee()
{
SIN = SINBox.Text,
FirstName = FirstNameBox.Text,
LastName = LastNameBox.Text,
Address = AddressBox.Text,
City = CityBox.Text,
Province = ProvinceBox.Text,
PostalCode = PostalCodeBox.Text,
Phone = PhoneBox.Text,
StartDate = DateTime.Today,
Wage = Convert.ToDecimal(WageBox.Text),
Username = UsernameBox.Text,
Password = PasswordBox.Password,
AccountType = type
};
context.Employees.Add(employee);
context.SaveChanges();
MessageBox.Show("Employee added");
}
catch
{
MessageBox.Show("Error adding employee");
return;
}
}
}
}
private void DeleteButton_Click(object sender, RoutedEventArgs e)
{
Movie current = (Movie)MovieList.SelectedItem;
if (current != null)
{
using (var context = new MovieRentalEntities())
{
if (MessageBox.Show("Are you sure you want to delete " + current.Title + "?", "Delete Movie", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
// Remove all references to the movie
var movie = context.Movies.Where(m => m.MovieID == current.MovieID).Single();
context.Movies.Remove(movie);
var orders = context.Orders.Where(o => o.MovieID == current.MovieID);
foreach (Order order in orders)
{
context.Orders.Remove(order);
}
var queues = context.Queues.Where(q => q.MovieID == current.MovieID);
foreach (Queue queue in queues)
{
context.Queues.Remove(queue);
}
var credits = context.Credits.Where(c => c.MovieID == current.MovieID);
foreach (Credit credit in credits)
{
context.Credits.Remove(credit);
}
context.SaveChanges();
MessageBox.Show(current.Title + " deleted");
}
else
{
return;
}
}
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
int copies; decimal fee;
string genre = Genre.SelectedValue.ToString();
try
{
copies = Convert.ToInt32(NumberOfCopies.Text);
}
catch
{
MessageBox.Show("Error in number of copies");
return;
}
try
{
fee = Convert.ToDecimal(DistributionFee.Text);
}
catch
{
MessageBox.Show("Error in distribution fee");
return;
}
using (var context = new MovieRentalEntities())
{
var movie = context.Movies.Where(m => m.MovieID == this.movie.MovieID).Single();
movie.Genre = genre;
movie.NumberOfCopies = copies;
movie.DistributionFee = fee;
context.SaveChanges();
if (MessageBox.Show("Changes saved", movie.Title, MessageBoxButton.OK, MessageBoxImage.None) == MessageBoxResult.OK)
{
this.Close();
}
}
}
private void Confirm_Click(object sender, RoutedEventArgs e)
{
using (var context = new MovieRentalEntities())
{
var mov = context.Movies.Where(m => m.MovieID == this.movie.MovieID).Single();
int total = (int)client.GetMovieAsync(mov.MovieID).Result.VoteAverage *client.GetMovieAsync(mov.MovieID).Result.VoteCount;
int votes = client.GetMovieAsync(mov.MovieID).Result.VoteCount;
votes = votes++;
if (RateOne.IsChecked == true)
{
total = total + 1;
}
else if (RateTwo.IsChecked == true)
{
total = total + 2;
}
else if (RateThree.IsChecked == true)
{
total = total + 3;
}
else if (RateFour.IsChecked == true)
{
total = total + 4;
}
else if (RateFive.IsChecked == true)
{
total = total + 5;
}
Console.WriteLine(total); Console.WriteLine(votes);
mov.Rating = (int)Math.Round((float)(total / votes)) / 2;
context.SaveChanges();
this.Close();
}
}
private void RemoveButton_Click(object sender, RoutedEventArgs e)
{
Customer selected = (Customer)CustomerList.SelectedItem;
if (selected != null)
{
using (var context = new MovieRentalEntities())
{
if (MessageBox.Show("Are you sure you want to delete " + selected.FirstName + " " + selected.LastName + "?", "Delete Customer", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
var customer = context.Customers.Where(cus => cus.AccountNumber == selected.AccountNumber).Single();
context.Customers.Remove(customer);
context.SaveChanges();
MessageBox.Show(selected.FirstName + " " + selected.LastName + " deleted");
}
else
{
return;
}
}
}
}
private void SaveButton_Click(object sender, RoutedEventArgs e)
{
Customer selected = (Customer)CustomerList.SelectedItem;
using (var context = new MovieRentalEntities())
{
var customer = context.Customers.Where(cus => cus.AccountNumber == selected.AccountNumber).Single();
if (customer != null)
{
if (!string.IsNullOrWhiteSpace(EmailBoxEdit.Text))
{
customer.Email = EmailBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(FirstNameBoxEdit.Text))
{
customer.FirstName = FirstNameBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(LastNameBoxEdit.Text))
{
customer.LastName = LastNameBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(AddressBoxEdit.Text))
{
customer.Address = AddressBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(CityBoxEdit.Text))
{
customer.City = CityBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(ProvinceBoxEdit.Text))
{
customer.Province = ProvinceBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(PostalCodeBoxEdit.Text))
{
customer.PostalCode = PostalCodeBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(PhoneNumberBoxEdit.Text))
{
customer.Phone = PhoneNumberBoxEdit.Text;
}
if (!string.IsNullOrWhiteSpace(AccountTypeBoxEdit.Text))
{
int value = int.Parse(AccountTypeBoxEdit.Text);
customer.AccountType = value;
}
if (!string.IsNullOrWhiteSpace(UsernameBox.Text))
{
customer.Username = UsernameBox.Text;
}
if (!string.IsNullOrWhiteSpace(PasswordBox.Password))
{
customer.Password = PasswordBox.Password;
}
context.SaveChanges();
MessageBox.Show("Changes saved");
}
}
}
private void Save_Click(object sender, RoutedEventArgs e)
{
Employee selected = (Employee)EmployeeList.SelectedItem;
using (var context = new MovieRentalEntities())
{
var employee = context.Employees.Where(emp => emp.SIN == selected.SIN).Single();
if (employee != null)
{
if (!string.IsNullOrWhiteSpace(SINBox.Text))
{
employee.SIN = SINBox.Text;
}
if (!string.IsNullOrWhiteSpace(FirstNameBox.Text))
{
employee.FirstName = FirstNameBox.Text;
}
if (!string.IsNullOrWhiteSpace(LastNameBox.Text))
{
employee.LastName = LastNameBox.Text;
}
if (!string.IsNullOrWhiteSpace(AddressBox.Text))
{
employee.Address = AddressBox.Text;
}
if (!string.IsNullOrWhiteSpace(CityBox.Text))
{
employee.City = CityBox.Text;
}
if (!string.IsNullOrWhiteSpace(ProvinceBox.Text))
{
employee.Province = ProvinceBox.Text;
}
if (!string.IsNullOrWhiteSpace(PostalCodeBox.Text))
{
employee.PostalCode = PostalCodeBox.Text;
}
if (!string.IsNullOrWhiteSpace(PhoneBox.Text))
{
employee.Phone = PhoneBox.Text;
}
if (!string.IsNullOrWhiteSpace(WageBox.Text))
{
employee.Wage = Convert.ToDecimal(WageBox.Text);
}
if (!string.IsNullOrWhiteSpace(UsernameBox.Text))
{
employee.Username = UsernameBox.Text;
}
if (!string.IsNullOrWhiteSpace(PasswordBox.Password) && PasswordBox.Password == ConfirmBox.Password)
{
employee.Password = PasswordBox.Password;
}
if (AccountType.SelectedIndex != -1)
{
string position = AccountType.SelectedItem.ToString();
if (position == "Employee")
{
employee.AccountType = 1;
}
else
{
employee.AccountType = 0;
}
}
context.SaveChanges();
MessageBox.Show("Changes saved");
}
}
Add.Visibility = Visibility.Visible;
}
private void Select_Click(object sender, RoutedEventArgs e)
{
int newAccount;
currentPage = UpgradeFrame.Content.GetType().Name.ToString();
if (currentPage == "Limited")
{
if (MessageBox.Show("Are you sure you want to change to the Limited account?", "Account request", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
newAccount = 0;
}
else
{
return;
}
}
// Current page is Unlimited 1, go to Unlimited 2
else if (currentPage == "Unlimited1")
{
if (MessageBox.Show("Are you sure you want to change to the Unlimited1 account?", "Account request", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
newAccount = 1;
}
else
{
return;
}
}
// Current page is Unlimited 2, go to Unlimited 3 and hide Next button
else if (currentPage == "Unlimited2")
{
if (MessageBox.Show("Are you sure you want to change to the Unlimited2 account?", "Account request", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
newAccount = 2;
}
else
{
return;
}
}
else
{
if (MessageBox.Show("Are you sure you want to change to the Unlimited3 account?", "Account request", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.Yes)
{
newAccount = 3;
}
else
{
return;
}
}
using (var context = new MovieRentalEntities())
{
var customer = context.Customers.SingleOrDefault(c => c.AccountNumber == this.customer.AccountNumber);
customer.AccountType = newAccount;
context.SaveChanges();
}
}
