public ActionResult Add(StudentManagementSystem.Models.StudentVM student)
{
string queryString = @"Insert into Students (FirstName, LastName, Removed) Values (@FirstName, @LastName, Null)";
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Parameters.Add("@FirstName", SqlDbType.VarChar);
command.Parameters.Add("@LastName", SqlDbType.VarChar);
command.Parameters["@FirstName"].Value = student.FirstName;
command.Parameters["@LastName"].Value = student.LastName;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(StudentManagementSystem.Models.StudentVM student)
{
string queryString = @"Update Students set FirstName=@FirstName, LastName=@LastName Where ID=@ID";
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters.Add("@FirstName", SqlDbType.VarChar);
command.Parameters.Add("@LastName", SqlDbType.VarChar);
command.Parameters["@ID"].Value = student.ID;
command.Parameters["@FirstName"].Value = student.FirstName;
command.Parameters["@LastName"].Value = student.LastName;
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
return(RedirectToAction("Index"));
}
public ActionResult Edit(int ID)
{
string queryString = "Select * From Students Where ID = @ID";
var student = new StudentManagementSystem.Models.StudentVM();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
command.Parameters.Add("@ID", SqlDbType.Int);
command.Parameters["@ID"].Value = ID;
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
student.ID = Convert.ToInt32(reader["ID"]);
student.FirstName = reader["FirstName"].ToString().Trim();
student.LastName = reader["LastName"].ToString().Trim();
}
connection.Close();
}
return(View(student));
}
