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"); } }
public void DeleteReply(string replyId) { ConnManager connManager = new ConnManager(); connManager.OpenConnection(); string strQuery = "Delete from Replies where ReplyId = " + replyId; SqlCommand command = new SqlCommand(strQuery, connManager.DataCon); command.ExecuteNonQuery(); connManager.DisposeConn(); }
public bool UserExists(string strEmail, ref double _userId) { ConnManager connManager = new ConnManager(); connManager.OpenConnection(); DataSet dsUserExists = connManager.GetData("Select * from Users where EMail = '" + strEmail + "'"); connManager.DisposeConn(); if (dsUserExists.Tables[0].Rows.Count > 0) { _userId = double.Parse(dsUserExists.Tables[0].Rows[0]["Userid"].ToString()); return true; } else return false; }
protected void btnSubmit_Click(object sender, EventArgs e) { user = (Users)Session["User"]; lblUserRegMsg.Visible = false; try { if (user != null && user.Email != null && user.Email == "*****@*****.**") { string targetFolder = HttpContext.Current.Server.MapPath("~/Articles/"); string targetPath = Path.Combine(targetFolder, fileUploadWordFile.FileName); if (fileUploadWordFile.HasFile && chkOverwrite.Checked) { fileUploadWordFile.SaveAs(targetPath); } else { if (!chkSkipSave.Checked) fileUploadWordFile.SaveAs(targetPath); targetPath = Path.Combine(targetFolder, fileUploadSourceFile.FileName); if (fileUploadSourceFile.HasFile && !chkSkipSave.Checked) fileUploadSourceFile.SaveAs(targetPath); user = new Users(); CodeArticles article = new CodeArticles(); ConnManager con = new ConnManager(); double dblArticleID = 0; SqlConnection LclConn = new SqlConnection(); SqlTransaction SetTransaction = null; bool IsinTransaction = false; if (LclConn.State != ConnectionState.Open) { article.SetConnection = article.OpenConnection(LclConn); SetTransaction = LclConn.BeginTransaction(IsolationLevel.ReadCommitted); IsinTransaction = true; } else { article.SetConnection = LclConn; } article.ArticleTitle = txtTitle.Text.Trim(); article.ArticleType = int.Parse(ddType.SelectedValue); article.UserId = int.Parse(ddUserEmail.SelectedValue); article.SourceFile = fileUploadSourceFile.FileName; article.WordFile = fileUploadWordFile.FileName; article.YouTubeURL = txtYoutTube.Text; article.ArticleDetails = txtDetails.Text; article.DemoURL = txtDemoURL.Text; if (chkIsDisplay.Checked) article.IsDisplay = 0; else article.IsDisplay = 1; if (chkhasDemo.Checked) article.HasDemo = 1; else article.HasDemo = 0; int[] myy = new int[22] { 15431, 14362, 21334, 25432, 13234, 18332, 9344, 3453, 6555, 7643, 2343, 1243, 5644, 1234, 2342, 3276, 1752, 2845, 1945, 986, 5898, 9123 }; Random ran = new Random(); int mynum = myy[ran.Next(0, myy.Length)]; article.Views = mynum; int[] myy2 = new int[30] { 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35 }; Random ran2 = new Random(); int mynum2 = myy2[ran2.Next(0, myy2.Length)]; article.ThumbsUp = mynum2; article.OptionID = 1; article.CreatedDateTime = DateTime.Now; bool result = article.CreateArticles(ref dblArticleID, SetTransaction); if (IsinTransaction && result) { SetTransaction.Commit(); } else { SetTransaction.Rollback(); } article.CloseConnection(LclConn); lblUserRegMsg.Visible = true; lblUserRegMsg.Text = "Article saved successfully"; } } else { Response.Redirect("/Tutorials/Basics"); } } catch (Exception ex) { lblUserRegMsg.Visible = true; lblUserRegMsg.Text = "There was an exception, please try again."; txtTitle.Text = ""; } }
private void BindUserEmail(string strQuery) { ConnManager connManager = new ConnManager(); connManager.OpenConnection(); DataSet DSQuestions = new DataSet(); DSQuestions = connManager.GetData(strQuery); connManager.DisposeConn(); if (DSQuestions != null) { if (DSQuestions.Tables[0].Rows.Count > 0) { ddUserEmail.DataSource = DSQuestions; ddUserEmail.DataBind(); } } }