public List <FilmList> GetFilmList(string cs)
{
using var con = new MySqlConnection(cs);
con.Open();
string sql = "CALL spGetFilmList";
using var cmd = new MySqlCommand(sql, con);
IList <FilmList> wsl = new List <FilmList>();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var ws = new FilmList();
ws.FilmID = reader.GetInt32("FilmID");
ws.FilmName = reader.GetString("FilmName");
ws.ReleaseDate = reader.GetString("ReleaseDate");
ws.AddedDate = reader.GetString("AddedDate");
ws.GenreText = reader.GetString("GenreText");
ws.Watched = reader.GetString("Watched");
ws.UserName = reader.GetString("UserName");
wsl.Add(ws);
}
reader.Close();
return((List <FilmList>)wsl);
}
/**
* Load màng hình chọn phim
*/
public void Load_FilmsScreen()
{
frmFilms = new FilmList();
frmFilms.MdiParent = this;
frmFilms.filmItem.Click += new EventHandler(this.Schedule_Load);
frmFilms.Show();
}
public async void GetJSON()
{
if (NetworkCheck.IsInternet())
{
var client = new System.Net.Http.HttpClient();
var response = await client.GetAsync("https://api.themoviedb.org/3/movie/upcoming?api_key=440d3555391bf8ebbceae19005baea22&language=fr-FR&page=1");
string contactsJson = response.Content.ReadAsStringAsync().Result;
FilmList ObjContactList = new FilmList();
// Test crash
//contactsJson = "";
try
{
//Converting JSON Array Objects into generic list
ObjContactList = JsonConvert.DeserializeObject <FilmList>(contactsJson);
}
catch (Exception exception)
{
Crashes.TrackError(exception);
}
//Binding listview with server response
listviewFilms.ItemsSource = ObjContactList.Results;
}
else
{
await DisplayAlert("JSONParsing", "No network is available.", "Ok");
Analytics.TrackEvent("No_Internet");
}
//Hide loader after server response
ProgressLoader.IsVisible = false;
}
public ActionResult Create(FilmList model, CountryJanrListModel listModel)
{
context.Film.Add(model.Film);
context.SaveChanges();
var filmCountries = new FilmCountry();
if (listModel.Countries == null || listModel.Janrs == null)
{
ViewBag.ErrorMessage = "Daxil edin";
}
else
{
foreach (var item in listModel.Countries)
{
filmCountries.CountryId = item;
filmCountries.FilmId = model.Film.Id;
context.FilmCountry.Add(filmCountries);
context.SaveChanges();
}
var filmJanr = new FilmJanr();
foreach (var item in listModel.Janrs)
{
filmJanr.JanrId = item;
filmJanr.FilmId = model.Film.Id;
context.FilmJanr.Add(filmJanr);
context.SaveChanges();
}
}
return(Redirect("Create"));
}
public Raport_Bazy_Filmowej()
{
InitializeComponent();
Deserializacja();
//liczba filmow
int count = FilmList.Count;
int suma = FilmList.Count;
label1.Text = suma.ToString();
//liczba kopii
for (int i = 0; i < count; i++)
{
x = x + FilmList[i].IloscKopii;
}
labelKopii.Text = x.ToString();
//Najdrozszy film
var najdrozszy = FilmList.Max(item => item.Cena);
labelNajdrozszy.Text = najdrozszy.ToString() + "zł";
var tytul = FilmList.FindIndex(item => item.Cena == najdrozszy);
labelTytujDrogi.Text = FilmList[tytul].Tytul;
//Najtanszy film
var najtanszy = FilmList.Min(item => item.Cena);
labelNajtanszy.Text = najtanszy.ToString() + "zł";
var tytul2 = FilmList.FindIndex(item => item.Cena == najtanszy);
labelTytulTani.Text = FilmList[tytul2].Tytul;
//Najwiecej kopii
var najwiecej = FilmList.Max(item => item.IloscKopii);
labelNajKopii.Text = najwiecej.ToString() + " sztuk";
var tytul3 = FilmList.FindIndex(item => item.IloscKopii == najwiecej);
labelNajKopiiTytul.Text = FilmList[tytul3].Tytul;
//Najmniej kopii
var najmniej = FilmList.Min(item => item.IloscKopii);
labelNajmniejKopi.Text = najmniej.ToString() + " sztuk";
var tytul4 = FilmList.FindIndex(item => item.IloscKopii == najmniej);
labelNajmniejKopiiTytul.Text = FilmList[tytul4].Tytul;
//Najwiecej wypozyczonych
var najwyp = FilmList.Max(item => item.Wypozyczonych);
labelWypozyczonychTytul.Text = najwyp.ToString() + " sztuk";
var tytul5 = FilmList.FindIndex(item => item.Wypozyczonych == najwyp);
labelWypozyczonychKopii.Text = FilmList[tytul5].Tytul;
}
public ActionResult Create()
{
FilmList list = new FilmList();
list.Films = context.Film.OrderByDescending(x => x.Id).Take(10).ToList();
list.Janrs = context.Janr.ToList();
list.Countries = context.Country.ToList();
return(View(list));
}
public Main()
{
InitializeComponent();
frmFilms = new FilmList();
frmSchedule = new ScheduleList();
frmRoom = new frmRoom();
frmLogin = new Login();
frmAreas = new Areas();
TicketN = new frmTicket();
frmConfirmTicket = new ConfirmTicket();
this.TopMost = true;
this.FormBorderStyle = FormBorderStyle.Fixed3D;
this.WindowState = FormWindowState.Maximized;
}
public MainWindow()
{
InitializeComponent();
filmList = new FilmList();
}
