/*============================
* 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);
}
}
