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