public ActionResult Edit(Student student)
{
try
{
StudentGateway studentGateway=new StudentGateway();
studentGateway.Update(student);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public ActionResult Create(Student student)
{
try
{
StudentGateway studentGateway=new StudentGateway();
studentGateway.Insert(student);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
public void Insert(Student aStudent)
{
CommandObj.CommandText = "spAddStudent";
CommandObj.CommandType = CommandType.StoredProcedure;
CommandObj.Parameters.Clear();
CommandObj.Parameters.AddWithValue("@Name", aStudent.Name);
CommandObj.Parameters.AddWithValue("@RegNo", aStudent.RegNo);
CommandObj.Parameters.AddWithValue("@Address", aStudent.Address);
CommandObj.Parameters.AddWithValue("@Phone", aStudent.Phone);
CommandObj.Parameters.AddWithValue("@Email", aStudent.Email);
ConnectionObj.Open();
CommandObj.ExecuteNonQuery();
CommandObj.Dispose();
ConnectionObj.Close();
}
public ActionResult Delete(Student student)
{
try
{
StudentGateway studentGateway=new StudentGateway();
studentGateway.Delete(student.Id);
return RedirectToAction("Index");
}
catch
{
return View();
}
}
