public ClassDetails GetFullClassDetails(int classId) { Connection(); Class classModel = new Class(); SqlCommand cmd = new SqlCommand("Project.GetFullClassDetailsByClass", con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@ClassId", classId); SqlDataAdapter sd = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); sd.Fill(dt); con.Close(); if (dt.Rows.Count > 0) { DataRow dr = dt.Rows[0]; return(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"]) }); } else { return(null); } }
public List <ClassDetails> GetStudentClassDetails(int studentId) { Connection(); Student student = new Student(); SqlCommand cmd = new SqlCommand("Project.GetFullClassDetailsByStudent", con) { CommandType = CommandType.StoredProcedure }; cmd.Parameters.AddWithValue("@StudentId", studentId); SqlDataAdapter sd = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); sd.Fill(dt); con.Close(); List <ClassDetails> classDetails = new List <ClassDetails>(); foreach (DataRow dr in dt.Rows) { classDetails.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(classDetails); }
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); }