/// <summary>
/// Call this function to get subject list
/// </summary>
/// <param name="course_code">course code</param>
/// <returns>SubjectCols collection</returns>
public static List <SubjectCols> getSubjectList(string course_code)
{
List <SubjectCols> items = null;
try
{
List <Row> rows = null;
items = new List <SubjectCols>();;
for (int t = 1; t <= Courses.getSemCount(course_code); t++)
{
rows = Medatabase.fetchRecords("SELECT * FROM subject_master WHERE course_code='" + course_code + "' AND semester=" + t);
foreach (Row row in rows)
{
items.Add(new SubjectCols {
subject_code = (string)row.column["sub_code"],
subject_name = (string)row.column["name"],
semNo = (semNo)row.column["semester"],
credits = (int)row.column["credits"]
});
}
}
}
catch (databaseException)
{
//do something
}
catch (Exception ex)
{
//do something
LogWriter.WriteError("While fetching subject list from database", ex.Message);
}
return(items);
}
/// <summary>
/// fetches all course_codes from database if regular student
/// else it fetches all course_codes only for which exam has held
/// </summary>
/// <param name="stype">Regular or non-regular</param>
/// <returns>course_code string collection</returns>
public static List <string> getCourseCodes(StudentType stype)
{
List <String> ccodes = new List <String>();
try
{
List <Row> rows;
if (stype == StudentType.REGULAR)
{
rows = Medatabase.fetchRecords("SELECT course_code FROM course_master");
}
else
{
rows = Medatabase.fetchRecords("SELECT DISTINCT course_code FROM exam_master");
}
foreach (Row row in rows)
{
ccodes.Add((string)row.column["course_code"]);
}
}
catch (databaseException)
{
//Do something
}
catch (Exception ex)
{
//Do something
LogWriter.WriteError("Fetching course code list from database", ex.Message);
}
return(ccodes);
}
/// <summary>
/// For filling course data in listview
/// </summary>
/// <returns>CourseCols collection</returns>
public static List <CourseCols> getCourseList()
{
List <CourseCols> items = null;
try
{
List <Row> rows = Medatabase.fetchRecords("SELECT * FROM course_master");
items = new List <CourseCols>();
foreach (Row row in rows)
{
items.Add(new CourseCols
{
c_code = (string)row.column["course_code"],
t_semesters = (int)row.column["total_semesters"],
in_semesters = (int)row.column["in_semesters"]
});
}
}
catch (databaseException)
{
//Do Something
}
catch (Exception ex)
{
//Do Something
LogWriter.WriteError("Fetching course list from database", ex.Message);
}
return(items);
}
/// <summary>
/// Returns the number of subject presents in a given course
/// </summary>
/// <param name="course_code">course code</param>
/// <returns>integer</returns>
public static int getSubjectCount(String course_code)
{
int count = 0;
List <Row> rows = Medatabase.fetchRecords("SELECT COUNT(sub_code) AS scount FROM subject_master WHERE course_code='" + course_code + "'");
if (rows.Count > 0)
{
count = Convert.ToInt16(rows[0].column["scount"]);
}
return(count);
}
/// <summary>
/// This method will return the no. of sems(in) in a particular course
/// </summary>
/// <param name="course_code">course for which sem count is requested</param>
/// <returns>Total sems count</returns>
public static int getInSemCount(string course_code)
{
int scount = 0;
List <Row> rows = Medatabase.fetchRecords("SELECT in_semesters FROM course_master WHERE course_code='" + course_code + "'");
foreach (Row row in rows)
{
scount = (int)row.column["in_semesters"];
}
return(scount);
}
private void cbxAYear_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbxAYear.SelectedIndex != -1)
{
List <String> months = new List <String>();
foreach (Row row in Medatabase.fetchRecords("SELECT DISTINCT month FROM exam_master WHERE course_code='" + (String)cbxACourse.SelectedItem + "' AND semester=" + Convert.ToInt16(cbxASem.SelectedItem)))
{
months.Add((String)row.column["month"]);
}
cbxAMonth.ItemsSource = months;
}
}
private void cbxASem_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (cbxASem.SelectedIndex != -1)
{
List <int> years = new List <int>();
foreach (Row row in Medatabase.fetchRecords("SELECT DISTINCT year FROM exam_master WHERE course_code='" + (String)cbxACourse.SelectedItem + "' AND semester=" + Convert.ToInt16(cbxASem.SelectedItem)))
{
years.Add(Convert.ToInt16(row.column["year"]));
}
cbxAYear.ItemsSource = years;
cbxAYear.Text = "-- YEAR --";
cbxAMonth.ItemsSource = null;
cbxAMonth.Text = "-- MONTH --";
}
}
/// <summary>
/// Returns batch years of a course
/// </summary>
/// <param name="course_code">course code</param>
/// <returns>int collection</returns>
public static List <int> getBatchList(String course_code)
{
List <int> list = new List <int>();
try
{
List <Row> rows = Medatabase.fetchRecords("SELECT DISTINCT year FROM student_details WHERE course_code='" + course_code + "'");
foreach (Row row in rows)
{
list.Add((int)row.column["year"]);
}
}
catch (Exception)
{
//Something went wrong
}
return(list);
}
private void button_Click(object sender, RoutedEventArgs e)
{
try
{
if (txtUsername.GetLineLength(0) == 0 || txtPassword.Password.Length == 0)
{
MessageBox.Show("Please input all the fields!", "WAIT", MessageBoxButton.OK, MessageBoxImage.Stop);
return;
}
string tmp = null;
List <Row> rows = Medatabase.fetchRecords("SELECT password FROM admin_login WHERE username='******'");
foreach (Row row in rows)
{
tmp = (string)row.column["password"];
}
if (string.Compare(tmp, txtPassword.Password) != 0 || tmp == null)
{
MessageBox.Show("Invalid username or password!", "Error", MessageBoxButton.OK, MessageBoxImage.Stop);
return;
}
admin_window obj = new admin_window();
obj.Show();
this.Hide();
}
catch (databaseException de)
{
MessageBox.Show(de.Message, "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error);
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong :(", "Error Occured", MessageBoxButton.OK, MessageBoxImage.Error);
LogWriter.WriteError("Login button clicked", ex.Message);
}
}
/// <summary>
/// Returns student details list
/// </summary>
/// <param name="course_code">Course code</param>
/// <param name="year">Batch or year</param>
/// <returns>Studentcols collection</returns>
public static List <StudentCols> getStudentList(String course_code, int year)
{
List <StudentCols> items = new List <StudentCols>();
try
{
List <Row> rows = Medatabase.fetchRecords("SELECT * FROM student_details WHERE course_code='" + course_code + "' AND year=" + year);
foreach (Row row in rows)
{
items.Add(new StudentCols
{
s_reg_id = (long)row.column["registration_id"],
s_name = (string)row.column["name"],
s_month = (string)row.column["month"]
});
}
}
catch (Exception ex)
{
LogWriter.WriteError("fetching student details", ex.Message);
}
return(items);
}
private void btnEvaluate_Click(object sender, RoutedEventArgs e)
{
bool isAllOk = true;
//validation
String error_message = null;
if (System.IO.File.Exists(txtIMFile.Text) == false)
{
error_message = "Please select internal marksheet file" + Environment.NewLine;
}
if (System.IO.File.Exists(txtEMFile.Text) == false)
{
error_message += "Please select external marksheet file" + Environment.NewLine;
}
if (System.IO.File.Exists(txtCutoffFile.Text) == false)
{
error_message += "Please select cut off file" + Environment.NewLine;
}
if (cbxECourse.SelectedIndex == -1)
{
error_message += "Please select course" + Environment.NewLine;
}
if (cbxESem.SelectedIndex == -1)
{
error_message += "Please select semester" + Environment.NewLine;
}
if (cbxEMonth.SelectedIndex == -1)
{
error_message += "Please select month" + Environment.NewLine;
}
if (cbxEType.SelectedIndex == -1)
{
error_message += "Please select student type" + Environment.NewLine;
}
if (cbxEYear.SelectedIndex == -1)
{
error_message += "Please select year" + Environment.NewLine;
}
if (error_message != null)
{
isAllOk = false;
MessageBox.Show("Please correct the following error(s)!" + Environment.NewLine + Environment.NewLine + error_message, "Invalid inputs", MessageBoxButton.OK, MessageBoxImage.Stop);
}
if (isAllOk) //Call for validation and evaluation
{
//get values from controls
int semester = (int)cbxESem.SelectedItem;
int year = Convert.ToInt16(cbxEYear.SelectedItem);
string course = (String)cbxECourse.SelectedItem;
string month = (cbxEMonth.SelectedItem as ComboBoxItem).Content.ToString(); //As the item is comboboxitem
try
{
List <Row> rows = Medatabase.fetchRecords("SELECT * FROM exam_master WHERE course_code='" + course + "' AND semester=" + semester + " AND year=" + year + " AND month='" + month + "'");
if (cbxEType.SelectedIndex == 0) //check if evaluation has already finished for given course, semester and date
{
if (rows.Count > 0)
{
MessageBox.Show("Evaluation has been finished already for semester " + semester + " of " + course + " on " + month + " " + year, "Stop", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
else //check if evaluation has been done or not for given course, semester and date
{
if (rows.Count == 0)
{
MessageBox.Show("No record of evaluation for semester " + semester + " of " + course + " on " + month + " " + year, "No records of exam for given values", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
}
catch (Exception)
{
MessageBox.Show("Something went wrong!");
return;
}
MessageBox.Show("Your files are going to be validated!", "Evaluator", MessageBoxButton.OK, MessageBoxImage.Information);
tabControl.IsEnabled = false;
this.Cursor = Cursors.Wait;
txtEvalOutput.Clear();
StudentType stype = StudentType.REGULAR;
if (String.Compare("Regular", (cbxEType.SelectedItem as ComboBoxItem).Content.ToString(), true) == 0)
{
stype = StudentType.REGULAR;
}
else if (String.Compare("Failed", (cbxEType.SelectedItem as ComboBoxItem).Content.ToString(), true) == 0)
{
stype = StudentType.FAILURE;
}
else
{
stype = StudentType.ABSENT;
}
(new Evaluator(txtIMFile.Text, txtEMFile.Text, txtCutoffFile.Text)).validateWorksheets(course, semester, year, month, stype);
}
}
