public enIcerikVideo VideoGetir(int videoId) { StringBuilder sb = new StringBuilder(); sb.Append("SELECT * FROM IcerikVideolari WHERE icrkVid_id = @id "); MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection()); adp.SelectCommand.Parameters.AddWithValue("@id", videoId); DataTable dt = new DataTable(); adp.Fill(dt); enIcerikVideo video = new enIcerikVideo(); if (dt.Rows.Count > 0) { DataRow rw = dt.Rows[0]; video.Aciklama = rw["icrkVid_aciklama"].ToString(); video.Baslik = rw["icrkVid_baslik"].ToString(); video.SayfaId = rw["icrkVid_site_id"].xToIntDefault(); video.Id = rw["icrkVid_id"].xToIntDefault(); video.KayitTarihi = rw["icrkVid_kayitTar"].xToDateTimeDefault(); video.Kaynak = rw["icrkVid_source"].ToString(); video.Kapak = rw["icrkVid_kapak"].ToString(); video.Sira = rw["icrkVid_sira"].xToIntDefault(); video.Statu = rw["icrkVid_statu"].xToBooleanDefault(); video.UrlKodu = rw["icrkVid_urlKodu"].ToString(); } return(video); }
public void VideoAciklamaGuncelle(enIcerikVideo video) { Dictionary <string, object> dict = new Dictionary <string, object>(); List <object> degerList = new List <object>(); dict.Add("icrkVid_aciklama", video.Aciklama); FxMySqlHelper.Update("IcerikVideolari", dict, "icrkVid_id", video.Id); }
protected void txtVideoSiraNo_TextChanged(object sender, EventArgs e) { RadTextBox txt = sender as RadTextBox; int id = txt.Attributes["dzID"].xToIntDefault(); enIcerikVideo video = bllIcerikVideolari.Getir(id); video.Sira = txt.Text.xToIntDefault(); bllIcerikVideolari.SiraGuncelle(video); VideolariGetir(); }
public List <enIcerikVideo> VideoleriGetir(int sayfaId, int?kayitSayisi, bool?statu) { string topStr = kayitSayisi == null ? "" : " TOP " + kayitSayisi + " "; StringBuilder sb = new StringBuilder(); MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection()); if (statu != null) { sb.Append("SELECT " + topStr + " * FROM IcerikVideolari WHERE icrkVid_site_id = @id AND icrkVid_statu = @statu ORDER BY icrkVid_sira "); adp.SelectCommand.Parameters.AddWithValue("@id", sayfaId); adp.SelectCommand.Parameters.AddWithValue("@statu", statu); } else { sb.Append("SELECT " + topStr + " * FROM IcerikVideolari WHERE icrkVid_site_id = @id ORDER BY icrkVid_sira "); adp.SelectCommand.Parameters.AddWithValue("@id", sayfaId); } adp.SelectCommand.CommandText = sb.ToString(); DataTable dt = new DataTable(); adp.Fill(dt); List <enIcerikVideo> videoler = new List <enIcerikVideo>(); foreach (DataRow rw in dt.Rows) { enIcerikVideo video = new enIcerikVideo(); video.Aciklama = rw["icrkVid_aciklama"].ToString(); video.Baslik = rw["icrkVid_baslik"].ToString(); video.SayfaId = rw["icrkVid_site_id"].xToIntDefault(); video.Id = rw["icrkVid_id"].xToIntDefault(); video.KayitTarihi = rw["icrkVid_kayitTar"].xToDateTimeDefault(); video.Kaynak = rw["icrkVid_source"].ToString(); video.Kapak = rw["icrkVid_kapak"].ToString(); video.Sira = rw["icrkVid_sira"].xToIntDefault(); video.Statu = rw["icrkVid_statu"].xToBooleanDefault(); video.UrlKodu = rw["icrkVid_urlKodu"].ToString(); videoler.Add(video); } return(videoler); }
public void YeniVideoEkle(enIcerikVideo video) { Dictionary <string, object> dict = new Dictionary <string, object>(); List <object> degerList = new List <object>(); dict.Add("icrkVid_site_id", video.SayfaId); dict.Add("icrkVid_baslik", video.Baslik); dict.Add("icrkVid_aciklama", video.Aciklama); dict.Add("icrkVid_source", video.Kaynak); dict.Add("icrkVid_kapak", video.Kapak); dict.Add("icrkVid_sira", video.Sira); dict.Add("icrkVid_statu", video.Statu); dict.Add("icrkVid_kayitTar", video.KayitTarihi); dict.Add("icrkVid_kaydeden", video.Kaydeden); dict.Add("icrkVid_urlKodu", video.UrlKodu); FxMySqlHelper.Insert("IcerikVideolari", dict); }
protected void btnVideoEkle_Click(object sender, EventArgs e) { enIcerikVideo video = new enIcerikVideo(); video.SayfaId = VwID.Value; video.Aciklama = txtVidAciklama.Text; video.Baslik = txtVidBaslik.Text; video.Kaynak = txtVidKaynak.Text.xBosMu() ? "//player.vimeo.com/video/" + txtVidKaynakVimeo.Text : "//www.youtube.com/embed/" + txtVidKaynak.Text; video.Kapak = hdnKapakUrl.Value; //imgKapak.Attributes["src"]; video.Kaydeden = SessionManager.Admin.Id; video.KayitTarihi = DateTime.Now.Date; video.Sira = bllIcerikVideolari.SonSiraNoGetir(video.SayfaId) + 1; video.Statu = chkVidAktifEkle.Checked; video.UrlKodu = txtVidKaynak.Text.xBosMu() ? txtVidKaynakVimeo.Text : txtVidKaynak.Text; bllIcerikVideolari.YeniEkle(video); VideolariGetir(); }
public static void AciklamaGuncelle(enIcerikVideo video) { new dalIcerikVideolari().VideoAciklamaGuncelle(video); }
public static void SiraGuncelle(enIcerikVideo video) { new dalIcerikVideolari().VideoSiraGuncelle(video); }
public static void YeniEkle(enIcerikVideo video) { new dalIcerikVideolari().YeniVideoEkle(video); }