private void btnsil_Click(object sender, EventArgs e)
        {
            DialogResult cvp = MessageBox.Show("Emin misiniz?", "Silme Onayı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (cvp == DialogResult.No)
            {
                return;
            }

            MusteriBL mbl = new MusteriBL();

            try
            {
                if (mbl.MusteriSil(musteriid))
                {
                    MessageBox.Show("Silme Başarılı'");
                }
                else
                {
                    MessageBox.Show("Silme Hatalı!!");
                }
                Temizle();
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                mbl.Dispose();
            }
        }
Пример #2
0
        private void btnkaydet_Click(object sender, EventArgs e)
        {
            MusteriBL mbl = new MusteriBL();

            foreach (DataRow item in dt.Rows)
            {
                MODEL.Musteri m = new MODEL.Musteri();
                if (item.RowState != DataRowState.Deleted)
                {
                    m.Musteriad    = item["Musteriad"].ToString();
                    m.Musterisoyad = item["Musterisoyad"].ToString();
                    m.Mustericep   = item["Mustericep"].ToString();
                    m.Musterimail  = item["Musterimail"].ToString();
                    m.Musteriadres = item["Musteriadres"].ToString();
                }
                switch (item.RowState)
                {
                case DataRowState.Added:
                    mbl.MusteriEkle(m);
                    break;

                case DataRowState.Deleted:
                    mbl.MusteriSil((int)item["MusteriId", DataRowVersion.Original]);
                    break;

                case DataRowState.Modified:
                    m.Musteriid = (int)item["MusteriId"];
                    mbl.MusteriGuncelle(m);
                    break;

                default:
                    break;
                }
            }
        }
Пример #3
0
        private void Msuteri_Sil_Button_Click(object sender, EventArgs e)
        {
            Musteri   mstr = new Musteri();
            MusteriBL mb   = new MusteriBL();

            mstr.Musteri_kod = musterSiltextbox.Text;
            mb.MusteriSil(mstr);
            mb.SaveChanges();
        }
Пример #4
0
        private void BtnSil_Click(object sender, EventArgs e)
        {
            DialogResult cvp = MessageBox.Show("Kayıt Silinecek. Emin misiniz?", "Silme Onayı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (cvp == DialogResult.Yes)
            {
                MusteriBL mbl = new MusteriBL();
                if (mbl.MusteriSil(MusteriID))
                {
                    Temizle();
                    MessageBox.Show("Silme Başarılı!");
                }
                else
                {
                    MessageBox.Show("Silme hatalı!");
                }
                mbl.Dispose();
            }
        }
Пример #5
0
        private void btnKaydet_Click(object sender, EventArgs e)
        {
            MusteriBL mbl = new MusteriBL();

            foreach (DataRow item in dt.Rows)
            {
                Musteri m = new Musteri();
                if (item.RowState != DataRowState.Deleted)
                {
                    m.Ad      = item[1].ToString();
                    m.Soyad   = item[2].ToString();
                    m.Telefon = item[3].ToString();
                    m.Sifre   = item[4].ToString();
                    m.EPosta  = item[5].ToString();
                    m.Adres   = item[6].ToString();
                    m.TCKNo   = item[7].ToString();
                }

                switch (item.RowState)
                {
                case DataRowState.Added:
                    mbl.Kaydet(m);
                    break;

                case DataRowState.Deleted:
                    mbl.MusteriSil(Convert.ToInt32(item[0, DataRowVersion.Original]));
                    break;

                case DataRowState.Modified:
                    m.Musteriid = Convert.ToInt32(item[0]);
                    mbl.Guncelle(m);
                    break;

                default:
                    break;
                }
            }
        }
Пример #6
0
        private void btnKaydet_Click(object sender, EventArgs e)
        {
            MusteriBL mbl = new MusteriBL();

            foreach (DataRow item in dt.Rows)
            {
                Musteri m = new Musteri();
                if (item.RowState != DataRowState.Deleted)
                {
                    m.TcKNo  = item[1].ToString();
                    m.Ad     = item[2].ToString();
                    m.Soyad  = item[3].ToString();
                    m.GirTar = Convert.ToDateTime(item[4]);
                    m.CikTar = Convert.ToDateTime(item[5]);
                    m.OdaNo  = Convert.ToInt32(item[6]);
                }
                switch (item.RowState)
                {
                case DataRowState.Added:
                    mbl.MusteriEkle(m);
                    break;

                case DataRowState.Deleted:
                    mbl.MusteriSil(Convert.ToInt32(item[0, DataRowVersion.Original]));
                    break;

                case DataRowState.Modified:
                    m.MusteriKayitID = Convert.ToInt32(item[0]);
                    mbl.MusteriGuncelle(m);
                    break;

                default:
                    break;
                }
            }
        }