public void GetNotes(string s) { db = new DatabaseLayer.DBConnection(); string query = "SELECT * FROM File_Spring_17 WHERE CourseID=(SELECT CourseID FROM OfferedCourses_Spring_17 Where CourseName='" + s + "');"; db.GetQuery(query); int i = 0; DataTable t = new DataTable(); db.dr.Dispose(); db.dt.Fill(t); i = t.Columns.Count; for (int j = 1; j <= i; j++) { string query1 = "Select Note" + j.ToString() + " From File_Spring_17 Where CourseID=(Select CourseID From OfferedCourses_Spring_17 Where CourseName='" + s + "');"; db = new DatabaseLayer.DBConnection(); db.GetQuery(query1); db.dr.Dispose(); db.dt.Fill(t); for (int a = 0; a < t.Columns.Count; a++) { string sl = t.Columns[a].ToString(); hList.Add(sl); } db.dr.Dispose(); db.dt.Dispose(); } }
public void getStudentRegistration(string getp, string s) { db = new DatabaseLayer.DBConnection(); for (int i = 1; i < 8; i++) { string query = "SELECT Subject" + i.ToString() + " FROM Registration_151_" + s + " WHERE Id='" + getp + "';"; db.GetQuery(query); if (db.dr.HasRows) { while (db.dr.Read()) { if (db.dr[0].ToString() != null) { try { string sl = db.dr.GetString(0); courseList.Add(new Courses(sl)); } catch (Exception ex) { } } } db.dr.Dispose(); } } db.con.Dispose(); this.GetCourseList(); }
public void GetStudentInfo(string getp, Student stu) { db = new DatabaseLayer.DBConnection(); string query = "Select * From Students_151 Where Id='" + getp + "';"; db.GetQuery(query); if (db.dr.HasRows) { while (db.dr.Read()) { stu.Id = db.dr.GetString(0); stu.Name = db.dr.GetString(2); stu.Cgpa = Convert.ToString(db.dr.GetDouble(3)); stu.Credit = Convert.ToString(db.dr.GetInt32(4)); stu.Program = db.dr.GetString(5); stu.Dept = db.dr.GetString(6); stu.Core = db.dr.GetString(7); if (db.dr[8].ToString() != null) { try { stu.Major = db.dr.GetString(8); stu.SecondMajor = db.dr.GetString(9); stu.Minor = db.dr.GetString(10); } catch (Exception ex) { stu.Major = "-"; stu.SecondMajor = "-"; stu.Minor = "-"; } } stu.Elective = db.dr.GetString(11); stu.FatherName = db.dr.GetString(12); stu.MotherName = db.dr.GetString(13); stu.PresentAddress = db.dr.GetString(14); stu.PermanentAddress = db.dr.GetString(15); stu.PhoneNo = (db.dr.GetString(16)); stu.Email = db.dr.GetString(17); stu.DateOfBirth = db.dr.GetString(18); stu.Sex = db.dr.GetString(19); stu.Nationality = db.dr.GetString(20); stu.Religion = db.dr.GetString(21); stu.MaritalStatus = db.dr.GetString(22); stu.Blood = db.dr.GetString(23); stu.AdmissionDate = db.dr.GetString(24); stu.GraduationDate = db.dr.GetString(25); } db.dr.Dispose(); } else { db.dr.Dispose(); } }
public void GetCourseList() { db = new DatabaseLayer.DBConnection(); for (int i = 0; i < courseList.Count; i++) { string query = "SELECT * FROM OfferedCourses_Spring_17 WHERE CourseName='" + courseList[i].courseName + "';"; db.GetQuery(query); if (db.dr.HasRows) { while (db.dr.Read()) { courseList[i].SetValue(db.dr.GetString(0), db.dr.GetString(2), db.dr.GetString(3), db.dr.GetString(5), db.dr.GetString(5), db.dr.GetString(6)); } db.dr.Dispose(); } } db.con.Dispose(); }