Пример #1
0
    protected void ButtonCsv_Click(object sender, EventArgs e)
    {
        MusteriBsWrapper wrapper = new MusteriBsWrapper();
        DataTable        dt      = wrapper.SorgulaHepsiniGetirDataTable();

        this.ExportHelper.ToCsv(dt, "Deneme", "csv", false, Encoding.UTF8);
    }
    protected void ButtonExcelDataView2_Click(object sender, EventArgs e)
    {
        DataTable dt = new MusteriBsWrapper().SorgulaHepsiniGetirDataTable();

        DataView dv = new DataView(dt, "Adi LIKE 'a%'", "Adi ASC", DataViewRowState.OriginalRows);

        this.ExportHelper.ToExcel(dv, "Musteri");
    }
    protected void ButtonExcelDataTable3_Click(object sender, EventArgs e)
    {
        DataTable dt = new MusteriBsWrapper().SorgulaHepsiniGetirDataTable();

        dt.Columns["Adi"].Caption    = "Adı";
        dt.Columns["Soyadi"].Caption = "Soyadı";

        this.ExportHelper.ToExcel(dt, "Musteri", true);
    }
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         MusteriBsWrapper wrapper = new MusteriBsWrapper();
         DataTable        dt      = wrapper.SorgulaAdiSoyadiVeDurumuIle("", "", true);
         this.ListHelper.ListControlaBindEt(dt, MusteriDropDownList, "MusteriKey", "TamAdi");
         this.ListHelper.ListControlaBindEtLutfenEkle(dt, MusteriLutfenDropDownList, "MusteriKey", "TamAdi");
     }
 }
    protected void ButtonExcelDataView3_Click(object sender, EventArgs e)
    {
        DataTable dt = new MusteriBsWrapper().SorgulaHepsiniGetirDataTable();

        dt.Columns["Adi"].Caption    = "Adı";
        dt.Columns["Soyadi"].Caption = "Soyadı";


        DataView dv = new DataView(dt, "Adi LIKE 'a%'", "Adi ASC", DataViewRowState.OriginalRows);

        this.ExportHelper.ToExcel(dv, "Musteri", false);
    }
Пример #6
0
    protected void ButtonKaydet_Click(object sender, EventArgs e)
    {
        try
        {
            Musteri          musteri   = new Musteri();
            MusteriBsWrapper musteriWp = new MusteriBsWrapper();
            musteri.Adi = TextBoxAdi.Text;
            if (CheckBoxAktifmi.Checked)
            {
                musteri.AktifMi = true;
            }
            else
            {
                musteri.AktifMi = false;
            }
            musteri.DogumTarihi = Convert.ToDateTime(TextBoxDogumTarihi.Text);
            musteri.IkinciAdi   = TextBoxIkinciAdi.Text;
            musteri.Soyadi      = TextBoxSoyadi.Text;

            if (Request.QueryString["Durum"] == "Guncelle")
            {
                musteri.MusteriKey = new Guid(Request.QueryString["MusteriKey"].ToString());
                musteriWp.Guncelle(musteri);
            }
            else
            {
                musteri.MusteriKey = Guid.NewGuid();
                musteriWp.Ekle(musteri);
            }
            MessageBox("Müşteri Kaydedilmiştir", MesajTuruEnum.Basari);
        }
        catch (Exception exc)
        {
            MessageBox("Müşteri Kaydedilirken bir hata ile karşılaşıldı. Hata Metni : " + exc.Message, MesajTuruEnum.Basari);
        }
    }
Пример #7
0
 private void BilgileriGetir()
 {
     if (Request.QueryString["Durum"] == "Guncelle")
     {
         Musteri          musteri   = new Musteri();
         MusteriBsWrapper musteriWp = new MusteriBsWrapper();
         musteri = musteriWp.SorgulaMusteriKeyIle(new Guid(Request.QueryString["MusteriKey"].ToString()));
         if (musteri != null)
         {
             TextBoxAdi.Text         = musteri.Adi;
             TextBoxDogumTarihi.Text = musteri.DogumTarihi.Value.ToShortDateString();
             TextBoxIkinciAdi.Text   = musteri.IkinciAdi;
             TextBoxSoyadi.Text      = musteri.Soyadi;
             if (musteri.AktifMi)
             {
                 CheckBoxAktifmi.Checked = true;
             }
             else
             {
                 CheckBoxAktifmi.Checked = false;
             }
         }
     }
 }