/*============================ * VALID SECTION * ==============================*/ public bool validSection(string sectionName) { int count = 0; bool valid = false; /*==============create connection==============*/ conn = new myConnection(); string sql = "SELECT count(*) as TotalValue FROM cce_student cs, cce_courselist cc, cce_studentCourseList cscl WHERE cs.id = cscl.studentID AND cc.id = cscl.courseID AND cc.sectionName ='" + sectionName + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { count = Int32.Parse(dr["TotalValue"].ToString()); } if (count == 0) { //return false valid = true; } else { //return false valid = false; } return(valid); /*==============check valid or not==============*/ /*==============create connection==============*/ }
/*================================== * SECTION IS AVAILABLE * ====================================*/ public bool validSection(string sectionName) { bool valid = false; int count = 0; conn = new myConnection(); string sql = "SELECT count(*) as count FROM cce_courselist WHERE sectionName='" + sectionName + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { count = Int32.Parse(dr["count"].ToString()); } if (count == 0) { //return false valid = true; } else { //return false valid = false; } return(valid); }
public bool checkValidSection(string secName, string roomNo, string sTime, string eTime, string day) { string _roomno = " ", _secName = " ", _startTime = " ", _endTime = " ", _day = " "; bool valid = false; conn = new myConnection(); string sql = "select section,startTime,endTime,day,roomno from cce_sectionlist where section= '" + secName + "' and roomno='" + roomNo + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { _secName = dr["section"].ToString(); _roomno = dr["roomno"].ToString(); _startTime = TimeSpan.Parse(dr["startTime"].ToString()).ToString(@"hh\:mm"); _endTime = TimeSpan.Parse(dr["endTime"].ToString()).ToString(@"hh\:mm"); _day = dr["day"].ToString(); if (sTime == _startTime && eTime == _endTime && day == _day && roomNo == _roomno) { valid = true; } } return(valid); }
/*============================================== * SHOW STUDENT DETAILS * ================================================*/ public void studentInformation(string fullName, string section, string roll, string courseID) { //create connection conn = new myConnection(); student_fullName.Content = fullName; student_section.Content = section; student_roll.Content = roll; course_ID.Content = courseID; //close connection conn.con.Close(); }
/*============INSERT ALL VALUES==================*/ public bool insertMarkDetails(int currStdID, int course_ID, double fQuiz, double assign, double rprt, double attendance, double term, double total, string grade) { try { conn = new myConnection(); string sql = "INSERT INTO cce_markDetails values(" + currStdID + "," + course_ID + "," + fQuiz + "," + assign + "," + rprt + "," + term + "," + total + ",'" + grade + "')"; conn.SqlQuery(sql); conn.NonQuery(); } catch (Exception ex) { throw ex; } return(true); }
public void ShowStudentInfo(string stdRoll, string sect, string courseID) { //MessageBox.Show(stdRoll); //show studentID; conn = new myConnection(); string sql = "select * from cce_student WHERE roll='" + stdRoll + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { studentname.Content = dr["firstname"].ToString().ToUpper() + " " + dr["lastname"].ToString().ToUpper(); email.Content = dr["email"].ToString(); roll.Content = dr["roll"].ToString(); section.Content = sect; course_id.Content = courseID; } }
/*============FIND STUDENT==================*/ public string findStudentID(string studentRoll) { try { conn = new myConnection(); string sql = "SELECT id FROM cce_student WHERE roll='" + studentRoll + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { std = dr["id"].ToString(); } return(std); } catch (Exception ex) { throw ex; } }
/*==============CONNNECT CHECK=================*/ private void establish_connection_Click(object sender, RoutedEventArgs e) { try { conn = new myConnection(); string sql = "select lastname FROM cce_student where firstname='wohhie'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { MessageBox.Show(dr["lastname"].ToString()); } } catch (Exception ex) { MessageBox.Show("Error : " + ex); } }
/*============RETRIVE ATTENDACE MARK==================*/ public string RetriveAttendanceMark(string stdID) { double stdid = double.Parse(stdID); try { conn = new myConnection(); string sql = "select sum(attendance) as totalAtdMark from cce_marks where studentID=" + stdid; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { std = dr["totalAtdMark"].ToString(); } return(std); } catch (Exception ex) { throw ex; } }
/*===================================================================== * DEPENDING ON THE SELECT SUBJECT * ======================================================================*/ private void subject_name_SelectionChanged(object sender, SelectionChangedEventArgs e) { //string courseName = subject_name.SelectionBoxItem.ToString(); string courseName = subject_name.SelectedValue.ToString(); string courseIndex = subject_name.SelectedIndex.ToString(); //MessageBox.Show(courseIndex); //MessageBox.Show(courseName); //English try { conn = new myConnection(); string sql = "select * from cce_courselist where courseName='" + courseName + "'"; conn.SqlQuery(sql); foreach (DataRow dr in conn.exQuery().Rows) { //add values string sectionName = dr["sectionName"].ToString(); string courseStartTime = dr["cStartTime"].ToString(); string courseEndTime = dr["cEndTime"].ToString(); starttime.SelectedIndex = Int32.Parse(courseIndex); endtime.SelectedIndex = Int32.Parse(courseIndex); select_section.SelectedIndex = Int32.Parse(courseIndex); //MessageBox.Show(courseStartTime); } conn.con.Close();; /*=== * try * { * SqlCommand cmd1 = new SqlCommand(); * cmd1.Connection = myConnection.conn; * cmd1.CommandText = "SELECT count(*) as currStudent FROM cce_student cs, cce_courselist cc, cce_studentCourseList cscl WHERE cs.id = cscl.studentID AND cc.id = cscl.courseID AND cc.sectionName='" + select_section.Text + "'"; * * using (SqlDataReader oReader = cmd1.ExecuteReader()) * { * while (oReader.Read()) * { * //student_name.Content = "welcome"; * current_student.Content = oReader["count"].ToString(); * } * * * } * * } * catch(Exception ex) * { * MessageBox.Show("Error : " + ex); * } * * ====*/ //close //MessageBox.Show("Successfully Inserted."); } catch (Exception ex) { MessageBox.Show("Error : " + ex); } }