public Student GetStudenInfoForEditing(int StudentId)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
Student student = new Student();
SqlCommand command = new SqlCommand();
command.CommandText = "select * from Student where StudentId=@StudentId;";
command.Parameters.AddWithValue("@StudentId", StudentId);
command.Connection = connection;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
student.StudentId = Convert.ToInt32(reader["StudentId"]);
student.Name = reader["Name"].ToString();
student.DepartmentName = reader["DepartmentName"].ToString();
student.DepartmentRoll = reader["DepartmentRoll"].ToString();
student.AcademicYear = reader["AcademicYear"].ToString();
student.AttachedHallName = reader["AttachedHallName"].ToString();
}
return student;
}
}
public int GetStudentIdAfterInsertStudentInfo(Student Student)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.CommandText = "INSERT INTO Student(Name,DepartmentName,DepartmentRoll,AcademicYear,AttachedHallName ) OUTPUT INSERTED.StudentId VALUES(@Name ,@DepartmentName ,@DepartmentRoll ,@AcademicYear,@AttachedHallName );";
command.Connection = connection;
command.Parameters.AddWithValue("@Name", Student.Name);
command.Parameters.AddWithValue("@DepartmentName", Student.DepartmentName);
command.Parameters.AddWithValue("@DepartmentRoll", Student.DepartmentRoll);
command.Parameters.AddWithValue("@AcademicYear", Student.AcademicYear);
command.Parameters.AddWithValue("@AttachedHallName", Student.AttachedHallName);
connection.Open();
Student.StudentId = (Int32)command.ExecuteScalar();
}
return Student.StudentId;
}
public void UpdateStudentInfoWithStudentId(Student Student)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand();
command.CommandText = "Update Student set Name=@Name,DepartmentName=@DepartmentName,DepartmentRoll=@DepartmentRoll,AcademicYear=@AcademicYear,AttachedHallName=@AttachedHallName where StudentId=@StudentId ;";
command.Connection = connection;
command.Parameters.AddWithValue("@Name", Student.Name);
command.Parameters.AddWithValue("@DepartmentName", Student.DepartmentName);
command.Parameters.AddWithValue("@DepartmentRoll", Student.DepartmentRoll);
command.Parameters.AddWithValue("@AcademicYear", Student.AcademicYear);
command.Parameters.AddWithValue("@AttachedHallName", Student.AttachedHallName);
command.Parameters.AddWithValue("@StudentId", Student.StudentId);
connection.Open();
command.ExecuteNonQuery();
}
}
public ActionResult Edited(Student student)
{
if (ModelState.IsValid)
{
StudentDAO Student_DAO = new StudentDAO();
Student_DAO.UpdateStudentInfoWithStudentId(student);
return View(Student_DAO.GetStudenInfoForEditing(student.StudentId));
}
else
{
return View("Edit");
}
}
