protected void Button1_Click(object sender, EventArgs e) { user = (Users)Session["User"]; if (user != null && user.Email != null && user.Email == "*****@*****.**") { ConnManager connManager = new ConnManager(); connManager.OpenConnection(); if(txtSQL.Text.ToLower().StartsWith("select")) { DataSet DSQuestions = new DataSet(); DSQuestions = connManager.GetData(txtSQL.Text); connManager.DisposeConn(); if (DSQuestions != null) { if (DSQuestions.Tables[0].Rows.Count > 0) { GridView1.DataSource = DSQuestions; GridView1.DataBind(); } } } else { SqlCommand comm = new SqlCommand(txtSQL.Text, connManager.DataCon); comm.ExecuteNonQuery(); } } else { Response.Redirect("http://www.codeanalyze.com"); } }
protected void Page_Load(object sender, EventArgs e) { Users user = new Users(); user = (Users)Session["User"]; if (user != null && user.Email != null && user.Email == "*****@*****.**") { } else { Response.Redirect("http://www.codeanalyze.com"); } }
public Users CreateUser(string strEmail, string strFirstName, string strLastName, string strImageURL) { Users user = new Users(); double dblUserID = 0; SqlConnection LclConn = new SqlConnection(); SqlTransaction SetTransaction = null; bool IsinTransaction = false; if (LclConn.State != ConnectionState.Open) { user.SetConnection = user.OpenConnection(LclConn); SetTransaction = LclConn.BeginTransaction(IsolationLevel.ReadCommitted); IsinTransaction = true; } else { user.SetConnection = LclConn; } user.Email = strEmail.Trim(); user.FirstName = strFirstName.Trim(); user.LastName = strLastName.Trim(); user.ImageURL = strImageURL.Trim(); user.OptionID = 1; user.CreatedDateTime = DateTime.Now; bool result = user.CreateUsers(ref dblUserID, SetTransaction); if (IsinTransaction && result) { SetTransaction.Commit(); user.UserId = dblUserID; } else { SetTransaction.Rollback(); } user.CloseConnection(LclConn); return user; }