public void consulta(string segmento, Int32 id_aluno)
{
if (id_aluno != null)
{
CTO campos = new CTO();
ComandosBLL gera = new ComandosBLL();
VerificaUser acao = new VerificaUser();
campos.seg = segmento;
campos.session = id_aluno;
DataTable x = gera.consulta(campos);
acao.gravacookiebook(segmento);
foreach (DataRow row in x.Rows)
{
campos.Campo1 = row[3].ToString();
campos.Campo2 = row[4].ToString();
campos.Campo3 = row[5].ToString();
campos.Campo4 = row[6].ToString();
campos.Campo5 = row[7].ToString();
campos.Campo6 = row[8].ToString();
campos.Campo7 = row[9].ToString();
campos.Campo8 = row[10].ToString();
campos.Campo9 = row[11].ToString();
campos.Campo10 = row[12].ToString();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
acao.gravacookiebook("step1-5");
if (string.IsNullOrEmpty(Request.Cookies["IDUSU"].Value) == false)
{
Pcampos.Session = Convert.ToInt32(Request.Cookies["IDUSU"].Value);
Label1.Text = Convert.ToString(Request.Cookies["NOME"].Value + ", Logged ! | ");
}
else
{
Response.Redirect("login.aspx");
}
}
catch
{
Response.Redirect("login.aspx");
}
if (!IsPostBack)
{
if (Pcampos.Session < 1)
{
Response.Redirect("login.aspx");
}
else
{
Pcampos.seg = "step1-5";
DataTable x = Gera.consulta(Pcampos);
foreach (DataRow row in x.Rows)
{
TextBox1.Text = row[3].ToString();
TextBox2.Text = row[4].ToString();
TextBox3.Text = row[5].ToString();
TextBox4.Text = row[6].ToString();
TextBox5.Text = row[7].ToString();
TextBox6.Text = row[8].ToString();
TextBox7.Text = row[9].ToString();
TextBox8.Text = row[10].ToString();
TextBox9.Text = row[11].ToString();
TextBox10.Text = row[12].ToString();
TextBox11.Text = row[13].ToString();
TextBox12.Text = row[14].ToString();
TextBox13.Text = row[15].ToString();
TextBox14.Text = row[16].ToString();
TextBox15.Text = row[17].ToString();
TextBox16.Text = row[18].ToString();
TextBox17.Text = row[19].ToString();
TextBox18.Text = row[20].ToString();
TextBox19.Text = row[21].ToString();
TextBox20.Text = row[22].ToString();
TextBox21.Text = row[23].ToString();
TextBox22.Text = row[24].ToString();
TextBox23.Text = row[25].ToString();
TextBox24.Text = row[26].ToString();
TextBox25.Text = row[27].ToString();
TextBox26.Text = row[28].ToString();
TextBox27.Text = row[29].ToString();
TextBox28.Text = row[30].ToString();
TextBox29.Text = row[31].ToString();
TextBox30.Text = row[32].ToString();
TextBox31.Text = row[33].ToString();
TextBox32.Text = row[34].ToString();
TextBox33.Text = row[35].ToString();
TextBox34.Text = row[36].ToString();
TextBox35.Text = row[37].ToString();
TextBox36.Text = row[38].ToString();
TextBox37.Text = row[39].ToString();
TextBox38.Text = row[40].ToString();
TextBox39.Text = row[41].ToString();
TextBox40.Text = row[42].ToString();
TextBox41.Text = row[43].ToString();
TextBox42.Text = row[44].ToString();
TextBox43.Text = row[45].ToString();
TextBox44.Text = row[46].ToString();
TextBox45.Text = row[47].ToString();
TextBox46.Text = row[48].ToString();
TextBox47.Text = row[49].ToString();
TextBox48.Text = row[50].ToString();
TextBox49.Text = row[51].ToString();
TextBox50.Text = row[52].ToString();
TextBox51.Text = row[53].ToString();
TextBox52.Text = row[54].ToString();
TextBox53.Text = row[55].ToString();
TextBox54.Text = row[56].ToString();
TextBox55.Text = row[57].ToString();
TextBox56.Text = row[58].ToString();
TextBox57.Text = row[59].ToString();
TextBox58.Text = row[60].ToString();
TextBox59.Text = row[61].ToString();
TextBox60.Text = row[62].ToString();
TextBox61.Text = row[63].ToString();
TextBox62.Text = row[64].ToString();
TextBox63.Text = row[65].ToString();
TextBox64.Text = row[66].ToString();
TextBox65.Text = row[67].ToString();
TextBox66.Text = row[68].ToString();
TextBox67.Text = row[69].ToString();
TextBox68.Text = row[70].ToString();
TextBox69.Text = row[71].ToString();
TextBox70.Text = row[72].ToString();
TextBox71.Text = row[73].ToString();
TextBox72.Text = row[74].ToString();
TextBox73.Text = row[75].ToString();
TextBox74.Text = row[76].ToString();
TextBox75.Text = row[77].ToString();
TextBox76.Text = row[78].ToString();
TextBox77.Text = row[79].ToString();
TextBox78.Text = row[80].ToString();
TextBox79.Text = row[81].ToString();
TextBox80.Text = row[82].ToString();
TextBox81.Text = row[83].ToString();
TextBox82.Text = row[84].ToString();
TextBox83.Text = row[85].ToString();
TextBox84.Text = row[86].ToString();
TextBox85.Text = row[87].ToString();
TextBox86.Text = row[88].ToString();
TextBox87.Text = row[89].ToString();
TextBox88.Text = row[90].ToString();
TextBox89.Text = row[91].ToString();
TextBox90.Text = row[92].ToString();
TextBox91.Text = row[93].ToString();
TextBox92.Text = row[94].ToString();
TextBox93.Text = row[95].ToString();
TextBox94.Text = row[96].ToString();
TextBox95.Text = row[97].ToString();
TextBox96.Text = row[98].ToString();
TextBox97.Text = row[99].ToString();
TextBox98.Text = row[100].ToString();
TextBox99.Text = row[101].ToString();
TextBox100.Text = row[102].ToString();
TextBox101.Text = row[103].ToString();
TextBox102.Text = row[104].ToString();
TextBox103.Text = row[105].ToString();
TextBox104.Text = row[106].ToString();
TextBox105.Text = row[107].ToString();
TextBox106.Text = row[108].ToString();
TextBox107.Text = row[109].ToString();
TextBox108.Text = row[110].ToString();
TextBox109.Text = row[111].ToString();
TextBox110.Text = row[112].ToString();
TextBox111.Text = row[113].ToString();
TextBox112.Text = row[114].ToString();
TextBox113.Text = row[115].ToString();
TextBox114.Text = row[116].ToString();
TextBox115.Text = row[117].ToString();
TextBox116.Text = row[118].ToString();
TextBox117.Text = row[119].ToString();
TextBox118.Text = row[120].ToString();
TextBox119.Text = row[121].ToString();
TextBox120.Text = row[122].ToString();
TextBox121.Text = row[123].ToString();
TextBox122.Text = row[124].ToString();
TextBox123.Text = row[125].ToString();
TextBox124.Text = row[126].ToString();
TextBox125.Text = row[127].ToString();
TextBox126.Text = row[128].ToString();
TextBox127.Text = row[129].ToString();
TextBox128.Text = row[130].ToString();
TextBox129.Text = row[131].ToString();
TextBox130.Text = row[132].ToString();
TextBox131.Text = row[133].ToString();
TextBox132.Text = row[134].ToString();
TextBox133.Text = row[135].ToString();
TextBox134.Text = row[136].ToString();
TextBox135.Text = row[137].ToString();
TextBox136.Text = row[138].ToString();
TextBox137.Text = row[139].ToString();
TextBox138.Text = row[140].ToString();
TextBox139.Text = row[141].ToString();
TextBox140.Text = row[142].ToString();
TextBox141.Text = row[143].ToString();
TextBox142.Text = row[144].ToString();
TextBox143.Text = row[145].ToString();
TextBox144.Text = row[146].ToString();
TextBox145.Text = row[147].ToString();
TextBox146.Text = row[148].ToString();
}
}
}
}