public ActionResult NewAssign(int student, int course)
{
JoinTableClass join = new JoinTableClass(student, course);
join.Save();
return(RedirectToAction("Assign"));
}
public ActionResult ShowCourse(int id)
{
Dictionary <string, object> allInfo = new Dictionary <string, object>();
List <StudentClass> students = JoinTableClass.GetStudentsByCourseId(id);
List <CourseClass> course = CourseClass.FindById(id);
allInfo.Add("students", students);
allInfo.Add("course", course);
return(View("ShowCourse", allInfo));
}
public ActionResult SaveFlight(string departureTime, string status, int cityOne, int cityTwo)
{
FlightClass flight = new FlightClass(departureTime, status);
flight.FlightSave();
List <FlightClass> flights = FlightClass.GetAll();
int flightId = flights[0].GetId();
JoinTableClass.SaveToJoinTable(cityOne, cityTwo, flightId);
return(RedirectToAction("NewFlight"));
}
public ActionResult Update(int id, int course, string status)
{
if (status == "1")
{
JoinTableClass.UpdatePassing(id, course);
}
else
{
JoinTableClass.UpdateFailing(id, course);
}
return(RedirectToAction("ShowStudent", id));
}
public ActionResult SaveFlight(string departureTime, string status, int cityOne, int cityTwo)
{
FlightClass flight = new FlightClass(departureTime, status);
flight.FlightSave();
List <FlightClass> flights = FlightClass.GetAll();
int flightId = flight.GetId();
// int flightId = flights[0].GetId();
// this /\ was grabbing the first flight in the list every time and setting all entries to 1
JoinTableClass.SaveToJoinTable(cityOne, cityTwo, flightId);
return(RedirectToAction("NewFlight"));
}
public ActionResult UpdateGrade(int id)
{
Dictionary <string, object> allInfo = new Dictionary <string, object>();
List <StudentClass> student = StudentClass.FindById(id);
List <CourseClass> courses = JoinTableClass.GetCoursesByStudentId(id);
List <bool> classStatus = new List <bool>()
{
};
foreach (CourseClass course in courses)
{
bool status = JoinTableClass.FindStatusByStudentAndCourseId(id, course.GetId());
classStatus.Add(status);
}
allInfo.Add("student", student);
allInfo.Add("courses", courses);
allInfo.Add("status", classStatus);
return(View(allInfo));
}
public static List <JoinTableClass> jointables()
{
List <JoinTableClass> jt = new List <JoinTableClass>();
string connection = "Data Source=(localdb)\\MSSQLLocalDB;Initial Catalog=CityData;Integrated Security=True";
using (SqlConnection sqlconn = new SqlConnection(connection))
{
using (SqlCommand sqlcomm = new SqlCommand("Jointables", sqlconn))
{
sqlconn.Open();
sqlcomm.CommandType = System.Data.CommandType.StoredProcedure;
SqlDataReader sdr = sqlcomm.ExecuteReader();
while (sdr.Read())
{
JoinTableClass jtc = new JoinTableClass();
jtc.Cname = sdr["Cname"].ToString();
jtc.Sname = sdr["Sname"].ToString();
jtc.Cityname = sdr["Cityname"].ToString();
jt.Add(jtc);
}
}
return(jt);
}
}
public ActionResult ShowFlights(int cityOneId)
{
List <JoinTableClass> totalFlightInfo = JoinTableClass.GetJoinTable(cityOneId);
return(View("ShowFlights", totalFlightInfo));
}
