///<summary>
/// Sehir Data Select
///</summary>
public static SehirCollection GetSelect()
{
SehirCollection rvSehir = new SehirCollection();
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 sehir order by adi asc", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSehir.Add(new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSehir);
}
///<summary>
/// Sehir Data PrimaryKey
///</summary>
public static Sehir GetSehir(byte pid)
{
Sehir rvSehir = new Sehir();
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 sehir where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.SmallInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvSehir = new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSehir);
}
///<summary>
/// Hesap Data Update
///</summary>
public static int Update(Hesap p)
{
int rowsAffected = 0;
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.StoredProcedure, "Hesap_Update", conneciton))
{
cmd.Parameters.Add("ID", p.ID, MSqlDbType.UniqueIdentifier);
cmd.Parameters.Add("IP", p.IP, MSqlDbType.VarChar);
cmd.Parameters.Add("Adi", System.Threading.Thread.CurrentThread.CurrentCulture.TextInfo.ToTitleCase(p.Adi.ToLower().Trim()), MSqlDbType.NVarChar);
cmd.Parameters.Add("Soyadi", p.Soyadi.ToUpper().Trim(), MSqlDbType.NVarChar);
cmd.Parameters.Add("Mail", p.Mail.Trim(), MSqlDbType.VarChar);
cmd.Parameters.Add("Sifre", p.Sifre, MSqlDbType.VarChar);
cmd.Parameters.Add("Roller", p.Roller, MSqlDbType.VarChar);
cmd.Parameters.Add("OnayKodu", p.OnayKodu, MSqlDbType.VarChar);
cmd.Parameters.Add("DogumTarihi", p.DogumTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("KayitTarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("Cinsiyet", MConvert.NullToByte(p.Cinsiyet), MSqlDbType.TinyInt);
cmd.Parameters.Add("Tipi", MConvert.NullToByte(p.Tipi), MSqlDbType.TinyInt);
cmd.Parameters.Add("Yorum", p.Yorum, MSqlDbType.Bit);
cmd.Parameters.Add("Abonelik", p.Abonelik, MSqlDbType.Bit);
cmd.Parameters.Add("Aktivasyon", p.Aktivasyon, MSqlDbType.Bit);
cmd.Parameters.Add("Aktif", p.Aktif, MSqlDbType.Bit);
rowsAffected = MConvert.NullToInt(cmd.ExecuteNonQuery());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
/// <summary>
/// Sehir Liste Getir
/// </summary>
public static SehirCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
SehirCollection rvSehir = new SehirCollection();
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())
{
rvSehir.Add(new Sehir(MConvert.NullToByte(IDR["id"]), MConvert.NullToString(IDR["adi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvSehir);
}
public static List <Kategori> GetMenu(string modulid, bool rootNode)
{
List <Kategori> rvKategori = new List <Kategori>();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
switch (rootNode)
{
case true:
rvKategori.Add(new Kategori("0", "", modulid, "<SeƧiniz>", "", 0, 1, false, "", "", ""));
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from kategori where modulid=?modulid and aktif=1 order by adi asc", conneciton))
{
cmd.Parameters.Add("modulid", modulid, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvKategori.Add(new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
/// <summary>
/// SeriIlan Liste Getir
/// </summary>
public static SeriIlanCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
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(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
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);
}
/// <summary>
/// Astroloji Liste Getir
/// </summary>
public static AstrolojiCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
AstrolojiCollection rvAstroloji = new AstrolojiCollection();
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())
{
rvAstroloji.Add(new Astroloji(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToByte(IDR["burcid"]), 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(rvAstroloji);
}
/// <summary>
/// Mesaj Getir
/// </summary>
public static Mesaj GetMesaj(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Mesaj rvMesaj = new Mesaj();
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 = 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);
}
public static Kategori GetKategori(string modulID, string id)
{
Kategori rvKategori = new Kategori();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT TOP(1) * FROM Kategori WHERE ModulID=@ModulID AND ID=@ID", conneciton))
{
cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar);
cmd.Parameters.Add("ID", id, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvKategori = new Kategori(MConvert.NullToString(IDR["ID"]), MConvert.NullToString(IDR["ParentID"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Dil"]), MConvert.NullToByte(IDR["Sira"]), MConvert.NullToBool(IDR["Tab"]), MConvert.NullToBool(IDR["Menu"]), MConvert.NullToBool(IDR["Aktif"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
/// <summary>
/// Hesap Getir
/// </summary>
public static Hesap GetHesap(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Hesap rvHesap = new Hesap();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
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.NullToGuid(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 Hesap GetHesap(string pUrl)
{
Hesap rvHesap = new Hesap();
Profil tempProfil = ProfilMethods.GetProfil(pUrl);
if (tempProfil != null)
{
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT TOP(1) * FROM Hesap WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", tempProfil.ID, MSqlDbType.UniqueIdentifier);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvHesap = new Hesap(MConvert.NullToGuid(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 = tempProfil;
return(rvHesap);
}
///<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>
/// 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);
}
public static KategoriCollection GetSelect()
{
KategoriCollection rvKategori = new KategoriCollection();
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 kategori", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvKategori.Add(new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
public static List <Kategori> GetMenu(string modulid, byte menuType)
{
List <Kategori> rvKategori = new List <Kategori>();
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
string query = "select * from kategori where modulid=?modulid and menu=?menu and aktif=1 order by sira asc, adi asc limit 20";
switch (menuType)
{
case 1:
query = "select * from kategori where modulid=?modulid and menu=?menu and aktif=1 order by sira asc, parentid asc limit 12";
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, query, conneciton))
{
cmd.Parameters.Add("modulid", modulid, MSqlDbType.VarChar);
cmd.Parameters.Add("menu", (byte)menuType, MSqlDbType.Byte);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvKategori.Add(new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
///<summary>
/// Mesaj Data Select
///</summary>
public static MesajCollection GetSelect(System.Guid pHesapID)
{
MesajCollection rvMesaj = new MesajCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Mesaj WHERE HesapID=@HesapID", conneciton))
{
cmd.Parameters.Add("HesapID", pHesapID, MSqlDbType.UniqueIdentifier);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMesaj.Add(new Mesaj(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToGuid(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);
}
public static List <UrunKatalog> GetUrunKatalog()
{
List <UrunKatalog> rvUrunKatalog = new List <UrunKatalog>();
try
{
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM UrunKatalog ORDER BY KategoriAdi ASC, UrunAdi ASC, Fiyat ASC", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
int siraNo = 0;
while (IDR.Read())
{
rvUrunKatalog.Add(new UrunKatalog(++siraNo, MConvert.NullToInt(IDR["StokID"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToInt(IDR["UrunID"]), MConvert.NullToInt(IDR["FirmaID"]), MConvert.NullToString(IDR["KategoriAdi"]), MConvert.NullToString(IDR["ImpaCode"]), MConvert.NullToString(IDR["UrunAdi"]), MConvert.NullToString(IDR["FirmaAdi"]), MConvert.NullToString(IDR["Telefon"]), MConvert.NullToFloat(IDR["Miktar"]), MConvert.NullToString(IDR["Birim"]), MConvert.NullToFloat(IDR["Kdv"]), MConvert.NullToFloat(IDR["Fiyat"]), MConvert.NullToFloat(IDR["KarOran"]), MConvert.NullToDateTime(IDR["GuncellemeTarihi"]), MConvert.NullToByte(IDR["Period"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
}
catch (Exception ex)
{
Commons.Status(Commons.GetErrorCode("UKT", 2) + ex.Message);
}
return(rvUrunKatalog);
}
///<summary>
/// Hesap Data URL
///</summary>
public static Hesap GetHesapUrl(string purl)
{
Hesap rvHesap = new Hesap();
Profil tempProfil = ProfilMethods.GetProfilUrl(purl);
if (tempProfil != null)
{
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", tempProfil.ID, 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 = tempProfil;
return(rvHesap);
}
public static List <Kategori> GetMenu(string modulID, bool rootNode)
{
List <Kategori> rvKategori = new List <Kategori>();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Kategori WHERE ModulID=@ModulID AND Menu=1 AND Aktif=1 ORDER BY ID ASC", conneciton))
{
cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
if (rootNode)
{
rvKategori.Add(new Kategori("0", "", modulID, "<SeƧiniz>", "", 0, false, false, false));
}
while (IDR.Read())
{
rvKategori.Add(new Kategori(MConvert.NullToString(IDR["ID"]), MConvert.NullToString(IDR["ParentID"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Dil"]), MConvert.NullToByte(IDR["Sira"]), MConvert.NullToBool(IDR["Tab"]), MConvert.NullToBool(IDR["Menu"]), MConvert.NullToBool(IDR["Aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
/// <summary>
/// Hesap Liste Getir
/// </summary>
public static HesapCollection GetList(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
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(cmdType, sqlQuery, conneciton))
{
if (parameters != null)
{
foreach (MParameter item in parameters)
{
cmd.Parameters.Add(item);
}
}
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"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvHesap);
}
///<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);
}
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>
/// Astroloji Data Select
///</summary>
public static AstrolojiCollection GetSelect()
{
AstrolojiCollection rvAstroloji = new AstrolojiCollection();
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 astroloji", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAstroloji.Add(new Astroloji(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToByte(IDR["burcid"]), 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(rvAstroloji);
}
/// <summary>
/// Sayfa Getir
/// </summary>
public static Sayfa GetSayfa(CommandType cmdType, string sqlQuery, MParameterCollection parameters)
{
Sayfa rvSayfa = new Sayfa();
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 = 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>
/// 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);
}
///<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);
}
public static MakaleCollection GetSelect(System.Guid pHesapID)
{
MakaleCollection rvMakale = new MakaleCollection();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT * FROM Makale WHERE HesapID=@HesapID", conneciton))
{
cmd.Parameters.Add("HesapID", pHesapID, MSqlDbType.UniqueIdentifier);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMakale.Add(new Makale(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToGuid(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.NullToByte(IDR["Durum"]), MConvert.NullToBool(IDR["Uye"]), MConvert.NullToBool(IDR["Yorum"]), MConvert.NullToBool(IDR["Aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMakale);
}
public static TeklifCollection GetSelect()
{
TeklifCollection rvTeklif = new TeklifCollection();
using (MConnection conneciton = new MConnection(MClientProvider.OleDb, Commons.ConnectionStringName))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "select * from Teklif", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvTeklif.Add(new Teklif(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToString(IDR["GemiAdi"]), MConvert.NullToString(IDR["BaglamaLimani"]), MConvert.NullToString(IDR["Acenta"]), MConvert.NullToString(IDR["Manager"]), MConvert.NullToDateTime(IDR["Tarih"]), MConvert.NullToFloat(IDR["Kur1"]), MConvert.NullToFloat(IDR["Kur2"]), MConvert.NullToString(IDR["ParaBirimi"]), MConvert.NullToByte(IDR["Kdv"]), MConvert.NullToFloat(IDR["TasimaUcreti"]), MConvert.NullToFloat(IDR["Iskonto"]), MConvert.NullToString(IDR["Hazirlayan"]), MConvert.NullToString(IDR["OdemeSekli"]), MConvert.NullToString(IDR["TeslimSuresi"]), MConvert.NullToString(IDR["Aciklama"]), MConvert.NullToDateTime(IDR["GuncellemeTarihi"]), MConvert.NullToByte(IDR["Durum"]), MConvert.NullToString(IDR["DurumNotu"]), MConvert.NullToString(IDR["TasimaUcretiNotu"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvTeklif);
}
///<summary>
/// Randevu Data PrimaryKey
///</summary>
public static Randevu GetRandevu(System.Guid pID)
{
Randevu rvRandevu = new Randevu();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, "SELECT TOP(1) * FROM Randevu WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", pID, MSqlDbType.UniqueIdentifier);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvRandevu = new Randevu(MConvert.NullToGuid(IDR["ID"]), MConvert.NullToGuid(IDR["HesapID"]), MConvert.NullToString(IDR["ModulID"]), MConvert.NullToString(IDR["IcerikID"]), MConvert.NullToString(IDR["Adi"]), MConvert.NullToString(IDR["Mail"]), MConvert.NullToString(IDR["Telefon"]), MConvert.NullToString(IDR["GSM"]), MConvert.NullToString(IDR["Icerik"]), MConvert.NullToDateTime(IDR["TarihSaat"]), MConvert.NullToByte(IDR["Durum"]), MConvert.NullToBool(IDR["YoneticiOnay"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvRandevu);
}
public static Kategori GetKategori(string modulid, string id)
{
Kategori rvKategori = new Kategori();
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 kategori where modulid=?modulid and id=?id limit 1", conneciton))
{
cmd.Parameters.Add("modulid", modulid, MSqlDbType.VarChar);
cmd.Parameters.Add("id", id, MSqlDbType.VarChar);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvKategori = new Kategori(MConvert.NullToString(IDR["id"]), MConvert.NullToString(IDR["parentid"]), MConvert.NullToString(IDR["modulid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToString(IDR["dil"]), MConvert.NullToByte(IDR["sira"]), MConvert.NullToByte(IDR["menu"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["renk"]), MConvert.NullToString(IDR["aciklama"]), MConvert.NullToString(IDR["etiket"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvKategori);
}
