private void Bindings() { using (admaticEntities con = new admaticEntities()) { var result = (from t0 in con.Musteriler where t0.INUSE == true orderby t0.ID ascending select new { t0.ID, t0.FirmaUnvan, t0.KisaAd, t0.VergiNo, t0.VergiDairesi, t0.Adres, t0.YetkiliKisi, t0.TelNo, t0.Mail, t0.OlusturulmaTarihi, t0.INUSE }).ToList(); if (result != null) { rptFirma.DataSource = result; rptFirma.DataBind(); } } }
private void Bindings() { using (admaticEntities con = new admaticEntities()) { int ID = Convert.ToInt32(Request.QueryString["ID"] == "" ? "0" : Request.QueryString["ID"]); if (ID != 0) { lblBaslik.Text = "Firma Bilgi Düzenle"; var result = con.Musteriler.Where(x => x.ID == ID).FirstOrDefault(); if (result != null) { txtFirmaUnvani.Text = result.FirmaUnvan; txtKisaAd.Text = result.KisaAd; txtVergiNo.Text = result.VergiNo; txtVergiDairesi.Text = result.VergiDairesi; txtYetkiliKisi.Text = result.YetkiliKisi; txtTelNo.Text = result.TelNo; txtMail.Text = result.Mail; txtAdres.Text = result.Adres; } } else { lblBaslik.Text = "Yeni Firma Ekle"; } } }
private void Bindings() { using (admaticEntities con = new admaticEntities()) { int FirmaID = Convert.ToInt32(Request.QueryString["Firma"] == "" ? "0" : Request.QueryString["Firma"]); var res = con.Musteriler.Where(x => x.ID == FirmaID).FirstOrDefault(); if (res != null) { lblKisaAd.Text = res.KisaAd; lblYeniFatura.Text = "<a class='ajax' id='colorboxa' href='TahsilatEkle.aspx?Firma=" + FirmaID + "'><div class='btn btn-default'>Yeni Fatura</div></a>"; lblTahsilat.Text = "<a class='ajax' id='colorboxa' href='TahsilatEkle.aspx?FirmaTahsilat=" + FirmaID + "'><div class='btn btn-blue'>Tahsilat Yap</div></a>"; DataSet ds = dbLayer.VadesiGelenMusteri(FirmaID); if (ds != null) { rptFirmaDetay.DataSource = ds.Tables[0]; rptFirmaDetay.DataBind(); rptFaturalar.DataSource = ds.Tables[1]; rptFaturalar.DataBind(); } } else { lblKisaAd.Text = "Hata Oluştu"; } } }
private void KullaniciBilgileri() { if ((BusinessLayer.WebUser)Session["WebUser"] != null) { _user = (BusinessLayer.WebUser)Session["WebUser"]; int KullaniciID = Convert.ToInt32(_user.KULLANICI_ID); lblAdSoyad.Text = _user.KULLANICI_ADI + " " + _user.KULLANICI_SOYADI; using (admaticEntities con = new admaticEntities()) { var result = (from t0 in con.Kullanici_Sayfa_Matrix join t1 in con.Sayfalar on t0.Sayfa_ID equals t1.ID where t0.Kullanici_ID == KullaniciID && t1.INUSE == true orderby t1.ID ascending select new { t1.ID, t1.Sayfa_Adi, t1.Sayfa_Url }).ToList(); if (result != null) { rptMenu.DataSource = result; rptMenu.DataBind(); } string linkGelenSayfaİsmi = Request.Path.ToString().Replace("/", ""); } } else { Response.Redirect("login.aspx"); } }
public static DataSet MusteriTahsilatNakitCekOdeme(int FirmaID) { using (admaticEntities con = new admaticEntities()) { try { SqlConnection conn = new SqlConnection(DBConnection()); SqlDataAdapter da = new SqlDataAdapter(); SqlCommand command = conn.CreateCommand(); command.CommandText = "MusteriTahsilatNakitCekOdeme"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@FirmaID", FirmaID)); command.CommandTimeout = 600; da.SelectCommand = command; DataSet ds = new DataSet(); conn.Open(); da.Fill(ds); conn.Close(); return ds; } catch (Exception e) { return null; } } }
private void Bindings() { int ID = Convert.ToInt32(Request.QueryString["ID"]); int Firma = Convert.ToInt32(Request.QueryString["Firma"]); int FirmaTahsilat = Convert.ToInt32(Request.QueryString["FirmaTahsilat"]); if (ID != 0 || Firma != 0) { dvYeniDuzenle.Visible = true; dvTahsilat.Visible = false; using (admaticEntities con = new admaticEntities()) { if (ID != 0) { lblBaslik.Text = "Fatura Düzenle"; var result = con.Faturalar.Where(x => x.ID == ID).FirstOrDefault(); if (result != null) { txtAciklama.Text = result.Aciklama; txtEtiket.Text = result.Etiket; txtRHB.Text = result.ReklamHizmetBilgisi; txtSeriNo.Text = result.FaturaSeriNo; txtSiraNo.Text = result.FaturaSiraNo; txtTutar.Text = result.FaturaTutar.ToString(); txtVade.Text = result.FaturaVade.ToString(); dpFDT.Text = result.FaturaDuzenlenmeTarihi.ToString(); drpIslemTuru.SelectedValue = result.IslemTuruID.ToString(); } } else { lblBaslik.Text = "Yeni Fatura Ekle"; } } } else if (FirmaTahsilat != 0) { dvYeniDuzenle.Visible = false; dvTahsilat.Visible = true; DataSet ds = dbLayer.MusteriTahsilatNakitCekOdeme(FirmaTahsilat); if (ds != null) { lblGecikmisTahsilat.Text = String.Format("{0:0.00}", ds.Tables[0].Rows.Count == 0 ? 0 : ds.Tables[0].Rows[0]["Gecikmis"]); lblYapilacakTahsilat.Text = String.Format("{0:0.00}", ds.Tables[1].Rows.Count == 0 ? 0 : ds.Tables[1].Rows[0]["Yapilacak"]); lblToplamTahsilat.Text = String.Format("{0:0.00}", ds.Tables[2].Rows.Count == 0 ? 0 : ds.Tables[2].Rows[0]["Toplam"]); } } }
private void Bindings() { using (admaticEntities con = new admaticEntities()) { DataTable result = dbLayer.FaturalariGetir(); if (result != null) { rptFatura.DataSource = result; rptFatura.DataBind(); } } }
protected void btnKaydet_Click(object sender, EventArgs e) { int Firma = Convert.ToInt32(Request.QueryString["Firma"]); int ID = Convert.ToInt32(Request.QueryString["ID"]); using (admaticEntities con = new admaticEntities()) { if (Firma != 0) { Faturalar myFatura = new Faturalar(); myFatura.Aciklama = txtAciklama.Text.Trim(); myFatura.Etiket = txtEtiket.Text.Trim(); myFatura.FaturaDuzenlenmeTarihi = Convert.ToDateTime(dpFDT.Text.Trim()); myFatura.FaturaSeriNo = txtSeriNo.Text.Trim(); myFatura.FaturaSiraNo = txtSiraNo.Text.Trim(); myFatura.FaturaTutar = Convert.ToDecimal(txtTutar.Text.Trim()); myFatura.FaturaVade = Convert.ToInt32(txtVade.Text.Trim()); myFatura.MusteriID = Firma; myFatura.OlusturulmaTarihi = DateTime.Now; myFatura.ReklamHizmetBilgisi = txtRHB.Text.Trim(); myFatura.Meblag = Convert.ToDecimal(txtTutar.Text.Trim()); myFatura.IslemTuruID = Convert.ToInt32(drpIslemTuru.SelectedValue); con.Faturalar.Add(myFatura); con.SaveChanges(); } else if (ID != 0) { Faturalar myFatura = new Faturalar(); myFatura = con.Faturalar.Where(x => x.ID == ID).FirstOrDefault(); if (myFatura != null) { myFatura.Aciklama = txtAciklama.Text.Trim(); myFatura.Etiket = txtEtiket.Text.Trim(); myFatura.FaturaDuzenlenmeTarihi = Convert.ToDateTime(dpFDT.Text.Trim()); myFatura.ReklamHizmetBilgisi = txtRHB.Text.Trim(); myFatura.FaturaSeriNo = txtSeriNo.Text.Trim(); myFatura.FaturaSiraNo = txtSiraNo.Text.Trim(); myFatura.FaturaTutar = Convert.ToDecimal(txtTutar.Text.Trim()); myFatura.FaturaVade = Convert.ToInt32(txtVade.Text.Trim()); myFatura.Meblag = Convert.ToDecimal(txtTutar.Text.Trim()); myFatura.IslemTuruID = Convert.ToInt32(drpIslemTuru.SelectedValue); con.SaveChanges(); } } } }
private void Bindings() { using (admaticEntities con = new admaticEntities()) { int FirmaID = 1; DataSet ds = dbLayer.VadesiGelenMusteri(FirmaID); if (ds != null) { rptFaturalar.DataSource = ds.Tables[1]; rptFaturalar.DataBind(); } } }
protected void btnLogin_Click(object sender, EventArgs e) { dvWarningMessage.InnerHtml = ""; string HashedPassword = Helper.PwHash(txtPassword.Text.Trim()); string EMail = txtEmail.Text.Trim(); using (admaticEntities con = new admaticEntities()) { try { RemoveInfoMessage("Hata oluştu"); Kullanicilar myKullanicilar = new Kullanicilar(); myKullanicilar = con.Kullanicilar.Where(x => x.Sifre == HashedPassword && x.Mail == EMail && x.INUSE == true).FirstOrDefault(); if (myKullanicilar != null) { RemoveInfoMessage("Hatalı kullanıcı adı veya şifre"); _user = new BusinessLayer.WebUser(); _user.KULLANICI_ADI = myKullanicilar.Ad; _user.KULLANICI_AKTIF = myKullanicilar.INUSE; _user.KULLANICI_ID = myKullanicilar.ID; _user.KULLANICI_MAIL = myKullanicilar.Mail; _user.KULLANICI_SIFRE = myKullanicilar.Sifre; _user.KULLANICI_SOYADI = myKullanicilar.Soyad; _user.OLUSTURULMA_TARIHI = myKullanicilar.OlusturulmaTarihi; Session["WebUser"] = _user; Response.Redirect("Firmalar.aspx", false); } else { AddInfoMessage("Hatalı kullanıcı adı veya şifre"); return; } } catch (Exception ex) { //Sistem Hatası AddInfoMessage("Hata oluştu"); return; } } }
protected void btnKaydet_Click(object sender, EventArgs e) { int ID = Convert.ToInt32(Request.QueryString["ID"] == "" ? "0" : Request.QueryString["ID"]); using (admaticEntities con = new admaticEntities()) { if (ID != 0) { Musteriler myMusteriler = new Musteriler(); myMusteriler = con.Musteriler.Where(x => x.ID == ID).FirstOrDefault(); if (myMusteriler != null) { myMusteriler.FirmaUnvan = txtFirmaUnvani.Text.Trim(); myMusteriler.KisaAd = txtKisaAd.Text.Trim(); myMusteriler.VergiNo = txtVergiNo.Text.Trim(); myMusteriler.VergiDairesi = txtVergiDairesi.Text.Trim(); myMusteriler.YetkiliKisi = txtYetkiliKisi.Text.Trim(); myMusteriler.TelNo = txtTelNo.Text.Trim().Replace("(", "").Replace(")", "").Replace(" ", "");; myMusteriler.Mail = txtMail.Text.Trim(); myMusteriler.Adres = txtAdres.Text.Trim(); con.SaveChanges(); } } else { Musteriler myMusteri = new Musteriler(); myMusteri.FirmaUnvan = txtFirmaUnvani.Text.Trim(); myMusteri.KisaAd = txtKisaAd.Text.Trim(); myMusteri.VergiNo = txtVergiNo.Text.Trim(); myMusteri.VergiDairesi = txtVergiDairesi.Text.Trim(); myMusteri.Adres = txtAdres.Text.Trim(); myMusteri.YetkiliKisi = txtYetkiliKisi.Text.Trim(); myMusteri.TelNo = txtTelNo.Text.Trim().Replace("(", "").Replace(")", "").Replace(" ", ""); myMusteri.Mail = txtMail.Text.Trim(); myMusteri.INUSE = true; myMusteri.OlusturulmaTarihi = DateTime.Now; con.Musteriler.Add(myMusteri); con.SaveChanges(); } } }
protected void rptFirma_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Sil") { int ID = Convert.ToInt32(((Button)e.Item.FindControl("btnSil")).CommandArgument); using (admaticEntities con = new admaticEntities()) { Musteriler myMusteriler = con.Musteriler.Where(x => x.ID == ID).FirstOrDefault(); if (myMusteriler != null) { myMusteriler.INUSE = false; con.SaveChanges(); Bindings(); } } } }
protected void rptFaturalar_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "Sil") { int ID = Convert.ToInt32(((Button)e.Item.FindControl("btnSil")).CommandArgument); using (admaticEntities con = new admaticEntities()) { Faturalar myFatura = con.Faturalar.Where(x => x.ID == ID).FirstOrDefault(); if (myFatura != null) { con.Faturalar.Remove(myFatura); con.SaveChanges(); Bindings(); } } } }
public static DataTable FaturalariGetir() { using (admaticEntities con = new admaticEntities()) { try { DataTable dtTransactions = new DataTable(); con.Database.Connection.Open(); var command = con.Database.Connection.CreateCommand(); command.CommandText = "FaturalariGetir"; dtTransactions.Load(command.ExecuteReader()); con.Database.Connection.Close(); return dtTransactions; } catch { return null; } } }
protected void rptDuzenle_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "DuzenleKaydet") { int ID = Convert.ToInt32(((Button)e.Item.FindControl("btnDuzenleKaydet")).CommandArgument); TextBox Aciklama = (TextBox)e.Item.FindControl("txtDAciklama"); TextBox Etiket = (TextBox)e.Item.FindControl("txtDEtiket"); TextBox FaturaDuzenlenmeTarihi = (TextBox)e.Item.FindControl("txtDFDT"); TextBox ReklamHizmetBilgisi = (TextBox)e.Item.FindControl("txtDRHB"); TextBox FaturaSeriNo = (TextBox)e.Item.FindControl("txtDSeriNo"); TextBox FaturaSiraNo = (TextBox)e.Item.FindControl("txtDSiraNo"); TextBox FaturaTutar = (TextBox)e.Item.FindControl("txtDTutar"); TextBox FaturaVade = (TextBox)e.Item.FindControl("txtDVade"); using (admaticEntities con = new admaticEntities()) { Faturalar myFatura = new Faturalar(); myFatura = con.Faturalar.Where(x => x.ID == ID).FirstOrDefault(); if (myFatura != null) { myFatura.Aciklama = Aciklama.Text.Trim(); myFatura.Etiket = Etiket.Text.Trim(); myFatura.FaturaDuzenlenmeTarihi = Convert.ToDateTime(FaturaDuzenlenmeTarihi.Text.Trim()); myFatura.ReklamHizmetBilgisi = ReklamHizmetBilgisi.Text.Trim(); myFatura.FaturaSeriNo = FaturaSeriNo.Text.Trim(); myFatura.FaturaSiraNo = FaturaSiraNo.Text.Trim(); myFatura.FaturaTutar = Convert.ToDecimal(FaturaTutar.Text.Trim()); myFatura.FaturaVade = Convert.ToInt32(FaturaVade.Text.Trim()); con.SaveChanges(); Bindings(); } } } }
protected void rptDuzenle_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName == "DuzenleKaydet") { int ID = Convert.ToInt32(((Button)e.Item.FindControl("btnDuzenleKaydet")).CommandArgument); TextBox FirmaUnvan = (TextBox)e.Item.FindControl("txtDFirmaUnvan"); TextBox KisaAd = (TextBox)e.Item.FindControl("txtDKisaAd"); TextBox VergiNo = (TextBox)e.Item.FindControl("txtDVergiNo"); TextBox VergiDairesi = (TextBox)e.Item.FindControl("txtDVergiDairesi"); TextBox YetkiliKisi = (TextBox)e.Item.FindControl("txtDYetkiliKisi"); TextBox TelNo = (TextBox)e.Item.FindControl("txtDTelNo"); TextBox Mail = (TextBox)e.Item.FindControl("txtDMail"); TextBox Adres = (TextBox)e.Item.FindControl("txtDAdres"); using (admaticEntities con = new admaticEntities()) { Musteriler myMusteriler = new Musteriler(); myMusteriler = con.Musteriler.Where(x => x.ID == ID).FirstOrDefault(); if (myMusteriler != null) { myMusteriler.FirmaUnvan = FirmaUnvan.Text.Trim(); myMusteriler.KisaAd = KisaAd.Text.Trim(); myMusteriler.VergiNo = VergiNo.Text.Trim(); myMusteriler.VergiDairesi = VergiDairesi.Text.Trim(); myMusteriler.YetkiliKisi = YetkiliKisi.Text.Trim(); myMusteriler.TelNo = TelNo.Text.Trim().Replace("(", "").Replace(")", "").Replace(" ", "");; myMusteriler.Mail = Mail.Text.Trim(); myMusteriler.Adres = Adres.Text.Trim(); con.SaveChanges(); Bindings(); } } } }
public static int MusteriTahsilatEkle(int FirmaID, decimal TahsilatTutar, int HesapID, string Aciklama, string TahsilatTipi, DateTime TahsilatTarihi, DateTime? TahsilatVadeTarihi) { using (admaticEntities con = new admaticEntities()) { try { int result; con.Database.Connection.Open(); var command = con.Database.Connection.CreateCommand(); command.CommandText = "MusteriTahsilatEkle"; command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@FirmaID", FirmaID)); command.Parameters.Add(new SqlParameter("@TahsilatTutar", TahsilatTutar)); command.Parameters.Add(new SqlParameter("@HesapID", HesapID)); command.Parameters.Add(new SqlParameter("@Aciklama", Aciklama)); command.Parameters.Add(new SqlParameter("@TahsilatTipi", TahsilatTipi)); command.Parameters.Add(new SqlParameter("@TahsilatTarihi", TahsilatTarihi)); if (TahsilatVadeTarihi.HasValue) { command.Parameters.Add(new SqlParameter("@TahsilatVadeTarihi", TahsilatVadeTarihi.Value)); } else { command.Parameters.Add(new SqlParameter("@TahsilatVadeTarihi", DBNull.Value)); } command.CommandTimeout = 600; result = Convert.ToInt32(command.ExecuteScalar()); con.Database.Connection.Close(); return result; } catch (Exception e) { return 0; } } }
private void BindDrp() { using (admaticEntities con = new admaticEntities()) { var result = (from t0 in con.Hesaplar where t0.INUSE == true select new { t0.ID, t0.HesapAdi }).ToList(); drpNHesap.DataSource = result; drpNHesap.DataValueField = "ID"; drpNHesap.DataTextField = "HesapAdi"; drpNHesap.DataBind(); drpCHesap.DataSource = result; drpCHesap.DataValueField = "ID"; drpCHesap.DataTextField = "HesapAdi"; drpCHesap.DataBind(); ListItem item = new ListItem(); item.Text = "Seçiniz"; item.Value = "0"; drpNHesap.Items.Insert(0, item); drpCHesap.Items.Insert(0, item); } }