public int SaveEnrollCourse(EnrollStudentCourse enrollStudentCourse)
{
try
{
connection = new SqlConnection(connectionString);
//string query = "INSERT INTO StudentEnrollInCourse VALUES(@StudentId,@CourseId,@EnrollDate)";
string query = "INSERT INTO StudentEnrollInCourse VALUES('" + enrollStudentCourse.StudentId + "','" + enrollStudentCourse.CourseId + "','" +
enrollStudentCourse.EnrollDate + "','" + 1 + "')";
command = new SqlCommand(query, connection);
connection.Open();
command = new SqlCommand(query, connection);
int rowAffected = command.ExecuteNonQuery();
connection.Close();
return(rowAffected);
//command.Parameters.Clear();
//command.Parameters.AddWithValue("@StudentId", enrollStudentCourse.StudentId);
//command.Parameters.AddWithValue("@CourseId", enrollStudentCourse.Name);
//command.Parameters.AddWithValue("@EnrollDate", enrollStudentCourse.EnrollDate);
//command.Parameters.AddWithValue("@Status",1);
//int rowAffected = command.ExecuteNonQuery();
//return rowAffected;
}
catch (Exception exception)
{
throw new Exception("Could Not save", exception);
}
finally
{
connection.Close();
}
}
public ActionResult DeleteConfirmed(int id)
{
EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id);
db.EnrollStudentCourses.Remove(enrollStudentCourse);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "EnrollStudentCourseID,CourseID,StudentID,Grade")] EnrollStudentCourse enrollStudentCourse)
{
if (ModelState.IsValid)
{
db.Entry(enrollStudentCourse).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollStudentCourse.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", enrollStudentCourse.StudentID);
return(View(enrollStudentCourse));
}
public string SaveEnrollCourse(EnrollStudentCourse enrollStudentCourse)
{
if (studentGateway.IsEXistEnrollStudentCourse(enrollStudentCourse.CourseId, enrollStudentCourse.StudentId))
{
return(" Exist Course");
}
if (studentGateway.SaveEnrollCourse(enrollStudentCourse) > 0)
{
return("Save Enroll Course");
}
return("Failed to save");
}
public ActionResult Create(EnrollStudentCourse enrollStudentCourse)
{
try
{
IEnumerable <Student> students = studentManager.GetStudents();
ViewBag.Students = students;
ViewBag.message = studentManager.SaveEnrollCourse(enrollStudentCourse);
return(View());
}
catch
{
return(View());
}
}
// GET: EnrollStudentCourse/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id);
if (enrollStudentCourse == null)
{
return(HttpNotFound());
}
return(View(enrollStudentCourse));
}
// GET: EnrollStudentCourse/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EnrollStudentCourse enrollStudentCourse = db.EnrollStudentCourses.Find(id);
if (enrollStudentCourse == null)
{
return(HttpNotFound());
}
ViewBag.CourseID = new SelectList(db.Courses, "CourseID", "Title", enrollStudentCourse.CourseID);
ViewBag.StudentID = new SelectList(db.Students, "StudentID", "FirstName", enrollStudentCourse.StudentID);
return(View(enrollStudentCourse));
}
