protected void login_Click(object sender, EventArgs e) { string UserName = txtUser.Text; string Password = KavsitWeb.CreateMD5Hash(txtPass.Text); try { string bag_str = WebConfigurationManager.ConnectionStrings["baglanti"].ConnectionString; SqlConnection baglanti = new SqlConnection(bag_str); baglanti.Open(); SqlCommand sorgu = new SqlCommand("select ID,memberName,memberActivated,memberEmail,memberUserName,memberPassword from Members WHERE ((memberUserName=@username OR memberEmail=@email) AND memberPassword=@password) AND memberActivated='True';", baglanti); sorgu.Parameters.AddWithValue("@username", txtUser.Text); sorgu.Parameters.AddWithValue("@email", txtUser.Text); sorgu.Parameters.AddWithValue("@password", Password); SqlDataReader dr = sorgu.ExecuteReader(); if (dr.Read()) { Session["ID"] = dr["ID"].ToString(); Session["username"] = dr["memberName"].ToString(); KavsitWeb.Query("update Members SET memberOnline='True' where ID=" + Session["ID"]); Response.Redirect("~/Theme/Profile.aspx"); } } catch (Exception ex) { error.Text = ex.Message; } }
public static string DeleteMenuItems(string secililer) { KavsitWeb KavsitWeb = new KavsitWeb(); KavsitWeb.Query("delete from Menu where ID IN(" + secililer + ")"); return("<div class='alert alert-success' role='alert'>Silme İşlemi Başarılı.</div>"); }
protected void Page_Load(object sender, EventArgs e) { KavsitWeb KavsitWeb = new KavsitWeb(); if (!Page.IsPostBack) { string ActivationKey = Request.QueryString["key"]; int Result = KavsitWeb.Query("update Members SET memberActivated='True' where memberActivationKey='" + ActivationKey + "'"); if (Result == 1) { KavsitWeb.Query("update Members SET memberActivationKey='' where memberActivationKey='" + ActivationKey + "'"); Response.Redirect("~/Theme/Login.aspx"); } else { error.Text = "Hata"; } } }
protected void Page_Load(object sender, EventArgs e) { var query = from a in dcx.News_Categories select a; membersgrid.DataSource = query; membersgrid.DataBind(); int q = Convert.ToInt16(Request.QueryString["q"]); if (q != 0) { KavsitWeb.Query("delete from catagory where ID=" + q); Response.Redirect("catagorys.aspx"); } }
protected void Page_Load(object sender, EventArgs e) { Session["url"] = Request.Url.Authority; var query = from a in dcx.Libraries select a; librarygrid.DataSource = query; librarygrid.DataBind(); string q = Request.QueryString["q"]; // Response.Write("<script>alert("+q+"); </script>"); if (q != null) { string bag_str = WebConfigurationManager.ConnectionStrings["baglanti"].ConnectionString; SqlConnection baglanti = new SqlConnection(bag_str); baglanti.Open(); SqlCommand sorgum = new SqlCommand("select libraryContent from library where ID=" + q.ToString(), baglanti); SqlDataReader dr = sorgum.ExecuteReader(); if (dr.Read()) { string Yol = dr["libraryContent"].ToString(); File.Delete(Request.PhysicalApplicationPath + "Library/" + Yol); KavsitWeb.Query("delete from library where ID=" + q); Response.Redirect("library.aspx"); _success.Visible = true; } else { _error.Visible = true; } } }
protected void btn_sqlExecute_Click(object sender, EventArgs e) { TextBox sql = panelDevelopSettings.FindControl("txt_sqlQuery") as TextBox; KavsitWeb.Query(sql.Text); }