protected void drp_Course_SelectedIndexChanged(object sender, EventArgs e)
{
if (drp_Course.SelectedItem.Value != "---Select a Course---")
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(Convert.ToInt32(drp_Semester.SelectedItem.Value), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyCourseId(studentid, connstr.Conn_string, iYear, iSem, drp_Course.SelectedItem.Value);
if (dt.Rows.Count > 0)
{
lbl_CourseCode.Text = drp_Course.SelectedItem.Value;
lbl_Instructor.Text = dt.Rows[0]["strLecturerDescEn"].ToString();
}
}
else
{
lbl_CourseCode.Text = "";
lbl_Instructor.Text = "";
}
}
public void getsemesters()
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetSemestersbyTerm(iYear, iSem);
if (dt.Rows.Count > 0)
{
drp_Semester.DataSource = dt;
drp_Semester.DataTextField = "LongDesc";
drp_Semester.DataValueField = "Term";
drp_Semester.DataBind();
drp_Semester.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Semester---", "---Select a Semester---"));
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
else
{
drp_Semester.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Semester---", "---Select a Semester---"));
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
}
public void getcourses(int term)
{
var services = new DAL.DAL();
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(term, out sem);
int iYear = Year;
int iSem = sem;
string studentid = Session["CurrentStudent"].ToString();
DataTable dt = services.GetCoursesbyStudentId(studentid, connstr.Conn_string, iYear, iSem);
if (dt.Rows.Count > 0)
{
drp_Course.DataSource = dt;
drp_Course.DataTextField = "Course";
drp_Course.DataValueField = "Code";
drp_Course.DataBind();
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
else
{
drp_Course.Items.Insert(0, new System.Web.UI.WebControls.ListItem("---Select a Course---", "---Select a Course---"));
}
}
public int DeleteCourseLeader(InitializeModule.EnumCampus Campus, string AcademicYear, string SemesterID, string CourseID)
{
int iEffected = 0;
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
try
{
string sSQL = GetDeleteCommand();
//sSQL += sCondition;
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Cmd.Parameters.Add(new SqlParameter("@AcademicYear", AcademicYear));
Cmd.Parameters.Add(new SqlParameter("@SemesterID", SemesterID));
Cmd.Parameters.Add(new SqlParameter("@CourseID", CourseID));
Conn.Open();
iEffected = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
public static bool SetOpportunity(string sSID)
{
bool isSet = false;
//U cannot use var from out of the scope. (Campus)
InitializeModule.EnumCampus campus = InitializeModule.EnumCampus.Males;
if (sSID.Contains("AF") || sSID.Contains("ESF"))
{
campus = InitializeModule.EnumCampus.Females;
}
Connection_StringCLS myConnection_String = new Connection_StringCLS(campus);
SqlConnection Conn = new SqlConnection(myConnection_String.Conn_string);
Conn.Open();
try
{
string sSQL = "UPDATE Reg_Applications SET isOpportunitySet=1";
sSQL += " WHERE (lngStudentNumber = '" + sSID + "')";
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
isSet = (Cmd.ExecuteNonQuery() > 0);
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
//divMsg.InnerText = ex.Message;
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(isSet);
}
//-----Get GetUpdateCommand Function -----------------------
public string GetUpdateCommand()
{
string sSQL = "";
try
{
sSQL = "UPDATE " + TableName;
sSQL += " SET ";
sSQL += LibraryMOD.GetFieldName(AcademicYearFN) + "=@AcademicYear";
sSQL += " , " + LibraryMOD.GetFieldName(SemesterIDFN) + "=@SemesterID";
sSQL += " , " + LibraryMOD.GetFieldName(CourseIDFN) + "=@CourseID";
sSQL += " , " + LibraryMOD.GetFieldName(CourseLeaderIDFN) + "=@CourseLeaderID";
sSQL += " , " + LibraryMOD.GetFieldName(CreationUserIDFN) + "=@CreationUserID";
sSQL += " , " + LibraryMOD.GetFieldName(CreationDateFN) + "=@CreationDate";
sSQL += " , " + LibraryMOD.GetFieldName(LastUpdateUserIDFN) + "=@LastUpdateUserID";
sSQL += " , " + LibraryMOD.GetFieldName(LastUpdateDateFN) + "=@LastUpdateDate";
sSQL += " , " + LibraryMOD.GetFieldName(PCNameFN) + "=@PCName";
sSQL += " , " + LibraryMOD.GetFieldName(NetUserNameFN) + "=@NetUserName";
sSQL += " , " + LibraryMOD.GetFieldName(TemplateCourseFN) + "=@TemplateCourse";
sSQL += " , " + LibraryMOD.GetFieldName(MoodleCourseNoFN) + "=@MoodleCourseNo";
sSQL += " WHERE ";
sSQL += LibraryMOD.GetFieldName(AcademicYearFN) + "=@AcademicYear";
sSQL += " And " + LibraryMOD.GetFieldName(SemesterIDFN) + "=@SemesterID";
sSQL += " And " + LibraryMOD.GetFieldName(CourseIDFN) + "=@CourseID";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
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);
}
//-----Get GetSelectCommand Function -----------------------
public string GetSelectCommand()
{
string sSQL = "";
try
{
sSQL = "SELECT ";
sSQL += AcademicYearFN;
sSQL += " , " + SemesterIDFN;
sSQL += " , " + CourseIDFN;
sSQL += " , " + CourseLeaderIDFN;
sSQL += " , " + CreationUserIDFN;
sSQL += " , " + CreationDateFN;
sSQL += " , " + LastUpdateUserIDFN;
sSQL += " , " + LastUpdateDateFN;
sSQL += " , " + PCNameFN;
sSQL += " , " + NetUserNameFN;
sSQL += " , " + TemplateCourseFN;
sSQL += " , " + MoodleCourseNoFN;
sSQL += " FROM " + m_TableName;
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//-----GetListSQl Function ---------------------------------
public string GetListSQL(string sCondition)
{
string sSQL = "";
try
{
sSQL = "SELECT ";
sSQL += AcademicYearFN;
sSQL += " , " + SemesterIDFN;
sSQL += " , " + CourseIDFN;
sSQL += " FROM " + m_TableName;
sSQL += " WHERE 1=1";
if (sCondition != "")
{
sSQL += sCondition;
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//================End Properties ===================
public CourseLeaderDAL()
{
try
{
this.TableName = "Reg_CourseLeader";
this.AcademicYearFN = m_TableName + ".AcademicYear";
this.SemesterIDFN = m_TableName + ".SemesterID";
this.CourseIDFN = m_TableName + ".CourseID";
this.CourseLeaderIDFN = m_TableName + ".CourseLeaderID";
this.CreationUserIDFN = m_TableName + ".CreationUserID";
this.CreationDateFN = m_TableName + ".CreationDate";
this.LastUpdateUserIDFN = m_TableName + ".LastUpdateUserID";
this.LastUpdateDateFN = m_TableName + ".LastUpdateDate";
this.PCNameFN = m_TableName + ".PCName";
this.NetUserNameFN = m_TableName + ".NetUserName";
this.TemplateCourseFN = m_TableName + ".TemplateCourse";
this.MoodleCourseNoFN = m_TableName + ".MoodleCourseNo";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
lbl_CurrentMajor.Text = dtStudentServices.Rows[0]["strCaption"].ToString();
SqlConnection sc = new SqlConnection(connstr.Conn_string);
SqlCommand cmd = new SqlCommand("SELECT Course_Balance_View_BothSides.iYear, Course_Balance_View_BothSides.Sem, Course_Balance_View_BothSides.Shift, Course_Balance_View_BothSides.Course, Course_Balance_View_BothSides.Class, Course_Balance_View_BothSides.Student, Course_Balance_View_BothSides.FactorBalance, Course_Balance_View_BothSides.IsIncluded_AtRisk, Reg_Courses.IsInternshipCourse FROM Course_Balance_View_BothSides INNER JOIN Reg_Courses ON Course_Balance_View_BothSides.Course = Reg_Courses.strCourse WHERE (Reg_Courses.IsInternshipCourse = 1) AND (Course_Balance_View_BothSides.iYear = " + iYear + ") AND (Course_Balance_View_BothSides.Sem = " + iSem + ") AND (Course_Balance_View_BothSides.Student = N'" + studentid + "')", sc);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
if (dt.Rows.Count > 0)
{
//Continue
}
else
{
div_Alert.Attributes["class"] = "alert alert-danger alert-dismissible ";
lbl_Msg.Text = "You are not allowed to generate this request (Only for students registered internship courses).";
lbl_Msg.Visible = true;
div_msg.Visible = true;
lnk_Generate.Enabled = false;
}
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
}
//-----Get GetInsertCommand Function -----------------------
public string GetInsertCommand()
{
string sSQL = "";
try
{
sSQL = "INSERT intO " + TableName;
sSQL += "( ";
sSQL += LibraryMOD.GetFieldName(iEntryFN);
sSQL += " , " + LibraryMOD.GetFieldName(strProgramFN);
sSQL += " , " + LibraryMOD.GetFieldName(iAdvisorFN);
sSQL += " , " + LibraryMOD.GetFieldName(byteCategoryFN);
sSQL += " , " + LibraryMOD.GetFieldName(isWeekendFN);
sSQL += ")";
sSQL += " VALUES ";
sSQL += "( ";
sSQL += " @iEntry";
sSQL += " ,@strProgram";
sSQL += " ,@iAdvisor";
sSQL += " ,@byteCategory";
sSQL += " ,@isWeekend";
sSQL += ") ";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
public void getdetails()
{
Connection_StringCLS connstr = new Connection_StringCLS(Campus);
int sem = 0;
int Year = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out sem);
int iYear = Year;
int iSem = sem;
string sSemester = LibraryMOD.GetSemesterString(iSem);
lbl_AcademicYear.Text = iYear.ToString();
lbl_Semester.Text = sSemester.ToString();
string studentid = Session["CurrentStudent"].ToString();
var services = new DAL.DAL();
DataTable dtStudentServices = services.GetStudentDetailsID(studentid, connstr.Conn_string);
if (dtStudentServices.Rows.Count > 0)
{
lbl_StudentName.Text = dtStudentServices.Rows[0]["strLastDescEn"].ToString();
lbl_StudentID.Text = dtStudentServices.Rows[0]["lngStudentNumber"].ToString();
lbl_StudentContact.Text = dtStudentServices.Rows[0]["Phone"].ToString();
lbl_StudentEmail.Text = dtStudentServices.Rows[0]["sECTemail"].ToString();
hdf_StudentEmail.Value = dtStudentServices.Rows[0]["sECTemail"].ToString();
}
}
//-----Get GetUpdateCommand Function -----------------------
public string GetUpdateCommand()
{
string sSQL = "";
try
{
sSQL = "UPDATE " + TableName;
sSQL += " SET ";
sSQL += LibraryMOD.GetFieldName(ObjectIDFN) + "=@ObjectID";
sSQL += " , " + LibraryMOD.GetFieldName(ObjectNameArFN) + "=@ObjectNameAr";
sSQL += " , " + LibraryMOD.GetFieldName(ObjectNameEnFN) + "=@ObjectNameEn";
sSQL += " , " + LibraryMOD.GetFieldName(DisplayObjectNameFN) + "=@DisplayObjectName";
sSQL += " , " + LibraryMOD.GetFieldName(ShowOrderFN) + "=@ShowOrder";
sSQL += " , " + LibraryMOD.GetFieldName(SystemIDFN) + "=@SystemID";
sSQL += " , " + LibraryMOD.GetFieldName(ParentIDFN) + "=@ParentID";
sSQL += " , " + LibraryMOD.GetFieldName(sURLFN) + "=@sURL";
sSQL += " , " + LibraryMOD.GetFieldName(iLevelFN) + "=@iLevel";
sSQL += " WHERE ";
sSQL += LibraryMOD.GetFieldName(ObjectIDFN) + "=@ObjectID";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
public int DeletePrivilegeObjects(InitializeModule.EnumCampus Campus, int ObjectID)
{
int iEffected = 0;
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
try
{
string sSQL = GetDeleteCommand();
//sSQL += sCondition;
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Cmd.Parameters.Add(new SqlParameter("@ObjectID", ObjectID));
Conn.Open();
iEffected = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
//-----Get GetInsertCommand Function -----------------------
public string GetInsertCommand()
{
string sSQL = "";
try
{
sSQL = "INSERT intO " + TableName;
sSQL += "( ";
sSQL += LibraryMOD.GetFieldName(PrivilegeIDFN);
sSQL += " , " + LibraryMOD.GetFieldName(PrivilegeNameArFN);
sSQL += " , " + LibraryMOD.GetFieldName(PriviligeNameEnFN);
sSQL += " , " + LibraryMOD.GetFieldName(DefaultEffectFN);
sSQL += ")";
sSQL += " VALUES ";
sSQL += "( ";
sSQL += " @PrivilegeID";
sSQL += " ,@PrivilegeNameAr";
sSQL += " ,@PriviligeNameEn";
sSQL += " ,@DefaultEffect";
sSQL += ") ";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//-----Get GetUpdateCommand Function -----------------------
public string GetUpdateCommand()
{
string sSQL = "";
try
{
sSQL = "UPDATE " + TableName;
sSQL += " SET ";
sSQL += LibraryMOD.GetFieldName(iEntryFN) + "=@iEntry";
sSQL += " , " + LibraryMOD.GetFieldName(strProgramFN) + "=@strProgram";
sSQL += " , " + LibraryMOD.GetFieldName(iAdvisorFN) + "=@iAdvisor";
sSQL += " , " + LibraryMOD.GetFieldName(byteCategoryFN) + "=@byteCategory";
sSQL += " , " + LibraryMOD.GetFieldName(isWeekendFN) + "=@isWeekend";
sSQL += " WHERE ";
sSQL += LibraryMOD.GetFieldName(iEntryFN) + "=@iEntry";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//-----Get GetInsertCommand Function -----------------------
public string GetInsertCommand()
{
string sSQL = "";
try
{
sSQL = "INSERT intO " + TableName;
sSQL += "( ";
sSQL += LibraryMOD.GetFieldName(intStudyYearFN);
sSQL += " , " + LibraryMOD.GetFieldName(byteSemesterFN);
sSQL += " , " + LibraryMOD.GetFieldName(byteShiftFN);
sSQL += " , " + LibraryMOD.GetFieldName(strCourseFN);
sSQL += " , " + LibraryMOD.GetFieldName(lngStudentNumberFN);
sSQL += " , " + LibraryMOD.GetFieldName(bytOrderFN);
sSQL += ")";
sSQL += " VALUES ";
sSQL += "( ";
sSQL += " @intStudyYear";
sSQL += " ,@byteSemester";
sSQL += " ,@byteShift";
sSQL += " ,@strCourse";
sSQL += " ,@lngStudentNumber";
sSQL += " ,@bytOrder";
sSQL += ") ";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//'-------DeleteRow -----------------------------
public int DeleteRow()
{
//DeleteRow= InitializeModule.FAIL_RET;
try
{
FindInMultiPKey(lngStudentNumber);
if ((RecommendationDataRow != null))
{
RecommendationDataRow.Delete();
CommitRecommendation();
if (MoveNext() == InitializeModule.FAIL_RET)
{
return(InitializeModule.FAIL_RET);
}
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(InitializeModule.SUCCESS_RET);
}
//-----Get GetUpdateCommand Function -----------------------
public string GetUpdateCommand()
{
string sSQL = "";
try
{
sSQL = "UPDATE " + TableName;
sSQL += " SET ";
sSQL += LibraryMOD.GetFieldName(intStudyYearFN) + "=@intStudyYear";
sSQL += " , " + LibraryMOD.GetFieldName(byteSemesterFN) + "=@byteSemester";
sSQL += " , " + LibraryMOD.GetFieldName(byteShiftFN) + "=@byteShift";
sSQL += " , " + LibraryMOD.GetFieldName(strCourseFN) + "=@strCourse";
sSQL += " , " + LibraryMOD.GetFieldName(lngStudentNumberFN) + "=@lngStudentNumber";
sSQL += " , " + LibraryMOD.GetFieldName(bytOrderFN) + "=@bytOrder";
sSQL += " WHERE ";
sSQL += LibraryMOD.GetFieldName(lngStudentNumberFN) + "=@lngStudentNumber";
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//'-------FindInMultiPKey -----------------------------
public int FindInMultiPKey(string PKlngStudentNumber)
{
//FindInMultiPKey= InitializeModule.FAIL_RET;
try
{
//' Create an array for the key values to find.
object[] findTheseVals = new object[1];
//' Set the values of the keys to find.
findTheseVals[0] = PKlngStudentNumber;
RecommendationDataRow = dsRecommendation.Tables[TableName].Rows.Find(findTheseVals);
if ((RecommendationDataRow != null))
{
lngCurRow = dsRecommendation.Tables[TableName].Rows.IndexOf(RecommendationDataRow);
SynchronizeDataRowToClass();
return(InitializeModule.SUCCESS_RET);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(InitializeModule.FAIL_RET);
}
//'-------FindInMultiPKey -----------------------------
public int FindInMultiPKey(int PKAcademicYear, int PKSemesterID, string PKCourseID)
{
//FindInMultiPKey= ECTGlobalDll.InitializeModule.FAIL_RET;
try
{
//' Create an array for the key values to find.
object[] findTheseVals = new object[1];
//' Set the values of the keys to find.
findTheseVals[0] = PKAcademicYear;
findTheseVals[1] = PKSemesterID;
findTheseVals[2] = PKCourseID;
CourseLeaderDataRow = dsCourseLeader.Tables[TableName].Rows.Find(findTheseVals);
if ((CourseLeaderDataRow != null))
{
lngCurRow = dsCourseLeader.Tables[TableName].Rows.IndexOf(CourseLeaderDataRow);
SynchronizeDataRowToClass();
return(ECTGlobalDll.InitializeModule.SUCCESS_RET);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(ECTGlobalDll.InitializeModule.FAIL_RET);
}
//-------Get DataAdapter -----------------------------
#region "DataAdapter"
public virtual SqlDataAdapter GetPrivilegeObjectsDataAdapter(string sCondition, SqlConnection con)
{
string sSQL = "";
try
{
sSQL = GetSQL();
sSQL += " " + sCondition;
//-----------------------------------------
daPrivilegeObjects = new SqlDataAdapter(sSQL, con);
// Create command builder. This line automatically generates the update commands for you, so you don't
// have to provide or create your own.
SqlCommandBuilder myDataRowsCommandBuilder = new SqlCommandBuilder(daPrivilegeObjects);
//Set the MissingSchemaAction property to AddWithKey because Fill will not cause primary
// key + unique key information to be retrieved unless AddWithKey is specified.
daPrivilegeObjects.MissingSchemaAction = MissingSchemaAction.AddWithKey;
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(daPrivilegeObjects);
}
//-----Get GetSelectCommand Function -----------------------
public string GetSelectCommand()
{
string sSQL = "";
try
{
sSQL = "SELECT ";
sSQL += ObjectIDFN;
sSQL += " , " + ObjectNameArFN;
sSQL += " , " + ObjectNameEnFN;
sSQL += " , " + DisplayObjectNameFN;
sSQL += " , " + ShowOrderFN;
sSQL += " , " + SystemIDFN;
sSQL += " , " + ParentIDFN;
sSQL += " , " + sURLFN;
sSQL += " , " + iLevelFN;
sSQL += " FROM " + m_TableName;
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(sSQL);
}
//'-------DeleteRow -----------------------------
public int DeleteRow()
{
//DeleteRow= ECTGlobalDll.InitializeModule.FAIL_RET;
try
{
FindInMultiPKey(AcademicYear, SemesterID, CourseID);
if ((CourseLeaderDataRow != null))
{
CourseLeaderDataRow.Delete();
CommitCourseLeader();
if (MoveNext() == ECTGlobalDll.InitializeModule.FAIL_RET)
{
return(ECTGlobalDll.InitializeModule.FAIL_RET);
}
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(ECTGlobalDll.InitializeModule.SUCCESS_RET);
}
public void bindmyattendancewrnigns()
{
int iCSem = 0;
int iCYear = LibraryMOD.SeperateTerm(LibraryMOD.GetCurrentTerm(), out iCSem);
Connection_StringCLS myConnection_String = new Connection_StringCLS(Campus);
SqlConnection sc = new SqlConnection(myConnection_String.Conn_string);
//SqlCommand cmd = new SqlCommand("SELECT [strCourse],max([byteWarningType]) as max FROM [ECTData].[dbo].[Reg_Students_Warning] where intStudyYear=@intStudyYear and byteSemester=@byteSemester and lngStudentNumber=@lngStudentNumber GROUP BY [strCourse] order by strCourse", sc);
SqlCommand cmd = new SqlCommand("SELECT iYear, Sem, Student, Course, Warning FROM Warning_Both_Side WHERE (iYear = @intStudyYear) AND (Sem = @byteSemester) AND (Student=@lngStudentNumber) order by course asc", sc);
cmd.Parameters.AddWithValue("@intStudyYear", iCYear);
cmd.Parameters.AddWithValue("@byteSemester", iCSem);
cmd.Parameters.AddWithValue("@lngStudentNumber", Session["CurrentStudent"].ToString());//BAM1906016 Session["CurrentStudent"].ToString()
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
try
{
sc.Open();
da.Fill(dt);
sc.Close();
Repeater1.DataSource = dt;
Repeater1.DataBind();
}
catch (Exception ex)
{
sc.Close();
Console.WriteLine(ex.Message);
}
finally
{
sc.Close();
}
}
//'-------DeleteRow -----------------------------
public int DeleteRow()
{
//DeleteRow= InitializeModule.FAIL_RET;
try
{
FindInMultiPKey(ObjectID);
if ((PrivilegeObjectsDataRow != null))
{
PrivilegeObjectsDataRow.Delete();
CommitPrivilegeObjects();
if (MoveNext() == InitializeModule.FAIL_RET)
{
return(InitializeModule.FAIL_RET);
}
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(InitializeModule.SUCCESS_RET);
}
//'-------FindInMultiPKey -----------------------------
public int FindInMultiPKey(int PKObjectID)
{
//FindInMultiPKey= InitializeModule.FAIL_RET;
try
{
//' Create an array for the key values to find.
object[] findTheseVals = new object[1];
//' Set the values of the keys to find.
findTheseVals[0] = PKObjectID;
PrivilegeObjectsDataRow = dsPrivilegeObjects.Tables[TableName].Rows.Find(findTheseVals);
if ((PrivilegeObjectsDataRow != null))
{
lngCurRow = dsPrivilegeObjects.Tables[TableName].Rows.IndexOf(PrivilegeObjectsDataRow);
SynchronizeDataRowToClass();
return(InitializeModule.SUCCESS_RET);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(InitializeModule.FAIL_RET);
}
public static bool IsFndCourseRequired(InitializeModule.EnumCampus Campus, string StudentID, string sFndCourse, string sRequirment, int iScoreofFndCourse, decimal dFoundationCourseMinScore)
{
bool isRequired = false;
try
{
switch (sRequirment)
{
case "HS":
if (iScoreofFndCourse < dFoundationCourseMinScore)
{
isRequired = true;
}
break;
case "Remedial":
if (!isFndCoursePassed(Campus, StudentID, sFndCourse))
{
isRequired = true;
}
break;
case "HS and Remedial":
if (iScoreofFndCourse < dFoundationCourseMinScore || !isFndCoursePassed(Campus, StudentID, sFndCourse))
{
isRequired = true;
}
break;
case "HS or Remedial":
if (iScoreofFndCourse < dFoundationCourseMinScore && !isFndCoursePassed(Campus, StudentID, sFndCourse))
{
isRequired = true;
}
break;
case "Graduation":
//allow to change major from ESL to academic program, can register remedial + major courses
isRequired = false;
break;
case "None":
isRequired = false;
break;
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
isRequired = true;
}
finally
{
}
return(isRequired);
}
//'-------SaveData -----------------------------
public int SaveData(int lFormMode)
{
//SaveData= InitializeModule.FAIL_RET;
try
{
switch (lFormMode)
{
case (int)InitializeModule.enumModes.NewMode:
DataRow dr = default(DataRow);
dr = dsPrivilegeObjects.Tables[TableName].NewRow();
dr[LibraryMOD.GetFieldName(ObjectIDFN)] = ObjectID;
dr[LibraryMOD.GetFieldName(ObjectNameArFN)] = ObjectNameAr;
dr[LibraryMOD.GetFieldName(ObjectNameEnFN)] = ObjectNameEn;
dr[LibraryMOD.GetFieldName(DisplayObjectNameFN)] = DisplayObjectName;
dr[LibraryMOD.GetFieldName(ShowOrderFN)] = ShowOrder;
dr[LibraryMOD.GetFieldName(SystemIDFN)] = SystemID;
dr[LibraryMOD.GetFieldName(ParentIDFN)] = ParentID;
dr[LibraryMOD.GetFieldName(sURLFN)] = sURL;
dr[LibraryMOD.GetFieldName(iLevelFN)] = iLevel;
//dr[LibraryMOD.GetFieldName(CreationUserIDFN)] = InitializeModule.gUserNo;
//dr[LibraryMOD.GetFieldName(CreationDateFN)] = DateTime.Now; //' CreationDate
//dr[LibraryMOD.GetFieldName(LastUpdateUserIDFN)] = InitializeModule.gUserNo; //'LastUpdateUserID
//dr[LibraryMOD.GetFieldName(LastUpdateDateFN)] = DateTime.Now; //'LastUpdateDate
//dr[LibraryMOD.GetFieldName(PCNameFN)] = InitializeModule.gPCName;
//dr[LibraryMOD.GetFieldName(NetUserNameFN)]= InitializeModule.gNetUserName;
dsPrivilegeObjects.Tables[TableName].Rows.Add(dr);
break;
case (int)InitializeModule.enumModes.EditMode:
DataRow[] drAry = null;
drAry = dsPrivilegeObjects.Tables[TableName].Select(LibraryMOD.GetFieldName(ObjectIDFN) + "=" + ObjectID);
//'its return array of rows and we can access the first by index 0
drAry[0][LibraryMOD.GetFieldName(ObjectIDFN)] = ObjectID;
drAry[0][LibraryMOD.GetFieldName(ObjectNameArFN)] = ObjectNameAr;
drAry[0][LibraryMOD.GetFieldName(ObjectNameEnFN)] = ObjectNameEn;
drAry[0][LibraryMOD.GetFieldName(DisplayObjectNameFN)] = DisplayObjectName;
drAry[0][LibraryMOD.GetFieldName(ShowOrderFN)] = ShowOrder;
drAry[0][LibraryMOD.GetFieldName(SystemIDFN)] = SystemID;
drAry[0][LibraryMOD.GetFieldName(ParentIDFN)] = ParentID;
drAry[0][LibraryMOD.GetFieldName(sURLFN)] = sURL;
drAry[0][LibraryMOD.GetFieldName(iLevelFN)] = iLevel;
//drAry[0][LibraryMOD.GetFieldName(LastUpdateUserIDFN)] = InitializeModule.gUserNo; //'LastUpdateUserID
//drAry[0][LibraryMOD.GetFieldName(LastUpdateDateFN)] = DateTime.Now; //'LastUpdateDate
//drAry[0][LibraryMOD.GetFieldName(PCNameFN)] = InitializeModule.gPCName;
//drAry[0][LibraryMOD.GetFieldName(NetUserNameFN)] = InitializeModule.gNetUserName;
break;
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
}
return(InitializeModule.SUCCESS_RET);
}
