public List <CourseLeader> GetList(InitializeModule.EnumCampus Campus, string sCondition, bool isDeafaultIncluded) { Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus); string sSQL = GetListSQL(sCondition); SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString()); SqlCommand Cmd = new SqlCommand(sSQL, Conn); Conn.Open(); SqlDataReader reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection); List <CourseLeader> results = new List <CourseLeader>(); try { //Default Value CourseLeader myCourseLeader = new CourseLeader(); if (isDeafaultIncluded) { //Change the code here myCourseLeader.AcademicYear = -1; myCourseLeader.SemesterID = -1; myCourseLeader.CourseID = "Select Course"; results.Add(myCourseLeader); } while (reader.Read()) { myCourseLeader = new CourseLeader(); if (reader[LibraryMOD.GetFieldName(AcademicYearFN)].Equals(DBNull.Value)) { myCourseLeader.AcademicYear = 0; } else { myCourseLeader.AcademicYear = int.Parse(reader[LibraryMOD.GetFieldName(AcademicYearFN)].ToString()); } if (reader[LibraryMOD.GetFieldName(SemesterIDFN)].Equals(DBNull.Value)) { myCourseLeader.SemesterID = 0; } else { myCourseLeader.SemesterID = int.Parse(reader[LibraryMOD.GetFieldName(SemesterIDFN)].ToString()); } myCourseLeader.CourseID = reader[LibraryMOD.GetFieldName(CourseIDFN)].ToString(); results.Add(myCourseLeader); } } catch (Exception ex) { LibraryMOD.ShowErrorMessage(ex); } finally { reader.Close(); reader.Dispose(); Conn.Close(); Conn.Dispose(); } return(results); }
public int UpdateCourseLeader(InitializeModule.EnumCampus Campus, int iMode, int AcademicYear, int SemesterID, string CourseID, int CourseLeaderID, int CreationUserID, DateTime CreationDate, int LastUpdateUserID, DateTime LastUpdateDate, string PCName, string NetUserName, string TemplateCourse, int MoodleCourseNo) { int iEffected = 0; Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus); SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString()); try { Conn.Open(); string sql = ""; CourseLeader theCourseLeader = new CourseLeader(); //'Updates the table switch (iMode) { case (int)ECTGlobalDll.InitializeModule.enumModes.EditMode: sql = GetUpdateCommand(); break; case (int)ECTGlobalDll.InitializeModule.enumModes.NewMode: sql = GetInsertCommand(); break; } SqlCommand Cmd = new SqlCommand(sql, Conn); Cmd.Parameters.Add(new SqlParameter("@AcademicYear", AcademicYear)); Cmd.Parameters.Add(new SqlParameter("@SemesterID", SemesterID)); Cmd.Parameters.Add(new SqlParameter("@CourseID", CourseID)); Cmd.Parameters.Add(new SqlParameter("@CourseLeaderID", CourseLeaderID)); Cmd.Parameters.Add(new SqlParameter("@CreationUserID", CreationUserID)); Cmd.Parameters.Add(new SqlParameter("@CreationDate", CreationDate)); Cmd.Parameters.Add(new SqlParameter("@LastUpdateUserID", LastUpdateUserID)); Cmd.Parameters.Add(new SqlParameter("@LastUpdateDate", LastUpdateDate)); Cmd.Parameters.Add(new SqlParameter("@PCName", PCName)); Cmd.Parameters.Add(new SqlParameter("@NetUserName", NetUserName)); Cmd.Parameters.Add(new SqlParameter("@TemplateCourse", TemplateCourse)); Cmd.Parameters.Add(new SqlParameter("@MoodleCourseNo", MoodleCourseNo)); iEffected = Cmd.ExecuteNonQuery(); } catch (Exception ex) { LibraryMOD.ShowErrorMessage(ex); } finally { Conn.Close(); Conn.Dispose(); } return(iEffected); }
public List <CourseLeader> GetCourseLeader(InitializeModule.EnumCampus Campus, string sCondition, bool isDeafaultIncluded) { //' returns a list of Classes instances based on the //' data in the CourseLeader Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus); string sSQL = GetSQL(); if (!string.IsNullOrEmpty(sCondition)) { sSQL += sCondition; } SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString()); SqlCommand Cmd = new SqlCommand(sSQL, Conn); Conn.Open(); SqlDataReader reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection); List <CourseLeader> results = new List <CourseLeader>(); try { //Default Value CourseLeader myCourseLeader = new CourseLeader(); if (isDeafaultIncluded) { //Change the code here myCourseLeader.AcademicYear = 0; myCourseLeader.SemesterID = 0; myCourseLeader.CourseID = ""; myCourseLeader.CourseID = "Select CourseLeader ..."; results.Add(myCourseLeader); } while (reader.Read()) { myCourseLeader = new CourseLeader(); if (reader[LibraryMOD.GetFieldName(AcademicYearFN)].Equals(DBNull.Value)) { myCourseLeader.AcademicYear = 0; } else { myCourseLeader.AcademicYear = int.Parse(reader[LibraryMOD.GetFieldName(AcademicYearFN)].ToString()); } if (reader[LibraryMOD.GetFieldName(SemesterIDFN)].Equals(DBNull.Value)) { myCourseLeader.SemesterID = 0; } else { myCourseLeader.SemesterID = int.Parse(reader[LibraryMOD.GetFieldName(SemesterIDFN)].ToString()); } myCourseLeader.CourseID = reader[LibraryMOD.GetFieldName(CourseIDFN)].ToString(); if (reader[LibraryMOD.GetFieldName(CourseLeaderIDFN)].Equals(DBNull.Value)) { myCourseLeader.CourseLeaderID = 0; } else { myCourseLeader.CourseLeaderID = int.Parse(reader[LibraryMOD.GetFieldName(CourseLeaderIDFN)].ToString()); } if (reader[LibraryMOD.GetFieldName(CreationUserIDFN)].Equals(DBNull.Value)) { myCourseLeader.CreationUserID = 0; } else { myCourseLeader.CreationUserID = int.Parse(reader[LibraryMOD.GetFieldName(CreationUserIDFN)].ToString()); } if (!reader[LibraryMOD.GetFieldName(CreationDateFN)].Equals(DBNull.Value)) { myCourseLeader.CreationDate = DateTime.Parse(reader[LibraryMOD.GetFieldName(CreationDateFN)].ToString()); } if (reader[LibraryMOD.GetFieldName(LastUpdateUserIDFN)].Equals(DBNull.Value)) { myCourseLeader.LastUpdateUserID = 0; } else { myCourseLeader.LastUpdateUserID = int.Parse(reader[LibraryMOD.GetFieldName(LastUpdateUserIDFN)].ToString()); } if (!reader[LibraryMOD.GetFieldName(LastUpdateDateFN)].Equals(DBNull.Value)) { myCourseLeader.LastUpdateDate = DateTime.Parse(reader[LibraryMOD.GetFieldName(LastUpdateDateFN)].ToString()); } myCourseLeader.PCName = reader[LibraryMOD.GetFieldName(PCNameFN)].ToString(); myCourseLeader.NetUserName = reader[LibraryMOD.GetFieldName(NetUserNameFN)].ToString(); myCourseLeader.TemplateCourse = reader[LibraryMOD.GetFieldName(TemplateCourseFN)].ToString(); if (reader[LibraryMOD.GetFieldName(MoodleCourseNoFN)].Equals(DBNull.Value)) { myCourseLeader.MoodleCourseNo = 0; } else { myCourseLeader.MoodleCourseNo = int.Parse(reader[LibraryMOD.GetFieldName(MoodleCourseNoFN)].ToString()); } results.Add(myCourseLeader); } } catch (Exception ex) { LibraryMOD.ShowErrorMessage(ex); } finally { reader.Close(); reader.Dispose(); Conn.Close(); Conn.Dispose(); } return(results); }