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