public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_ziyaretciInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pIp", Ip)
, new OleDbParameter("pDil", Dil)
, new OleDbParameter("pSistem", Sistem)
, new OleDbParameter("pBrowser", Browser)
, new OleDbParameter("pTarih", Tarih.ToString())
, new OleDbParameter("pLink", Link)
, new OleDbParameter("pGonderen", Gonderen)
, new OleDbParameter("pDurum", Durum)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public static List <ayar> SelectAll()
{
OleDbCommand komut = new OleDbCommand("select * from ayar");
komut.CommandType = CommandType.Text;
return(SistemDAL.SelectAllayar(komut));
}
public static List <iletisim> SelectAll()
{
OleDbCommand komut = new OleDbCommand("select * from iletisim");
komut.CommandType = CommandType.Text;
return(SistemDAL.SelectAlliletisim(komut));
}
public static iletisim Select(int Id)
{
OleDbCommand komut = new OleDbCommand("select * from iletisim where Id=" + Id + "");
komut.CommandType = CommandType.Text;
return(SistemDAL.Selectiletisim(komut));
}
public static kullanici Select(int Id)
{
OleDbCommand komut = new OleDbCommand("select * from kullanici where Id=" + Id + "");
komut.CommandType = CommandType.Text;
return(SistemDAL.Selectkullanici(komut));
}
public static List <Toplam> SelectAll()
{
OleDbCommand komut = new OleDbCommand("usp_ToplamSelectAll");
komut.CommandType = CommandType.StoredProcedure;
return(SistemDAL.SelectAllToplam(komut));
}
public Result <int> Update()
{
OleDbCommand komut = new OleDbCommand("usp_iletisimUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pId", Id)
, new OleDbParameter("pIsim", Isim)
, new OleDbParameter("pEmail", Email)
, new OleDbParameter("pKonu", Konu)
, new OleDbParameter("pMesaj", Mesaj)
, new OleDbParameter("pDurum", Durum)
, new OleDbParameter("pTarih", Tarih.ToString())
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public int Insert()
{
OleDbCommand komut = new OleDbCommand("usp_hataInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pHelpLink", HelpLink)
, new OleDbParameter("pInnerException", InnerException)
, new OleDbParameter("pMessage", Message)
, new OleDbParameter("pSource", Source)
, new OleDbParameter("pStackTrace", StackTrace)
, new OleDbParameter("pTargetSite", TargetSite)
, new OleDbParameter("pTarih", Tarih.ToString())
, new OleDbParameter("pFkKullanici", FkKullanici)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.Execute(komut));
}
public static List <SayacIp> SelectAll()
{
OleDbCommand komut = new OleDbCommand("usp_SayacIpSelectAll");
komut.CommandType = CommandType.StoredProcedure;
return(SistemDAL.SelectAllSayacIp(komut));
}
public static List <hata> SelectAll()
{
OleDbCommand komut = new OleDbCommand("select * from hata");
komut.CommandType = CommandType.Text;
return(SistemDAL.SelectAllhata(komut));
}
public static ayar Select(int Id)
{
OleDbCommand komut = new OleDbCommand("select * from ayar where Id=" + Id + "");
komut.CommandType = CommandType.Text;
return(SistemDAL.Selectayar(komut));
}
public static ayar Select()
{
OleDbCommand komut = new OleDbCommand("select top 1 * from ayar");
komut.CommandType = CommandType.Text;
return(SistemDAL.Selectayar(komut));
}
public static List <kullanici> SelectAll()
{
OleDbCommand komut = new OleDbCommand("select * from kullanici");
komut.CommandType = CommandType.Text;
return(SistemDAL.SelectAllkullanici(komut));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_kullaniciInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pAdiSoyadi", AdiSoyadi)
, new OleDbParameter("pKullaniciAdi", KullaniciAdi)
, new OleDbParameter("pSifre", Sifre)
, new OleDbParameter("pMail", Mail)
, new OleDbParameter("pTel", Tel)
, new OleDbParameter("pAdres", Adres)
, new OleDbParameter("pAdminMi", AdminMi)
, new OleDbParameter("pDurum", Durum)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public static aktivite SelectByKullaniciId(Int32 Id)
{
OleDbCommand komut = new OleDbCommand("usp_aktiviteSelectByKullaniciId");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pKullaniciId", Id)
};
komut.Parameters.AddRange(parametreler);
return(SistemDAL.Selectaktivite(komut));
}
public static SayacIp Select(int IpId)
{
OleDbCommand komut = new OleDbCommand("usp_SayacIpSelect");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pIpId", IpId)
};
komut.Parameters.AddRange(parametreler);
return(SistemDAL.SelectSayacIp(komut));
}
public static sayac Select(string Tarih, int Gunluk, int Aylik, int Yillik, int Toplam)
{
OleDbCommand komut = new OleDbCommand("usp_sayacSelect");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pTarih", Tarih)
, new OleDbParameter("@pGunluk", Gunluk)
, new OleDbParameter("@pAylik", Aylik)
, new OleDbParameter("@pYillik", Yillik)
, new OleDbParameter("@pToplam", Toplam)
};
komut.Parameters.AddRange(parametreler);
return(SistemDAL.Selectsayac(komut));
}
public static int Temizle(DateTime tarih)
{
OleDbCommand komut = new OleDbCommand("usp_hataTemizle");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pTarih", tarih.ToString())
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.Execute(komut));
}
public int Delete()
{
OleDbCommand komut = new OleDbCommand("usp_ayarDelete");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("@pId", this.Id)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.Execute(komut));
}
public Result <int> Update()
{
OleDbCommand komut = new OleDbCommand("usp_ToplamUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pId", Id)
, new OleDbParameter("pTotal", Total)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_aktiviteInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pKullaniciId", KullaniciId)
, new OleDbParameter("pTarih", Tarih.ToString())
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public Result <int> Update()
{
OleDbCommand komut = new OleDbCommand("usp_SayacIpUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pIpId", IpId)
, new OleDbParameter("pIp", Ip)
, new OleDbParameter("pHit", Hit)
, new OleDbParameter("pTarih", Tarih.ToString())
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.ExecuteWithResult(komut));
}
public Result <int> Insert()
{
OleDbCommand komut = new OleDbCommand("usp_ToplamInsert");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
//new OleDbParameter("pId", Id)
new OleDbParameter("pTotal", Total)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
OleDbCommand komutIdentity = new OleDbCommand("SELECT @@Identity FROM Toplam");
return(SistemDAL.ExecuteReturnIdentity(komut, komutIdentity));
}
public int Update()
{
OleDbCommand komut = new OleDbCommand("usp_ayarUpdate");
komut.CommandType = CommandType.StoredProcedure;
OleDbParameter[] parametreler = new OleDbParameter[]
{
new OleDbParameter("pId", Id)
, new OleDbParameter("pSirketAdi", SirketAdi)
, new OleDbParameter("pSiteAdi", SiteAdi)
, new OleDbParameter("pAdres", Adres)
, new OleDbParameter("pTelefon", Telefon)
, new OleDbParameter("pTelefon2", Telefon2)
, new OleDbParameter("pFaks", Faks)
, new OleDbParameter("pGsm", Gsm)
, new OleDbParameter("pKlasor", Klasor)
, new OleDbParameter("pAdminMail", AdminMail)
, new OleDbParameter("pMail", Mail)
, new OleDbParameter("pMailServer", MailServer)
, new OleDbParameter("pMailPassword", MailPassword)
, new OleDbParameter("pMailPort", MailPort)
, new OleDbParameter("pSorumluMail", SorumluMail)
, new OleDbParameter("pHataLoglama", HataLoglama)
, new OleDbParameter("pHataMail", HataMail)
, new OleDbParameter("pAktif", Aktif)
};
komut.Parameters.AddRange(parametreler);
//OleDbParameter sonuc = new OleDbParameter("@pReturnValue", DbType.Int32);
//sonuc.Direction = ParameterDirection.Output;
//komut.Parameters.Add(sonuc);
return(SistemDAL.Execute(komut));
}
