/// <summary> /// Добавление фильма /// </summary> /// <param name="name"></param> /// <param name="age"></param> /// <param name="descrip"></param> /// <param name="time"></param> /// <param name="producer"></param> /// <param name="year"></param> /// <param name="poster"></param> public static void Add(string name, string age, string descrip, TimeSpan time, string producer, short year, string poster) { if (Check(name, true, 0)) { db.FilmSet.Add(new Film { Name = name, AgeLimit = age, Description = descrip, length = time, Producer = producer, Year = year, Poster = poster }); db.SaveChanges(); } }
/// <summary> /// Добавление кинотеатра /// </summary> /// <param name="name"></param> /// <param name="city"></param> /// <param name="adress"></param> public static void Add(string name, string city, string adress) { if (Check(name, city, adress, true, 0)) { db.CinemaSet.Add(new Cinema { Name = name, City = city, Adress = adress }); db.SaveChanges(); } }
/// <summary> /// Добавление кассира /// </summary> /// <param name="login"></param> /// <param name="FIO"></param> /// <param name="password"></param> /// <param name="cinema"></param> public static void Add(string login, string FIO, string password, Cinema cinema) { if (Cheack(login, true, 0)) { Сashier c = new Сashier(); c.FIO = FIO; c.Login = login; c.Password = password; c.Cinema = db.CinemaSet.Find(cinema.ID); db.СashierSet.Add(c); db.SaveChanges(); } }
/// <summary> /// Добавление зала /// </summary> /// <param name="cinema"></param> /// <param name="num"></param> /// <param name="type"></param> /// <param name="rows"></param> /// <param name="seats"></param> public static void Add(Cinema cinema, byte num, string type, byte rows, byte seats) { if (Check(cinema, num, true, 0)) { Hall c = new Hall(); c.Num = num; c.Type = type; c.AmountOfRow = rows; c.AmountOfSeats = seats; c.Cinema = db.CinemaSet.Find(cinema.ID); db.HallSet.Add(c); db.SaveChanges(); } }
private void btAdd_Click(object sender, EventArgs e) { if ((tbName.Text == "") || (tbProd.Text == "") || ((poster == "") && (add)) || (tbDescrip.Text == "")) { MessageBox.Show("Вы заполнили не все поля!"); } else { TimeSpan time = new TimeSpan((int)nudHour.Value, (int)nudMin.Value, 0); if (add) { FilmWork.Add(tbName.Text, dudAge.Text, tbDescrip.Text, time, tbProd.Text, (short)nudYear.Value, poster); } else { DialogResult dialogResult = MessageBox.Show("Данные о фильме будут сохранены. Вы уверены, что хотите изменить их?", "Сохранение изменений", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { FilmWork.Change(tbName.Text, film.ID, dudAge.Text, tbDescrip.Text, time, tbProd.Text, (short)nudYear.Value, poster); } } db.SaveChanges(); form.UpdateFilms(); saved = true; } }
private void btAdd_Click(object sender, EventArgs e) { if ((cbCinema.Text == "") || (cbHall.Text == "") || (cbFilm.Text == "")) { MessageBox.Show("Вы заполнили не все поля!"); } else { DateTime t = new DateTime(dtpDate.Value.Year, dtpDate.Value.Month, dtpDate.Value.Day, (int)nudHour.Value, (int)nudMin.Value, 0); if (add) { SessionWork.Add(db.HallSet.Find(((Hall)(cbHall.SelectedValue)).ID), t, db.FilmSet.Find(((Film)(cbFilm.SelectedValue)).ID), (short)nudPrice.Value); } else { DialogResult dialogResult = MessageBox.Show("Данные о сеансе будут сохранены. Вы уверены, что хотите изменить их?", "Сохранение изменений", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { SessionWork.Change(db.HallSet.Find(((Hall)(cbHall.SelectedValue)).ID), t, db.FilmSet.Find(((Film)(cbFilm.SelectedValue)).ID), (short)nudPrice.Value, session.ID); } } db.SaveChanges(); form.UpdateSession(); saved = true; } }
private void btAdd_Click(object sender, EventArgs e) { if ((tbFIO.Text == "") || (tbLogin.Text == "") || (tbPassword.Text == "") || (cbCinema.Text == "")) { MessageBox.Show("Вы заполнили не все поля!"); } else { if (add) { CashierWork.Add(tbLogin.Text, tbFIO.Text, tbPassword.Text, db.CinemaSet.Find(((Cinema)cbCinema.SelectedValue).ID)); } else { DialogResult dialogResult = MessageBox.Show("Данные о кассире будут сохранены. Вы уверены, что хотите изменить их?", "Сохранение изменений", MessageBoxButtons.YesNo); if (dialogResult == DialogResult.Yes) { CashierWork.Change(tbLogin.Text, tbFIO.Text, tbPassword.Text, cashier.ID); } } db.SaveChanges(); form.UpdateCashier(); saved = true; } }
private void btBuy_Click(object sender, EventArgs e) { if (choose.Count > 0) { if (!cashier) { string tick = ""; made = true; foreach (Seat d in choose) { Ticket t = new Ticket(); t.Seat = db.SeatSet.Find(d.ID); db.TicketSet.Add(t); db.SeatSet.Find(d.ID).State = "Занято"; db.SaveChanges(); tick = tick + " " + db.SeatSet.Find(d.ID).Ticket.Number.ToString(); } MessageBox.Show("Номера ваших билетов: " + tick + ". Запомните или запишите их и предъявите на кассе."); } else { made = true; foreach (Seat d in choose) { db.SeatSet.Find(d.ID).State = "Занято"; Booking r; if (d.Booking != null) {//удаляем брони, если есть r = d.Booking; db.BookingSet.Remove(r); } Ticket z; if (d.Ticket != null) {//удаляем билеты, если есть z = d.Ticket; db.TicketSet.Remove(z); } } } db.SaveChanges(); UploadPicture(); NotBut(); } }
/// <summary> /// Добавление сеанса /// </summary> /// <param name="hall"></param> /// <param name="date"></param> /// <param name="film"></param> /// <param name="price"></param> public static void Add(Hall hall, DateTime date, Film film, short price) { if (Check(hall, date, true, 0)) { Session c = new Session(); c.Film = db.FilmSet.Find(film.ID); c.Hall = db.HallSet.Find(hall.ID); c.Price = price; c.Date = date; c.Time = date; db.SessionSet.Add(c); db.SaveChanges(); for (int i = 1; i <= c.Hall.AmountOfRow; i++) { for (int j = 1; j <= c.Hall.AmountOfSeats; j++) { SeatWork.Add(c.ID, (byte)i, (byte)j, db); } } db.SaveChanges(); } }
private void Form1_Load(object sender, EventArgs e) { user = eUser.Клиент; BlockZapr(); BlockNewEnt(); btExit.Enabled = false; foreach (Session d in db.SessionSet) { if (d.Time < DateTime.Now) { SessionWork.Delete(d.ID, db); } } db.SaveChanges(); ListNull(); ListDB(); }