public ActionResult Index(SaveCourse aCourse) { ViewBag.Message = _saveCourseManager.Save(aCourse); ViewBag.Departments = _departmentManager.GetAllDepartment(); ViewBag.Semesters = _semesterManager.GetAllSemesters(); return(View()); }
public List <SaveCourse> GateCourseDetail(int id) { SqlConnection connection = new SqlConnection(); connection.ConnectionString = connectionString; SqlCommand command = new SqlCommand(); command.Connection = connection; command.CommandText = "SELECT * FROM Course WHERE Id=" + id; connection.Open(); SqlDataReader reader = command.ExecuteReader(); List <SaveCourse> courses = new List <SaveCourse>(); while (reader.Read()) { SaveCourse course = new SaveCourse { Id = (int)reader["Id"], Name = reader["Name"].ToString(), Code = reader["Code"].ToString(), Credit = (double)reader["Credit"] }; courses.Add(course); } reader.Close(); connection.Close(); return(courses); }
public string SaveCourse(SaveCourse data) { int rowAffected = aSave.SaveCourse(data); if (rowAffected > 0) { return("Department Added Successfully"); } return("Fail to Save Information!"); }
public bool Check(SaveCourse aCourse) { var connection = new SqlConnection(connectionString); var command = new SqlCommand(); command.CommandText = "SELECT * FROM Course WHERE Code='" + aCourse.Code + "' OR Name='" + aCourse.Name + "'"; command.Connection = connection; connection.Open(); SqlDataReader reader = command.ExecuteReader(); return(reader.HasRows); }
public string Save(SaveCourse aCourse) { if (_saveCourseGateway.Check(aCourse)) { return("Course code or name already exists"); } if (aCourse.Code.Length < 5) { return("Course code must be at least five characters long"); } if (aCourse.Credit < .5 || aCourse.Credit > 5) { return("Course credit must be at least .5 and at most 5"); } string result = _saveCourseGateway.Save(aCourse); return(result); }
public string Save(SaveCourse aCourse) { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand(); cmd.CommandText = "INSERT INTO Course (Code, Name, Credit, Description, DepartmentId, Semester) VALUES ('" + aCourse.Code + "','" + aCourse.Name + "','" + aCourse.Credit + "','" + aCourse.Description + "'" + ",'" + aCourse.DepartmentId + "','" + aCourse.Semester + "')"; cmd.CommandType = CommandType.Text; cmd.Connection = con; con.Open(); int rowAffected = cmd.ExecuteNonQuery(); if (rowAffected > 0) { return("New course inserted"); } con.Close(); return("New course not inserted"); }
public ActionResult Index(SaveCourse data) { ViewBag.Message = aManage.SaveCourse(data); return(View()); }