public ActionResult Create(AddCourseViewModels course) { try { SqlConnection con = new SqlConnection(connection); con.Open(); string filename = Path.GetFileNameWithoutExtension(course.ImageFile.FileName); string extension = Path.GetExtension(course.ImageFile.FileName); filename = filename + DateTime.Now.ToString("yymmssfff") + extension; course.CourseImage = "~/images/" + filename; filename = Path.Combine(Server.MapPath("~/images/"), filename); course.ImageFile.SaveAs(filename); string query = "INSERT INTO Course(Title,Credits,Fee,DepartmentId,CourseImage)VALUES ('" + course.Title + "','" + course.Credits + "','" + course.Fee + "','" + DeptId + "','" + course.CourseImage + "')"; SqlCommand cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); // ViewBag.Message("Successfull"); return(RedirectToAction("Index", new { id = DeptId })); } catch (Exception ex) { return(View(ex)); } }
// GET: AddCourse public ActionResult Index(int id) { SqlConnection conn = new SqlConnection(connection); string query; SqlCommand SqlCommand; List <AddCourseViewModels> lists = new List <AddCourseViewModels>(); //Open the connection to db conn.Open(); //Generating the query to fetch the contact details query = " SELECT * FROM Course where DepartmentId= ' " + id + "' "; SqlCommand = new SqlCommand(query, conn); SqlDataReader rdr = SqlCommand.ExecuteReader(); while (rdr.Read()) { var dpt = new AddCourseViewModels(); dpt.Id = Convert.ToInt32(rdr[0]); dpt.Title = rdr[1].ToString(); dpt.Credits = rdr[2].ToString(); dpt.Fee = Convert.ToInt32(rdr[3]); dpt.DepartmentId = Convert.ToInt32(rdr[4]); dpt.CourseImage = rdr[5].ToString(); lists.Add(dpt); } return(View(lists)); }
public ActionResult AllCourses(int id) { SqlConnection conn = new SqlConnection(connection); string query; SqlCommand SqlCommand; instructorId = id; List <AddCourseViewModels> lists = new List <AddCourseViewModels>(); SqlDataAdapter adapter = new SqlDataAdapter(); //Open the connection to db conn.Open(); //Generating the query to fetch the contact details query = " select * from Course where not exists (select * from AssignInstructor where Course.Id=AssignInstructor.CourseId) "; SqlCommand = new SqlCommand(query, conn); SqlDataReader rdr = SqlCommand.ExecuteReader(); while (rdr.Read()) { var dpt = new AddCourseViewModels(); dpt.Id = Convert.ToInt32(rdr[0]); dpt.Title = rdr[1].ToString(); dpt.Credits = rdr[2].ToString(); dpt.Fee = Convert.ToInt32(rdr[3]); dpt.DepartmentId = Convert.ToInt32(rdr[4]); dpt.CourseImage = rdr[5].ToString(); lists.Add(dpt); } return(View(lists)); }
public ActionResult DetailsForStudents(int CID) { SqlConnection con = new SqlConnection(connection); con.Open(); List <AddCourseViewModels> lists = new List <AddCourseViewModels>(); string query = "SELECT * from Course where Id='" + CID + "'"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { var course = new AddCourseViewModels(); course.Id = Convert.ToInt32(rdr[0]); course.Title = rdr[1].ToString(); course.Credits = rdr[2].ToString(); course.Fee = Convert.ToInt32(rdr[3]); course.DepartmentId = Convert.ToInt32(rdr[4]); course.CourseImage = rdr[5].ToString(); lists.Add(course); } rdr.Close(); return(View(lists)); }
public ActionResult RegisteredCourses() { SqlConnection conn = new SqlConnection(connection); string query; SqlCommand SqlCommand; List <AddCourseViewModels> lists = new List <AddCourseViewModels>(); //Open the connection to db conn.Open(); //Generating the query to fetch the contact details query = " select Course.Id,StudentRegisterCourse.DepartmentId,Course.Title,Course.Fee,Course.Credits,Course.CourseImage from Course inner join StudentRegisterCourse on Course.Id=StudentRegisterCourse.CourseId and StudentRegisterCourse.StudentId='" + loginId + "'"; SqlCommand = new SqlCommand(query, conn); SqlDataReader rdr = SqlCommand.ExecuteReader(); while (rdr.Read()) { var course = new AddCourseViewModels(); course.Id = Convert.ToInt32(rdr[0]); course.DepartmentId = Convert.ToInt32(rdr[1]); course.Title = rdr[2].ToString(); course.Fee = Convert.ToInt32(rdr[3]); course.Credits = rdr[4].ToString(); course.CourseImage = rdr[5].ToString(); lists.Add(course); } return(View(lists)); }
public ActionResult Edit(int id, AddCourseViewModels course) { try { SqlConnection con = new SqlConnection(connection); con.Open(); // TODO: Add update logic here string query = "UPDATE Course SET Title='" + course.Title + "', Credits='" + course.Credits + "',Fee='" + course.Fee + "' where Id='" + id + "'"; SqlCommand cmd = new SqlCommand(query, con); cmd.ExecuteNonQuery(); return(RedirectToAction("Details", new { CId = id })); } catch { return(View()); } }
// GET: Course/Edit/5 public ActionResult Edit(int id) { SqlConnection con = new SqlConnection(connection); con.Open(); string query = "SELECT * from Course where Id='" + id + "'"; SqlCommand cmd = new SqlCommand(query, con); SqlDataReader rdr = cmd.ExecuteReader(); var course = new AddCourseViewModels(); while (rdr.Read()) { course.Id = Convert.ToInt32(rdr[0]); course.Title = rdr[1].ToString(); course.Credits = rdr[2].ToString(); course.Fee = Convert.ToInt32(rdr[3]); course.DepartmentId = Convert.ToInt32(rdr[4]); course.CourseImage = rdr[5].ToString(); } rdr.Close(); return(View(course)); }