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();
        }
Esempio n. 3
0
        public static ECARD show_Card_item(int a)
        {
            ECARD item = new ECARD();

            try
            {
                SqlCommand com = new SqlCommand("show_card_item", 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.CardNo      = Convert.ToInt32(rdr["CardNo"]);
                        item.CCV         = Convert.ToInt32(rdr["CCV"]);
                        item.SKT         = Convert.ToInt32(rdr["SKT"]);
                        item.FakeBalance = Convert.ToInt32(rdr["FakeBalance"]);
                    }
                }
                com.Connection.Close();
                rdr.Close();
            }
            catch
            {
            }

            return(item);
        }
Esempio n. 4
0
        public static int update_Card(ECARD item)
        {
            int satir = -1;

            try
            {
                SqlCommand com = new SqlCommand("update_Card", FCONNECTION.conn);
                com.CommandType = CommandType.StoredProcedure;

                if (com.Connection.State != ConnectionState.Open)
                {
                    com.Connection.Open();
                }
                com.Parameters.AddWithValue("CardNo", item.CardNo);
                com.Parameters.AddWithValue("SKT", item.SKT);
                com.Parameters.AddWithValue("CCV", item.CCV);
                com.Parameters.AddWithValue("FakeBalance", item.FakeBalance);
                com.Parameters.AddWithValue("UsersID", item.UsersID);
                satir = com.ExecuteNonQuery();
                com.Connection.Close();
            }
            catch
            {
                satir = -1;
            }
            return(satir);
        }
        private void kart_ekle_buton_Click(object sender, EventArgs e)
        {
            arayuzayar.SelectedIndex = 1;
            ECARD item = BLLCARD.show_Card_item(UserIDNo);

            Card_No.Text      = item.CardNo.ToString();
            SKT.Text          = item.SKT.ToString();
            CCV.Text          = item.CCV.ToString();
            Fake_Balance.Text = item.FakeBalance.ToString();
        }
        private void CardEkle_Click(object sender, EventArgs e)
        {
            int var1_yok0 = BLLCARD.Card_kontrol(UserIDNo);

            if (var1_yok0 == 1)
            {
                ECARD item = new ECARD();
                item.CardNo      = Convert.ToInt32(Card_No.Text);
                item.SKT         = Convert.ToInt32(SKT.Text);
                item.CCV         = Convert.ToInt32(CCV.Text);
                item.FakeBalance = Convert.ToInt32(Fake_Balance.Text);
                item.UsersID     = UserIDNo;

                if (BLLCARD.update_Card(item) == -1)
                {
                    MessageBox.Show("Ekleme hatasi");
                }
                //update
            }
            else if (var1_yok0 == 0)
            {
                ECARD item = new ECARD();
                item.CardNo      = Convert.ToInt32(Card_No.Text);
                item.SKT         = Convert.ToInt32(SKT.Text);
                item.CCV         = Convert.ToInt32(CCV.Text);
                item.FakeBalance = Convert.ToInt32(Fake_Balance.Text);
                item.UsersID     = UserIDNo;

                if (BLLCARD.insert_Card(item) == -1)
                {
                    MessageBox.Show("Ekleme hatasi");
                }
                //insert
            }
            arayuzayar.SelectedIndex = 0;
            kullanici_arayuz_bilgi();
        }
Esempio n. 7
0
 public static int update_Card(ECARD item)
 {
     return(FCARD.update_Card(item));
 }
Esempio n. 8
0
 public static int insert_Card(ECARD item)
 {
     return(FCARD.insert_Card(item));
 }