public List <StudentTakeCourse> downloadStudentTakeCoursesFromFirebase()
{
List <StudentTakeCourse> allStudentTakeCourses = new List <StudentTakeCourse>();
using (StreamReader read = new StreamReader("student_take_courses_total_reduced.txt"))
{
string line;
while ((line = read.ReadLine()) != null)
{
String[] arr = line.Split(',');
StudentTakeCourse s1 = new StudentTakeCourse();
s1.idSTC = Convert.ToInt32(arr[0]);
s1.rollNoSTC = arr[1];
s1.courseCodeSTC = arr[2];
allStudentTakeCourses.Add(s1);
}
}
/* for (int a=0; a<allStudentTakeCourses.Count; a++)
* {
* Console.WriteLine(allStudentTakeCourses[a].idSTC+", "+allStudentTakeCourses[a].rollNoSTC+", " + allStudentTakeCourses[a].courseCodeSTC);
* }
*/
return(allStudentTakeCourses);
}
public void Test26StudentTakeCourse()
{
StudentTakeCourse c1 = new StudentTakeCourse();
c1.courseCodeSTC = c1.courseCodeSTC;
c1.idSTC = c1.idSTC;
c1.rollNoSTC = c1.rollNoSTC;
}
public List <StudentTakeCourse> getAllStudentTakeCourses(String dummyString = "null")
{
if (dummyString != "null")
{
connectionString += dummyString;
}
SqlConnection con = null;
List <StudentTakeCourse> allStudentTakeCourses = new List <StudentTakeCourse>();
SqlCommand cmd = null;
try
{
con = new SqlConnection(connectionString);
cmd = new SqlCommand("SELECT * FROM " + studentTakeCourseTable, con);
cmd.Connection.Open();
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
StudentTakeCourse s1 = new StudentTakeCourse();
s1.idSTC = (int)sdr["id"];
s1.courseCodeSTC = (String)sdr["courseCode"];
s1.rollNoSTC = (String)sdr["rollNo"];
// Console.WriteLine(s1.idSTC+", "+ s1.courseCodeSTC + ", " + s1.rollNoSTC);
allStudentTakeCourses.Add(s1);
}
cmd.Connection.Close();
}
catch (Exception e)
{
cmd.Connection.Close();
Console.WriteLine("Getting all studentTakeCourses error");
// Console.WriteLine(e.ToString());
return(null);
}
// Console.WriteLine("StudentTakeCourses returned");
return(allStudentTakeCourses);
}