public static Profil GetProfilUrl(string purl)
{
Profil rvProfil = new Profil();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from profil where url=?url limit 1", conneciton))
{
cmd.Parameters.Add("url", purl, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvProfil = new Profil(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["url"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["meslek"]), MConvert.NullToString(IDR["egitim"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["hakkimda"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvProfil);
}
public static Album GetAlbum(string padi)
{
Album rvAlbum = new Album();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from album where adi=?adi limit 1", conneciton))
{
cmd.Parameters.Add("adi", padi, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAlbum = new Album(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvAlbum);
}
///<summary>
/// Firma Data Select
///</summary>
public static FirmaCollection GetSelect(System.String phesapid)
{
FirmaCollection rvFirma = new FirmaCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from firma where hesapid=?hesapid", conneciton))
{
cmd.Parameters.Add("hesapid", phesapid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvFirma.Add(new Firma(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["yetkili"]), MConvert.NullToString(IDR["adres"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon1"]), MConvert.NullToString(IDR["telefon2"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvFirma);
}
///<summary>
/// Makale Data Select
///</summary>
public static MakaleCollection GetSelect(string phesapid, int top)
{
MakaleCollection rvMakale = new MakaleCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from makale where hesapid=?hesapid and yoneticionay=1 and aktif=1 order by guncellemetarihi desc limit " + top, conneciton))
{
cmd.Parameters.Add("hesapid", phesapid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMakale.Add(new Makale(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["ozet"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMakale);
}
///<summary>
/// Manset Data Select
///</summary>
public static MansetCollection GetSelect(byte yerlesim, byte limit)
{
MansetCollection rvManset = new MansetCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from manset where yerlesim=" + yerlesim + " and aktif=1 and resimbuyuk<>'' limit " + limit, conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvManset.Add(new Manset(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["resimbuyuk"]), MConvert.NullToString(IDR["baslik1"]), MConvert.NullToString(IDR["baslik2"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["baglanti"]), MConvert.NullToString(IDR["dugme"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvManset);
}
///<summary>
/// Hesap Data PrimaryKey
///</summary>
public static Hesap GetHesap(System.String pid)
{
Hesap rvHesap = new Hesap();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from hesap where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap = new Hesap(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["soyadi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["sifre"]), MConvert.NullToString(IDR["roller"]), MConvert.NullToString(IDR["onaykodu"]), MConvert.NullToDateTime(IDR["dogumtarihi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["cinsiyet"]), MConvert.NullToByte(IDR["tipi"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["abonelik"]), MConvert.NullToBool(IDR["aktivasyon"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
rvHesap.ProfilObject = ProfilMethods.GetProfil(rvHesap.ID);
}
return(rvHesap);
}
///<summary>
/// Manset Data PrimaryKey
///</summary>
public static Manset GetManset(System.String pid)
{
Manset rvManset = new Manset();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from manset where id=?id order by guncellemetarihi desc limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvManset = new Manset(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["resimbuyuk"]), MConvert.NullToString(IDR["baslik1"]), MConvert.NullToString(IDR["baslik2"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["baglanti"]), MConvert.NullToString(IDR["dugme"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvManset);
}
///<summary>
/// Galeri Data Select
///</summary>
public static GaleriCollection GetSelect(Int64 palbumid)
{
GaleriCollection rvGaleri = new GaleriCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from galeri where albumid=?albumid", conneciton))
{
cmd.Parameters.Add("albumid", palbumid, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvGaleri.Add(new Galeri(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToInt64(IDR["albumid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["kapak"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvGaleri);
}
public static AnketPuanCollection GetSelect(Int64 psoruid)
{
AnketPuanCollection rvAnketPuan = new AnketPuanCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from anketpuan where soruid=?soruid", conneciton))
{
cmd.Parameters.Add("soruid", psoruid, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAnketPuan.Add(new AnketPuan(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToInt64(IDR["soruid"]), MConvert.NullToString(IDR["ip"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvAnketPuan);
}
public static HesapCollection GetSelect(string query, bool isProfilObjects)
{
HesapCollection rvHesap = new HesapCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, query, conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap.Add(new Hesap(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["soyadi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["sifre"]), MConvert.NullToString(IDR["roller"]), MConvert.NullToString(IDR["onaykodu"]), MConvert.NullToDateTime(IDR["dogumtarihi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["cinsiyet"]), MConvert.NullToByte(IDR["tipi"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["abonelik"]), MConvert.NullToBool(IDR["aktivasyon"]), MConvert.NullToBool(IDR["aktif"]), isProfilObjects));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvHesap);
}
///<summary>
/// Profil Data Select
///</summary>
public static ProfilCollection GetSelect()
{
ProfilCollection rvProfil = new ProfilCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from profil", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvProfil.Add(new Profil(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["url"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["meslek"]), MConvert.NullToString(IDR["egitim"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["hakkimda"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvProfil);
}
///<summary>
/// Sayfa Data Select
///</summary>
public static SayfaCollection GetSelect(byte yerlesim, byte limit)
{
SayfaCollection rvSayfa = new SayfaCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from sayfa where aktif=1 and yerlesim=5 or aktif=1 and yerlesim=?yerlesim limit " + limit, conneciton))
{
cmd.Parameters.Add("yerlesim", yerlesim, MSqlDbType.SmallInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSayfa.Add(new Sayfa(MConvert.NullToInt16(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSayfa);
}
///<summary>
/// Gosterim Data Select
///</summary>
public static GosterimCollection GetSelect()
{
GosterimCollection rvGosterim = new GosterimCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from gosterim", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvGosterim.Add(new Gosterim(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["icerikid"]), MConvert.NullToDateTime(IDR["kayittarihi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvGosterim);
}
///<summary>
/// Gosterim Data PrimaryKey
///</summary>
public static Gosterim GetGosterim(System.String pid)
{
Gosterim rvGosterim = new Gosterim();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from gosterim where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvGosterim = new Gosterim(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["icerikid"]), MConvert.NullToDateTime(IDR["kayittarihi"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvGosterim);
}
///<summary>
/// Mesaj Data Select
///</summary>
public static MesajCollection GetSelect()
{
MesajCollection rvMesaj = new MesajCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from mesaj", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMesaj.Add(new Mesaj(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["konu"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["yanit"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToByte(IDR["durum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMesaj);
}
///<summary>
/// Video Data Select
///</summary>
public static VideoCollection GetSelect(Int64 id, byte limit)
{
VideoCollection rvVideo = new VideoCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from video where id<>?id order by guncellemetarihi desc limit ?limit", conneciton))
{
cmd.Parameters.Add("id", id, MSqlDbType.BigInt);
cmd.Parameters.Add("limit", limit, MSqlDbType.TinyInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvVideo.Add(new Video(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["embed"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvVideo);
}
///<summary>
/// Hesap Data Select
///</summary>
public static HesapCollection GetSelect()
{
HesapCollection rvHesap = new HesapCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select id,concat(adi,' ',soyadi) adi from hesap where aktivasyon=1 and aktif=1 and tipi in(1,2,3,5)", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap.Add(new Hesap {
ID = MConvert.NullToGuidString(IDR["id"]), Adi = MConvert.NullToString(IDR["adi"])
});
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvHesap);
}
public static HaberCollection GetSelect(string pkategoriid)
{
HaberCollection rvHaber = new HaberCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from haber where kategoriid=?kategoriid", conneciton))
{
cmd.Parameters.Add("kategoriid", pkategoriid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHaber.Add(new Haber(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["ozet"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToInt64(IDR["video"]), MConvert.NullToInt64(IDR["galeri"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["anasayfa"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvHaber);
}
///<summary>
/// Yorum Data Select
///</summary>
public static YorumCollection GetSelect()
{
YorumCollection rvYorum = new YorumCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from yorum", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvYorum.Add(new Yorum(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["icerikid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvYorum);
}
/// <summary>
/// Hesap Getir
/// </summary>
public static Hesap GetHesap(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Hesap rvHesap = new Hesap();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap = new Hesap(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["soyadi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["sifre"]), MConvert.NullToString(IDR["roller"]), MConvert.NullToString(IDR["onaykodu"]), MConvert.NullToDateTime(IDR["dogumtarihi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["cinsiyet"]), MConvert.NullToByte(IDR["tipi"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["abonelik"]), MConvert.NullToBool(IDR["aktivasyon"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
rvHesap.ProfilObject = ProfilMethods.GetProfil(rvHesap.ID);
}
return(rvHesap);
}
public static AnketPuanCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
AnketPuanCollection rvAnketPuan = new AnketPuanCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAnketPuan.Add(new AnketPuan(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToInt64(IDR["soruid"]), MConvert.NullToString(IDR["ip"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvAnketPuan);
}
/// <summary>
/// Gosterim Liste Getir
/// </summary>
public static GosterimCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
GosterimCollection rvGosterim = new GosterimCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvGosterim.Add(new Gosterim(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["icerikid"]), MConvert.NullToDateTime(IDR["kayittarihi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvGosterim);
}
/// <summary>
/// Mesaj Liste Getir
/// </summary>
public static MesajCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
MesajCollection rvMesaj = new MesajCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMesaj.Add(new Mesaj(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["konu"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["yanit"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToByte(IDR["durum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMesaj);
}
/// <summary>
/// Sayfa Liste Getir
/// </summary>
public static SayfaCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
SayfaCollection rvSayfa = new SayfaCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSayfa.Add(new Sayfa(MConvert.NullToInt16(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToByte(IDR["yerlesim"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSayfa);
}
/// <summary>
/// Firma Liste Getir
/// </summary>
public static FirmaCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
FirmaCollection rvFirma = new FirmaCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvFirma.Add(new Firma(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["yetkili"]), MConvert.NullToString(IDR["adres"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon1"]), MConvert.NullToString(IDR["telefon2"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvFirma);
}
/// <summary>
/// Yorum Getir
/// </summary>
public static Yorum GetYorum(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Yorum rvYorum = new Yorum();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvYorum = new Yorum(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["ip"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["icerikid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvYorum);
}
/// <summary>
/// Galeri Liste Getir
/// </summary>
public static GaleriCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
GaleriCollection rvGaleri = new GaleriCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvGaleri.Add(new Galeri(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToInt64(IDR["albumid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["kapak"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvGaleri);
}
/// <summary>
/// Makale Liste Getir
/// </summary>
public static MakaleCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
MakaleCollection rvMakale = new MakaleCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMakale.Add(new Makale(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["ozet"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMakale);
}
/// <summary>
/// Profil Liste Getir
/// </summary>
public static ProfilCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
ProfilCollection rvProfil = new ProfilCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvProfil.Add(new Profil(MConvert.NullToGuidString(IDR["id"]), MConvert.NullToString(IDR["url"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["mail"]), MConvert.NullToString(IDR["web"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToString(IDR["gsm"]), MConvert.NullToString(IDR["meslek"]), MConvert.NullToString(IDR["egitim"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["hakkimda"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvProfil);
}
///<summary>
/// SeriIlan Data Select
///</summary>
public static SeriIlanCollection GetSelect(System.String phesapid)
{
SeriIlanCollection rvSeriIlan = new SeriIlanCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from seriilan where hesapid=?hesapid", conneciton))
{
cmd.Parameters.Add("hesapid", phesapid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSeriIlan.Add(new SeriIlan(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["detay"]), MConvert.NullToString(IDR["semt"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToString(IDR["telefon"]), MConvert.NullToFloat(IDR["fiyat"]), MConvert.NullToByte(IDR["kimden"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSeriIlan);
}
