///<summary> /// Haber Data Delete ///</summary> public static int Delete(Haber p) { int 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, "delete from haber where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.BigInt); rowsAffected = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
public static Haber GetHaber(string pbaslik) { Haber rvHaber = new Haber(); 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 h where h.baslik=?baslik limit 1", conneciton)) { cmd.Parameters.Add("baslik", pbaslik, MSqlDbType.VarChar); using (IDataReader IDR = cmd.ExecuteReader()) { while (IDR.Read()) { rvHaber = new Haber(MConvert.NullToInt64(IDR["id"]), MConvert.NullToGuidString(IDR["hesapid"]), MConvert.NullToString(IDR["kategoriid"]), MConvert.NullToString(IDR["resimurl"]), MConvert.NullToString(IDR["baslik"]), MConvert.NullToString(IDR["ozet"]), MConvert.NullToString(IDR["icerik"]), MConvert.NullToString(IDR["etiket"]), MConvert.NullToString(IDR["sehir"]), MConvert.NullToDateTime(IDR["kayittarihi"]), MConvert.NullToDateTime(IDR["guncellemetarihi"]), MConvert.NullToBool(IDR["gosterimsayi"]), MConvert.NullToInt64(IDR["video"]), MConvert.NullToInt64(IDR["galeri"]), MConvert.NullToBool(IDR["uye"]), MConvert.NullToBool(IDR["yorum"]), MConvert.NullToBool(IDR["yoneticionay"]), MConvert.NullToBool(IDR["anasayfa"]), MConvert.NullToBool(IDR["aktif"])); } IDR.Close(); } } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rvHaber); }
///<summary> /// Haber Data Update ///</summary> public static int Update(Haber p) { int 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, "update haber set hesapid=?hesapid,kategoriid=?kategoriid,resimurl=?resimurl,baslik=?baslik,ozet=?ozet,icerik=?icerik,etiket=?etiket,sehir=?sehir,kayittarihi=?kayittarihi,guncellemetarihi=?guncellemetarihi,gosterimsayi=?gosterimsayi,video=?video,galeri=?galeri,uye=?uye,yorum=?yorum,yoneticionay=?yoneticionay,anasayfa=?anasayfa,aktif=?aktif where id=?id", conneciton)) { cmd.Parameters.Add("id", p.ID, MSqlDbType.BigInt); 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 = cmd.ExecuteNonQuery(); } switch (conneciton.State) { case System.Data.ConnectionState.Open: conneciton.Close(); break; } } return(rowsAffected); }
///<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> /// Haber Getir /// </summary> public static Haber GetHaber(CommandType cmdType, string sqlQuery, MParameterCollection parameters) { Haber rvHaber = new Haber(); 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()) { rvHaber = 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 void Remove(Haber obj) { this.List.Remove(obj); }
public int IndexOf(Haber obj) { return(this.List.IndexOf(obj)); }
public bool Contains(Haber obj) { return(this.List.Contains(obj)); }
public void Insert(int index, Haber obj) { this.List.Insert(index, obj); }
public int Add(Haber obj) { return(this.List.Add(obj)); }