public int UpdatePrograms_Advisors(InitializeModule.EnumCampus Campus, int iMode, int iEntry, string strProgram, int iAdvisor, int byteCategory, string isWeekend)
{
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 = "";
Programs_Advisors thePrograms_Advisors = new Programs_Advisors();
//'Updates the table
switch (iMode)
{
case (int)InitializeModule.enumModes.EditMode:
sql = GetUpdateCommand();
break;
case (int)InitializeModule.enumModes.NewMode:
sql = GetInsertCommand();
break;
}
SqlCommand Cmd = new SqlCommand(sql, Conn);
Cmd.Parameters.Add(new SqlParameter("@iEntry", iEntry));
Cmd.Parameters.Add(new SqlParameter("@strProgram", strProgram));
Cmd.Parameters.Add(new SqlParameter("@iAdvisor", iAdvisor));
Cmd.Parameters.Add(new SqlParameter("@byteCategory", byteCategory));
Cmd.Parameters.Add(new SqlParameter("@isWeekend", isWeekend));
iEffected = Cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(iEffected);
}
public List <Programs_Advisors> GetPrograms_Advisors(InitializeModule.EnumCampus Campus, string sDegree, string sMajor)
{
//' returns a list of Classes instances based on the
//' data in the Programs_Advisors
Connection_StringCLS MyConnection_string = new Connection_StringCLS(Campus);
string sSQL = "SELECT PA.iAdvisor, A.strLecturerDescEn AS sAdvisor, PA.byteCategory AS bCategory, S.strSpecialization";
sSQL += " FROM Reg_Programs_Advisors AS PA INNER JOIN Reg_Lecturers AS A ON PA.iAdvisor = A.intLecturer INNER JOIN";
sSQL += " Reg_Specializations AS S ON PA.strProgram = S.sAdvisingProgram";
sSQL += " WHERE S.strSpecialization ='" + sMajor + "' and S.strDegree ='" + sDegree + "'";
SqlConnection Conn = new SqlConnection(MyConnection_string.Conn_string.ToString());
SqlCommand Cmd = new SqlCommand(sSQL, Conn);
Conn.Open();
SqlDataReader reader = Cmd.ExecuteReader(CommandBehavior.CloseConnection);
List <Programs_Advisors> results = new List <Programs_Advisors>();
try
{
//Default Value
Programs_Advisors myPrograms_Advisors = new Programs_Advisors();
while (reader.Read())
{
myPrograms_Advisors = new Programs_Advisors();
if (reader["iAdvisor"].Equals(DBNull.Value))
{
myPrograms_Advisors.iAdvisor = 0;
}
else
{
myPrograms_Advisors.iAdvisor = int.Parse(reader["iAdvisor"].ToString());
}
myPrograms_Advisors.SAdvisor = reader["sAdvisor"].ToString();
if (reader["bCategory"].Equals(DBNull.Value))
{
myPrograms_Advisors.byteCategory = 0;
}
else
{
myPrograms_Advisors.byteCategory = byte.Parse(reader["bCategory"].ToString());
}
results.Add(myPrograms_Advisors);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
reader.Close();
reader.Dispose();
Conn.Close();
Conn.Dispose();
}
return(results);
}
public List <Programs_Advisors> GetPrograms_Advisors(InitializeModule.EnumCampus Campus, string sCondition, bool isDeafaultIncluded)
{
//' returns a list of Classes instances based on the
//' data in the Programs_Advisors
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 <Programs_Advisors> results = new List <Programs_Advisors>();
try
{
//Default Value
Programs_Advisors myPrograms_Advisors = new Programs_Advisors();
if (isDeafaultIncluded)
{
//Change the code here
myPrograms_Advisors.iEntry = 0;
myPrograms_Advisors.strProgram = "Select Programs_Advisors ...";
results.Add(myPrograms_Advisors);
}
while (reader.Read())
{
myPrograms_Advisors = new Programs_Advisors();
if (reader[LibraryMOD.GetFieldName(iEntryFN)].Equals(DBNull.Value))
{
myPrograms_Advisors.iEntry = 0;
}
else
{
myPrograms_Advisors.iEntry = int.Parse(reader[LibraryMOD.GetFieldName(iEntryFN)].ToString());
}
myPrograms_Advisors.strProgram = reader[LibraryMOD.GetFieldName(strProgramFN)].ToString();
if (reader[LibraryMOD.GetFieldName(iAdvisorFN)].Equals(DBNull.Value))
{
myPrograms_Advisors.iAdvisor = 0;
}
else
{
myPrograms_Advisors.iAdvisor = int.Parse(reader[LibraryMOD.GetFieldName(iAdvisorFN)].ToString());
}
if (reader[LibraryMOD.GetFieldName(byteCategoryFN)].Equals(DBNull.Value))
{
myPrograms_Advisors.byteCategory = 0;
}
else
{
myPrograms_Advisors.byteCategory = int.Parse(reader[LibraryMOD.GetFieldName(byteCategoryFN)].ToString());
}
myPrograms_Advisors.isWeekend = reader[LibraryMOD.GetFieldName(isWeekendFN)].ToString();
results.Add(myPrograms_Advisors);
}
}
catch (Exception ex)
{
LibraryMOD.ShowErrorMessage(ex);
}
finally
{
reader.Close();
reader.Dispose();
Conn.Close();
Conn.Dispose();
}
return(results);
}