///<summary>
/// Gosterim Data Count
///</summary>
public static Int64 GetCount(string modulID, string id)
{
Int64 rvCount = 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.Text, "SELECT COUNT(DISTINCT IP) AS TotalView FROM Gosterim WHERE ModulID=@ModulID AND IcerikID=@IcerikID", conneciton))
{
cmd.Parameters.Add("ModulID", modulID, MSqlDbType.VarChar);
cmd.Parameters.Add("IcerikID", id, MSqlDbType.VarChar);
rvCount = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvCount);
}
public static List <TeklifDetay> GetSelect(Teklif p)
{
List <TeklifDetay> rvTeklifDetay = new List <TeklifDetay>();
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 TeklifDetay where TeklifID=@TeklifID order by ID asc", conneciton))
{
cmd.Parameters.Add("TeklifID", p.ID, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
int siraNo = 0;
while (IDR.Read())
{
rvTeklifDetay.Add(new TeklifDetay(++siraNo, MConvert.NullToInt64(IDR["ID"]), MConvert.NullToInt64(IDR["TeklifID"]), MConvert.NullToInt(IDR["StokID"]), MConvert.NullToInt(IDR["KategoriID"]), MConvert.NullToInt(IDR["FirmaID"]), MConvert.NullToString(IDR["FirmaAdi"]), MConvert.NullToString(IDR["UrunAdi"]), MConvert.NullToFloat(IDR["BirimFiyati"]), MConvert.NullToFloat(IDR["KarOrani"]), MConvert.NullToFloat(IDR["Miktar"]), MConvert.NullToString(IDR["Birim"]), MConvert.NullToFloat(IDR["Adet"]), MConvert.NullToFloat(IDR["Kdv"]), p.Kur1, p.Kur2));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvTeklifDetay);
}
///<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);
}
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>
/// 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>
/// ResmiIlan Data Select
///</summary>
public static ResmiIlanCollection GetSelect()
{
ResmiIlanCollection rvResmiIlan = new ResmiIlanCollection();
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 resmiilan", conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvResmiIlan.Add(new ResmiIlan(MConvert.NullToInt64(IDR["id"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvResmiIlan);
}
public static Int64 GetCount(string pMail, bool pAktif)
{
Int64 rvCount = 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.Text, "SELECT COUNT(ID) AS TotalCount FROM Yorum WHERE Mail=@Mail AND Aktif=@Aktif", conneciton))
{
cmd.Parameters.Add("Mail", pMail, MSqlDbType.VarChar);
cmd.Parameters.Add("Aktif", pAktif, MSqlDbType.Bit);
rvCount = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvCount);
}
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);
}
public static AnketCollection GetSelect(Anket p)
{
AnketCollection rvAnket = new AnketCollection();
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 anket where anketid=?anketid order by " + (BAYMYO.UI.Converts.NullToBool(p.Grup) ? "grup asc," : "") + " id asc", conneciton))
{
cmd.Parameters.Add("anketid", p.ID, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAnket.Add(new Anket(MConvert.NullToInt64(IDR["id"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["grup"]), MConvert.NullToBool(IDR["yatay"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvAnket);
}
///<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>
/// Anket Data PrimaryKey
///</summary>
public static Anket GetAnket(Int64 pid)
{
Anket rvAnket = new Anket();
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 anket where id=?id limit 1", conneciton))
{
cmd.Parameters.Add("id", pid, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvAnket = new Anket(MConvert.NullToInt64(IDR["id"]), MConvert.NullToInt64(IDR["anketid"]), MConvert.NullToString(IDR["adi"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToBool(IDR["aktif"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["grup"]), MConvert.NullToBool(IDR["yatay"]));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvAnket);
}
public static Int64 GetCount(bool pYoneticiOnay)
{
Int64 rvCount = 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.Text, "SELECT COUNT(ID) AS TotalCount FROM Yorum WHERE YoneticiOnay=@YoneticiOnay", conneciton))
{
cmd.Parameters.Add("YoneticiOnay", pYoneticiOnay, MSqlDbType.Bit);
rvCount = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvCount);
}
public static Int64 GetCount(Guid pHesapID, byte pDurum, bool pYoneticiOnay)
{
Int64 rvCount = 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.Text, "SELECT COUNT(ID) AS TotalCount FROM Randevu WHERE HesapID=@HesapID AND YoneticiOnay=@YoneticiOnay AND Durum=@Durum", conneciton))
{
cmd.Parameters.Add("HesapID", pHesapID, BAYMYO.MultiSQLClient.MSqlDbType.UniqueIdentifier);
cmd.Parameters.Add("Durum", pDurum, MSqlDbType.TinyInt);
cmd.Parameters.Add("YoneticiOnay", pYoneticiOnay, MSqlDbType.Bit);
rvCount = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvCount);
}
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>
/// Makale Data PrimaryKey
///</summary>
public static Makale GetMakale(Int64 pID)
{
Makale rvMakale = new Makale();
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 Makale WHERE ID=@ID", conneciton))
{
cmd.Parameters.Add("ID", pID, MSqlDbType.BigInt);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMakale = 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);
}
///<summary>
/// ResmiIlan Data Insert
///</summary>
public static Int64 Insert(ResmiIlan p)
{
Int64 rowsAffected = 0;
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, "insert into resmiilan (baslik,icerik,sehir,kayittarihi,aktif) values(?baslik,?icerik,?sehir,?kayittarihi,?aktif); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar);
cmd.Parameters.Add("icerik", p.Icerik, MSqlDbType.LongText);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
public static Int64 GetCount(Guid pHesapID, string pUrl, bool pYoneticiOnay, bool pAktif)
{
Int64 rvCount = 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.Text, "SELECT COUNT(ID) AS TotalCount FROM Yorum WHERE (YoneticiOnay=@YoneticiOnay AND Aktif=@Aktif) AND (EXISTS(SELECT ID FROM Makale WHERE HesapID=@HesapID) OR EXISTS(SELECT ID FROM Mesaj WHERE HesapID=@HesapID) OR EXISTS(SELECT ID FROM Video WHERE HesapID=@HesapID) OR IcerikID=@Url)", conneciton))
{
cmd.Parameters.Add("HesapID", pHesapID, BAYMYO.MultiSQLClient.MSqlDbType.UniqueIdentifier);
cmd.Parameters.Add("Url", pUrl, BAYMYO.MultiSQLClient.MSqlDbType.VarChar);
cmd.Parameters.Add("YoneticiOnay", pYoneticiOnay, MSqlDbType.Bit);
cmd.Parameters.Add("Aktif", pAktif, MSqlDbType.Bit);
rvCount = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvCount);
}
///<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>
/// 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>
/// 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>
/// 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);
}
///<summary>
/// Anket Data Insert
///</summary>
public static Int64 Insert(Anket p)
{
Int64 rowsAffected = 0;
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, "insert into anket (anketid,adi,kayittarihi,aktif,resimurl,grup,yatay) values(?anketid,?adi,?kayittarihi,?aktif,?resimurl,?grup,?yatay); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("anketid", p.AnketID, MSqlDbType.BigInt);
cmd.Parameters.Add("adi", p.Adi, MSqlDbType.VarChar);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("grup", p.Grup, MSqlDbType.VarChar);
cmd.Parameters.Add("yatay", p.Yatay, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
public static VideoCollection GetSelect(System.Guid pHesapID)
{
VideoCollection rvVideo = new VideoCollection();
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 Video WHERE HesapID=@HesapID", conneciton))
{
cmd.Parameters.Add("HesapID", pHesapID, MSqlDbType.UniqueIdentifier);
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvVideo.Add(new Video(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToGuid(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.NullToBool(IDR["Yorum"]), MConvert.NullToBool(IDR["Aktif"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvVideo);
}
public static Int64 Insert(Teklif p)
{
Int64 rowsAffected = 0;
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, "insert into Teklif (GemiAdi,BaglamaLimani,Acenta,Manager,Tarih,Kur1,Kur2,ParaBirimi,Kdv,TasimaUcreti,Iskonto,Hazirlayan,OdemeSekli,TeslimSuresi,Aciklama,GuncellemeTarihi,Durum,DurumNotu,TasimaUcretiNotu) values(@GemiAdi,@BaglamaLimani,@Acenta,@Manager,@Tarih,@Kur1,@Kur2,@ParaBirimi,@Kdv,@TasimaUcreti,@Iskonto,@Hazirlayan,@OdemeSekli,@TeslimSuresi,@Aciklama,@GuncellemeTarihi,@Durum,@DurumNotu,@TasimaUcretiNotu)", conneciton))
{
cmd.Parameters.Add("GemiAdi", p.GemiAdi, MSqlDbType.NVarChar);
cmd.Parameters.Add("BaglamaLimani", p.BaglamaLimani, MSqlDbType.NVarChar);
cmd.Parameters.Add("Acenta", p.Acenta, MSqlDbType.NVarChar);
cmd.Parameters.Add("Manager", p.Manager, MSqlDbType.NVarChar);
cmd.Parameters.Add("Tarih", p.Tarih, MSqlDbType.DateTime);
cmd.Parameters.Add("Kur1", p.Kur1, MSqlDbType.Float);
cmd.Parameters.Add("Kur2", p.Kur2, MSqlDbType.Float);
cmd.Parameters.Add("ParaBirimi", p.ParaBirimi, MSqlDbType.VarChar);
cmd.Parameters.Add("Kdv", p.Kdv, MSqlDbType.TinyInt);
cmd.Parameters.Add("TasimaUcreti", p.TasimaUcreti, MSqlDbType.Float);
cmd.Parameters.Add("Iskonto", p.Iskonto, MSqlDbType.Float);
cmd.Parameters.Add("Hazirlayan", p.Hazirlayan, MSqlDbType.NVarChar);
cmd.Parameters.Add("OdemeSekli", p.OdemeSekli, MSqlDbType.NVarChar);
cmd.Parameters.Add("TeslimSuresi", p.TeslimSuresi, MSqlDbType.NVarChar);
cmd.Parameters.Add("Aciklama", p.Aciklama, MSqlDbType.NVarChar);
cmd.Parameters.Add("GuncellemeTarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("Durum", p.Durum, MSqlDbType.Number);
cmd.Parameters.Add("DurumNotu", p.DurumNotu, MSqlDbType.NVarChar);
cmd.Parameters.Add("TasimaUcretiNotu", p.DurumNotu, MSqlDbType.NVarChar);
if (cmd.ExecuteNonQuery() > 0)
{
cmd.Parameters.Clear();
//;select top 1 ID from Teklif where GemiAdi=@GemiAdi and BaglamaLimani=@BaglamaLimani and Acenta=@Acenta and Manager=@Manager and Tarih=@Tarih;
cmd.CommandText = "SELECT @@IDENTITY";
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// Makale Data Select
///</summary>
public static List <MakaleJSON> GetJSON(QueryType sorguTipi, int top)
{
List <MakaleJSON> rvMakale = new List <MakaleJSON>();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
string query = "";
switch (sorguTipi)
{
case QueryType.Date:
query = "SELECT TOP(" + top + ") Makale.ID, Makale.KategoriID, Makale.ResimUrl, Makale.Baslik, Makale.Icerik as Ozet, Makale.KayitTarihi, dbo.GetHesapUrl(Makale.HesapID) AS Url, (Hesap.Adi +' '+Hesap.Soyadi) AS AdiSoyadi FROM Makale INNER JOIN Hesap ON Makale.HesapID = Hesap.ID WHERE Makale.KayitTarihi=(SELECT MAX(Makale.KayitTarihi) FROM Makale WHERE Makale.HesapID=Hesap.ID) AND Makale.Aktif=1";
break;
case QueryType.Populer:
query = "SELECT * FROM (SELECT TOP(" + top + ") Makale.ID, Makale.KategoriID, Makale.ResimUrl, Makale.Baslik, Makale.Ozet, Makale.KayitTarihi, dbo.GetHesapUrl(Makale.HesapID) AS Url, (Hesap.Adi +' '+Hesap.Soyadi) AS AdiSoyadi, dbo.GetGosterimOran('makale',Makale.ID) AS Oran FROM Makale INNER JOIN Hesap ON Makale.HesapID = Hesap.ID WHERE Makale.KayitTarihi=(SELECT MAX(Makale.KayitTarihi) FROM Makale WHERE Makale.HesapID=Hesap.ID) AND Makale.Aktif=1 ORDER BY Oran DESC) MakaleListe WHERE Oran >= 1";
break;
case QueryType.WeekOfThe:
query = "SELECT TOP(" + top + ") Makale.ID, Makale.KategoriID, Makale.ResimUrl, Makale.Baslik, Makale.Icerik as Ozet, Makale.KayitTarihi, dbo.GetHesapUrl(Makale.HesapID) AS Url, (Hesap.Adi +' '+Hesap.Soyadi) AS AdiSoyadi FROM Makale INNER JOIN Hesap ON Makale.HesapID = Hesap.ID WHERE Makale.KayitTarihi=(SELECT MAX(Makale.KayitTarihi) FROM Makale WHERE Makale.HesapID=Hesap.ID) AND Makale.Aktif=1 AND Makale.Durum=2";
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, query, conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvMakale.Add(new MakaleJSON(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToString(IDR["KategoriID"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["Baslik"]), MConvert.NullToString(IDR["Ozet"]), MConvert.NullToString(IDR["Url"]), MConvert.NullToString(IDR["AdiSoyadi"]), MConvert.NullToDateTime(IDR["KayitTarihi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvMakale);
}
///<summary>
/// Video Data Select
///</summary>
public static List <VideoJSON> GetJSON(QueryType sorguTipi, int top)
{
List <VideoJSON> rvVideo = new List <VideoJSON>();
using (MConnection conneciton = new MConnection(MClientProvider.MSSQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
string query = "";
switch (sorguTipi)
{
case QueryType.Date:
query = "SELECT TOP(" + top + ") Video.ID, Video.ResimUrl, Video.Baslik, Video.KayitTarihi, dbo.GetHesapUrl(Video.HesapID) AS Url, (Hesap.Adi +' '+Hesap.Soyadi) AS AdiSoyadi FROM Video INNER JOIN Hesap ON Video.HesapID = Hesap.ID WHERE Video.KayitTarihi=(SELECT MAX(Video.KayitTarihi) FROM Video WHERE Video.HesapID=Hesap.ID) AND Video.Aktif=1";
break;
case QueryType.Populer:
query = "SELECT * FROM (SELECT TOP(" + top + ") Video.ID, Video.ResimUrl, Video.Baslik, Video.KayitTarihi, dbo.GetHesapUrl(Video.HesapID) AS Url, (Hesap.Adi +' '+Hesap.Soyadi) AS AdiSoyadi, dbo.GetGosterimOran('video',Video.ID) AS Oran FROM Video INNER JOIN Hesap ON Video.HesapID = Hesap.ID WHERE Video.KayitTarihi=(SELECT MAX(Video.KayitTarihi) FROM Video WHERE Video.HesapID=Hesap.ID) AND Video.Aktif=1 ORDER BY Oran DESC) VideoListe WHERE Oran >= 1";
break;
}
using (MCommand cmd = new MCommand(CommandType.Text, query, conneciton))
{
using (IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rvVideo.Add(new VideoJSON(MConvert.NullToInt64(IDR["ID"]), MConvert.NullToString(IDR["ResimUrl"]), MConvert.NullToString(IDR["Baslik"]), MConvert.NullToString(IDR["Url"]), MConvert.NullToString(IDR["AdiSoyadi"]), MConvert.NullToDateTime(IDR["KayitTarihi"])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rvVideo);
}
///<summary>
/// Haber Data Insert
///</summary>
public static Int64 Insert(Haber p)
{
Int64 rowsAffected = 0;
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, "insert into haber (hesapid,kategoriid,resimurl,baslik,ozet,icerik,etiket,sehir,kayittarihi,guncellemetarihi,gosterimsayi,video,galeri,uye,yorum,yoneticionay,anasayfa,aktif) values(?hesapid,?kategoriid,?resimurl,?baslik,?ozet,?icerik,?etiket,?sehir,?kayittarihi,?guncellemetarihi,?gosterimsayi,?video,?galeri,?uye,?yorum,?yoneticionay,?anasayfa,?aktif); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar);
cmd.Parameters.Add("kategoriid", p.KategoriID, MSqlDbType.VarChar);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar);
cmd.Parameters.Add("ozet", p.Ozet, MSqlDbType.VarChar);
cmd.Parameters.Add("icerik", p.Icerik, MSqlDbType.LongText);
cmd.Parameters.Add("etiket", p.Etiket, MSqlDbType.VarChar);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("guncellemetarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("gosterimsayi", p.GosterimSayi, MSqlDbType.Boolean);
cmd.Parameters.Add("video", p.Video, MSqlDbType.BigInt);
cmd.Parameters.Add("galeri", p.Galeri, MSqlDbType.BigInt);
cmd.Parameters.Add("uye", p.Uye, MSqlDbType.Boolean);
cmd.Parameters.Add("yorum", p.Yorum, MSqlDbType.Boolean);
cmd.Parameters.Add("yoneticionay", p.YoneticiOnay, MSqlDbType.Boolean);
cmd.Parameters.Add("anasayfa", p.Anasayfa, MSqlDbType.Boolean);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// Firma Data Insert
///</summary>
public static Int64 Insert(Firma p)
{
Int64 rowsAffected = 0;
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, "insert into firma (hesapid,kategoriid,resimurl,adi,yetkili,adres,mail,web,telefon1,telefon2,gsm,sehir,kayittarihi,guncellemetarihi,gosterimsayi,yoneticionay,aktif) values(?hesapid,?kategoriid,?resimurl,?adi,?yetkili,?adres,?mail,?web,?telefon1,?telefon2,?gsm,?sehir,?kayittarihi,?guncellemetarihi,?gosterimsayi,?yoneticionay,?aktif); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar);
cmd.Parameters.Add("kategoriid", p.KategoriID, MSqlDbType.VarChar);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("adi", p.Adi, MSqlDbType.VarChar);
cmd.Parameters.Add("yetkili", p.Yetkili, MSqlDbType.VarChar);
cmd.Parameters.Add("adres", p.Adres, MSqlDbType.VarChar);
cmd.Parameters.Add("mail", p.Mail, MSqlDbType.VarChar);
cmd.Parameters.Add("web", p.Web, MSqlDbType.VarChar);
cmd.Parameters.Add("telefon1", p.Telefon1, MSqlDbType.VarChar);
cmd.Parameters.Add("telefon2", p.Telefon2, MSqlDbType.VarChar);
cmd.Parameters.Add("gsm", p.GSM, MSqlDbType.VarChar);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("guncellemetarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("gosterimsayi", p.GosterimSayi, MSqlDbType.Boolean);
cmd.Parameters.Add("yoneticionay", p.YoneticiOnay, MSqlDbType.Boolean);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
///<summary>
/// SeriIlan Data Insert
///</summary>
public static Int64 Insert(SeriIlan p)
{
Int64 rowsAffected = 0;
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, "insert into seriilan (hesapid,kategoriid,resimurl,baslik,detay,semt,sehir,telefon,fiyat,kimden,kayittarihi,guncellemetarihi,gosterimsayi,yoneticionay,aktif) values(?hesapid,?kategoriid,?resimurl,?baslik,?detay,?semt,?sehir,?telefon,?fiyat,?kimden,?kayittarihi,?guncellemetarihi,?gosterimsayi,?yoneticionay,?aktif); select last_insert_id();", conneciton))
{
cmd.Parameters.Add("hesapid", p.HesapID, MSqlDbType.VarChar);
cmd.Parameters.Add("kategoriid", p.KategoriID, MSqlDbType.VarChar);
cmd.Parameters.Add("resimurl", p.ResimUrl, MSqlDbType.VarChar);
cmd.Parameters.Add("baslik", p.Baslik, MSqlDbType.VarChar);
cmd.Parameters.Add("detay", p.Detay, MSqlDbType.VarChar);
cmd.Parameters.Add("semt", p.Semt, MSqlDbType.VarChar);
cmd.Parameters.Add("sehir", p.Sehir, MSqlDbType.VarChar);
cmd.Parameters.Add("telefon", p.Telefon, MSqlDbType.VarChar);
cmd.Parameters.Add("fiyat", p.Fiyat, MSqlDbType.Float);
cmd.Parameters.Add("kimden", p.Kimden, MSqlDbType.SmallInt);
cmd.Parameters.Add("kayittarihi", p.KayitTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("guncellemetarihi", p.GuncellemeTarihi, MSqlDbType.DateTime);
cmd.Parameters.Add("gosterimsayi", p.GosterimSayi, MSqlDbType.Boolean);
cmd.Parameters.Add("yoneticionay", p.YoneticiOnay, MSqlDbType.Boolean);
cmd.Parameters.Add("aktif", p.Aktif, MSqlDbType.Boolean);
rowsAffected = MConvert.NullToInt64(cmd.ExecuteScalar());
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rowsAffected);
}
/// <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);
}
