public ProgramationObject[] SelectDiasMes(int mes, int ano)
{
int cantidadRegistros = SelectCantidadDiasMes(mes, ano);
string query = "SELECT cafe_programation.idfecha, cafe_programation.dia, cafe_programation.mes, cafe_programation.ano, empleado.nombre FROM cafe_programation, empleado WHERE cafe_programation.noempleado = empleado.noempleado AND MES = " + mes + " AND " + "ANO = " + ano + " ORDER BY IDFECHA";
ProgramationObject[] diasMes = new ProgramationObject[cantidadRegistros];
if (oConexion.OpenConnection() == true)
{
MySqlCommand cmd = new MySqlCommand(query, oConexion.connection);
MySqlDataReader dataReader = cmd.ExecuteReader();
int i = 0;
while (dataReader.Read())
{
diasMes[i] = ReadSingleRow((IDataRecord)dataReader);
i++;
}
dataReader.Close();
oConexion.CLoseConection();
return diasMes;
}
else
{
return diasMes;
}
}
private static ProgramationObject ReadSingleRow(IDataRecord record)
{
ProgramationObject objecto = new ProgramationObject();
objecto.idfecha = record[0]+"";
objecto.dia = int.Parse(record[1]+"");
objecto.mes = int.Parse(record[2]+"");
objecto.ano = int.Parse(record[3]+"");
objecto.noempleado = record[4]+"";
return objecto;
}
