public string SaveCourse(Course courseObj) { string query = "INSERT INTO Course VALUES (@code, @name,@credit,@description,@deptID,@semesetr)"; SqlCommand insertCommand = new SqlCommand(query, connection); insertCommand.Parameters.Clear(); insertCommand.Parameters.Add("code", SqlDbType.VarChar); insertCommand.Parameters["code"].Value = courseObj.CourseCode; insertCommand.Parameters.Add("name", SqlDbType.VarChar); insertCommand.Parameters["name"].Value = courseObj.CourseName; insertCommand.Parameters.Add("credit", SqlDbType.Decimal); insertCommand.Parameters["credit"].Value = courseObj.Credit; insertCommand.Parameters.Add("description", SqlDbType.VarChar); insertCommand.Parameters["description"].Value = courseObj.Description; insertCommand.Parameters.Add("deptID", SqlDbType.Int); insertCommand.Parameters["deptID"].Value = courseObj.DepartmentId; insertCommand.Parameters.Add("semesetr", SqlDbType.Int); insertCommand.Parameters["semesetr"].Value = courseObj.Semester; connection.Open(); int rowAffected = insertCommand.ExecuteNonQuery(); connection.Close(); if (rowAffected > 0) return "Saved Successfully"; return "Saved Failed"; }
public List<Course> LoadDepartment() { string query = "SELECT * FROM Department"; SqlCommand command = new SqlCommand(query, connection); connection.Open(); List<Course> departmentList = new List<Course>(); try { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Course departmets = new Course(); departmets.DepartmentId = Convert.ToInt32(reader["DepartmentID"].ToString()); departmets.Department = reader["DepartmentName"].ToString(); departmentList.Add(departmets); } reader.Close(); } catch (Exception e) { connection.Close(); throw e; } connection.Close(); return departmentList; }
public ActionResult SaveCourse(Course courseObj) { ViewBag.departmentList = manager.departmentList(); ViewBag.Semester = GetSemester(); ViewBag.Savemessage = manager.SaveCourse(courseObj); return View(); }
public string SaveCourse(Course courseObj) { string message = gateWay.SaveCourse(courseObj); return message; }