public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
string id = context.Request["id"];
string aciklama = context.Request["aciklama"];
try
{
SqlCommand guncelle = new SqlCommand("UPDATE galeriFotograf SET aciklama='" + aciklama + "' where ID=" + id + "", baglanti.baglanti());
guncelle.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(id);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
HttpPostedFile postedFile = context.Request.Files["Filedata"];
string haberid = context.Request["haberid"];
string id = context.Request["id"];
try
{
SqlCommand guncelle = new SqlCommand("UPDATE SliderHaber SET haberid=" + haberid + " where id=" + Convert.ToInt16(id) + "", baglanti.baglanti());
guncelle.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
string id = context.Request["yazar_id"];
string sira = context.Request["ord"];
try
{
SqlCommand guncelle = new SqlCommand("UPDATE yazarlar SET ord=" + sira + " where yazar_id=" + id + "", baglanti.baglanti());
guncelle.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(id);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
string sira = context.Request["sira"];
string ad = context.Request["ad"];
try
{
SqlCommand sor = new SqlCommand("insert into turlerHaber (AnasayfaSira,tur_ad,Anasayfada) values(" + sira + ",'" + ad + "',1)", baglanti.baglanti());
sor.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
string cid = context.Request["veri"];
try
{
SqlDataReader okuyucu;
SqlCommand sor = new SqlCommand("SELECT Anasayfada as durum FROM turlerHaber where tur_id=" + Convert.ToInt32(cid) + "", baglanti.baglanti());
okuyucu = sor.ExecuteReader();
int durumoku = 0;
string sonuc = "";
while (okuyucu.Read())
{
durumoku = Convert.ToInt16(okuyucu["durum"].ToString());
}
if (durumoku == 1)
{
sonuc = "0";
yazi = cid;
}
else
{
sonuc = "1";
yazi = cid;
}
SqlCommand guncelle = new SqlCommand("UPDATE turlerHaber SET Anasayfada=" + sonuc + " where tur_id=" + Convert.ToInt16(cid) + "", baglanti.baglanti());
guncelle.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
HttpPostedFile postedFile = context.Request.Files["Filedata"];
string cid = context.Request["veri"];
try
{
fonk baglanti = new fonk();
SqlCommand sor = new SqlCommand("SELECT * FROM yoneticiler", baglanti.baglanti());
SqlDataReader okuyucu = sor.ExecuteReader();
string sifrete = "";
while (okuyucu.Read())
{
sifrete = okuyucu["adm_password"].ToString();
}
baglanti.son();
SmtpClient sc = new SmtpClient();
sc.Port = 587;
sc.Host = "mail.qualitydergisi.com";
sc.EnableSsl = false;
sc.Timeout = 50000;
sc.Credentials = new NetworkCredential("*****@*****.**", "QUality265");
MailMessage mail = new MailMessage();
mail.From = new MailAddress("*****@*****.**", "*****@*****.**");
mail.To.Add("*****@*****.**");
mail.Subject = "Site Yönetim Şifresi";
mail.IsBodyHtml = true;
mail.Body = sifrete;
sc.Send(mail);
yazi = "Adresinize gönderildi";
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
string sonuc = "";
try
{
try
{
SqlCommand sor = new SqlCommand("SELECT turlerHaber.tur_ad as adi,turlerHaber.renk as renk, ( select count(id) from haberler where haberler.tur_id=turlerHaber.tur_id ) AS hit FROM turlerHaber ORDER BY hit DESC", baglanti.baglanti());
SqlDataReader oku = sor.ExecuteReader();
while (oku.Read())
{
sonuc += "<div class='new' style='background:" + oku["renk"].ToString() + "'><b>" + oku["adi"].ToString() + "</b> <br> " + oku["hit"].ToString() + "<br></div>";
}
baglanti.son();
string habersayisiSTR = "";
SqlCommand habersayisisorgu = new SqlCommand("select count(*) from haberler", baglanti.baglanti());
SqlDataReader habersayisisorgusuoku = habersayisisorgu.ExecuteReader();
while (habersayisisorgusuoku.Read())
{
habersayisiSTR = habersayisisorgusuoku[0].ToString();
}
context.Response.Write("<div style=''>'" + sonuc + "</div><br><br><div class='clearfix'></div><br><br><div style='background:#dff0d8;color:#468847;border:1px solid #468847; padding:20px;>'<p style='font-size:20px !important'>" + habersayisiSTR + " Haber </p></div>");
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write("Hata Oldu Kapat Hemen");
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
string tur_id = context.Request["tur_id"];
string baslik = context.Request["baslik"];
string metin = context.Request["metin"].ToString();
string foto = context.Request["foto"].ToString();
try
{
try
{
//context.Response.Write(tur_id.ToString() + baslik + metin + foto.ToString());
SqlCommand kayit = new SqlCommand("insert into haberler (tur_id,baslik,metin,foto,akt) " +
"values(" + Convert.ToInt16(tur_id) + ",'" + baslik.ToString() + "','" +
System.Net.WebUtility.HtmlEncode(metin.ToString()) + "','" + foto.ToString() + "',1)", baglanti.baglanti());
kayit.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
string ad = context.Request["ad"];
string resim = context.Request["resim"];
try
{
try
{
//context.Response.Write(tur_id.ToString() + baslik + metin + foto.ToString());
SqlCommand kayit = new SqlCommand("insert into yazarlar (ad,resim,akt) values('" + ad + "','" + resim + "',1)", baglanti.baglanti());
kayit.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
public void ProcessRequest(HttpContext context)
{
string yazi = "";
fonk baglanti = new fonk();
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
HttpPostedFile postedFile = context.Request.Files["Filedata"];
string cid = context.Request["veri"];
try
{
SqlDataReader okuyucu;
SqlCommand sor = new SqlCommand("SELECT aktif as durum FROM galeri where ID=" + Convert.ToInt32(cid) + "", baglanti.baglanti());
okuyucu = sor.ExecuteReader();
string durumoku = "";
string sonuc = "";
bool yeni = true;
while (okuyucu.Read())
{
durumoku = okuyucu["durum"].ToString();
yeni = bool.Parse(durumoku);
}
if (yeni)
{
sonuc = "0";
yazi = "NO";
}
else
{
sonuc = "1";
yazi = "OK";
}
SqlCommand guncelle = new SqlCommand("UPDATE galeri SET aktif=" + sonuc + " where ID=" + Convert.ToInt16(cid) + "", baglanti.baglanti());
guncelle.ExecuteNonQuery();
baglanti.son();
}
catch (Exception ex)
{
context.Response.Write(ex.ToString());
}
finally
{
context.Response.Write(yazi);
context.Response.StatusCode = 200;
}
}
catch
{
context.Response.Write(yazi);
}
}
