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);
}
}
