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); }