public async Task <ActionResult> DeleteConfirmed(int id) { TSql_Country tSql_Country = await db.TSql_Country.FindAsync(id); db.TSql_Country.Remove(tSql_Country); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "IDCountry,CountryName")] TSql_Country tSql_Country) { if (ModelState.IsValid) { db.Entry(tSql_Country).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(tSql_Country)); }
public async Task <ActionResult> Create([Bind(Include = "IDCountry,CountryName")] TSql_Country tSql_Country) { if (ModelState.IsValid) { db.TSql_Country.Add(tSql_Country); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(tSql_Country)); }
// GET: Admin/TSql_Country/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TSql_Country tSql_Country = await db.TSql_Country.FindAsync(id); if (tSql_Country == null) { return(HttpNotFound()); } return(View(tSql_Country)); }
// Search Country public ViewResult Search_Country(int?page, int?id) { int num = 36; int pagenum = (page ?? 1); TSql_Country tCountry = db.TSql_Country.SingleOrDefault(m => m.IDCountry == id); if (tCountry == null) { Response.StatusCode = 404; return(View()); } List <TSql_Films> tFilm = db.TSql_Films.Where(m => m.IDCountry == id).ToList(); if (tFilm.Count == 0) { ViewBag.danger = "Not found"; } Session["country"] = tCountry.CountryName; ViewBag.success = "Have " + tFilm.Count + " result"; return(View(tFilm.OrderBy(m => m.FilmName).ToPagedList(pagenum, num))); }