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