public bool validar_horario() { DaoUser datos = new DaoUser(); String id = ddt_curso.SelectedValue.ToString(); int g = int.Parse(id); bool ok = true; DataTable mat = datos.horarioCurso(g); int n = mat.DefaultView.Count; for (int i = 0; i < n; i++) { if ((mat.Rows[i]["dia"].ToString() == ddt_Dia.SelectedValue) & (mat.Rows[i]["hora_inicio"].ToString() == ddt_Hora.SelectedValue)) { return(false); } else { ok = true; } } return(ok); }
public void horario() { EUser usua = new EUser(); DaoUser dat = new DaoUser(); string l8 = " ", m8 = " ", w8 = " ", j8 = " ", v8 = " ", l10 = " ", m10 = " ", w10 = " ", j10 = " ", v10 = " ", l12 = " ", m12 = " ", w12 = " ", j12 = " ", v12 = " "; int id_curso; id_curso = int.Parse(ddt_curso.SelectedValue); DataTable registro = dat.horarioCurso(id_curso); int n = registro.DefaultView.Count; DataSet reg = new DataSet(); DataTable Dt = new DataTable(); Dt.Columns.Add(" ", typeof(string)); Dt.Columns.Add(" Lunes ", typeof(string)); Dt.Columns.Add(" Martes ", typeof(string)); Dt.Columns.Add(" Miercoles ", typeof(string)); Dt.Columns.Add(" Jueves ", typeof(string)); Dt.Columns.Add(" Viernes ", typeof(string)); for (int i = 0; i < n; i++) { //8:00:00 if (registro.Rows[i]["hora_inicio"].ToString() == "8:00:00" && registro.Rows[i]["dia"].ToString() == "Lunes") { l8 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "8:00:00" && registro.Rows[i]["dia"].ToString() == "Martes") { m8 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "8:00:00" && registro.Rows[i]["dia"].ToString() == "Miercoles") { w8 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "8:00:00" && registro.Rows[i]["dia"].ToString() == "Jueves") { j8 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "8:00:00" && registro.Rows[i]["dia"].ToString() == "Viernes") { v8 = registro.Rows[i]["nombre_materia"].ToString(); } //10:00:00 if (registro.Rows[i]["hora_inicio"].ToString() == "10:00:00" && registro.Rows[i]["dia"].ToString() == "Lunes") { l10 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "10:00:00" && registro.Rows[i]["dia"].ToString() == "Martes") { m10 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "10:00:00" && registro.Rows[i]["dia"].ToString() == "Miercoles") { w10 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "10:00:00" && registro.Rows[i]["dia"].ToString() == "Jueves") { j10 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "10:00:00" && registro.Rows[i]["dia"].ToString() == "Viernes") { v10 = registro.Rows[i]["nombre_materia"].ToString(); } //12:00:00 if (registro.Rows[i]["hora_inicio"].ToString() == "12:00:00" && registro.Rows[i]["dia"].ToString() == "Lunes") { l12 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "12:00:00" && registro.Rows[i]["dia"].ToString() == "Martes") { m12 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "12:00:00" && registro.Rows[i]["dia"].ToString() == "Miercoles") { w12 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "12:00:00" && registro.Rows[i]["dia"].ToString() == "Jueves") { j12 = registro.Rows[i]["nombre_materia"].ToString(); } if (registro.Rows[i]["hora_inicio"].ToString() == "12:00:00" && registro.Rows[i]["dia"].ToString() == "Viernes") { v12 = registro.Rows[i]["nombre_materia"].ToString(); } } Dt.Rows.Add(" 8:00:00-9:29:00 ", l8, m8, w8, j8, v8); Dt.Rows.Add(" 09:30:00-9:59:00 ", " L ", " I ", " B ", " R ", " E "); Dt.Rows.Add(" 10:00:00-11:59:00", l10, m10, w10, j10, v10); Dt.Rows.Add(" 12:00:00-2:00:00", l12, m12, w12, j12, v12); GridView1.DataSource = Dt; GridView1.DataBind(); }