public void CargarHorarios()
{
//MessageBox.Show(Conector.LeerTodosHorarios(gs.getID()).Length.ToString());
h = Conector.LeerTodosHorarios(gs.getID());
for (int i = 0; i < h.Length; i++)
{
BotonHoraC boton = tablePanelHorairo.GetControlFromPosition(h[i].Dia - 1, h[i].Hora - 1) as BotonHoraC;
//MessageBox.Show(Conector.LeerTodosHorarios(gs.getID())[i].Clase.ToString());
boton.Text =
Conector.leerClase(h[i].Clase).NombreMateria + Environment.NewLine + Conector.leerNombreProfesor(Conector.leerClase(h[i].Clase).Profesor)
+ Environment.NewLine + Conector.leerAulaPorId(h[i].Aula);
}
}
private void bttnExportar_Click(object sender, EventArgs e)
{
Excel.Application oApp;
Excel.Worksheet oSheet;
Excel.Workbook oBook;
oApp = new Excel.Application();
oBook = oApp.Workbooks.Add();
oSheet = (Excel.Worksheet)oBook.Worksheets.get_Item(1);
//rango de celdas
Excel.Range rango = oSheet.Range["A1", "F9"];
//estilo del borde
rango.Borders.LineStyle = Excel.XlLineStyle.xlContinuous;
rango.BorderAround(Excel.XlLineStyle.xlContinuous, Excel.XlBorderWeight.xlMedium, Excel.XlColorIndex.xlColorIndexAutomatic, Excel.XlColorIndex.xlColorIndexAutomatic);
//estilo de fuente
oSheet.Rows.Cells.Font.Size = 11;
oSheet.Rows.Cells.Font.Name = "Calibri";
//ancho de columnas
rango.ColumnWidth = 20;
//text align
//rango.HorizontalAlignment = HorizontalAlignment.Center;
rango.VerticalAlignment = Excel.XlVAlign.xlVAlignCenter;
rango.HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
//rango.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.AliceBlue);
Excel.Range rangoTitulo = oSheet.Range["B1", "D1"];
Excel.Range rangoDias = oSheet.Range["A3", "F3"];
Excel.Range rangoGrupo = oSheet.Range["A1", "F2"];
Excel.Range rangoCampos = oSheet.Range["A4", "F9"];
//color de Horario y grupo
rangoTitulo.Font.Size = 14;
rangoTitulo.Font.Bold = true;
rangoDias.Font.Bold = true;
rangoDias.Font.Size = 14;
rangoDias.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.DarkBlue);
rangoGrupo.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Silver);
rangoDias.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.SkyBlue);
rangoCampos.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.AliceBlue);
oSheet.Cells[1, 2] = "Horario";
oSheet.Cells[1, 3] = "del grupo:";
if (editar)
{
oSheet.Cells[1, 4] = Conector.leerGrupoPorID(gs.getID());
h = Conector.LeerTodosHorarios(gs.getID());
for (int i = 0; i < h.Length; i++)
{
oSheet.Cells[h[i].Hora + 3, h[i].Dia + 1] = Conector.leerClase(h[i].Clase).NombreMateria + Environment.NewLine + Conector.leerNombreProfesor(Conector.leerClase(h[i].Clase).Profesor)
+ Environment.NewLine + Conector.leerAulaPorId(h[i].Aula);
}
}
else
{
oSheet.Cells[1, 4] = Conector.TodosGrupo()[Conector.TodosGrupo().Length - 1].Nombre;
h = Conector.LeerTodosHorarios(Conector.TodosGrupo()[Conector.TodosGrupo().Length - 1].Id);
for (int i = 0; i < h.Length; i++)
{
oSheet.Cells[h[i].Hora + 3, h[i].Dia + 1] = Conector.leerClase(h[i].Clase).NombreMateria + Environment.NewLine +
Conector.leerNombreProfesor(Conector.leerClase(h[i].Clase).Profesor)
+ Environment.NewLine + Conector.leerAulaPorId(h[i].Aula);
}
}
oSheet.Cells[3, 1] = "Hora";
oSheet.Cells[3, 2] = "Lunes";
oSheet.Cells[3, 3] = "Martes";
oSheet.Cells[3, 4] = "Miércoles";
oSheet.Cells[3, 5] = "Jueves";
oSheet.Cells[3, 6] = "Viernes";
oSheet.Cells[4, 1] = "2:10-3:00 PM";
oSheet.Cells[5, 1] = "3:00-3:50 PM";
oSheet.Cells[6, 1] = "3:50-4:40 PM";
oSheet.Cells[7, 1] = "5:10-6:00 PM";
oSheet.Cells[8, 1] = "6:00-7:40 PM";
oSheet.Cells[9, 1] = "7:40-8:30 PM";
oBook.Close();
oApp.Quit();
}
