public ActionResult EditStudent(int id)
{
HomeDbUtil dbObj = new HomeDbUtil();
StudentDetails stdobj = dbObj.GetStudentByID(id);
return(View(stdobj));
}
public ActionResult AddStudent(StudentDetails std)
{
/*
* Creating object of DAL class `HomeDbUtil`
*/
HomeDbUtil db = new HomeDbUtil();
/*
* @param StudentDetails modal class to CreateAccount method of Account class
* @return number of rows affected
*/
int rows = db.CreateStudent(std);
if (rows > 0)
{
/*
* if insert success
*/
Session["Notification"] = 1;
return(RedirectToAction("Index"));
}
else
{
/*
* if insert failure
*/
Session["Notification"] = 2;
return(RedirectToAction("Index"));
}
}
public ActionResult Index()
{
/*
* Creating object of DAL class `HomeDbUtil`
*/
HomeDbUtil dbObj = new HomeDbUtil();
/*
* List class of type `StudentDetails` model
* List is a dynamic generic collection array
*/
List <StudentDetails> details = new List <StudentDetails>();
details = dbObj.GetAllStudents();
return(View(details));
}
public ActionResult EditStudent(StudentDetails std)
{
HomeDbUtil dbObj = new HomeDbUtil();
int rows = dbObj.EditStud(std);
if (rows > 0)
{
/*
* if update success
*/
Session["Notification"] = 3;
return(RedirectToAction("Index"));
}
else
{
/*
* if update failure
*/
Session["Notification"] = 4;
return(RedirectToAction("Index"));
}
}
public ActionResult DeleteStudent(int id)
{
HomeDbUtil dbObj = new HomeDbUtil();
int rows = dbObj.Delete(id);
if (rows > 0)
{
/*
* if delete success
*/
Session["Notification"] = 5;
return(RedirectToAction("Index"));
}
else
{
/*
* if delete failure
*/
Session["Notification"] = 6;
return(RedirectToAction("Index"));
}
}
