public static List <MissingStudent> GetAllStudents(string query)
{
Files.dbConnection con = new Files.dbConnection();
//List<Student> studentCollection = new List<Student>(100000);
List <MissingStudent> studentCollection = new List <MissingStudent>();
//var model = null;
DataTable tempTable = null;
string sclearsql = string.Concat(@"[dbo].[sp_getMissingStudents]");
//tempTable = con.executeSelectNoParameter(sclearsql);
SqlParameter[] parameter =
{
new SqlParameter("@query", SqlDbType.VarChar)
{
Value = query
}
};
tempTable = con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTable == null) || (tempTable.Rows.Count == 0))
{
}
else
{
foreach (DataRow dr in tempTable.Rows)
{
MissingStudent st = new MissingStudent();
st.crn = dr["crn"].ToString();
st.termCode = dr["termCode"].ToString();
st.heatId = dr["heatId"].ToString();
st.bannerId = dr["bannerId"].ToString();
st.login = dr["login"].ToString();
st.studentName = dr["studentName"].ToString();
st.ticketRefNumber = dr["ticketRefNumber"].ToString();
st.mobilePersonal = dr["mobilePersonal"].ToString();
//string mag = dr["Magcode"].ToString();
st.Magcode = dr["Magcode"].ToString();
//st.image = "http://latasha.com.au/wp-content/uploads/online-profile-picture-45x45.jpg";
if (dr["Magcode"].ToString() == "")
{
st.image = @"\\SMSODBPWV01\photos$\PROD\" + "NoImage" + ".jpg";
}
else
{
st.image = @"\\SMSODBPWV01\photos$\PROD\" + dr["bannerId"].ToString() + ".jpg";
}
//st.image = @"\\SMSODBPWV01\photos$\PROD\"+ dr["bannerId"].ToString() +".jpg";
st.checkBox = false;
studentCollection.Add(st);
}
}
//return model;
return(studentCollection);
}
public static List <MissingStudent> GetAllStudents(string query)
{
Files.dbConnection con = new Files.dbConnection();
List <MissingStudent> studentCollection = new List <MissingStudent>();
#region SQL
DataTable tempTable = null;
string sclearsql = string.Concat(@"[dbo].[sp_getMissingStudentsDemo]");
SqlParameter[] parameter =
{
new SqlParameter("@query", SqlDbType.VarChar)
{
Value = query
}
};
tempTable = con.executeSelectQueryWithSP(sclearsql, parameter);
if ((tempTable == null) || (tempTable.Rows.Count == 0))
{
}
else
{
foreach (DataRow dr in tempTable.Rows)
{
MissingStudent st = new MissingStudent();
st.crn = dr["crn"].ToString();
st.termCode = dr["termCode"].ToString();
st.heatId = dr["heatId"].ToString();
st.bannerId = dr["bannerId"].ToString();
st.login = dr["login"].ToString();
st.studentName = dr["studentName"].ToString();
st.ticketRefNumber = dr["ticketRefNumber"].ToString();
st.mobilePersonal = dr["mobilePersonal"].ToString();
//string mag = dr["Magcode"].ToString();
st.Magcode = dr["Magcode"].ToString();
//st.image = "http://latasha.com.au/wp-content/uploads/online-profile-picture-45x45.jpg";
if (dr["Magcode"].ToString() == "")
{
st.image = @"\\SMSODBPWV01\photos$\PROD\" + "NoImage" + ".jpg";
//st.image = @"\\webapp01d-doc\sam\11Data\NoImage1.jpg";
}
else
{
st.image = @"\\SMSODBPWV01\photos$\PROD\" + dr["bannerId"].ToString() + ".jpg";
}
//st.image = @"\\SMSODBPWV01\photos$\PROD\"+ dr["bannerId"].ToString() +".jpg";
st.checkBox = false;
//st.Tick1= @"\\webapp01d-doc\C$\inetpub\wwwroot\SAM\11Data\Tick1Copy.jpg";
st.Tick1 = "//webapp01d-doc/sam/11Data/Tick1Copy.jpg";
studentCollection.Add(st);
}
}
#endregion
#region Oracle
//OracleConnection OrCon = new OracleConnection(oradb);
//OracleCommand cmd = new OracleCommand();
//cmd.CommandText = "select sirasgn_crn,sirasgn_term_code from sirasgn where sirasgn_pidm=" + pidm;
//cmd.Connection = OrCon;
//OrCon.Open();
//
//OracleDataReader dr = cmd.ExecuteReader();
//if (dr.HasRows)
//{
// while (dr.Read())
// {
// //AttendanceCrnTerm list = new AttendanceCrnTerm();
// //list.crn = dr["sirasgn_crn"].ToString();
// //list.termCode = dr["sirasgn_term_code"].ToString();
// //crnTermColl.Add(list);
// }
//}
//
//OrCon.Close();
// OrCon.Dispose();
#endregion
//return model;
return(studentCollection);
}