コード例 #1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["user"] == null)
            {
                Response.Redirect("FirstPage.aspx");
            }

            DataOperation db     = new DataOperation();
            User          user   = new User();
            string        uname  = Session["user"].ToString();
            string        name   = "";
            string        email  = "";
            string        mobile = "";
            string        status = "";
            SqlConnection con    = new SqlConnection(db.connectstr);
            string        query  = "Select ID from UsersInfo where Username='******'";
            SqlCommand    cmd    = new SqlCommand(query, con);

            con.Open();
            user.getid = (int)cmd.ExecuteScalar();
            con.Close();
            Session["id"] = user.getid;
            string        query2 = "Select Name, Email,Mobile from UsersInfo where ID='" + user.getid + "' ";
            SqlCommand    cmd2   = new SqlCommand(query2, con);
            SqlDataReader reader = null;

            con.Open();
            reader = cmd2.ExecuteReader();

            while (reader.Read())
            {
                name   = reader["Name"].ToString();
                email  = reader["Email"].ToString();
                mobile = reader["Mobile"].ToString();
            }
            con.Close();
            Name.Text     = name;
            Email.Text    = email;
            Mobile.Text   = mobile;
            Username.Text = uname;

            string query3 = "Select ComplaintID, Status from UserComplaints where ID='" + user.getid + "'";

            complaints.DataSource = db.GetDataTable(query3);
            complaints.DataBind();
            con.Open();
            SqlDataReader reader2 = null;
            SqlCommand    cmd3    = new SqlCommand(query3, con);

            reader = cmd3.ExecuteReader();
            while (reader.Read())
            {
                status = reader["Status"].ToString();
            }

            if (status == "Pending" || status == "Accepted" || status == "Processing")
            {
                complaints.Columns[3].Visible = false;
            }
            else
            {
                complaints.Columns[3].Visible = true;
            }
        }