Exemplo n.º 1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     MyiTestDataDataContext db = new MyiTestDataDataContext();
     int iduser = (int)(Session["idlogin"]);
     st_GetUserInfoResult user = db.st_GetUserInfo(iduser).FirstOrDefault();
     if (user != null)
     {
         txtUsername.Text = user.iUserName;
     }
 }
Exemplo n.º 2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            MyiTestDataDataContext db = new MyiTestDataDataContext();

            //if (Session["UserName"] != null)
            {
                gdv_User.DataSource = db.st_GetUserInfo(Convert.ToInt32(Session["idlogin"]));
                gdv_User.DataBind();

                lblUserName.Text = gdv_User.Rows[0].Cells[1].Text;
                lblCreatedDate.Text = gdv_User.Rows[0].Cells[6].Text;
                lblEmail.Text = gdv_User.Rows[0].Cells[3].Text;
                lblSumBuonus.Text = db.st_GetBonus(Convert.ToInt32(Session["idlogin"])).ToString();

                float sumtest = (float)db.st_GetSumTest(Convert.ToInt32(Session["idlogin"]));
                float summark = (float)db.st_GetMark(Convert.ToInt32(Session["idlogin"]));

                lblSumMark.Text = summark.ToString();
                lblSumTest.Text = sumtest.ToString();

                double avg = Math.Round((double)(summark/sumtest),2);
                lblAvgMark.Text = avg.ToString();
            }
        }