//} protected void Button1_Click(object sender, EventArgs e) { //CheckBox evsahibi = (CheckBox)FindControl("evsahibi"); //CheckBox muteahhit = (CheckBox)FindControl("muteahhit"); //int kullaniciTipi = 3; //if (evsahibi.Checked) //{ kullaniciTipi = 0; } //else if (muteahhit.Checked) //{ kullaniciTipi = 1; } //else if (evsahibi.Checked && muteahhit.Checked) //{ kullaniciTipi = 2; } //else { } //string cepTel = TextBox4.Text; //string evTel = TextBox5.Text; //string isTel = TextBox6.Text; //string il = illerDrpDwn.SelectedValue.ToString(); //string ilce = ilcelerDrpDwn.SelectedValue.ToString(); kullanici kull = new kullanici(); kull = kull.getUser(TextBox3.Text); string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("updateUserDetails.aspx?e=" +txt1Enc); }
//} protected void Button1_Click(object sender, EventArgs e) { //CheckBox evsahibi = (CheckBox)FindControl("evsahibi"); //CheckBox muteahhit = (CheckBox)FindControl("muteahhit"); //int kullaniciTipi = 3; //if (evsahibi.Checked) //{ kullaniciTipi = 0; } //else if (muteahhit.Checked) //{ kullaniciTipi = 1; } //else if (evsahibi.Checked && muteahhit.Checked) //{ kullaniciTipi = 2; } //else { } //string cepTel = TextBox4.Text; //string evTel = TextBox5.Text; //string isTel = TextBox6.Text; //string il = illerDrpDwn.SelectedValue.ToString(); //string ilce = ilcelerDrpDwn.SelectedValue.ToString(); kullanici kull = new kullanici(); kull = kull.getUser(TextBox3.Text); string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("updateUserDetails.aspx?e=" + txt1Enc); }
public kullanici getUser(string email) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id, isim, soyad, eposta, sifre,guid FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { kull.id = reader.GetInt32(0); kull.name = reader.GetString(1); kull.surName = reader.GetString(2); kull.email = reader.GetString(3); kull.pass = reader.GetString(4); kull.guid = reader.GetString(5); } sqlConn.Close(); return(kull); }
protected void Button1_Click(object sender, EventArgs e) { CheckBox evsahibi = (CheckBox)FindControl("evsahibi"); CheckBox muteahhit = (CheckBox)FindControl("muteahhit"); int kullaniciTipi = 3; if (evsahibi.Checked && muteahhit.Checked) { kullaniciTipi = 2; } else if (muteahhit.Checked) { kullaniciTipi = 1; } else if (evsahibi.Checked) { kullaniciTipi = 0; } else { } string email = TextBox3.Text; string name = TextBox1.Text; string surName = TextBox2.Text; string cepTel = TextBox4.Text; string evTel = TextBox5.Text; string isTel = TextBox6.Text; string il = illerDrpDwn.SelectedValue.ToString(); string ilce = ilcelerDrpDwn.SelectedValue.ToString(); kullanici kull = new kullanici(); kull = kull.getUser(TextBox3.Text); kull.updateUserDetails(kull.id,name, surName, email, kullaniciTipi, cepTel, evTel, isTel, il, ilce); string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("loggeddef.aspx?e=" + txt1Enc); }
protected void Page_Load(object sender, EventArgs e) { if (Request.QueryString["e"] == null) { Response.Redirect("Default.aspx"); } else { string email = Request.QueryString["e"]; byte[] encodedByte = Convert.FromBase64String(email); string base64Encoded = Encoding.UTF8.GetString(encodedByte); kullanici kull = new kullanici(); kullanici kull1 = new kullanici(); kull = kull.getUser(base64Encoded); kull1 = kull1.getUserDetails(base64Encoded); TextBox1.Text = kull.name; TextBox2.Text = kull.surName; TextBox3.Text = kull.email; TextBox4.Text = kull1.cellPhone; TextBox5.Text = kull1.homePhone; TextBox6.Text = kull1.workPhone; CheckBox chkEv = (CheckBox)FindControl("evsahibi"); CheckBox chkMut = (CheckBox)FindControl("muteahhit"); if (kull1.userType == 0) { chkEv.Checked = true; chkMut.Checked = false; } else if (kull1.userType == 1) { chkMut.Checked = true; chkEv.Checked = false; } else if (kull1.userType == 2) { chkEv.Checked = true; chkMut.Checked = true; } illerDrpDwn.Items.Add(kull1.city); ilcelerDrpDwn.Items.Add(kull1.district); } }
protected void Unnamed1_Click(object sender, EventArgs e) { TextBox txt = (TextBox)FindControl("TextBox1"); TextBox txt1 = (TextBox)FindControl("TextBox2"); if (txt.Text=="" || txt1.Text =="") { Label lblWarning = (Label)FindControl("Label1"); lblWarning.ForeColor = System.Drawing.Color.Red; lblWarning.Text = "Eposta ve/veya şifre alanlarını boş bıraktınız."; return; } string email = txt.Text; string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(txt1.Text)); kullanici kull = new kullanici(); kull = kull.getUser(email); // SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); // SqlCommand check = new SqlCommand("SELECT eposta, sifre FROM kullanici WHERE eposta=@email", sqlConn); // check.Parameters.AddWithValue("@email", email); // sqlConn.Open(); // SqlDataReader reader = check.ExecuteReader(); //reader.Read() && if (kull.pass == txt1Enc) { string emailEnc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("loggeddef.aspx?e=" + emailEnc); } else { Label lblWarning = (Label)FindControl("Label1"); lblWarning.ForeColor = System.Drawing.Color.Red; lblWarning.Text = "Eposta veya şifreniz hatalıdır lütfen tekrar deneyiniz."; } }
protected void Unnamed1_Click(object sender, EventArgs e) { TextBox txt = (TextBox)FindControl("TextBox1"); TextBox txt1 = (TextBox)FindControl("TextBox2"); if (txt.Text == "" || txt1.Text == "") { Label lblWarning = (Label)FindControl("Label1"); lblWarning.ForeColor = System.Drawing.Color.Red; lblWarning.Text = "Eposta ve/veya şifre alanlarını boş bıraktınız."; return; } string email = txt.Text; string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(txt1.Text)); kullanici kull = new kullanici(); kull = kull.getUser(email); // SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); // SqlCommand check = new SqlCommand("SELECT eposta, sifre FROM kullanici WHERE eposta=@email", sqlConn); // check.Parameters.AddWithValue("@email", email); // sqlConn.Open(); // SqlDataReader reader = check.ExecuteReader(); //reader.Read() && if (kull.pass == txt1Enc) { string emailEnc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("loggeddef.aspx?e=" + emailEnc); } else { Label lblWarning = (Label)FindControl("Label1"); lblWarning.ForeColor = System.Drawing.Color.Red; lblWarning.Text = "Eposta veya şifreniz hatalıdır lütfen tekrar deneyiniz."; } }
protected void Button1_Click(object sender, EventArgs e) { CheckBox evsahibi = (CheckBox)FindControl("evsahibi"); CheckBox muteahhit = (CheckBox)FindControl("muteahhit"); int kullaniciTipi = 3; if (evsahibi.Checked && muteahhit.Checked) { kullaniciTipi = 2; } else if (muteahhit.Checked) { kullaniciTipi = 1; } else if (evsahibi.Checked) { kullaniciTipi = 0; } else { } string email = TextBox3.Text; string name = TextBox1.Text; string surName = TextBox2.Text; string cepTel = TextBox4.Text; string evTel = TextBox5.Text; string isTel = TextBox6.Text; string il = illerDrpDwn.SelectedValue.ToString(); string ilce = ilcelerDrpDwn.SelectedValue.ToString(); kullanici kull = new kullanici(); kull = kull.getUser(TextBox3.Text); kull.updateUserDetails(kull.id, name, surName, email, kullaniciTipi, cepTel, evTel, isTel, il, ilce); string txt1Enc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(kull.email)); Response.Redirect("loggeddef.aspx?e=" + txt1Enc); }
public void updateUserDetails(int id, string isim, string soyad, string eposta, int kullaniciTipi, string cepTel, string evTel, string isTel, string il, string ilce) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); kull.id = Convert.ToInt32(sql.ExecuteScalar()); sqlConn.Close(); if (kull.id == 0) { } else { SqlConnection sqlConn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sqlInsertUserDetails = new SqlCommand("UPDATE kullanici SET isim=@name,soyad=@surname,kullaniciTipi=@kullaniciTipi,cepTel=@cepTel,evTel=@evTel,isTel=@isTel,timeStamp=@timeStamp,il=@il,ilce=@ilce WHERE id=@id", sqlConn1); sqlInsertUserDetails.Parameters.AddWithValue("@id", id); sqlInsertUserDetails.Parameters.AddWithValue("@name", isim); sqlInsertUserDetails.Parameters.AddWithValue("@surname", surName); sqlInsertUserDetails.Parameters.AddWithValue("@kullaniciTipi", kullaniciTipi); sqlInsertUserDetails.Parameters.AddWithValue("@cepTel", cepTel); sqlInsertUserDetails.Parameters.AddWithValue("@evTel", evTel); sqlInsertUserDetails.Parameters.AddWithValue("@isTel", isTel); sqlInsertUserDetails.Parameters.AddWithValue("@timeStamp", DateTime.Now); sqlInsertUserDetails.Parameters.AddWithValue("@il", il); sqlInsertUserDetails.Parameters.AddWithValue("@ilce", ilce); sqlConn1.Open(); sqlInsertUserDetails.ExecuteNonQuery(); } }
public kullanici getUserDetails(string email) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id, isim, soyad, eposta, sifre,cepTel,evTel,isTel, kullaniciTipi,il,ilce FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { kull.id = reader.GetInt32(0); kull.name = reader.GetString(1); kull.surName = reader.GetString(2); kull.email = reader.GetString(3); kull.pass = reader.GetString(4); if (reader.IsDBNull(5)) { kull.cellPhone = ""; } else { kull.cellPhone = reader.GetString(5); } if (reader.IsDBNull(6)) { kull.homePhone = ""; } else { kull.homePhone = reader.GetString(6); } if (reader.IsDBNull(7)) { kull.workPhone = ""; } else { kull.workPhone = reader.GetString(7); } if (reader.IsDBNull(8)) { kull.userType = 3; } else { kull.userType = reader.GetInt32(8); } if (reader.IsDBNull(9)) { kull.city = ""; } else { kull.city = reader.GetString(9); } if (reader.IsDBNull(10)) { kull.district = ""; } else { kull.district = reader.GetString(10); } } return(kull); }
protected void Unnamed1_Click1(object sender, EventArgs e) { if (isim.Text == "" || soyisim.Text == "" || email.Text == "" || password.Text == "" || password1.Text == "" || password.Text != password1.Text) { isimLbl.Text = "Lütfen kontrol ediniz"; soyisimLbl.Text = "Lütfen kontrol ediniz"; emailLbl.Text = "Lütfen kontrol ediniz"; sifreLbl.Text = "Lütfen kontrol ediniz"; sifreLbl2.Text = "Lütfen kontrol ediniz"; return; } kullanici kull = new kullanici(); //SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); //SqlCommand insert = new SqlCommand("insert into kullanici(isim,soyad,eposta,sifre,guid) values(@isim,@soyisim,@eposta,@sifre,@guid)", sqlConn); //insert.Parameters.AddWithValue("@isim", isim.Text); //insert.Parameters.AddWithValue("@soyisim", soyisim.Text); //insert.Parameters.AddWithValue("@eposta", email.Text); //string sifreEnc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(password.Text)); //insert.Parameters.AddWithValue("@sifre", sifreEnc); //Guid guid = Guid.NewGuid(); //insert.Parameters.AddWithValue("@guid", guid); //sqlConn.Open(); bool epostaKayitlimi = checkMail(email.Text); string eposta = email.Text; if (epostaKayitlimi == false) { emailLbl.Text = "bu posta adresi ile daha önce kayıt alınmıştır"; return; } else { try { kullanici kull1 = new kullanici(); kull1.insertUser(isim.Text, soyisim.Text, email.Text, password.Text); SmtpClient client = new SmtpClient("mail.orkunantmen.com"); client.Port = 25; client.EnableSsl = true; client.Timeout = 10000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Narosirt71"); MailMessage mm; try { mm = new MailMessage("*****@*****.**", email.Text); } catch { emailLbl.ForeColor = System.Drawing.Color.Red; emailLbl.Text = "Eposta adresinisi kontrol ediniz."; return; } string body1 = "Kentsel dönüşüm platformuna kayıt olduğunuz için teşekkür ederiz. Üyeliğinizin aktif hale getirilmesi için lütfen aşağıdaki linki tıklayınız."; string body2 = "\r\n"; string body3 = "http://www.kentseldonusumplatformu.com/uyeonay.aspx?g="; string cliGuid = guidSql(email.Text); char[] cliGuidArray = cliGuid.ToCharArray(); Array.Reverse(cliGuidArray); string revCliGuid = new String(cliGuidArray); mm.Body = body1 + body2 + body3 + cliGuid + revCliGuid; mm.Subject = "Kentsel Dönüşüm Platformuna hoşgeldiniz!"; try { client.Send(mm); } catch (SmtpException smEx) { isimLbl.Text = smEx.ToString(); } Response.Redirect("kayitBasarili.aspx"); } catch (SqlException ex) { isimLbl.Text = ex.Message.ToString(); } //sqlConn.Close(); clearForm(); } }
public void updateUserDetails(int id, string isim, string soyad, string eposta, int kullaniciTipi, string cepTel, string evTel, string isTel, string il, string ilce) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); kull.id = Convert.ToInt32(sql.ExecuteScalar()); sqlConn.Close(); if (kull.id == 0) { } else { SqlConnection sqlConn1 = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sqlInsertUserDetails = new SqlCommand("UPDATE kullanici SET isim=@name,soyad=@surname,kullaniciTipi=@kullaniciTipi,cepTel=@cepTel,evTel=@evTel,isTel=@isTel,timeStamp=@timeStamp,il=@il,ilce=@ilce WHERE id=@id" , sqlConn1); sqlInsertUserDetails.Parameters.AddWithValue("@id", id); sqlInsertUserDetails.Parameters.AddWithValue("@name", isim); sqlInsertUserDetails.Parameters.AddWithValue("@surname", surName); sqlInsertUserDetails.Parameters.AddWithValue("@kullaniciTipi", kullaniciTipi); sqlInsertUserDetails.Parameters.AddWithValue("@cepTel", cepTel); sqlInsertUserDetails.Parameters.AddWithValue("@evTel", evTel); sqlInsertUserDetails.Parameters.AddWithValue("@isTel", isTel); sqlInsertUserDetails.Parameters.AddWithValue("@timeStamp", DateTime.Now); sqlInsertUserDetails.Parameters.AddWithValue("@il", il); sqlInsertUserDetails.Parameters.AddWithValue("@ilce", ilce); sqlConn1.Open(); sqlInsertUserDetails.ExecuteNonQuery(); } }
public kullanici getUserDetails(string email) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id, isim, soyad, eposta, sifre,cepTel,evTel,isTel, kullaniciTipi,il,ilce FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { kull.id = reader.GetInt32(0); kull.name = reader.GetString(1); kull.surName = reader.GetString(2); kull.email = reader.GetString(3); kull.pass = reader.GetString(4); if (reader.IsDBNull(5)) { kull.cellPhone = ""; } else { kull.cellPhone = reader.GetString(5); } if (reader.IsDBNull(6)) { kull.homePhone = ""; } else { kull.homePhone = reader.GetString(6); } if (reader.IsDBNull(7)) { kull.workPhone = ""; } else { kull.workPhone = reader.GetString(7); } if (reader.IsDBNull(8)) { kull.userType = 3; } else { kull.userType = reader.GetInt32(8); } if (reader.IsDBNull(9)) { kull.city = ""; } else { kull.city = reader.GetString(9); } if (reader.IsDBNull(10)) { kull.district = ""; } else { kull.district = reader.GetString(10); } } return kull; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["e"] == null) { Response.Redirect("loggeddef.aspx"); } illerDrpDwn.Items.Clear(); iller iller = new iller(); List<string> illers = iller.getIller(); illerDrpDwn.DataSource = illers; illerDrpDwn.DataBind(); illerDrpDwn.Items.Insert(0, "Lütfen seçiniz"); string email = Request.QueryString["e"]; byte[] encodedByte = Convert.FromBase64String(email); string base64Encoded = Encoding.UTF8.GetString(encodedByte); //kullanici kull = new kullanici(); //kull = kull.getUser(base64Encoded); //TextBox1.Text = kull.name; //TextBox2.Text = kull.surName; //TextBox3.Text = kull.email; kullanici kull = new kullanici(); kullanici kull1 = new kullanici(); kull = kull.getUser(base64Encoded); kull1 = kull1.getUserDetails(base64Encoded); TextBox1.Text = kull.name; TextBox2.Text = kull.surName; TextBox3.Text = kull.email; TextBox3.Enabled = false; TextBox4.Text = kull1.cellPhone; TextBox5.Text = kull1.homePhone; TextBox6.Text = kull1.workPhone; CheckBox chkEv = (CheckBox)FindControl("evsahibi"); CheckBox chkMut = (CheckBox)FindControl("muteahhit"); if (kull1.userType == 0) { chkEv.Checked = true; chkMut.Checked = false; } else if (kull1.userType == 1) { chkMut.Checked = true; chkEv.Checked = false; } else if (kull1.userType == 2) { chkEv.Checked = true; chkMut.Checked = true; } foreach (string il in illers) { if (il == kull1.city) illerDrpDwn.SelectedValue = il; } ilcelerDrpDwn.Items.Clear(); iller ilceler = new iller(); List<string> ilcelers = ilceler.getIlceler(kull1.city); ilcelerDrpDwn.DataSource = ilcelers; ilcelerDrpDwn.DataBind(); foreach (string ilce in ilcelers) { if (ilce == kull1.district) ilcelerDrpDwn.SelectedValue = ilce; } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["e"] == null) { Response.Redirect("loggeddef.aspx"); } illerDrpDwn.Items.Clear(); iller iller = new iller(); List <string> illers = iller.getIller(); illerDrpDwn.DataSource = illers; illerDrpDwn.DataBind(); illerDrpDwn.Items.Insert(0, "Lütfen seçiniz"); string email = Request.QueryString["e"]; byte[] encodedByte = Convert.FromBase64String(email); string base64Encoded = Encoding.UTF8.GetString(encodedByte); //kullanici kull = new kullanici(); //kull = kull.getUser(base64Encoded); //TextBox1.Text = kull.name; //TextBox2.Text = kull.surName; //TextBox3.Text = kull.email; kullanici kull = new kullanici(); kullanici kull1 = new kullanici(); kull = kull.getUser(base64Encoded); kull1 = kull1.getUserDetails(base64Encoded); TextBox1.Text = kull.name; TextBox2.Text = kull.surName; TextBox3.Text = kull.email; TextBox3.Enabled = false; TextBox4.Text = kull1.cellPhone; TextBox5.Text = kull1.homePhone; TextBox6.Text = kull1.workPhone; CheckBox chkEv = (CheckBox)FindControl("evsahibi"); CheckBox chkMut = (CheckBox)FindControl("muteahhit"); if (kull1.userType == 0) { chkEv.Checked = true; chkMut.Checked = false; } else if (kull1.userType == 1) { chkMut.Checked = true; chkEv.Checked = false; } else if (kull1.userType == 2) { chkEv.Checked = true; chkMut.Checked = true; } foreach (string il in illers) { if (il == kull1.city) { illerDrpDwn.SelectedValue = il; } } ilcelerDrpDwn.Items.Clear(); iller ilceler = new iller(); List <string> ilcelers = ilceler.getIlceler(kull1.city); ilcelerDrpDwn.DataSource = ilcelers; ilcelerDrpDwn.DataBind(); foreach (string ilce in ilcelers) { if (ilce == kull1.district) { ilcelerDrpDwn.SelectedValue = ilce; } } } }
protected void Unnamed1_Click1(object sender, EventArgs e) { if (isim.Text == "" || soyisim.Text == "" || email.Text == "" || password.Text == "" || password1.Text == "" || password.Text != password1.Text) { isimLbl.Text = "Lütfen kontrol ediniz"; soyisimLbl.Text = "Lütfen kontrol ediniz"; emailLbl.Text = "Lütfen kontrol ediniz"; sifreLbl.Text = "Lütfen kontrol ediniz"; sifreLbl2.Text = "Lütfen kontrol ediniz"; return; } kullanici kull = new kullanici(); //SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); //SqlCommand insert = new SqlCommand("insert into kullanici(isim,soyad,eposta,sifre,guid) values(@isim,@soyisim,@eposta,@sifre,@guid)", sqlConn); //insert.Parameters.AddWithValue("@isim", isim.Text); //insert.Parameters.AddWithValue("@soyisim", soyisim.Text); //insert.Parameters.AddWithValue("@eposta", email.Text); //string sifreEnc = Convert.ToBase64String(System.Text.Encoding.ASCII.GetBytes(password.Text)); //insert.Parameters.AddWithValue("@sifre", sifreEnc); //Guid guid = Guid.NewGuid(); //insert.Parameters.AddWithValue("@guid", guid); //sqlConn.Open(); bool epostaKayitlimi = checkMail(email.Text); string eposta = email.Text; if (epostaKayitlimi == false) { emailLbl.Text = "bu posta adresi ile daha önce kayıt alınmıştır"; return; } else { try { kullanici kull1 = new kullanici(); kull1.insertUser(isim.Text, soyisim.Text, email.Text, password.Text); SmtpClient client = new SmtpClient("mail.orkunantmen.com"); client.Port = 25; client.EnableSsl = true; client.Timeout = 10000; client.DeliveryMethod = SmtpDeliveryMethod.Network; client.UseDefaultCredentials = false; client.Credentials = new System.Net.NetworkCredential("*****@*****.**", "Narosirt71"); MailMessage mm; try { mm = new MailMessage("*****@*****.**", email.Text); } catch { emailLbl.ForeColor = System.Drawing.Color.Red; emailLbl.Text = "Eposta adresinisi kontrol ediniz."; return; } string body1 = "Kentsel dönüşüm platformuna kayıt olduğunuz için teşekkür ederiz. Üyeliğinizin aktif hale getirilmesi için lütfen aşağıdaki linki tıklayınız."; string body2 = "\r\n"; string body3 = "http://www.kentseldonusumplatformu.com/uyeonay.aspx?g="; string cliGuid = guidSql(email.Text); char[] cliGuidArray = cliGuid.ToCharArray(); Array.Reverse(cliGuidArray); string revCliGuid = new String(cliGuidArray); mm.Body = body1 + body2 + body3 + cliGuid +revCliGuid; mm.Subject = "Kentsel Dönüşüm Platformuna hoşgeldiniz!"; try { client.Send(mm); } catch (SmtpException smEx) { isimLbl.Text = smEx.ToString(); } Response.Redirect("kayitBasarili.aspx"); } catch (SqlException ex) { isimLbl.Text = ex.Message.ToString(); } //sqlConn.Close(); clearForm(); } }
public kullanici getUser(string email) { kullanici kull = new kullanici(); SqlConnection sqlConn = new SqlConnection(ConfigurationManager.ConnectionStrings["kentDon"].ConnectionString); SqlCommand sql = new SqlCommand("SELECT id, isim, soyad, eposta, sifre,guid FROM kullanici WHERE eposta = @email", sqlConn); sql.Parameters.AddWithValue("@email", email); sqlConn.Open(); SqlDataReader reader = sql.ExecuteReader(); while (reader.Read()) { kull.id = reader.GetInt32(0); kull.name = reader.GetString(1); kull.surName = reader.GetString(2); kull.email = reader.GetString(3); kull.pass = reader.GetString(4); kull.guid = reader.GetString(5); } sqlConn.Close(); return kull; }