protected void Page_Load(object sender, EventArgs e)
{
Response.Cache.SetNoStore();
if (Session["userId"] != null)
{
EUser usua = new EUser();
DaoUser dat = new DaoUser();
string l8 = " ", m8 = " ", w8 = " ", j8 = " ", v8 = " ", l10 = " ", m10 = " ", w10 = " ", j10 = " ", v10 = " ", l12 = " ", m12 = " ", w12 = " ", j12 = " ", v12 = " ";
String id_est = Session["userId"].ToString();
DataTable registro = dat.horario(id_est);
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 ", " R ", " E ", " C E ", " S ", " O ");
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();
}
else
{
Response.Redirect("AccesoDenegado.aspx");
}
}