public void ArkaPlanRengiGuncelle(enSiteHaritasi_Blok sBlok)
{
string strW = sBlok.SayfaId == 0 ? "" : " AND site_id = @siteId ";
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE SiteHaritasi_Blok ");
sb.Append("SET arkaplan_rengi = @renk ");
sb.Append("WHERE bPoz_id = @pozId AND blok_id = @blokId " + strW);
MySqlCommand cmd = new MySqlCommand(sb.ToString(), FxMySqlHelper.Connection());
cmd.Parameters.AddWithValue("@arkaplan_rengi", sBlok.ArkaplanRengi);
cmd.Parameters.AddWithValue("@bPoz_id", sBlok.PozisyonId);
cmd.Parameters.AddWithValue("@blokId", sBlok.BlokId);
if (sBlok.SayfaId != 0)
{
cmd.Parameters.AddWithValue("@siteId", sBlok.SayfaId);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public enCarouselResim BirAlttakiResmiGetir(enCarouselResim gResim)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT TOP 1 * FROM CarouselResimleri
WHERE carRes_car_id = @id AND carRes_sira > @sira ORDER BY carRes_sira ");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", gResim.CarouselId);
adp.SelectCommand.Parameters.AddWithValue("@sira", gResim.Sira);
DataTable dt = new DataTable();
adp.Fill(dt);
enCarouselResim resim = new enCarouselResim();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
resim.Buyuk = rw["carRes_buyuk"].ToString();
resim.CarouselId = rw["carRes_car_id"].xToIntDefault();
resim.Id = rw["carRes_id"].xToIntDefault();
resim.KayitTarihi = rw["carRes_kayitTar"].xToDateTimeDefault();
resim.Kucuk = rw["carRes_kucuk"].ToString();
resim.Orta = rw["carRes_orta"].ToString();
resim.Sira = rw["carRes_sira"].xToIntDefault();
resim.Statu = rw["carRes_statu"].xToBooleanDefault();
}
return(resim);
}
public List <enBlok> SayfaEklenmemisleriGetir(int sayfaId, bool?statu)
{
string whereStr = statu == null ? "" : " AND Bloklar.blok_statu = @statu ";
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT Bloklar.*, SiteHaritasi_Blok.*
FROM Bloklar LEFT JOIN
[SELECT SiteHaritasi_Blok.* FROM SiteHaritasi_Blok WHERE SiteHaritasi_Blok.site_id = @siteId ]. AS SiteHaritasi_Blok
ON Bloklar.blok_id = SiteHaritasi_Blok.blok_id
WHERE SiteHaritasi_Blok.blok_id IS NULL" + whereStr);
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@siteId", sayfaId);
if (statu != null)
{
adp.SelectCommand.Parameters.AddWithValue("@statu", statu);
}
DataTable dt = new DataTable();
adp.Fill(dt);
List <enBlok> bloklar = new List <enBlok>();
foreach (DataRow rw in dt.Rows)
{
enBlok blok = new enBlok();
blok.Adi = rw["blok_adi"].ToString();
blok.Icerik = rw["blok_icerik"].ToString();
blok.Id = rw["Bloklar.blok_id"].xToIntDefault();
blok.Sira = rw["sira"].xToIntDefault();
blok.UscYolu = rw["blok_uscYol"].ToString();
blok.BaslikKullanimi = rw["baslik"].xToBooleanDefault();
blok.Height = rw["height"].ToString();
blok.Statu = rw["blok_statu"].xToBooleanDefault();
blok.CerceveKullanimi = rw["cerceve"].xToBooleanDefault();
blok.Default = rw["blok_default"].xToBooleanDefault();
blok.PozisyonId = rw["bPoz_id"].xToIntDefault();
blok.SayfaId = rw["blok_sayfa_id"].xToInt();
blok.Aciklama = rw["blok_aciklama"].ToString();
blok.CarouselId = rw["blok_car_id"].xToInt();
blok.CerceveRengi = rw["cerceve_rengi"].ToString();
blok.ArkaplanRengi = rw["arkaplan_rengi"].ToString();
blok.MetinRengi = rw["metin_rengi"].ToString();
if (SessionManager.Admin != null && SessionManager.Admin.Finex)
{
blok.Default = false;
}
bloklar.Add(blok);
}
return(bloklar);
}
public void Kaldir(int pozisyonId, int blokId, int?sayfaId = null)
{
string wStr = sayfaId == null ? "" : " AND site_id = @siteId ";
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM SiteHaritasi_Blok ");
sb.Append("WHERE bPoz_id = @pozId AND blok_id = @blokId " + wStr);
MySqlCommand cmd = new MySqlCommand(sb.ToString(), FxMySqlHelper.Connection());
cmd.Parameters.AddWithValue("@pozId", pozisyonId);
cmd.Parameters.AddWithValue("@blokId", blokId);
if (sayfaId != null)
{
cmd.Parameters.AddWithValue("@siteId", sayfaId);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public enBlokPozisyon Getir(int id)
{
StringBuilder sb = new StringBuilder();
MySqlDataAdapter adp = new MySqlDataAdapter("", FxMySqlHelper.Connection());
sb.Append("SELECT * FROM BlokPozisyonlari WHERE bPoz_id = @id");
adp.SelectCommand.Parameters.AddWithValue("@id", id);
adp.SelectCommand.CommandText = sb.ToString();
DataTable dt = new DataTable();
adp.Fill(dt);
enBlokPozisyon pozisyon = new enBlokPozisyon();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
pozisyon.Id = rw["bPoz_id"].xToIntDefault();
pozisyon.Adi = rw["bPoz_adi"].ToString();
pozisyon.Master = rw["bPoz_master"].xToBooleanDefault();
}
return(pozisyon);
}
public void YukseklikGuncelle(enSiteHaritasi_Blok sBlok)
{
string strW = sBlok.SayfaId == 0 ? "" : " AND site_id = @siteId ";
StringBuilder sb = new StringBuilder();
sb.Append("UPDATE SiteHaritasi_Blok ");
sb.Append("SET height = @height ");
sb.Append("WHERE bPoz_id = @pozId AND blok_id = @blokId " + strW);
MySqlCommand cmd = new MySqlCommand(sb.ToString(), FxMySqlHelper.Connection());
cmd.Parameters.AddWithValue("@height", sBlok.Height.xToIntDefault() == 0 ? "" : sBlok.Height);
cmd.Parameters.AddWithValue("@bPoz_id", sBlok.PozisyonId);
cmd.Parameters.AddWithValue("@blokId", sBlok.BlokId);
if (sBlok.SayfaId != 0)
{
cmd.Parameters.AddWithValue("@siteId", sBlok.SayfaId);
}
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
public enCssDosya CssGetir(int cssId)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM CssDosyalari WHERE css_id = @id");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", cssId);
DataTable dt = new DataTable();
adp.Fill(dt);
enCssDosya css = new enCssDosya();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
css.Id = rw["css_id"].xToIntDefault();
css.Adi = rw["css_adi"].ToString();
css.SablonId = rw["css_sbl_id"].xToIntDefault();
}
return(css);
}
public enGmap GmapGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM GMap");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
enGmap gmap = new enGmap();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
gmap.Id = rw["gmap_id"].xToIntDefault();
gmap.APIKey = rw["gmap_apiKey"].ToString();
gmap.Latitude = rw["gmap_lat"].ToString();
gmap.Longitude = rw["gmap_long"].ToString();
gmap.Statu = rw["gmap_statu"].xToBooleanDefault();
gmap.Metin = rw["gmap_metin"].ToString();
}
return(gmap);
}
public List <enTasarimAyar> TasarimAyarlariniGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM TasarimAyarlari");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
List <enTasarimAyar> ayarlar = new List <enTasarimAyar>();
foreach (DataRow rw in dt.Rows)
{
enTasarimAyar ayar = new enTasarimAyar();
ayar.Id = rw["tasAy_id"].xToIntDefault();
ayar.Adi = rw["tasAy_adi"].ToString();
ayar.Degeri = rw["tasAy_degeri"].ToString();
ayarlar.Add(ayar);
}
return(ayarlar);
}
public enTasarimAyar TasarimAyariGetir(int id)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM TasarimAyarlari WHERE tasAy_id = @id");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", id);
DataTable dt = new DataTable();
adp.Fill(dt);
enTasarimAyar ayar = new enTasarimAyar();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
ayar.Id = rw["tasAy_id"].xToIntDefault();
ayar.Adi = rw["tasAy_adi"].ToString();
ayar.Degeri = rw["tasAy_degeri"].ToString();
}
return(ayar);
}
public enIcerikSablon SablonGetir(int sablonId)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM IcerikSablonlari WHERE icerikSablon_id = @id");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", sablonId);
DataTable dt = new DataTable();
adp.Fill(dt);
enIcerikSablon sablon = new enIcerikSablon();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
sablon.Id = rw["icerikSablon_id"].xToIntDefault();
sablon.Adi = rw["icerikSablon_adi"].ToString();
sablon.Aciklama = rw["icerikSablon_aciklama"].ToString();
sablon.MasterPageFile = rw["icerikSablon_masterPage"].ToString();
}
return(sablon);
}
public List <enIcerikSablon> SablonlariGetir()
{
StringBuilder sb = new StringBuilder();
MySqlDataAdapter adp = new MySqlDataAdapter("", FxMySqlHelper.Connection());
sb.Append("SELECT * FROM IcerikSablonlari");
adp.SelectCommand.CommandText = sb.ToString();
DataTable dt = new DataTable();
adp.Fill(dt);
List <enIcerikSablon> IcerikSablonlari = new List <enIcerikSablon>();
foreach (DataRow rw in dt.Rows)
{
enIcerikSablon sablon = new enIcerikSablon();
sablon.Id = rw["icerikSablon_id"].xToIntDefault();
sablon.Adi = rw["icerikSablon_adi"].ToString();
sablon.Aciklama = rw["icerikSablon_aciklama"].ToString();
sablon.MasterPageFile = rw["icerikSablon_masterPage"].ToString();
IcerikSablonlari.Add(sablon);
}
return(IcerikSablonlari);
}
public enAdmin AdminGetir(int adminId)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM Admin WHERE adm_id = @id ");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@adi", adminId);
DataTable dt = new DataTable();
adp.Fill(dt);
enAdmin admin = new enAdmin();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
admin.KullaniciAdi = rw["adm_kullAdi"].ToString();
admin.Sifre = rw["adm_sifre"].ToString();
admin.Id = rw["adm_id"].xToIntDefault();
admin.Finex = rw["adm_finex"].xToBooleanDefault();
admin.Statu = rw["adm_statu"].xToBooleanDefault();
}
return(admin);
}
public List <enAdmin> AdminleriGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM Admin");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
List <enAdmin> adminler = new List <enAdmin>();
foreach (DataRow rw in dt.Rows)
{
enAdmin admin = new enAdmin();
admin.KullaniciAdi = rw["adm_kullAdi"].ToString();
admin.Sifre = rw["adm_sifre"].ToString();
admin.Id = rw["adm_id"].xToIntDefault();
admin.Finex = rw["adm_finex"].xToBooleanDefault();
admin.Statu = rw["adm_statu"].xToBooleanDefault();
adminler.Add(admin);
}
return(adminler);
}
public List <enBlokPozisyon> Getir()
{
StringBuilder sb = new StringBuilder();
MySqlDataAdapter adp = new MySqlDataAdapter("", FxMySqlHelper.Connection());
sb.Append("SELECT * FROM BlokPozisyonlari ORDER BY bPoz_adi");
adp.SelectCommand.CommandText = sb.ToString();
DataTable dt = new DataTable();
adp.Fill(dt);
List <enBlokPozisyon> pozisyonlar = new List <enBlokPozisyon>();
foreach (DataRow rw in dt.Rows)
{
enBlokPozisyon pozisyon = new enBlokPozisyon();
pozisyon.Id = rw["bPoz_id"].xToIntDefault();
pozisyon.Adi = rw["bPoz_adi"].ToString();
pozisyon.Master = rw["bPoz_master"].xToBooleanDefault();
pozisyonlar.Add(pozisyon);
}
return(pozisyonlar);
}
public enGenelAyar GenelAyarGetir(int ayarId)
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM GenelAyarlar WHERE gayr_id = @id");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", ayarId);
DataTable dt = new DataTable();
adp.Fill(dt);
enGenelAyar ayar = new enGenelAyar();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
ayar.Adi = rw["gayr_adi"].ToString();
ayar.Icerik = rw["gayr_icerik"].ToString();
ayar.Id = rw["gayr_id"].xToIntDefault();
ayar.Statu = rw["gayr_statu"].xToBooleanDefault();
}
return(ayar);
}
public List <enGenelAyar> GenelAyarlariGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT * FROM GenelAyarlar");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
List <enGenelAyar> ayarlar = new List <enGenelAyar>();
foreach (DataRow rw in dt.Rows)
{
enGenelAyar ayar = new enGenelAyar();
ayar.Adi = rw["gayr_adi"].ToString();
ayar.Icerik = rw["gayr_icerik"].ToString();
ayar.Id = rw["gayr_id"].xToIntDefault();
ayar.Statu = rw["gayr_statu"].xToBooleanDefault();
ayarlar.Add(ayar);
}
return(ayarlar);
}
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 enDizi DiziGetirEnt(string kodu)
{
string sql = @"select * from Diziler where dizi_kodu = @kodu";
MySqlDataAdapter adp = new MySqlDataAdapter(sql, FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@kodu", kodu);
DataTable dt = new DataTable();
adp.Fill(dt);
enDizi dizi = new enDizi();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
dizi.Id = rw["dizi_id"].xToIntDefault();
dizi.Kodu = rw["dizi_kodu"].ToString();
dizi.VarsayilanDegeri = rw["dizi_degeri"].ToString();
}
return(dizi);
}
public enCarousel Getir(int carouselId)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM Carousel WHERE car_id = @id");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@id", carouselId);
DataTable dt = new DataTable();
adp.Fill(dt);
enCarousel carousel = new enCarousel();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
carousel.Adi = rw["car_adi"].ToString();
carousel.Id = rw["car_id"].xToIntDefault();
carousel.KayitTarihi = rw["car_kayitTar"].xToDateTimeDefault();
carousel.Statu = rw["car_statu"].xToBooleanDefault();
carousel.TekrarSayisi = rw["car_tekrarSayisi"].xToIntDefault();
carousel.GosterimSuresi = rw["car_gosterimSuresi"].xToIntDefault();
}
return(carousel);
}
public List <enCarousel> CarouselleriGetir()
{
StringBuilder sb = new StringBuilder();
sb.Append(@"SELECT rg.*,(SELECT COUNT(*) FROM CarouselResimleri r WHERE r.carcarRes_car_id = rg.car_id) AS ResimSayisi
FROM Carousel rg ");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
DataTable dt = new DataTable();
adp.Fill(dt);
List <enCarousel> carouseller = new List <enCarousel>();
foreach (DataRow rw in dt.Rows)
{
enCarousel carousel = new enCarousel();
carousel.Adi = rw["car_adi"].ToString();
carousel.Id = rw["car_id"].xToIntDefault();
carousel.KayitTarihi = rw["car_kayitTar"].xToDateTimeDefault();
carousel.Statu = rw["car_statu"].xToBooleanDefault();
carousel.ResimSayisi = rw["ResimSayisi"].xToIntDefault();
carousel.TekrarSayisi = rw["car_tekrarSayisi"].xToIntDefault();
carousel.GosterimSuresi = rw["car_gosterimSuresi"].xToIntDefault();
carouseller.Add(carousel);
}
return(carouseller);
}
public List <enSosyalMedya> AktifleriGetir()
{
DataTable dt = FxMySqlHelper.Select_Dt("SosyalMedya", "*", "sos_statu = " + true);
List <enSosyalMedya> medyalar = new List <enSosyalMedya>();
foreach (DataRow rw in dt.Rows)
{
enSosyalMedya sos = new enSosyalMedya();
sos.sos_adi = rw["sos_adi"].ToString();
sos.sos_id = rw["sos_id"].xToIntDefault();
sos.sos_ikonu = rw["sos_ikonu"].ToString();
sos.sos_sira = rw["sos_sira"].xToIntDefault();
sos.sos_statu = rw["sos_statu"].xToBooleanDefault();
sos.sos_url = rw["sos_url"].ToString();
sos.sos_menu = rw["sos_menu"].xToBooleanDefault();
sos.sos_yanMenu = rw["sos_yanMenu"].xToBooleanDefault();
sos.sos_footer = rw["sos_footer"].xToBooleanDefault();
medyalar.Add(sos);
}
return(medyalar);
}
public enIcerikResim AnaResimGetir(int?sayfaId)
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * From IcerikResimleri where icrkRes_site_id=@sayfaId and icrkRes_anaResim=true");
MySqlDataAdapter adp = new MySqlDataAdapter(sb.ToString(), FxMySqlHelper.Connection());
adp.SelectCommand.Parameters.AddWithValue("@sayfaId", sayfaId);
DataTable dt = new DataTable();
adp.Fill(dt);
enIcerikResim resim = new enIcerikResim();
if (dt.Rows.Count > 0)
{
DataRow rw = dt.Rows[0];
resim.Aciklama = rw["icrkRes_aciklama"].ToString();
resim.Buyuk = rw["icrkRes_buyuk"].ToString();
resim.SayfaId = rw["icrkRes_site_id"].xToIntDefault();
resim.Id = rw["icrkRes_id"].xToIntDefault();
resim.KayitTarihi = rw["icrkRes_kayitTar"].xToDateTimeDefault();
resim.Kucuk = rw["icrkRes_kucuk"].ToString();
resim.Orta = rw["icrkRes_orta"].ToString();
resim.Sira = rw["icrkRes_sira"].xToIntDefault();
resim.Statu = rw["icrkRes_statu"].xToBooleanDefault();
resim.AnaResim = rw["icrkRes_anaResim"].xToBooleanDefault();
}
return(resim);
}
public void YeniKod(enDizi dizi)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("dizi_kodu", dizi.Kodu);
FxMySqlHelper.Insert("Diziler", dict);
}
public void VarsayilanDiziDuncelle(enDizi dizi)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
dict.Add("dizi_degeri", dizi.VarsayilanDegeri);
FxMySqlHelper.Update("Diziler", dict, "dizi_id", dizi.Id);
}
public void SiraGuncelle(int sosId, int sira)
{
Dictionary <string, object> pair = new Dictionary <string, object>();
pair.Add("sos_sira", sira);
FxMySqlHelper.Update("SosyalMedya", pair, "sos_id", sosId);
}
public void StatuGuncelle(int sosId, bool statu)
{
Dictionary <string, object> pair = new Dictionary <string, object>();
pair.Add("sos_statu", statu);
FxMySqlHelper.Update("SosyalMedya", pair, "sos_id", sosId);
}
public void YanMenudeGoster(enSosyalMedya sos)
{
Dictionary <string, object> pair = new Dictionary <string, object>();
pair.Add("sos_yanMenu", sos.sos_yanMenu);
FxMySqlHelper.Update("SosyalMedya", pair, "sos_id", sos.sos_id);
}
public void FooterdaGoster(enSosyalMedya sos)
{
Dictionary <string, object> pair = new Dictionary <string, object>();
pair.Add("sos_footer", sos.sos_menu);
FxMySqlHelper.Update("SosyalMedya", pair, "sos_id", sos.sos_id);
}
public void ResimSiraGuncelle(enIcerikResim resim)
{
Dictionary <string, object> dict = new Dictionary <string, object>();
List <object> degerList = new List <object>();
dict.Add("icrkRes_sira", resim.Sira);
FxMySqlHelper.Update("IcerikResimleri", dict, "icrkRes_id", resim.Id);
}
