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