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;
}
