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