/********************** * Get all classes taught by instructor id **********************/ public List <ClassDetails> GetClassDetailsByInstructor(int id) { Connection(); List <ClassDetails> classlist = new List <ClassDetails>(); SqlCommand cmd = new SqlCommand("Project.GetFullClassDetailsFromInstructor", con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@InstructorId", id); SqlDataAdapter sd = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); sd.Fill(dt); con.Close(); foreach (DataRow dr in dt.Rows) { classlist.Add( new ClassDetails { ClassId = Convert.ToInt32(dr["ClassId"]), ClassName = Convert.ToString(dr["ClassName"]), Building = Convert.ToString(dr["Building"]), Days = ClassDetails.ConvertBitsToDays(Convert.ToInt32(dr["Days"])), FirstName = Convert.ToString(dr["FirstName"]), LastName = Convert.ToString(dr["LastName"]), StartTime = TimeSpan.Parse(Convert.ToString(dr["StartTime"])), EndTime = TimeSpan.Parse(Convert.ToString(dr["EndTime"])), TermName = Convert.ToString(dr["TermName"]), RoomNumber = Convert.ToInt32(dr["RoomNumber"]) }); } return(classlist); }
public List <ClassDetails> GetFilteredClasses(string firstName, string lastName, string department, string days, string startTime, string endTime, string termName, string termYear, string type) { Connection(); List <ClassDetails> classlist = new List <ClassDetails>(); SqlCommand cmd = new SqlCommand("Project.GetFilteredClasses", con) { CommandType = CommandType.StoredProcedure }; if (department != "") { cmd.Parameters.AddWithValue("@Department", department); } if (firstName != "") { cmd.Parameters.AddWithValue("@FirstName", firstName); } if (lastName != "") { cmd.Parameters.AddWithValue("@LastName", lastName); } if (startTime != "") { cmd.Parameters.AddWithValue("@StartTime", startTime); } if (endTime != "") { cmd.Parameters.AddWithValue("@EndTime", endTime); } if (days != "") { cmd.Parameters.AddWithValue("@Days", ClassDetails.ConvertDaysToBits(days)); } if (termName != "") { cmd.Parameters.AddWithValue("@TermName", termName); } if (termYear != "") { cmd.Parameters.AddWithValue("@TermYear", termYear); } if (type != "") { cmd.Parameters.AddWithValue("@Type", type); } SqlDataAdapter sd = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); sd.Fill(dt); con.Close(); foreach (DataRow dr in dt.Rows) { classlist.Add( new ClassDetails { ClassName = Convert.ToString(dr["ClassName"]), ClassId = Convert.ToInt32(dr["ClassId"]), FirstName = Convert.ToString(dr["FirstName"]), LastName = Convert.ToString(dr["LastName"]), TermName = Convert.ToString(dr["TermName"]), Days = ClassDetails.ConvertBitsToDays(Convert.ToInt32(dr["Days"])), StartTime = TimeSpan.Parse(Convert.ToString(dr["StartTime"])), EndTime = TimeSpan.Parse(Convert.ToString(dr["EndTime"])), Building = Convert.ToString(dr["Building"]), RoomNumber = Convert.ToInt32(dr["RoomNumber"]) }); } return(classlist); }
public ClassReviewViewModel(ClassDetails cmodel, List <Review> reviews) { ClassModel = cmodel; ReviewsModel = reviews; }