public ActionResult Add_category_film(FormCollection collection)
{
int id = int.Parse(collection["film_id"]);
ViewBag.film_id = id;
ViewBag.category = Get_list_all_category();
if (ModelState.IsValid)
{
film_category fil_cate = new film_category();
fil_cate.film_id = id;
fil_cate.category_id = int.Parse(collection["category_id"]);
var a = from filc in data.film_categories
where filc.film_id == fil_cate.film_id && filc.category_id == fil_cate.category_id
select filc;
if (a.Count() == 0)
{
data.film_categories.InsertOnSubmit(fil_cate);
data.SubmitChanges();
return(RedirectToAction("Manager_film_category", new { id = id }));
}
return(RedirectToAction("Manager_film_category", new { id = id }));
}
else
{
return(HttpNotFound());
}
}
public async Task <IActionResult> Edit(int id, [Bind("film_id,category_id,last_update")] film_category film_category)
{
if (id != film_category.film_id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(film_category);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!film_categoryExists(film_category.film_id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(film_category));
}
public async Task <IActionResult> Create([Bind("film_id,category_id,last_update")] film_category film_category)
{
if (ModelState.IsValid)
{
_context.Add(film_category);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(film_category));
}
public ActionResult Create_film_category(film_category fil_cat)
{
ViewBag.id = fil_cat.film_id;
ViewBag.category_id = new SelectList(data.categories.ToList().OrderBy(n => n.name), "id", "name");
if (ModelState.IsValid)
{
data.film_categories.InsertOnSubmit(fil_cat);
data.SubmitChanges();
return(RedirectToAction("Create_film_category"));
}
else
{
return(HttpNotFound());
}
}
public ActionResult Delete_film_category(int id)
{
film_category fil_cat = data.film_categories.SingleOrDefault(n => n.id == id);
if (fil_cat == null)
{
Response.StatusCode = 404;
return(null);
}
else
{
data.film_categories.DeleteOnSubmit(fil_cat);
data.SubmitChanges();
return(RedirectToAction("Create_film_category", "Admin", new { id = id }));
}
}
public ActionResult Delete_film_category(int id)
{
film_category f_c = data.film_categories.SingleOrDefault(n => n.id == id);
if (f_c == null)
{
Response.StatusCode = 404;
return(null);
}
else
{
int film_id = int.Parse(f_c.film_id.ToString());
data.film_categories.DeleteOnSubmit(f_c);
data.SubmitChanges();
return(RedirectToAction("Manager_film_category", new { id = film_id }));
}
}
