public static List <Curso> searchCursos(Int64 pIdSucursal, string pText, Year pYear)
{
List <Curso> lista = new List <Curso>();
using (MySqlConnection _con = new Conexion().Conectar())
{
try
{
_con.Open();
MySqlCommand comando = new MySqlCommand("select * from curso where IdSucursal=@pIdSucursal " + (pYear == null ? "" : " and IdYear=" + pYear.Id) +
" and Upper(Nombre) like'%" + pText.ToUpper() + "%' and Estado ='A' order by Id desc", _con);
comando.Parameters.AddWithValue("@pIdSucursal", pIdSucursal);
MySqlDataReader _reader = comando.ExecuteReader();
while (_reader.Read())
{
Curso item = new Curso(
_reader.GetInt64(0),
_reader.GetString(1),
_reader.GetString(2),
_reader.GetString(3),
_reader.GetString(4),
_reader.GetString(5),
_reader.GetString(6),
_reader.GetString(7),
_reader.GetInt64(8),
_reader.GetInt64(9),
_reader.GetInt64(10),
ContratoDAL.getContratoById(_reader.GetInt64(8)),
YearDAL.getYearById(_reader.GetInt64(10)),
DiasDAL.getDiasByIdCurso(_reader.GetInt64(0)),
DetCursoDAL.getDetscursoByIdCurso(_reader.GetInt64(0))
);
lista.Add(item);
}
_reader.Close();
}
catch (Exception ex)
{
_con.Close();
throw ex;
}
finally
{
_con.Close();
}
}
return(lista);
}
public static Curso getCursoById(Int64 pId)
{
Curso item = null;
using (MySqlConnection _con = new Conexion().Conectar())
{
try
{
_con.Open();
MySqlCommand cmdGetItemById = new MySqlCommand("select * from curso where Id=@pId", _con);
cmdGetItemById.Parameters.AddWithValue("@pId", pId);
MySqlDataReader _reader = cmdGetItemById.ExecuteReader();
while (_reader.Read())
{
item = new Curso(
_reader.GetInt64(0),
_reader.GetString(1),
_reader.GetString(2),
_reader.GetString(3),
_reader.GetString(4),
_reader.GetString(5),
_reader.GetString(6),
_reader.GetString(7),
_reader.GetInt64(8),
_reader.GetInt64(9),
_reader.GetInt64(10),
ContratoDAL.getContratoById(_reader.GetInt64(8)),
YearDAL.getYearById(_reader.GetInt64(10)),
DiasDAL.getDiasByIdCurso(_reader.GetInt64(0)),
DetCursoDAL.getDetscursoByIdCurso(_reader.GetInt64(0))
);
}
_reader.Close();
}
catch (Exception ex)
{
_con.Close();
throw ex;
}
finally
{
_con.Close();
}
}
return(item);
}
