public static List <CurrentSemester> GetCurrentSemesterStudents(string Faculty, string Session, int Semester) { int batchId = Convert.ToInt32(Session.Substring(2, 2)); //startIndex, Length int startRange = batchId * 100000; int endRange = ((batchId + 1) * 100000) - 1; List <CurrentSemester> AllStudents = new List <CurrentSemester>(); SqlConnection con = new SqlConnectionGenerator().FromFaculty(Faculty); con.Open(); SqlCommand cmd = new SqlCommand("SELECT * FROM CurrentSemester WHERE StudentId BETWEEN " + startRange + " AND " + endRange + " AND Semester=" + Semester + ";", con); using (SqlDataReader reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { CurrentSemester CS = new CurrentSemester(); CS.StudentId = Convert.ToInt32(reader.GetValue(1)); CS.Semester = Convert.ToInt32(reader.GetValue(2)); AllStudents.Add(CS); } reader.Close(); } else { return(null); } } con.Close(); return(AllStudents); }
public Boolean InsertEnrollment(IDictionary <string, object> dict) { CurrentSemester currentSemester = CheckIsudentIsPresentOrNot(dict); if (currentSemester == null) { InsertCurrentSemester(dict); String sql = ""; if (Convert.ToInt32(dict["Semester"]) % 2 == 0) { sql = "Insert Into JulEnrollment ("; } else { sql = "Insert Into JanEnrollment ("; } String value = " VALUES ("; foreach (KeyValuePair <string, object> item in dict) { sql += item.Key + ", "; value += "'" + item.Value + "' , "; } sql = sql.Substring(0, sql.Length - 2); value = value.Substring(0, value.Length - 2); sql = sql + ") " + value + ")"; SqlCommand myCommand = new SqlCommand(sql, myConn); try { myConn.Open(); myCommand.ExecuteNonQuery(); } catch (System.Exception ex) { return(false); } finally { if (myConn.State == ConnectionState.Open) { myConn.Close(); } } } else { UpdateEnrollment(dict); } return(true); }
private CurrentSemester CheckIsudentIsPresentOrNot(IDictionary <string, object> dict) { CurrentSemester currentSemester = new CurrentSemester(); String str; str = "SELECT * FROM CurrentSemester WHERE StudentId ='" + dict["StudentId"] + "'"; SqlCommand myCommand = new SqlCommand(str, myConn); try { myConn.Open(); SqlDataReader oReader = myCommand.ExecuteReader(); if (oReader.Read()) { currentSemester.StudentId = Convert.ToInt32(oReader["StudentId"]); currentSemester.Semester = Convert.ToInt32(oReader["Semester"]); } else { currentSemester = null; } } catch (System.Exception ex) { return(currentSemester); } finally { if (myConn.State == ConnectionState.Open) { myConn.Close(); } } return(currentSemester); }