public ActionResult Ayarlar(FormCollection form)
        {
            string kullaniciadi = form["kullaniciadi"].ToString();
            string sifre        = form["sifre"].ToString();
            string sifre2       = form["sifre2"].ToString();

            if (string.Equals(sifre, sifre2))
            {
                using (ModelDB db = new ModelDB())
                {
                    AdminLogin al = db.AdminLogin.SingleOrDefault();
                    al.kullaniciadi = kullaniciadi;
                    al.sifre        = sifre;

                    int sonuc = db.SaveChanges();
                    if (sonuc > 0)
                    {
                        TempData["Result"] = "Kaydedildi";
                        TempData["Status"] = "success";
                    }
                }
            }
            else
            {
                TempData["Result"] = "Şifreler birbiri ile aynı olmak zorundadır.";
                TempData["Status"] = "danger";
            }
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.admin = db.AdminLogin.SingleOrDefault();

                return(View(at));
            }
        }
        public ActionResult Blog()
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.lstKategori = db.Kategoriler.ToList();
                return(View(at));
            }
        }
        public ActionResult FileLoad(int id)
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.secResiim = db.Resimler.Where(x => x.resimNo == id).SingleOrDefault();
                return(View(at));
            }
        }
        public ActionResult FileLoad(HttpPostedFileBase file, int id)
        {
            if (file != null && file.ContentLength > 0)
            {
                try
                {
                    string path = Path.Combine(Server.MapPath("~/Images"),
                                               Path.GetFileName(file.FileName));
                    string path2 = "/Images/" + file.FileName;
                    using (ModelDB db = new ModelDB())
                    {
                        AllTables2 at = new AllTables2();
                        at.secResiim = db.Resimler.Where(x => x.resimNo == id).SingleOrDefault();
                        if (at.secResiim != null)
                        {
                            at.secResiim.resimYol = path2;
                            db.SaveChanges();
                        }
                        else
                        {
                            Resimler r = new Resimler();
                            r.resimYol = path2;
                            r.resimNo  = id;
                            db.Resimler.Add(r);
                            db.SaveChanges();
                        }
                    }
                    file.SaveAs(path);

                    ViewBag.Message = "Resim Yüklendi.";
                }
                catch (Exception ex)
                {
                    ViewBag.Message = "ERROR:" + ex.Message.ToString();
                }
            }
            else
            {
                ViewBag.Message = "You have not specified a file.";
            }
            return(RedirectToAction("FileLoad"));
        }
        public ActionResult YeniProje(int id)
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            AllTables2 at = new AllTables2();

            using (ModelDB db = new ModelDB())
            {
                at.lstProjeCategory = db.ProjeCategory.ToList();
            }
            return(View(at));
        }
        public ActionResult YeniBeceri()
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            AllTables2 at = new AllTables2();

            using (ModelDB db = new ModelDB())
            {
                at.lstBeceriYetenek = db.BeceriYetenek.ToList();
            }
            return(View(at));
        }
        public ActionResult ProjeKategori()
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.secResiim        = db.Resimler.Where(x => x.resimNo == 2).SingleOrDefault();
                at.lstProjeCategory = db.ProjeCategory.ToList();
                return(View(at));
            }
        }
        public ActionResult Ayarlar()
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.admin = db.AdminLogin.SingleOrDefault();

                return(View(at));
            }
        }
        public ActionResult BlogIncele(string id)
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.lstBlog     = db.Blog.Where(x => x.tip == id).ToList();
                at.secKategori = db.Kategoriler.Where(x => x.tip == id).SingleOrDefault();
                return(View(at));
            }
        }
        public ActionResult ProjeSil(int?id)
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.secilenProje         = db.Proje.Where(x => x.id == id).SingleOrDefault();
                at.secilenProjeKategori = db.ProjeCategory.Where(x => x.categoryNo == at.secilenProje.CategoryID).FirstOrDefault();

                return(View(at));
            }
        }
        public ActionResult ProjeGuncelle(int id)
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            AllTables2 at = new AllTables2();

            using (ModelDB db = new ModelDB())
            {
                Proje p = db.Proje.Where(x => x.id == id).SingleOrDefault();

                at.secilenProje = p;
                at.secilenProjeKategori.categoryNo = p.CategoryID;
                at.lstProjeCategory = db.ProjeCategory.ToList();
            }
            return(View(at));
        }
        public ActionResult Index()
        {
            if (Session["ActiveUser"] != null)
            {
                ViewBag.UserName = Session["ActiveUser"].ToString();
            }
            else
            {
                return(RedirectToAction("login"));
            }

            ViewBag.UserName = Session["ActiveUser"].ToString();
            using (ModelDB db = new ModelDB())
            {
                AllTables2 at = new AllTables2();
                at.lstKisi          = db.Kisi.ToList();
                at.lstDilBilgi      = db.DilBilgi.ToList();
                at.lstDeneyim       = db.Deneyim.ToList();
                at.lstEgitim        = db.Egitim.ToList();
                at.lstBeceriYetenek = db.BeceriYetenek.ToList();
                at.secResiim        = db.Resimler.Where(x => x.resimNo == 1).FirstOrDefault();
                return(View(at));
            }
        }