}//end getAll
//obtiene Teacher activos
public List <Teacher> getAllActive()
{
String sql = "SP_GETALLTEACHERACTIVE";
try
{
SqlCommand oCommand = new SqlCommand(sql);
oCommand.CommandType = System.Data.CommandType.StoredProcedure;
DataTable oDataTable = DAO.getInstance().executeQuery(oCommand);
List <Teacher> listTeacher = new List <Teacher>();
foreach (DataRow oDataRow in oDataTable.Rows)
{
Teacher oTeacher = new Teacher();
InternalDesignation oInternalDesignation = new InternalDesignation();
oTeacher.code = Convert.ToInt32(oDataRow[0].ToString());
oTeacher.id = oDataRow[1].ToString();
oTeacher.name = oDataRow[2].ToString();
oTeacher.lastName = oDataRow[3].ToString();
oTeacher.homePhone = oDataRow[4].ToString();
oTeacher.cellPhone = oDataRow[5].ToString();
oTeacher.email = oDataRow[6].ToString();
oInternalDesignation.code = Convert.ToInt32(oDataRow[7].ToString());
oInternalDesignation.description = oDataRow[8].ToString();
oTeacher.state = Convert.ToInt16(oDataRow[9].ToString());
oTeacher.Position = oInternalDesignation;
listTeacher.Add(oTeacher);
}
return(listTeacher);
}
catch (Exception ex)
{
throw ex;
}
finally { }
}//getActive
public InternalDesignation getInternalDesignation(Int32 pCode)
{
String oSql = "SP_GETINTERNAL_DESIGNATION";
try
{
SqlCommand oCommand = new SqlCommand(oSql);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@ID", pCode);
DataTable oDataTable = DAO.getInstance().executeQuery(oCommand);
InternalDesignation oInternalDesignation = new InternalDesignation();
foreach (DataRow oDataRow in oDataTable.Rows)
{
oInternalDesignation.code = Convert.ToInt32(oDataRow[0].ToString());
oInternalDesignation.description = oDataRow[1].ToString();
oInternalDesignation.baseSalary = Convert.ToDouble(oDataRow[2].ToString());
oInternalDesignation.annuity = Convert.ToDouble(oDataRow[3].ToString());
oInternalDesignation.state = Convert.ToInt16(oDataRow[4].ToString());
}
return(oInternalDesignation);
}
catch (Exception ex)
{
throw ex;
}
finally { }
}
public List <InternalDesignation> getAllDesactive()
{
String sql = "SP_GETALLINTERNAL_DESIGNATIONDESACTIVE";
try
{
SqlCommand oCommand = new SqlCommand(sql);
oCommand.CommandType = System.Data.CommandType.StoredProcedure;
DataTable oDataTable = DAO.getInstance().executeQuery(oCommand);
List <InternalDesignation> listInternalDesignation = new List <InternalDesignation>();
foreach (DataRow oDataRow in oDataTable.Rows)
{
InternalDesignation oInternalDesignation = new InternalDesignation();
oInternalDesignation.code = Convert.ToInt32(oDataRow[0].ToString());
oInternalDesignation.description = oDataRow[1].ToString();
oInternalDesignation.baseSalary = Convert.ToDouble(oDataRow[2].ToString());
oInternalDesignation.annuity = Convert.ToDouble(oDataRow[3].ToString());
oInternalDesignation.state = Convert.ToInt16(oDataRow[4].ToString());
listInternalDesignation.Add(oInternalDesignation);
}
return(listInternalDesignation);
}
catch (Exception)
{
throw;
}
finally { }
}
public OpeningJustification getJustification(Int32 pCode)
{
String sql = "SP_OPENINGJUSTIFCATION";
try
{
SqlCommand oCommand = new SqlCommand(sql);
oCommand.CommandType = System.Data.CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@ID", pCode);
DataTable oDataTable = DAO.getInstance().executeQuery(oCommand);
OpeningJustification oJustification = new OpeningJustification();
AcademicOffer oAcademic = new AcademicOffer();
Teacher oTeacher = new Teacher();
Course oCourse = new Course();
InternalDesignation oInternal = new InternalDesignation();
foreach (DataRow oDataRow in oDataTable.Rows)
{
oAcademic.code = Convert.ToInt32(oDataRow[0].ToString());
oTeacher.name = oDataRow[1].ToString();
oTeacher.lastName = oDataRow[2].ToString();
oInternal.description = oDataRow[3].ToString();
oInternal.baseSalary = Convert.ToDouble(oDataRow[4].ToString());
oInternal.annuity = Convert.ToDouble(oDataRow[5].ToString());
oAcademic.price = Convert.ToDecimal(oDataRow[6].ToString());
oAcademic.hours = Convert.ToInt32(oDataRow[7].ToString());
oCourse.description = oDataRow[8].ToString();
oInternal.code = Convert.ToInt32(oDataRow[9].ToString());
oAcademic.oteacher = oTeacher;
oAcademic.oCourse = oCourse;
oJustification.Anuality = 0;
oJustification.CauntAnualities = 0;
oJustification.CCSS = 0;
oJustification.Diference = 0;
oJustification.Others = 0;
oJustification.publicity = 0;
oJustification.Salary = 0;
oJustification.Students = 0;
oJustification.TotalBimensual = 0;
oJustification.TotalIncome = 0;
oJustification.TotalMensual = 0;
oJustification.oInternal = oInternal;
oJustification.oAcademic = oAcademic;
}
return(oJustification);
}
catch (Exception ex)
{
throw ex;
}
finally { }
}
public Int32 insert(InternalDesignation pInternalDesignation)
{
String oSql = "SP_INSERTINTERNAL_DESIGNATION";
try
{
SqlCommand oCommand = new SqlCommand(oSql);
oCommand.CommandType = CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@ID", pInternalDesignation.code);
oCommand.Parameters.AddWithValue("@DESCRIPTION", pInternalDesignation.description);
oCommand.Parameters.AddWithValue("@SALARY", pInternalDesignation.baseSalary);
oCommand.Parameters.AddWithValue("@ANNUITY", pInternalDesignation.annuity);
oCommand.Parameters.AddWithValue("@STATE", pInternalDesignation.state);
return(DAO.getInstance().executeSQL(oCommand));
}
catch (Exception ex)
{
throw ex;
}
finally { }
}
}//getActive
//get one especific teacher
public Teacher getTeacher(Int32 pCode)
{
String sql = "SP_GETTEACHER";
try
{
SqlCommand oCommand = new SqlCommand(sql);
oCommand.CommandType = System.Data.CommandType.StoredProcedure;
oCommand.Parameters.AddWithValue("@ID", pCode);
oCommand.Parameters[0].Direction = ParameterDirection.Input;
DataTable oDataTable = DAO.getInstance().executeQuery(oCommand);
Teacher oTeacher = new Teacher();
InternalDesignation oInternalDesignation = new InternalDesignation();
foreach (DataRow oDataRow in oDataTable.Rows)
{
oTeacher.code = Convert.ToInt32(oDataRow[0].ToString());
oTeacher.id = oDataRow[1].ToString();
oTeacher.name = oDataRow[2].ToString();
oTeacher.lastName = oDataRow[3].ToString();
oTeacher.homePhone = oDataRow[4].ToString();
oTeacher.cellPhone = oDataRow[5].ToString();
oTeacher.email = oDataRow[6].ToString();
oInternalDesignation.code = Convert.ToInt32(oDataRow[7].ToString());
oInternalDesignation.description = oDataRow[8].ToString();
oTeacher.state = Convert.ToInt16(oDataRow[9].ToString());
oTeacher.Position = oInternalDesignation;
}
return(oTeacher);
}
catch (Exception ex)
{
throw ex;
}
finally { }
}
