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; } }
protected void bntRegister_Click(object sender, EventArgs e) { string ActivationKey = KavsitWeb.CreateRandomPassword(7); string Domain = Request.Url.Authority; string MD5pass = KavsitWeb.CreateMD5Hash(pass.Text); Member m = new Member() { Name = name.Text, Surname = sur.Text, Email = mail.Text, UserName = user.Text, Password = MD5pass, ActivationKey = ActivationKey }; dcx.Members.InsertOnSubmit(m); dcx.SubmitChanges(); success.Visible = true; try { KavsitWeb.SendMail(mail.Text, KavsitWeb.Company("companyName") + " Aktivasyon Kodu", "<a href='http://" + Domain + "/Theme/Activation.aspx?key=" + ActivationKey + "'>Aktivasyon İçin Tıklayınız.<a>"); } catch (Exception ex) { lblerror.Text = ex.Message; } }
protected void btnGir_Click(object sender, EventArgs e) { string email = txtEmail.Text; string passwordMD = KavsitWeb.CreateMD5Hash(txtsifre.Text); var query = from a in dcx.Members where a.Email == email && a.Password == passwordMD select a; if (query.Count() == 1) { var user = query.SingleOrDefault(); Session["Ad"] = user.Name; Session["ID"] = user.ID; Session["Authority"] = user.MemberType.Title; Response.Redirect("~/Panel/kavsit.aspx"); } else { Label1.Text = "Giriş Başarısız..."; } }