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 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();
}
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();
}
public static int update_user(EUSERS item)
{
int satir = -1;
try
{
SqlCommand com = new SqlCommand("UPDATE_USER", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("ID", item.ID);
com.Parameters.AddWithValue("Username", item.Username);
com.Parameters.AddWithValue("Name", item.Name);
com.Parameters.AddWithValue("Surname", item.Surname);
com.Parameters.AddWithValue("Email", item.Email);
satir = com.ExecuteNonQuery();
com.Connection.Close();
}
catch
{
satir = -1;
}
return(satir);
}
public static int User_ID_al(string name)
{
EUSERS item = new EUSERS();
SqlCommand com2 = new SqlCommand("User_ID_al", FCONNECTION.conn);
com2.CommandType = CommandType.StoredProcedure;
com2.Parameters.AddWithValue("Username", name);
if (com2.Connection.State != ConnectionState.Open)
{
com2.Connection.Open();
}
SqlDataReader rdr = com2.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.ID = Convert.ToInt32(rdr["ID"]);
}
}
com2.Connection.Close();
rdr.Close();
return(item.ID);
}
private void girisYap_Click(object sender, EventArgs e)
{
EUSERS item = new EUSERS();
item.Username = email_giris.Text;
item.Email = email_giris.Text;
item.Pass = sifre_giris.Text;
if (BLLUSERS.Login(item, ref UserIDNo) == 1)
{
MessageBox.Show("Basariyla giris yaptiniz.");
}
else
{
MessageBox.Show("Giris hatasi");
}
TabloUst.SelectedIndex = 0;
}
private void incele1_Click(object sender, EventArgs e)
{
TABLO.SelectedIndex = 1;
//if(sol1sag2==1)
EPICTURE resim1 = resim_yolu(temp_UrunID);
UrunAlPic.ImageLocation = resim1.PicDirectory;
urunID.Text = temp_UrunID.ToString();
UsersID.Text = TempUsersID.Text;
tempurunID1.Text = temp_UrunID.ToString();
EPRODUCT deger = BLLPRODUCT.urun_listele(temp_UrunID);//sayfa no
urun_ad.Text = deger.Name;
urun_fiyat.Text = deger.Price.ToString();
EUSERS deger2 = BLLUSERS.kullanici_ismi(Convert.ToInt32(UsersID.Text));
urun_sahibi.Text = "(" + deger2.Username + ") " + deger2.Name + " " + deger2.Surname;
}
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 int get_user_ID(EUSERS item)
{
SqlCommand com2 = new SqlCommand("get_UserID", FCONNECTION.conn);
com2.CommandType = CommandType.StoredProcedure;
com2.Parameters.AddWithValue("Username", item.Username);
com2.Parameters.AddWithValue("Email", item.Email);
com2.Parameters.AddWithValue("Pass", item.Pass);
SqlDataReader rdr = com2.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.ID = Convert.ToInt32(rdr["ID"]);
}
}
com2.Connection.Close();
rdr.Close();
return(item.ID);
}
public static int Login(EUSERS item, ref int UserIDNo)
{
int temp;
SqlCommand com = new SqlCommand("SEARCH_USER", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("Username", item.Username);
com.Parameters.AddWithValue("Email", item.Email);
com.Parameters.AddWithValue("Pass", item.Pass);
temp = (Int32)com.ExecuteScalar();
SqlCommand com2 = new SqlCommand("get_UserID", FCONNECTION.conn);
com2.CommandType = CommandType.StoredProcedure;
com2.Parameters.AddWithValue("Username", item.Username);
com2.Parameters.AddWithValue("Email", item.Email);
com2.Parameters.AddWithValue("Pass", item.Pass);
SqlDataReader rdr = com2.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.ID = Convert.ToInt32(rdr["ID"]);
}
}
UserIDNo = item.ID;
com2.Connection.Close();
rdr.Close();
return(temp);
}
private void calisan_atama_Click(object sender, EventArgs e)
{
arayuzayar.SelectedIndex = 0;
EUSERS item = new EUSERS();
item.Username = secilen_kisi.Text;
int kullanici_ID = BLLUSERS.User_ID_al(item.Username);
if (atanacak_poz_combobox.Text == "Normal")
{
BLLUSERS.set_user_mode(kullanici_ID, 0);
//Employee tablosundan sil
}
else if (atanacak_poz_combobox.Text == "Calisan")
{
BLLUSERS.set_user_mode(kullanici_ID, 1);
//Employee tablosuna ekle ID
}
else if (atanacak_poz_combobox.Text == "Yonetici")
{
BLLUSERS.set_user_mode(kullanici_ID, 2);
//Employe tablosundan sil
}
}
public static EUSERS kullanici_ismi(int a)
{
EUSERS item = new EUSERS();
try
{
SqlCommand com = new SqlCommand("user_name_satin", FCONNECTION.conn);
com.CommandType = CommandType.StoredProcedure;
if (com.Connection.State != ConnectionState.Open)
{
com.Connection.Open();
}
com.Parameters.AddWithValue("ID", a);
SqlDataReader rdr = com.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
item.Username = rdr["Username"].ToString();
item.Name = rdr["Name"].ToString();
item.Surname = rdr["Surname"].ToString();
item.Email = rdr["Email"].ToString();
item.Mode = Convert.ToInt32(rdr["Mode"]);
}
}
com.Connection.Close();
rdr.Close();
}
catch
{
}
return(item);
}
public static int update_user(EUSERS item)
{
return(FUSERS.update_user(item));
}
public static int get_user_ID(EUSERS item)
{
return(FUSERS.get_user_ID(item));
}
public static int Login(EUSERS item, ref int UserIDNo)
{
return(FUSERS.Login(item, ref UserIDNo));
}
public static int Insert(EUSERS item)
{
return(FUSERS.Insert(item));
}
