/// <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();
}