using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;
using WebApplication27.Models;
namespace WebApplication27.Controllers
{
public class HomeController : Controller
{
StudentContext db = new StudentContext();
// GET: Home
public ActionResult Index()
{
var data = db.students.ToList();
return View(data);
}
public ActionResult Create()
{
return View();
}
[HttpPost]
public ActionResult Create(Student std)
{
if (ModelState.IsValid ==true)
{
db.students.Add(std);
int a = db.SaveChanges();
if (a>0)
{
TempData["Message"] = "Data Inserted Sucessfully !!";
return RedirectToAction("index");
}
else
{
TempData["Message"] = "Data not Inserted Sucessfully !!";
}
}
return View();
}
public ActionResult Delete(int id)
{
var StudentIdRow = db.students.Where(model => model.Id == id).FirstOrDefault();
return View(StudentIdRow);
//if (id>0)
//{
// var StudentIdRow = db.students.Where(model => model.Id == id).FirstOrDefault();
// if (StudentIdRow !=null)
// {
// db.Entry(StudentIdRow).State = System.Data.Entity.EntityState.Deleted;
// int a = db.SaveChanges();
// if (a>0)
// {
// TempData["DeleteMessage"] = "Data Deleted Sucessfully !!";
// }
// else
// {
// TempData["DeleteMessage"] = "Data not Deleted Sucessfully !!";
// }
// }
//}
//return RedirectToAction("index");
}
[HttpPost]
public ActionResult Delete(Student std)
{
db.Entry(std).State = System.Data.Entity.EntityState.Deleted;
int a = db.SaveChanges();
if (a > 0)
{
TempData["DeleteMessage"] = "Data Deleted Sucessfully !!";
}
else
{
TempData["DeleteMessage"] = "Data not Deleted Sucessfully !!";
}
return RedirectToAction("index");
}
public ActionResult Edit(int id)
{
var StudentIdRow = db.students.Where(model => model.Id == id).FirstOrDefault();
return View(StudentIdRow);
}
[HttpPost]
public ActionResult Edit(Student std)
{
db.Entry(std).State = System.Data.Entity.EntityState.Modified;
int a = db.SaveChanges();
if (a > 0)
{
TempData["DeleteMessage"] = "Data Deleted Sucessfully !!";
}
else
{
TempData["DeleteMessage"] = "Data not Deleted Sucessfully !!";
}
return RedirectToAction("index");
}
}
}
No comments: