private void cargarHorarios()
{
flowLayoutPanel1.Controls.Clear();
string connectionString = "Server=DESKTOP-MU4EH1E;Database=FicharApp;User Id=admin;Password=123;";
string sql = "SELECT * FROM Horario, Tramos_Horarios WHERE Tramos_Horarios.ID = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Authors_table");
connection.Close();
string IDActual = "";
controlHorario ch = new controlHorario();
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (IDActual == "")
{
ch.label1.Text = dr.ItemArray[1].ToString();
}
else if (IDActual != dr.ItemArray[0].ToString())
{
flowLayoutPanel1.Controls.Add(ch);
ch = new controlHorario();
ch.label1.Text = dr.ItemArray[1].ToString();
}
Label l = new Label();
l.Text = dr.ItemArray[3].ToString() + " - " + dr.ItemArray[4].ToString();
ch.flowLayoutPanel1.Controls.Add(l);
IDActual = dr.ItemArray[0].ToString();
}
if (ds.Tables[0].Rows.Count > 0)
{
flowLayoutPanel1.Controls.Add(ch);
}
}
private void lbHorarios_SelectedIndexChanged(object sender, EventArgs e)
{
lbTramos.Items.Clear();
//Nos conectamos a bdd
string connectionString = "Server=DESKTOP-MU4EH1E;Database=FicharApp;User Id=admin;Password=123;";
string sql = "select * from Tramos_Horarios where id=" + ((sender as ListBox).SelectedItem as Horario).id;
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Authors_table");
connection.Close();
controlHorario ch = new controlHorario();
foreach (DataRow dr in ds.Tables[0].Rows)
{
lbTramos.Items.Add(new Tramos(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString(), dr.ItemArray[2].ToString(), dr.ItemArray[3].ToString()));
}
}
private void cargarHorarios()
{
lbHorarios.Items.Clear();
string connectionString = "Server=DESKTOP-MU4EH1E;Database=FicharApp;User Id=admin;Password=123;";
string sql = "select * from horario";
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Authors_table");
connection.Close();
controlHorario ch = new controlHorario();
foreach (DataRow dr in ds.Tables[0].Rows)
{
lbHorarios.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
}
lbHorarios.SelectedIndex = 0;
}
private void CambiarHorarioACalendario_Load(object sender, EventArgs e)
{
string connectionString = "Server=DESKTOP-MU4EH1E;Database=FicharApp;User Id=admin;Password=123;";
string sql = "select * from horario";
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Authors_table");
connection.Close();
controlHorario ch = new controlHorario();
//Añadir Horario Vacío (Festivo)
cbLunes.Items.Add(new Horario("-1", ""));
cbMartes.Items.Add(new Horario("-1", ""));
cbMiercoles.Items.Add(new Horario("-1", ""));
cbJueves.Items.Add(new Horario("-1", ""));
cbViernes.Items.Add(new Horario("-1", ""));
cbSabado.Items.Add(new Horario("-1", ""));
cbDomingo.Items.Add(new Horario("-1", ""));
foreach (DataRow dr in ds.Tables[0].Rows)
{
//Añadir Horarios de DB
cbLunes.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbMartes.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbMiercoles.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbJueves.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbViernes.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbSabado.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
cbDomingo.Items.Add(new Horario(dr.ItemArray[0].ToString(), dr.ItemArray[1].ToString()));
}
//Buscamos el horario de cada día y si no tiene, seleccionamos el 0 por defecto.
int cuentaLunes = 0;
cbLunes.SelectedIndex = 0;
foreach (Horario item in cbLunes.Items)
{
if (item.id == Calendar.lun)
{
cbLunes.SelectedIndex = cuentaLunes;
}
cuentaLunes++;
}
int cuentaMartes = 0;
cbMartes.SelectedIndex = 0;
foreach (Horario item in cbMartes.Items)
{
if (item.id == Calendar.mar)
{
cbMartes.SelectedIndex = cuentaMartes;
}
cuentaMartes++;
}
int cuentaMiercoles = 0;
cbMiercoles.SelectedIndex = 0;
foreach (Horario item in cbMiercoles.Items)
{
if (item.id == Calendar.mie)
{
cbMiercoles.SelectedIndex = cuentaMiercoles;
}
cuentaMiercoles++;
}
int cuentaJueves = 0;
cbJueves.SelectedIndex = 0;
foreach (Horario item in cbJueves.Items)
{
if (item.id == Calendar.jue)
{
cbJueves.SelectedIndex = cuentaJueves;
}
cuentaJueves++;
}
int cuentaViernes = 0;
cbViernes.SelectedIndex = 0;
foreach (Horario item in cbViernes.Items)
{
if (item.id == Calendar.vie)
{
cbViernes.SelectedIndex = cuentaViernes;
}
cuentaViernes++;
}
int cuentaSabado = 0;
cbSabado.SelectedIndex = 0;
foreach (Horario item in cbSabado.Items)
{
if (item.id == Calendar.sab)
{
cbSabado.SelectedIndex = cuentaSabado;
}
cuentaSabado++;
}
int cuentaDomingo = 0;
cbDomingo.SelectedIndex = 0;
foreach (Horario item in cbDomingo.Items)
{
if (item.id == Calendar.dom)
{
cbDomingo.SelectedIndex = cuentaDomingo;
}
cuentaDomingo++;
}
}
private void cargarHorario()
{
if (trabajador.isAdmin)
{
horaEntrada.Text = "00:00";
horaSalida.Text = "00:00";
}
else
{
string connectionString = "Server=DESKTOP-MU4EH1E;Database=FicharApp;User Id=admin;Password=123;";
switch (DateTime.Now.DayOfWeek)
{
case DayOfWeek.Monday:
string sql = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Lunes = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connection = new SqlConnection(connectionString);
SqlDataAdapter dataadapter = new SqlDataAdapter(sql, connection);
DataSet ds = new DataSet();
connection.Open();
dataadapter.Fill(ds, "Authors_table");
connection.Close();
string IDActual = "";
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Tuesday:
string sqlMar = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Martes = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionMar = new SqlConnection(connectionString);
SqlDataAdapter dataadapterMar = new SqlDataAdapter(sqlMar, connectionMar);
DataSet dsMar = new DataSet();
connectionMar.Open();
dataadapterMar.Fill(dsMar, "Authors_table");
connectionMar.Close();
string IDActualMar = "";
controlHorario chMar = new controlHorario();
foreach (DataRow dr in dsMar.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Wednesday:
string sqlMie = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Miércoles = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionMie = new SqlConnection(connectionString);
SqlDataAdapter dataadapterMie = new SqlDataAdapter(sqlMie, connectionMie);
DataSet dsMie = new DataSet();
connectionMie.Open();
dataadapterMie.Fill(dsMie, "Authors_table");
connectionMie.Close();
string IDActualMie = "";
controlHorario chMie = new controlHorario();
foreach (DataRow dr in dsMie.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Thursday:
string sqlJue = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Jueves = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionJue = new SqlConnection(connectionString);
SqlDataAdapter dataadapterJue = new SqlDataAdapter(sqlJue, connectionJue);
DataSet dsJue = new DataSet();
connectionJue.Open();
dataadapterJue.Fill(dsJue, "Authors_table");
connectionJue.Close();
string IDActualJue = "";
controlHorario chJue = new controlHorario();
foreach (DataRow dr in dsJue.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Friday:
string sqlVie = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Viernes = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionVie = new SqlConnection(connectionString);
SqlDataAdapter dataadapterVie = new SqlDataAdapter(sqlVie, connectionVie);
DataSet dsVie = new DataSet();
connectionVie.Open();
dataadapterVie.Fill(dsVie, "Authors_table");
connectionVie.Close();
string IDActualVie = "";
controlHorario chVie = new controlHorario();
foreach (DataRow dr in dsVie.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Saturday:
string sqlSab = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Sábado = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionSab = new SqlConnection(connectionString);
SqlDataAdapter dataadapterSab = new SqlDataAdapter(sqlSab, connectionSab);
DataSet dsSab = new DataSet();
connectionSab.Open();
dataadapterSab.Fill(dsSab, "Authors_table");
connectionSab.Close();
string IDActualSab = "";
controlHorario chSab = new controlHorario();
foreach (DataRow dr in dsSab.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
case DayOfWeek.Sunday:
string sqlDom = "SELECT * FROM Horario, Tramos_Horarios, Calendario WHERE Tramos_Horarios.ID = Horario.ID AND " + trabajador.calendario +
" = Calendario.id AND Calendario.Domingo = Horario.ID Order BY Tramos_Horarios.IDTramo";
SqlConnection connectionDom = new SqlConnection(connectionString);
SqlDataAdapter dataadapterDom = new SqlDataAdapter(sqlDom, connectionDom);
DataSet dsDom = new DataSet();
connectionDom.Open();
dataadapterDom.Fill(dsDom, "Authors_table");
connectionDom.Close();
string IDActualDom = "";
controlHorario chDom = new controlHorario();
foreach (DataRow dr in dsDom.Tables[0].Rows)
{
if (horario == 0)
{
horaEntrada.Text = dr.ItemArray[3].ToString();
horario++;
}
else
{
horaSalida.Text = dr.ItemArray[4].ToString();
}
}
break;
default:
Console.WriteLine("Default case");
break;
}
}
}
