public static List <jSonObject> GetHaberler(DateTime tarih1, DateTime tarih2, byte limit)
{
//GOSTERİM SAYISINA GORE GETİRİR
List <jSonObject> rv = new List <jSonObject>();
if (limit > 20)
{
return(rv);
}
using (System.Data.DataTable table = new System.Data.DataTable("haber"))
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(table, "select h.id,h.resimurl,h.baslik,h.ozet,h.kayittarihi,h.video,h.galeri,COUNT(g.icerikid) cnt from haber h inner join gosterim g on g.modulid='haber' and g.icerikid=h.id where h.yoneticionay=1 and h.aktif=1 and h.resimurl<>'' and h.kayittarihi < ?yayintarihi and h.kayittarihi between ?tarih1 and ?tarih2 group by h.id,h.resimurl,h.baslik,h.ozet,h.kayittarihi,h.video,h.galeri order by cnt desc limit " + limit))
{
data.Parameters.Add("yayintarihi", DateTime.Now, BAYMYO.MultiSQLClient.MSqlDbType.DateTime);
data.Parameters.Add("tarih1", tarih1, BAYMYO.MultiSQLClient.MSqlDbType.DateTime);
data.Parameters.Add("tarih2", tarih2, BAYMYO.MultiSQLClient.MSqlDbType.DateTime);
data.Execute();
foreach (System.Data.DataRow item in table.Rows)
{
m_ContentDate = BAYMYO.UI.Converts.NullToDateTime(item[4]);
rv.Add(new jSonObject {
ID = item[0].ToString(), Link = Core.CreateLink("haber", item[0], item[2]), Resim = item[1].ToString(), Baslik = item[2].ToString(), Ozet = item[3].ToString(), Tarih = m_ContentDate.ToLongDateString(), Saat = m_ContentDate.ToShortTimeString(), Video = !(item[5].ToString().Equals("0")), Galeri = !(item[6].ToString().Equals("0")), Yeni = (m_ContentDate >= DateTime.Now.AddHours(-5))
});
}
}
}
return(rv);
}
private void GetData()
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(rptMuayene, "CalismaAlani", "Kurum", "HesapID=@HesapID"))
{
data.Top = 10;
data.Parameters.Add("HesapID", Settings.CurrentUser().ID, BAYMYO.MultiSQLClient.MSqlDbType.UniqueIdentifier);
data.Execute();
}
}
private void GetOtherData(Album m)
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(rptOther,
"select g.id as resimid,g.resimurl,a.id,a.adi,a.kayittarihi from album a inner join galeri g on g.albumid=a.id and g.kapak=1 where a.id<>?id and a.yoneticionay=1 and a.aktif=1 and a.kategoriid like ?kategoriid order by a.guncellemetarihi desc limit 10"))
{
data.Parameters.Add("id", m.ID + "%", BAYMYO.MultiSQLClient.MSqlDbType.BigInt);
data.Parameters.Add("kategoriid", m.KategoriID + "%", BAYMYO.MultiSQLClient.MSqlDbType.VarChar);
data.Execute();
}
}
private void GetOtherData(Video m)
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(rptOther, "video", "guncellemetarihi desc", "id<>?id and yoneticionay=1 and aktif=1 and kategoriid like ?kategoriid"))
{
data.Top = 10;
data.Parameters.Add("id", m.ID + "%", BAYMYO.MultiSQLClient.MSqlDbType.BigInt);
data.Parameters.Add("kategoriid", m.KategoriID + "%", BAYMYO.MultiSQLClient.MSqlDbType.VarChar);
data.Execute();
}
}
public static List <jSonObject> GetHaberler(string q, byte type, byte limit)
{
List <jSonObject> rv = new List <jSonObject>();
if (limit > 20)
{
return(rv);
}
string query = "select h.id,h.resimurl,h.baslik,h.ozet,h.kayittarihi,h.video,h.galeri,h.kategoriid,k.adi,k.renk from haber h inner join kategori k on k.modulid='haber' and k.id=h.kategoriid where h.resimurl<>'' and h.kayittarihi < ?yayintarihi and h.yoneticionay=1 and h.aktif=1 ";
switch (type)
{
case 1:
query += " and h.anasayfa=1 ";
break;
}
if (string.IsNullOrWhiteSpace(q))
{
query += " and h.kategoriid NOT LIKE '" + Settings.Site.Category1.ID + "%' and h.kategoriid NOT LIKE '" + Settings.Site.Category2.ID + "%' and h.kategoriid NOT LIKE '" + Settings.Site.Category3.ID + "%' and h.kategoriid NOT LIKE '" + Settings.Site.Category4.ID + "%' ";
}
else if (type == 9 & q.Length >= 4 & q.Length <= 10)
{
query += " and h.baslik like '%" + q + "%' ";
}
else if (q.Length >= 3 & type != 9)
{
query += " and h.kategoriid like '" + q + "%' ";
}
query += " order by h.kayittarihi desc limit " + limit;
using (System.Data.DataTable table = new System.Data.DataTable("haber"))
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(table, query))
{
data.Parameters.Add("yayintarihi", DateTime.Now, BAYMYO.MultiSQLClient.MSqlDbType.DateTime);
data.Execute();
foreach (System.Data.DataRow item in table.Rows)
{
m_ContentDate = BAYMYO.UI.Converts.NullToDateTime(item[4]);
rv.Add(new jSonObject {
ID = item[0].ToString(), KategoriID = item[7].ToString(), KategoriAdi = item[8].ToString().ToUpper(), Deger = item[9].ToString(), Link = Core.CreateLink("haber", item[0], item[2]), Resim = item[1].ToString(), Baslik = item[2].ToString(), Ozet = item[3].ToString(), Tarih = m_ContentDate.ToLongDateString(), Saat = m_ContentDate.ToShortTimeString(), Video = !(item[5].ToString().Equals("0")), Galeri = !(item[6].ToString().Equals("0")), Yeni = (m_ContentDate >= DateTime.Now.AddHours(-5))
});
}
}
}
query = null;
return(rv);
}
private void CreateXml()
{
try
{
using (System.Data.DataTable dt = new System.Data.DataTable("Manset"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(dt, "Manset", "KayitTarihi DESC", "Aktif=1"))
{
query.Top = 9;
query.Execute();
dt.WriteXml(Server.MapPath(Settings.XmlPath + "manset.xml"), System.Data.XmlWriteMode.WriteSchema);
}
}
}
catch (Exception)
{
}
}
void CreateXml()
{
try
{
using (System.Data.DataTable dt = new System.Data.DataTable("manset"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(dt, "manset", "guncellemetarihi desc", "aktif=1"))
{
query.Top = 25;
query.Execute();
dt.WriteXml(Server.MapPath(Settings.XmlPath + "manset.xml"), System.Data.XmlWriteMode.WriteSchema);
}
}
}
catch (Exception ex)
{
CustomizeControl1.MessageText = MessageBox.Show(DialogResult.Error, ex.Message);
}
}
void CreateXml()
{
try
{
using (System.Data.DataTable dt = new System.Data.DataTable("manset"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(dt, "manset", "kayittarihi desc", "aktif=1"))
{
query.Top = 10;
query.Execute();
dt.WriteXml(Server.MapPath(Settings.XmlPath + "manset.xml"), System.Data.XmlWriteMode.WriteSchema);
}
}
}
catch (Exception ex)
{
pageNumberLiteral.Text = ex.Message;
}
}
public static List <jSonObject> GetGeleriler(string q, byte type, byte limit)
{
List <jSonObject> rv = new List <jSonObject>();
if (limit > 20)
{
return(rv);
}
using (System.Data.DataTable data = new System.Data.DataTable("album"))
{
string mq = "select COUNT(m.icerikid) from manset m where m.icerikid=a.id and m.kayittarihi < ?yayintarihi and m.resimbuyuk<>'' and m.modulid='album' and m.aktif=1 order by m.sira asc, m.kayittarihi desc limit 27";
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery())
{
query.TargetControl = data;
query.CommandText = "select a.id,g.resimurl,a.adi,a.kayittarihi from album a inner join galeri g on g.albumid=a.id and g.kapak=1 where (" + mq + ") <= 0 and a.yoneticionay=1 and a.aktif=1 ";
if (type == 9 & q.Length >= 3 & q.Length <= 10)
{
query.CommandText += " and a.adi like '%" + q + "%' ";
}
else if (q.Length >= 3 & type != 9)
{
query.CommandText += " and a.kategoriid like '" + q + "%' ";
}
query.CommandText += "order by a.kayittarihi desc limit " + limit;
query.Parameters.Add("yayintarihi", DateTime.Now, BAYMYO.MultiSQLClient.MSqlDbType.DateTime);
query.Execute();
foreach (System.Data.DataRow item in data.Rows)
{
m_ContentDate = BAYMYO.UI.Converts.NullToDateTime(item[3]);
rv.Add(new jSonObject {
ID = item[0].ToString(), Resim = Settings.ImagesPath + "album/" + item[0].ToString() + "/" + item[1].ToString(), Link = Core.CreateLink("galeri", item[0].ToString(), item[2].ToString()), Baslik = item[2].ToString(), Tarih = m_ContentDate.ToLongDateString(), Saat = m_ContentDate.ToShortTimeString(), Yeni = (m_ContentDate >= DateTime.Now.AddHours(-5))
});
}
}
}
return(rv);
}
public static List <jSonObject> GetSeriIlanlar(byte limit)
{
List <jSonObject> rv = new List <jSonObject>();
if (limit > 10)
{
return(rv);
}
using (System.Data.DataTable data = new System.Data.DataTable("seriilan"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(data, "select s.id,s.resimurl,s.baslik,s.fiyat,s.guncellemetarihi from seriilan s where s.aktif=1 order by s.guncellemetarihi desc limit " + limit))
{
query.Execute();
foreach (System.Data.DataRow item in data.Rows)
{
rv.Add(new jSonObject {
ID = item[0].ToString(), Resim = item[1].ToString(), Link = Core.CreateLink("seriilan", item[0].ToString(), item[2].ToString()), Baslik = item[2].ToString(), Deger = string.Format("{0:#0.00}", item[3]), Tarih = BAYMYO.UI.Converts.NullToDateTime(item[4]).ToLongDateString()
});
}
}
}
return(rv);
}
public static List <jSonObject> GetBaglantilar(byte limit)
{
List <jSonObject> rv = new List <jSonObject>();
if (limit > 10)
{
return(rv);
}
using (System.Data.DataTable data = new System.Data.DataTable("firma"))
{
using (BAYMYO.UI.Web.CustomSqlQuery query = new BAYMYO.UI.Web.CustomSqlQuery(data, "select f.id,f.resimurl,f.adi,f.adres,f.telefon1,f.guncellemetarihi from firma f where f.aktif=1 order by f.guncellemetarihi desc limit " + limit))
{
query.Execute();
foreach (System.Data.DataRow item in data.Rows)
{
rv.Add(new jSonObject {
ID = item[0].ToString(), Resim = item[1].ToString(), Link = Core.CreateLink("firma", item[0].ToString(), item[2].ToString()), Baslik = item[2].ToString(), Ozet = item[3].ToString() + " Tel: <b class=\"phone\">" + item[4].ToString() + "</b>", Tarih = BAYMYO.UI.Converts.NullToDateTime(item[5]).ToLongDateString()
});
}
}
}
return(rv);
}
private void GetData(Guid pHesapID)
{
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(rptMakaleler, "Makale", "KayitTarihi DESC", "Aktif=1"))
{
data.Where += " AND HesapID=@HesapID";
data.Parameters.Add("HesapID", pHesapID, BAYMYO.MultiSQLClient.MSqlDbType.UniqueIdentifier);
data.Top = 5;
data.Execute();
if (rptMakaleler.Items.Count < 1)
{
ltrMessage.Visible = true;
ltrMessage.Text = "<div style=\"display:inline-block;\">" + MessageBox.IsNotViews() + "</div>";
}
}
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(rptMuayene, "SELECT TOP(5) CalismaAlani.* FROM CalismaAlani WHERE (CalismaAlani.HesapID=@HesapID) AND (CalismaAlani.Varsayilan=0) AND (CalismaAlani.Aktif=1)"))
{
data.Parameters.Add("HesapID", pHesapID, BAYMYO.MultiSQLClient.MSqlDbType.UniqueIdentifier);
data.Execute();
workArea.Visible = (rptMuayene.Items.Count >= 1);
}
}
public static List <Database> ProcRun(DatabaseProccesType procType)
{
List <Database> rv = new List <Database>();
string commandText = null;
switch (procType)
{
case DatabaseProccesType.Analyze:
commandText = "analyze tables ";
break;
case DatabaseProccesType.Check:
commandText = "check tables ";
break;
case DatabaseProccesType.Repair:
commandText = "repair tables ";
break;
default:
commandText = "optimize tables ";
break;
}
using (System.Data.DataTable dt = new System.Data.DataTable("tables"))
{
using (BAYMYO.UI.Web.CustomSqlQuery q = new BAYMYO.UI.Web.CustomSqlQuery(dt, "show tables"))
{
q.Execute();
int count = dt.Rows.Count - 2;
for (int i = 0; i < count; i++)
{
commandText += MConvert.NullToString(dt.Rows[i][0]) + ',';
}
if (dt.Rows.Count > 0)
{
commandText += MConvert.NullToString(dt.Rows[count + 1][0]);
}
count = 0;
}
}
using (MConnection conneciton = new MConnection(MClientProvider.MySQL))
{
switch (conneciton.State)
{
case System.Data.ConnectionState.Closed:
conneciton.Open();
break;
}
using (MCommand cmd = new MCommand(System.Data.CommandType.Text, commandText, conneciton))
{
using (System.Data.IDataReader IDR = cmd.ExecuteReader())
{
while (IDR.Read())
{
rv.Add(new Database(MConvert.NullToString(IDR[0]), MConvert.NullToString(IDR[1]), MConvert.NullToString(IDR[2]), MConvert.NullToString(IDR[3])));
}
IDR.Close();
}
}
switch (conneciton.State)
{
case System.Data.ConnectionState.Open:
conneciton.Close();
break;
}
}
return(rv);
}
protected override void OnInit(EventArgs e)
{
try
{
CustomizeControl1.FormTitle = string.Format(Settings.FormTitleFormat, "Makale", "Ekleme/Düzeltme Formu");
if (Request.QueryString["mklid"] != null)
{
ViewState["tempID"] = Request.QueryString["mklid"];
}
using (Makale m = MakaleMethods.GetMakale(BAYMYO.UI.Converts.NullToInt64(ViewState["tempID"])))
{
bool notNull = (m.ID > 0), isAdmin = Core.IsUserAdmin;
if (notNull)
{
Default(m, isAdmin);
}
TextBox txt = new TextBox();
txt.ID = "Baslik";
txt.CssClass = "form-control";
txt.Text = m.Baslik;
txt.MaxLength = 75;
CustomizeControl1.AddControl("Başlık", txt);
txt = new TextBox();
txt.ID = "Ozet";
txt.CssClass = "form-control";
txt.Text = m.Ozet;
txt.TextMode = TextBoxMode.MultiLine;
txt.MaxLength = 150;
CustomizeControl1.AddControl("Özet", txt, "Liste ve RSS'ler için gösterilecek içeriktir.");
CKEditor.NET.CKEditorControl fck = new CKEditor.NET.CKEditorControl();
fck.ID = "Icerik";
fck.Height = 400;
fck.Text = m.Icerik;
CustomizeControl1.AddControl("Editör", fck);
txt = new TextBox();
txt.ID = "Etiket";
txt.CssClass = "form-control";
txt.Text = m.Etiket;
txt.MaxLength = 100;
CustomizeControl1.AddControl("Etiket", txt, string.Format("Lütfen virgül({0}) ile ayrıarak ve boşluk bırakmadan yazınız! Örnek: elma{0}meyve{0}sebze{0}bahçe", Settings.SplitFormat));
//DateTimeControl cnt = this.Page.LoadControl(Settings.DateTimeControlPath) as DateTimeControl;
//cnt.ID = "Tarih";
//cnt.FormatType = FormatTypes.DateTime;
//CustomizeControl1.AddControl("Tarih", cnt, "* Seçilmesi zorunlu alan.");
//cnt.Date = m.KayitTarihi;
DropDownList ddl = new DropDownList();
ddl.ID = "Yazar";
ddl.Width = 250;
ddl.CssClass = "form-control";
ddl.DataMember = "hesap";
ddl.DataValueField = "id";
ddl.DataTextField = "adi";
using (BAYMYO.UI.Web.CustomSqlQuery data = new BAYMYO.UI.Web.CustomSqlQuery(ddl, "select id, concat_ws(' ',adi,soyadi) as adi from hesap where tipi in(1,2,5)"))
{
data.Execute();
}
ddl.Items.Insert(0, new ListItem("<Seçiniz>", ""));
ddl.SelectedValue = BAYMYO.UI.Converts.NullToString(m.HesapID);
CustomizeControl1.AddControl("Yazarlar", ddl, "<a href=\"" + Settings.PanelPath + "?go=hesap&type=2\">[+] Yeni Yazar</a> (Not: Buraya sadece <b>Admin</b>, <b>Moderatör</b> ve <b>Private</b> olan yazarlar getirilir.)");
ddl = new DropDownList();
ddl.ID = "Kategori";
ddl.Width = 250;
ddl.CssClass = "form-control";
ddl.DataMember = "kategori";
ddl.DataValueField = "id";
ddl.DataTextField = "adi";
List <Kategori> kategoriler = KategoriMethods.GetMenu("makale", true);
ListItem item = null;
foreach (Kategori kategori in kategoriler)
{
switch (kategori.ParentID)
{
case "":
item = new ListItem(kategori.Adi, kategori.ID);
item.Attributes.CssStyle.Value = "padding-left: 5px;background: #f5f5f5; color: #454545;";
break;
case "0":
item = new ListItem(kategori.Adi, kategori.ID);
item.Attributes.CssStyle.Value = "padding-left: 25px;background: #f5f5f5; color: #fe760c; font-weight: bold;";
break;
default:
item = new ListItem(kategori.Adi, kategori.ID);
item.Attributes.CssStyle.Value = string.Format("padding-left: {0}px;background: #f5f5f5; color: #454545;", (BAYMYO.UI.Converts.NullToInt(kategori.ParentID.Split(',').Length + 1) * 25));
break;
}
ddl.Items.Add(item);
}
kategoriler.Clear();
ddl.SelectedValue = BAYMYO.UI.Converts.NullToString(m.KategoriID);
CustomizeControl1.AddControl("Kategori", ddl, "<a href=\"" + Settings.PanelPath + "?go=kategori&mdl=makale\">[+] Yeni Kategori</a>");
Image img = new Image();
img.ID = "BuyukResim";
img.ToolTip = m.ResimUrl;
if (!string.IsNullOrEmpty(m.ResimUrl))
{
img.ImageUrl = Settings.ImagesPath + "makale/" + m.ResimUrl;
}
else
{
img.ImageUrl = Settings.ImagesPath + "admin-yok.png";
}
CustomizeControl1.AddControl("Makale Resim", img);
FileUpload flu = new FileUpload();
flu.ID = "ResimUrl";
flu.ToolTip = m.ResimUrl;
flu.CssClass = "form-control";
CustomizeControl1.AddControl("Resim Ekle", flu, "Genişlik(W):728px - Yükseklik(H):300px");
CheckBoxList chkList = new CheckBoxList();
chkList.ID = "chkList";
chkList.RepeatDirection = RepeatDirection.Horizontal;
chkList.Items.Add("Gösterim Sayı");
chkList.Items[0].Selected = notNull ? m.GosterimSayi : true;
chkList.Items.Add("Üyelere Özel");
chkList.Items[1].Selected = m.Uye;
chkList.Items.Add("Yorumları Göster");
chkList.Items[2].Selected = notNull ? m.Yorum : false;
chkList.Items.Add("Yönetici Onayı");
chkList.Items[3].Selected = notNull ? m.YoneticiOnay : isAdmin;
chkList.Items[3].Enabled = isAdmin;
chkList.Items.Add("Yayımla");
chkList.Items[4].Selected = notNull ? m.Aktif : isAdmin;
chkList.Items[4].Enabled = isAdmin;
CustomizeControl1.AddControl("Seçimler", chkList);
CustomizeControl1.SubmitClick += new CustomizeControl.ButtonEvent(CustomizeControl1_SubmitClick);
CustomizeControl1.RemoveClick += new CustomizeControl.ButtonEvent(CustomizeControl1_RemoveClick);
}
}
catch (Exception ex)
{
CustomizeControl1.MessageText = MessageBox.Show(DialogResult.Error, ex.Message);
}
base.OnInit(e);
}
