private void Buying(string metoda)
{
using (DatabasePZEntities db = new DatabasePZEntities())
{
GODZINY updateSpot = db.GODZINY.Where(h => h.Godzina == _selectedHour).FirstOrDefault(s => s.Id_Seansu == _seance.SeansID);
char[] spots = updateSpot.Miejsca.ToCharArray();
bool canBuying = _spots.Where(n => spots[n.SpotNumber - 1] == '0').Count() != 0;
if (canBuying)
{
foreach (var spot in _spots)
{
BILET ticket = new BILET()
{
Potwierdzenie = 0,
Imie = _firstName,
Nazwisko = _lastName,
Email = _email,
Telefon = _phoneNumber,
Id_Godziny = updateSpot.Id_Godziny,
Id_ulga = _selectedDiscount + 1,
Realizacja = 0,
Miejsce = spot.SpotNumber - 1
};
db.BILET.Add(ticket);
spot.IsAvailable = 1;
spots[spot.SpotNumber - 1] = '1';
}
updateSpot.Miejsca = new string(spots);
db.SaveChanges();
// Tutaj bedzie przekierowanie do jakiegos api platnosci karta/gotowka
// tresc emaila
string trescEmaila = "Tutaj bedzie jakas tresc emaila";
SendEmail email = new SendEmail();
email.SendAsync(_email, "Rezerwacja filmu", trescEmaila);
MessageBox.Show("Bilet kupiony - " + metoda);
NavigationManager.BackToMain();
}
else
{
{
foreach (var spot in _spots)
{
spot.IsAvailable = 1;
}
MessageBox.Show("Miejsca zostaly juz przez kogos zarezerwowane. Prosze wybrac inne");
NavigationManager.BackToMain();
}
}
}
}
private Grid CreateDiscount()
{
var mainGrid = new Grid();
ComboBox ulgi;
TextBlock tekst;
DatabasePZEntities context = new DatabasePZEntities();
mainGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
mainGrid.ColumnDefinitions.Add(new ColumnDefinition()
{
Width = GridLength.Auto
});
for (int i = 0; i < _spots.Count; i++)
{
mainGrid.RowDefinitions.Add(new RowDefinition()
{
Height = GridLength.Auto
});
tekst = new TextBlock()
{
Text = "Bilet #" + mainGrid.RowDefinitions.Count
};
tekst.Margin = new Thickness(0, 0, 10, 10);
tekst.Width = 150;
Grid.SetColumn(tekst, 0);
Grid.SetRow(tekst, i);
mainGrid.Children.Add(tekst);
ulgi = new ComboBox();
ulgi.SelectedIndex = SelectedDiscount;
ulgi.Width = 150;
foreach (var ulga in context.ULGA)
{
ulgi.Items.Add(new ComboBoxItem()
{
Content = ulga.Nazwa
});
}
Grid.SetColumn(ulgi, 1);
Grid.SetRow(ulgi, i);
mainGrid.Children.Add(ulgi);
}
return(mainGrid);
}
private void FakeBooking()
{
_bookingList = new ObservableCollection <BILET>();
db = new DatabasePZEntities();
foreach (var bilet in db.BILET.Include("ULGA").Include("GODZINY"))
{
_bookingList.Add(bilet);
}
_filteredBookingList = new ObservableCollectionView <BILET>(_bookingList);
}
private void LoginUser(string log, PasswordBox pass)
{
DatabasePZEntities context = new DatabasePZEntities();
UZYTKOWNICY user = context.UZYTKOWNICY.Where(l => l.Login == log)
.Where(h => h.Haslo == pass.Password)
.FirstOrDefault();
if (user != null)
{
WrongData = string.Empty;
NavigationManager.NavigateTo(new UserPage());
}
else
{
WrongData = "Bledne dane";
}
}
private void InitData()
{
DatabasePZEntities context = new DatabasePZEntities();
var api = new ApiRequester();
Movie movie;
foreach (var seans in context.SEANS)
{
movie = api.getAppMovie((int)seans.Id_film);
var hours = new ObservableCollection <string>();
var rooms = new ObservableCollection <Room>();
string spotTable;
int currentSpotNumber;
foreach (var godziny in context.GODZINY.Where(id => id.Id_Seansu == seans.Id_seans))
{
hours.Add(godziny.Godzina);
var spots = new ObservableCollection <Spot>();
SALA room = godziny.SEANS.SALA;
spotTable = godziny.Miejsca;
for (int i = 0; i < room.Ilosc_wierszy; i++)
{
for (int j = 0; j < room.Ilosc_kolumn; j++)
{
currentSpotNumber = (i * (int)room.Ilosc_kolumn) + j;
int isAvailable = Int32.Parse(spotTable[currentSpotNumber].ToString());
spots.Add(new Spot(isAvailable, j, i, currentSpotNumber + 1));
}
}
rooms.Add(new Room(room.Id_sala, spots, (int)room.Ilosc_kolumn, (int)room.Ilosc_wierszy));
}
App.Current.Dispatcher.BeginInvoke((Action) delegate()
{
Seances.Add(new Seance(movie, rooms, hours, (DateTime)seans.Data_rozpoczecia, (DateTime)seans.Data_zakonczenia, seans.Id_seans));
});
}
}
