static public bool IsValide(film film)
{
if (film == null)
{
throw new NullParametreException("IsFilmExist", "film");
}
try
{
if (
PropretyValidation.IsStringValide(film.titre, film.titreMin, film.titreMax) &&
PropretyValidation.IsStringValide(film.description, film.descriptionMin, film.descriptionMax) &&
PropretyValidation.IsNumberValide(film.annee_parution, film.anneeParutionMin, film.anneeParutionMax) &&
PropretyValidation.IsNumberValide(film.duree, film.dureeMin, film.dureeMax)
)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
static public bool IsTitleExist(film candidate, List <film> films)
{
if (candidate == null)
{
throw new NullParametreException("IsFilmExist", "candidate");
}
if (films == null)
{
throw new NullParametreException("IsFilmExist", "films");
}
try
{
List <film> existingOne = films.Where(o => o.titre == candidate.titre).ToList();
if (existingOne.Count != 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
film film = await db.films.FindAsync(id);
if (film == null)
{
return(HttpNotFound());
}
SelectList style = new SelectList(db.styles_list, "film_style", "film_style");
ViewBag.styles = style;
SelectList Age_raiting = new SelectList(db.age_rating_list, "Age_Rating", "Age_Rating");
ViewBag.ages = Age_raiting;
SelectList regiss = new SelectList(db.regs_list, "regisseur", "regisseur");
ViewBag.regis = regiss;
SelectList distrr = new SelectList(db.distr_list, "distributor", "distributor");
ViewBag.distr = distrr;
SelectList country = new SelectList(db.countries_list, "Country_Name", "Country_Name");
ViewBag.country = country;
return(View(film));
}
public ActionResult Create([Bind(Include = "id,titre,description,annee_parution,duree,rating,revenu,ranking,votes,metascore,id_type,id_film")] film film)
{
try
{
ManagerFilm manager = new ManagerFilm();
if (ModelState.IsValid)
{
if (manager.PostFilm(film))
{
Session[SessionKeys.openedTab] = "Details";
Session[SessionKeys.filmId] = film.id;
return(RedirectToAction("Index"));
}
}
else
{
throw new InvalidItemException("film");
}
}
catch (Exception e)
{
TempData.Add("Alert", e.Message);
}
ViewBag.id_type = new SelectList(new ManagerTypeFilm().GetType_film(), "id", "typage");
ViewBag.id_film = new SelectList(new ManagerFilm().GetAllFilms(), "id", "titre");
return(View(film));
}
public void TestarIncluirFilmeAtor()
{
var filme = new film()
{
title = "A VOLTA DOS QUE N�O FORAM",
language_id = 1
};
var ator = new actor()
{
first_name = "FABIO",
last_name = "QUIRINO",
last_update = DateTime.Now
};
var film_actor = new film_actor()
{
actor = ator,
film = filme,
last_update = DateTime.Now
};
filme.films_actors = new List <film_actor>()
{
film_actor
};
new ServicoFilm().Incluir(filme);
Assert.IsTrue(true);
}
public void PostConflictingTitre()
{
//Arrange
var managerFilm = new ManagerFilm(_context);
var conflictingFilm = new film()
{
id = 10, titre = "film test 1", description = "", annee_parution = 2000, duree = 15, id_type = 2
};
//Act
try
{
managerFilm.PostFilm(conflictingFilm);
Assert.Fail("an exception should have been thrown");
}
//Assert
catch (ExistingItemException eie)
{
Assert.AreEqual("cet 'film' existe deja", eie.Message);
}
catch (Exception e)
{
Assert.Fail($"unexpected error of type {e.GetType()} occure with a message : {e.Message}");
}
}
//Редактирование фильма. Возвращает логическое значение = отредактирован ли он
public bool EditFilmInDB(int filmId, film newFilmData)
{
var thisFilm = GetFilmFromDB(filmId);
using (var ctx = new DataContext()) {
try {
ctx.films.Attach(thisFilm);
thisFilm.name = newFilmData.name;
thisFilm.year = newFilmData.year;
thisFilm.country = newFilmData.country;
thisFilm.budget = newFilmData.budget;
thisFilm.age_limit = newFilmData.age_limit;
thisFilm.duration = newFilmData.duration;
thisFilm.rating = newFilmData.rating;
thisFilm.genre = newFilmData.genre;
thisFilm.company_id = newFilmData.company_id;
thisFilm.director = newFilmData.director;
thisFilm.composer = newFilmData.composer;
ctx.SaveChanges();
}
catch {
return(false);
}
}
return(true);
}
public ActionResult CreatePromo([Bind(Include = "id,titre,description,annee_parution,duree,id_film")] film film)
{
try
{
if (film.id_type == 0)
{
film.id_type = new ManagerTypeFilm().GetAllType_film().Where(t => t.typage.ToUpper() == "PROMOTIONNEL").ToList()[0].id;
}
ManagerFilm manager = new ManagerFilm();
if (ModelState.IsValid)
{
if (manager.PostFilm(film))
{
Session[SessionKeys.openedTab] = "Details";
Session[SessionKeys.filmId] = film.id;
return(RedirectToAction("Index"));
}
}
else
{
throw new InvalidItemException("film");
}
}
catch (Exception e)
{
TempData.Add("Alert", e.Message);
}
ViewBag.id_film = new SelectList(new ManagerFilm().GetAllFilms(), "id", "titre");
return(View(film));
}
public List <film> readFilms()
{
var film1 = new film()
{
idFilm = 1,
dateStart = new DateTime(2019, 11, 30, 19, 20, 001),
nameFilm = "Terminator I",
duration = "2 horas",
stateInBillboard = true
};
var film2 = new film()
{
idFilm = 2,
dateStart = new DateTime(2019, 10, 28, 23, 01, 002),
nameFilm = "Terminator II",
duration = "1 hora y 50 Minutos",
stateInBillboard = false
};
var film3 = new film()
{
idFilm = 3,
dateStart = new DateTime(2019, 09, 30, 01, 35, 03),
nameFilm = "El Depredador I",
duration = "2 hora y 50 Minutos",
stateInBillboard = false
};
var film4 = new film()
{
idFilm = 4,
dateStart = new DateTime(2019, 08, 20, 03, 10, 004),
nameFilm = "Hombre Araña I",
duration = "2 hora y 30 Minutos",
stateInBillboard = true
};
var film5 = new film()
{
idFilm = 5,
dateStart = new DateTime(2019, 09, 28, 01, 35, 005),
nameFilm = "La mascara",
duration = "3 hora y 10 Minutos",
stateInBillboard = false
};
var film6 = new film()
{
idFilm = 6,
dateStart = new DateTime(2017, 09, 10, 01, 35, 006),
nameFilm = "Man Heroe",
duration = "2 hora y 15 Minutos",
stateInBillboard = true
};
return(new List <film> {
film1, film2, film3, film4, film5, film6
});
}
//Edit
#region
// GET: films/Edit/5
public ActionResult Edit(int?id)
{
if (Request.IsAjaxRequest())
{
try
{
ManagerFilm manager = new ManagerFilm();
film film = manager.GetFilm(id);
ViewBag.id_type = new SelectList(new ManagerTypeFilm().GetType_film(), "id", "typage");
ViewBag.id_film = new SelectList(new ManagerFilm().GetAllFilms(), "id", "titre");
ManagerFilm m = new ManagerFilm();
film f = m.GetFilm(id);
if (f != null)
{
return(PartialView("PartialEdit", f));
}
}
catch (Exception e)
{
TempData.Add("Alert", e.Message);
}
}
return(RedirectToAction("Index"));
}
//Suppression via objet
public static int SuppFilm(film f)
{
int _retour = 0;
film filmASuprimer = dtc.film.Where(x => x.Id == f.Id).SingleOrDefault();
dtc.film.Remove(filmASuprimer);
_retour = dtc.SaveChanges();
return _retour;
}
public ActionResult FilmsDeleteConfirmed(int id)
{
film filmler = db.films.Find(id);
db.films.Remove(filmler);
db.SaveChanges();
return(RedirectToAction("Films"));
}
public ActionResult DeleteConfirmed(decimal id)
{
film film = db.films.Find(id);
db.films.Remove(film);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public void Incluir(film filme)
{
using (var db = new SakilaContext())
{
db.films.Add(filme);
db.SaveChanges();
}
}
public ActionResult Edit_film(int id)
{
film fil = data.films.SingleOrDefault(n => n.id == id);
if (fil == null)
{
Response.StatusCode = 404;
return(null);
}
if (fil.release != null)
{
DateTime release = DateTime.Parse(fil.release.ToString());
String year = release.Year.ToString();
String month, day;
if (release.Month < 10)
{
month = "0" + release.Month.ToString();
}
else
{
month = release.Month.ToString();
}
if (release.Day < 10)
{
day = "0" + release.Day.ToString();
}
else
{
day = release.Day.ToString();
}
ViewBag.release = year + "-" + month + "-" + day;
}
if (fil.created != null)
{
DateTime created = DateTime.Parse(fil.created.ToString());
String year_ = created.Year.ToString();
String month_, day_;
if (created.Month < 10)
{
month_ = "0" + created.Month.ToString();
}
else
{
month_ = created.Month.ToString();
}
if (created.Day < 10)
{
day_ = "0" + created.Day.ToString();
}
else
{
day_ = created.Day.ToString();
}
ViewBag.created = year_ + "-" + month_ + "-" + day_;
}
ViewBag.form = Get_list_form();
return(View(fil));
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
film film = await db.films.FindAsync(id);
db.films.Remove(film);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
//Обновление указанного объекта ListView
public void UpdateItemInTable(ListViewItem item, films_and_actors contract, film f, actor a)
{
item.SubItems[0].Text = f.ToString();
item.SubItems[1].Text = a.ToString();
item.SubItems[2].Text = contract.actor_honorarium.ToString();
item.Tag = new ContractPrimaryKey {
FilmId = contract.film_id, ActorId = contract.actor_id
}; //т.к. контракты мы пересоздаём
}
public void AddFilm(film film)
{
if (film == null)
{
return;
}
db.films.Add(film);
db.SaveChanges();
}
//Ajout
public static int AjouterFilm( film f)
{
int _retour = 0;
if (string.IsNullOrEmpty(f.Titre)) _retour = -1;
if (string.IsNullOrEmpty(f.Synopsis)) _retour = -2;
dtc.film.Add(f);
_retour = dtc.SaveChanges();
return _retour;
}
//-------------------------------СТАНДАРТНЫЕ ЗАПРОСЫ ДЛЯ ПОИСКА-------------------------------
//Поиск всех актёров данного фильма
public List <actor> GetActorsForFilm(DataContext ctx, film f)
{
List <actor> rez;
rez = (from contract in ctx.films_and_actors
where contract.film_id == f.id
select contract.actor).ToList();
return(rez);
}
public ActionResult Edit([Bind(Include = "Id,name,desc,start_date,end_date,price,theatre_id")] film film)
{
if (ModelState.IsValid)
{
db.Entry(film).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(film));
}
public void EditFilm(int id, film film)
{
if (film == null)
{
return;
}
db.films.Find(id);
db.films.Add(film);
db.SaveChanges();
}
public ActionResult Edit_film(film fil)
{
if (ModelState.IsValid)
{
UpdateModel(fil);
data.SubmitChanges();
return(RedirectToAction("Detail_film", new { id = fil.id }));
}
return(this.Edit_film(fil.id));
}
public ActionResult Edit([Bind(Include = "name_film,producer,genre,year,age_limit,film_id")] film film)
{
if (ModelState.IsValid)
{
db.Entry(film).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(film));
}
public ActionResult Edit([Bind(Include = "Id,FilmName,Desctiption,Director,Creator,Year,ImageUrl")] film film)
{
if (ModelState.IsValid)
{
db.Entry(film).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(film));
}
public async Task <ActionResult> Create([Bind(Include = "Id,date_of_session,filmname,time_of_session,hallname,hallId,filmId,price_of_tickets")] sessions sessions)
{
if (ModelState.IsValid)
{
var film = db.films.Where(c => c.Id == sessions.filmId).FirstOrDefault();
if (DateTime.Parse(sessions.date_of_session) >= DateTime.Parse(film.release_date))
{
string todaydate = DateTime.Today.ToString("yyyy.MM.dd");
int dd = DateTime.Parse(todaydate).CompareTo(DateTime.Parse(sessions.date_of_session));
if (dd <= 0)
{
db.session.Add(sessions);
await db.SaveChangesAsync();
hall current_hall = db.halls
.Where(d => d.Id == sessions.hallId).FirstOrDefault();
film current_film = db.films
.Where(d => d.Id == sessions.filmId).FirstOrDefault();
int number_rows = current_hall.number_of_rows;
int number_seats = current_hall.number_of_seats_in_a_row;
for (int i = 1; i < number_rows + 1; i++)
{
for (int j = 1; j < number_seats + 1; j++)
{
places place = new places();
{
place.sessionsId = sessions.Id;
place.number_of_row = i;
place.number_of_seat_in_a_row = j;
place.status = "Свободно";
//place.date_of_operation = DateTime.Now;
};
db.places_list.Add(place);
await db.SaveChangesAsync();
}
}
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("date_of_session", "Неверная дата начала сеанса. Введите коррекную дату(Нельзя задать прошедший день)");
}
}
else
{
ModelState.AddModelError("date_of_session", "Неверная дата начала сеанса. Введите коррекную дату(позднее даты релиза фильма)");
}
}
ViewBag.filmId = new SelectList(db.films, "Id", "film_name", sessions.filmId);
ViewBag.hallId = new SelectList(db.halls, "Id", "hall_name", sessions.hallId);
return(View(sessions));
}
//Добавление фильма в БД. Возвращает id добавленного фильма, или -1 при ошибке
public int AddFilmToDB(film newFilm)
{
if (AddObjectToDB("film", newFilm) == false)
{
return(-1);
}
else
{
return(newFilm.id); //Обновился при сохранении
}
}
public ActionResult Edit_film(int id)
{
film fil = data.films.SingleOrDefault(n => n.id == id);
if (fil == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(fil));
}
public ActionResult Create([Bind(Include = "Id,name,desc,start_date,end_date,price,theatre_id")] film film)
{
if (ModelState.IsValid)
{
db.films.Add(film);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(film));
}
public ActionResult Create([Bind(Include = "name_film,producer,genre,year,age_limit,film_id")] film film)
{
if (ModelState.IsValid)
{
db.film.Add(film);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(film));
}
