private void arayuz_bilgi_duzenle_Click(object sender, EventArgs e)
{
EUSERS item = new EUSERS();
item.ID = UserIDNo;
item.Username = ARkullaniciadi.Text;
item.Name = ARadi.Text;
item.Surname = ARsoyadi.Text;
item.Email = ARemail.Text;
BLLUSERS.update_user(item);
EADDRESS item2 = new EADDRESS();
item2.Cadde = ARcadde.Text;
item2.Street = ARsokak.Text;
item2.City = ARil.Text;
item2.Town = ARilce.Text;
item2.Num = Convert.ToInt32(ARno.Text);
item2.UsersID = UserIDNo;
BLLADDRESS.update_address(item2);
arayuzayar.SelectedIndex = 0;
kullanici_arayuz_bilgi();
}
private void arayuzBilgiDuzenle_Click(object sender, EventArgs e)
{
arayuzayar.SelectedIndex = 2;
EUSERS item = BLLUSERS.kullanici_ismi(UserIDNo);
ARkullaniciadi.Text = item.Username;
ARadi.Text = item.Name;
ARsoyadi.Text = item.Surname;
ARemail.Text = item.Email;
int temp = item.Mode;
if (temp == 0)
{
ARpozisyon.Text = "Normal kullanici";
}
else if (temp == 1)
{
ARpozisyon.Text = "Calisan uye";
}
else if (temp == 2)
{
ARpozisyon.Text = "Admin";
}
ECARD item2 = BLLCARD.show_Card_item(UserIDNo);
ARbakiye.Text = item2.FakeBalance.ToString();
EADDRESS item3 = BLLADDRESS.show_Address_item(UserIDNo);
ARcadde.Text = item3.Cadde;
ARsokak.Text = item3.Street;
ARil.Text = item3.City;
ARilce.Text = item3.Town;
ARno.Text = item3.Num.ToString();
}
private void kullanici_arayuz_bilgi()
{
EUSERS item = BLLUSERS.kullanici_ismi(UserIDNo);
Akullaniciadi.Text = item.Username;
Aadi.Text = item.Name;
Asoyadi.Text = item.Surname;
Aemail.Text = item.Email;
int temp = item.Mode;
if (temp == 0)
{
Apozisyon.Text = "Normal kullanici";
}
else if (temp == 1)
{
Apozisyon.Text = "Calisan uye";
}
else if (temp == 2)
{
Apozisyon.Text = "Admin";
}
ECARD item2 = BLLCARD.show_Card_item(UserIDNo);
Abakiye.Text = item2.FakeBalance.ToString();
EADDRESS item3 = BLLADDRESS.show_Address_item(UserIDNo);
Acadde.Text = item3.Cadde;
Asokak.Text = item3.Street;
Ail.Text = item3.City;
Ailce.Text = item3.Town;
Ano.Text = item3.Num.ToString();
}
public static int update_address(EADDRESS item2)
{
int satir = -1;
try
{
SqlCommand com = new SqlCommand("ADRES_GUNCELLE", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("Cadde", item2.Cadde);
com.Parameters.AddWithValue("Street", item2.Street);
com.Parameters.AddWithValue("City", item2.City);
com.Parameters.AddWithValue("town", item2.Town);
com.Parameters.AddWithValue("Num", item2.Num);
com.Parameters.AddWithValue("UsersID", item2.UsersID);
satir = com.ExecuteNonQuery();
com.Connection.Close();
}
catch
{
satir = -1;
}
return(satir);
}
private void kayitol_Click(object sender, EventArgs e)
{
if (string.Compare(sifre.Text, sifre2.Text) == 0)
{
EUSERS item = new EUSERS();
item.Username = username.Text;
item.Pass = sifre.Text;
item.Name = name.Text;
item.Surname = surname.Text;
item.Email = email.Text;
item.SecurityAnswer = gizlisoru.Text;
if (BLLUSERS.Insert(item) > 0)
{
int temp_user_ID = BLLUSERS.get_user_ID(item);
EADDRESS item2 = new EADDRESS();
item2.Cadde = Cadde.Text;
item2.Street = Sokak.Text;
item2.City = il.Text;
item2.Town = ilce.Text;
item2.Num = Convert.ToInt32(no.Text);
item2.UsersID = temp_user_ID;
BLLADDRESS.insert_Address(item2);
MessageBox.Show("Basariyla kayit oldunuz.");
}
else
{
MessageBox.Show("Kayit hatasi");
}
}
else
{
MessageBox.Show("Sifreler uyusmuyor!");
}
TabloUst.SelectedIndex = 1;
}
public static EADDRESS show_Address_item(int a)
{
EADDRESS item = new EADDRESS();
try
{
SqlCommand com = new SqlCommand("ADRES_GOSTER", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("UsersID", a);
SqlDataReader rdr = com.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.Cadde = rdr["Cadde"].ToString();
item.Street = rdr["Street"].ToString();
item.Town = rdr["town"].ToString();
item.City = rdr["City"].ToString();
item.Num = Convert.ToInt32(rdr["Num"]);
}
}
com.Connection.Close();
rdr.Close();
}
catch
{
}
return(item);
}
public static int update_address(EADDRESS item)
{
return(FADDRESS.update_address(item));
}
public static int insert_Address(EADDRESS item2)
{
return(FADDRESS.insert_Address(item2));
}
