public ActionResult MakaleSil(int GelenID)
{
RazerBlogContext _db = new RazerBlogContext();
Makale ToDel = _db.Makales.FirstOrDefault(x => x.MakaleID == GelenID);
return(View(ToDel));
}
public ActionResult KategoriGoster(int ViewKategoriID, string StrSayfa)
{
int Sayfa = 0;
if (StrSayfa == "" || StrSayfa == null)
{
Sayfa = 1;
}
else
{
Sayfa = Convert.ToInt32(StrSayfa);
}
int Kactan = 0;
int Kacar = 2;
RazerBlogContext _db = new RazerBlogContext();
int MakaleSayisi = _db.Makales.Where(x => x.Category.CategoryID == ViewKategoriID).Count();
double SayfaSayisi = Math.Ceiling((float)((1.0 * MakaleSayisi) / Kacar));
ViewBag.sayfasayisi = SayfaSayisi;
ViewBag.sayfa = Sayfa;
Kactan = (Sayfa * Kacar) - Kacar;
List <Makale> SayfaMakale = new List <Makale>(_db.Makales.Where(x => x.Category.CategoryID == ViewKategoriID).OrderByDescending(x => x.MakaleID).Skip(Kactan).Take(Kacar));
ViewBag.sayfamakale = SayfaMakale;
ViewBag.AktifKategoriID = ViewKategoriID;
return(View());
}
public ActionResult KategoriSil(int KategoriID)
{
RazerBlogContext _db = new RazerBlogContext();
Category CategoryToDel = _db.Categories.First(x => x.CategoryID == KategoriID);
return(View(CategoryToDel));
}
public ActionResult YorumlariYonet()
{
RazerBlogContext _db = new RazerBlogContext();
List <Yorum> YorumlarList = _db.Yorums.ToList();
return(View(YorumlarList));
}
public void yakalaıd(int yakalananıd)
{
RazerBlogContext _db = new RazerBlogContext();
List <SelectListItem> katlist = new List <SelectListItem>();
List <Category> katsorgu = _db.Categories.ToList();
foreach (Category item in katsorgu)
{
SelectListItem li = new SelectListItem();
li.Text = item.Name;
li.Value = item.CategoryID.ToString();
if (yakalananıd == item.CategoryID)
{
li.Selected = true;
//katlist.Add(new SelectListItem { Text = item.Name, Value = item.CategoryID.ToString(), Selected = true });
}
katlist.Add(li);
//else
//{
// katlist.Add(new SelectListItem { Text = item.Name, Value = item.CategoryID.ToString() });
//}
}
ViewBag.kat = katlist;
}
public bool MailGonder(string GelenMail, string Konu, string Mesaj)
{
try
{
RazerBlogContext _db = new RazerBlogContext();
string MailFrom = _db.SistemMails.FirstOrDefault(x => x.SistemMailID == 1).Mail;
string MailPassword = _db.SistemMails.FirstOrDefault(x => x.SistemMailID == 1).Password;
new SmtpClient
{
Host = "Smtp.Gmail.com",
Port = 465,
EnableSsl = true,
Timeout = 10000,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(MailFrom, MailPassword)
}.Send(new MailMessage {
From = new MailAddress(MailFrom, ""), To = { MailFrom }, Subject = Konu, Body = Mesaj, BodyEncoding = Encoding.UTF8
});
return(true);
}
catch (Exception)
{
throw;
}
}
public ActionResult KategoriGuncelle(int KategoriID)
{
RazerBlogContext _db = new RazerBlogContext();
Category ToEdit = _db.Categories.First(x => x.CategoryID == KategoriID);
return(View(ToEdit));
}
public ActionResult MakaleGoster(int ViewMakaleID)
{
RazerBlogContext _db = new RazerBlogContext();
Makale MakaleToShow = _db.Makales.FirstOrDefault(x => x.MakaleID == ViewMakaleID);
return(View(MakaleToShow));
}
// GET: Home
public ActionResult Index(string StrSayfa)
{
int Sayfa = 0;
if (StrSayfa == "" || StrSayfa == null)
{
Sayfa = 1;
}
else
{
Sayfa = Convert.ToInt32(StrSayfa);
}
int Kactan = 0;
int Kacar = 2;
RazerBlogContext _db = new RazerBlogContext();
//List<Makale> MakalelerList = _db.Makales.ToList();
int MakaleSayisi = _db.Makales.Count();
double SayfaSayisi = Math.Ceiling((float)((1.0 * MakaleSayisi) / Kacar));
ViewBag.sayfasayisi = SayfaSayisi;
ViewBag.sayfa = Sayfa;
Kactan = (Sayfa * Kacar) - Kacar;
List <Makale> SayfaMakale = new List <Makale>(_db.Makales.OrderByDescending(x => x.MakaleID).Skip(Kactan).Take(Kacar));
ViewBag.sayfamakale = SayfaMakale;
return(View());
}
public ActionResult MailGuncelle()
{
RazerBlogContext _db = new RazerBlogContext();
SistemMail ToEdit = _db.SistemMails.FirstOrDefault(x => x.SistemMailID == 1);
return(View(ToEdit));
}
public ActionResult MakaleGuncelle(int GelenMakaleID, FormCollection frm)
{
RazerBlogContext _db = new RazerBlogContext();
Makale ToEdit = _db.Makales.FirstOrDefault(x => x.MakaleID == GelenMakaleID);
yakalaıd(Convert.ToInt32(ToEdit.Category.CategoryID));
return(View(ToEdit));
}
public List <Admin> TumAdmin()
{
RazerBlogContext _db = new RazerBlogContext();
List <Admin> AdminList = _db.Admins.ToList();
ViewBag.admins = AdminList;
return(AdminList);
}
public List <Category> TumKategoriler()
{
RazerBlogContext _db = new RazerBlogContext();
List <Category> KategorilerList = _db.Categories.ToList();
ViewBag.kategoriler = KategorilerList;
return(KategorilerList);
}
public ActionResult YorumOnayiKaldir(int ViewYorumID)
{
RazerBlogContext _db = new RazerBlogContext();
Yorum ToEdit = _db.Yorums.FirstOrDefault(x => x.YorumID == ViewYorumID);
ToEdit.OnayDurumu = 0;
_db.SaveChanges();
return(RedirectToAction("YorumlariYonet"));
}
public ActionResult YorumSil(int ViewYorumID)
{
RazerBlogContext _db = new RazerBlogContext();
Yorum ToDelete = _db.Yorums.FirstOrDefault(x => x.YorumID == ViewYorumID);
_db.Yorums.Remove(ToDelete);
_db.SaveChanges();
return(RedirectToAction("YorumlariYonet"));
}
public ActionResult MakaleSil(Makale m)
{
RazerBlogContext _db = new RazerBlogContext();
Makale ToDel = _db.Makales.FirstOrDefault(x => x.MakaleID == m.MakaleID);
_db.Makales.Remove(ToDel);
_db.SaveChanges();
return(RedirectToAction("MakaleListele"));
}
public ActionResult KategoriSil(Category c)
{
RazerBlogContext _db = new RazerBlogContext();
Category ToDel = _db.Categories.First(x => x.CategoryID == c.CategoryID);
_db.Categories.Remove(ToDel);
_db.SaveChanges();
return(RedirectToAction("KategoriListele"));
}
public ActionResult KategoriGuncelle(Category c)
{
RazerBlogContext _db = new RazerBlogContext();
Category ToEdit = _db.Categories.First(x => x.CategoryID == c.CategoryID);
ToEdit.Name = c.Name;
ToEdit.UrlName = c.UrlName;
_db.SaveChanges();
return(RedirectToAction("KategoriListele"));
}
public ActionResult Login(AdminHelper model)
{
if (ModelState.IsValid)
{
using (RazerBlogContext _db = new RazerBlogContext())
{
var admin = _db.Admins.FirstOrDefault(x => x.UserName == model.UserName && x.Password == model.Password);
if (admin != null)
{
Session.Add("giris", true);
Session.Add("adminid", admin.AdminID);
return(RedirectToAction("Index", "Admin"));
}
}
}
ViewBag.mesaj = "Kullanıcı Adı veya Şifre Yanlış";
return(View());
}
public ActionResult MakaleGuncelle(FormCollection frm, HttpPostedFileBase file)
{
int ViewMakaleID = Convert.ToInt32(frm.Get("MakaleID"));
string ViewTitle = frm.Get("Title");
string ViewDescription = frm.Get("Description");
int ViewCategoryID = Convert.ToInt32(frm.Get("Category.CategoryID"));
string ViewText = frm.Get("Text");
string ViewKeywords = frm.Get("Keywords");
bool ViewResmiSil = frm.Get("ResmiSil").Contains("true");
RazerBlogContext _db = new RazerBlogContext();
Makale MakaleToEdit = _db.Makales.FirstOrDefault(x => x.MakaleID == ViewMakaleID);
Category CategoryToAdd = _db.Categories.FirstOrDefault(x => x.CategoryID == ViewCategoryID);
if (ViewResmiSil)
{
string FileFullPath = Request.MapPath(MakaleToEdit.Image);
System.IO.File.Delete(FileFullPath);
MakaleToEdit.Image = null;
}
else
{
if (file != null)
{
string FileFullPath = Request.MapPath(MakaleToEdit.Image);
System.IO.File.Delete(FileFullPath);
Random rnd = new Random();
string sayi = rnd.Next(111111, 999999).ToString();
var FileName = Path.GetFileName(file.FileName);
var File = Path.Combine(Server.MapPath("~/MakaleResimler/"), sayi + FileName);
file.SaveAs(File);
string FilePath = "~/MakaleResimler/" + sayi + FileName;
MakaleToEdit.Image = FilePath;
}
}
MakaleToEdit.Title = ViewTitle;
MakaleToEdit.Description = ViewDescription;
MakaleToEdit.text = ViewText;
MakaleToEdit.Keywords = ViewKeywords;
MakaleToEdit.Category = CategoryToAdd;
_db.SaveChanges();
return(RedirectToAction("MakaleListele"));
}
public ActionResult MakaleEkle(FormCollection frm, HttpPostedFileBase file)
{
RazerBlogContext _db = new RazerBlogContext();
string ViewTitle = frm.Get("Title");
string ViewDescription = frm.Get("Description");
int ViewCategoryID = Convert.ToInt32(frm.Get("Category"));
string ViewText = frm.Get("Text");
string ViewKeywords = frm.Get("Keywords");
int ViewYazarID = Convert.ToInt32(Session["adminid"]);
Makale ToAdd = new Makale();
ToAdd.AuthorName = _db.Admins.FirstOrDefault(x => x.AdminID == ViewYazarID);
ToAdd.Category = _db.Categories.FirstOrDefault(x => x.CategoryID == ViewCategoryID);
ToAdd.Description = ViewDescription;
if (file != null)
{
Random rnd = new Random();
string sayi = rnd.Next(111111, 999999).ToString();
var FileName = Path.GetFileName(file.FileName);
var File = Path.Combine(Server.MapPath("~/MakaleResimler/"), sayi + FileName);
file.SaveAs(File);
string FilePath = "~/MakaleResimler/" + sayi + FileName;
ToAdd.Image = FilePath;
}
ToAdd.Keywords = ViewKeywords;
ToAdd.text = ViewText;
ToAdd.Title = ViewTitle;
//RazerBlogContext _db = new RazerBlogContext();
_db.Makales.Add(ToAdd);
if (_db.SaveChanges() > 0)
{
ViewBag.Mesaj = "Makale Ekleme Başarılı";
}
else
{
ViewBag.Mesaj = "";
}
TumKategoriler();
TumAdmin();
return(View());
}
public ActionResult MailGuncelle(FormCollection frm)
{
RazerBlogContext _db = new RazerBlogContext();
SistemMail ToEdit = _db.SistemMails.FirstOrDefault(x => x.SistemMailID == 1);
string ViewMail = frm.Get("Mail");
string ViewPassword = frm.Get("Password");
ToEdit.Mail = ViewMail;
ToEdit.Password = ViewPassword;
if (_db.SaveChanges() > 0)
{
ViewBag.Mesaj = "Mail Ayarları Güncellendi";
}
else
{
ViewBag.Mesaj = "Mail Ayarları sırasında Bir Hata olustu";
}
return(RedirectToAction("Index"));
}
public ActionResult Ozhakikikategoriekle(FormCollection frm)
{
string KategoriAdi = frm.Get("CategoryName");
if (KategoriAdi == "")
{
ViewBag.hatavar = true;
ViewBag.hata = "Kategori Adi Boş Geçilemez";
}
else
{
ViewBag.hatavar = false;
RazerBlogContext _db = new RazerBlogContext();
List <Category> CakisanKategoriler = _db.Categories.Where(x => x.Name == KategoriAdi).ToList();
if (CakisanKategoriler.Count > 0)
{
ViewBag.hatavar = true;
ViewBag.hata = "Bu Kategori Zaten Mevcut";
}
else
{
ViewBag.hatavar = false;
CategoryHelper chelp = new CategoryHelper();
chelp.kategoriolustur(KategoriAdi);
Category c = new Category();
c.Name = chelp.CategoryName;
c.UrlName = chelp.UrlName;
_db.Categories.Add(c);
if (_db.SaveChanges() == 0)
{
ViewBag.hatavar = true;
ViewBag.hata = "Veritabanı Bağlantısında Sorun var";
}
else
{
ViewBag.hatavar = false;
}
}
}
return(View());
}
public ActionResult MakaleGoster(FormCollection frm, int ViewMakaleID)
{
RazerBlogContext _db = new RazerBlogContext();
string ViewCommenterName = frm.Get("isim");
string ViewComment = frm.Get("yorum");
Yorum YorumToAdd = new Yorum();
YorumToAdd.Name = ViewCommenterName;
YorumToAdd.Comment = ViewComment;
Makale MakaleToEdit = _db.Makales.FirstOrDefault(x => x.MakaleID == ViewMakaleID);
MakaleToEdit.Yorumlar.Add(YorumToAdd);
if (_db.SaveChanges() > 0)
{
ViewBag.Mesaj = "Yorumunuz Başarı İle Gönderildi Onay Bekleniyor";
}
else
{
ViewBag.mesaj = "Yorum Gönderme Sırasında Bir Hata Oluştu";
}
return(View(MakaleToEdit));
}
public ActionResult KategoriListele()
{
RazerBlogContext _db = new RazerBlogContext();
return(View(_db.Categories.ToList()));
}
public ActionResult MakaleListele()
{
RazerBlogContext _db = new RazerBlogContext();
return(View(_db.Makales.ToList()));
}
