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());
}
