public ActionResult MeqaleYaz([Bind(Include = "PostId,MuellifId,Baslig,Context,PhotoId,CategoryId,Tarixi,Baxis,Beyenme,Keyword")] tbl_post post, HttpPostedFileBase sekil, string etiket)
        {
            tbl_etiket etkt = new tbl_etiket();

            ViewBag.CategoryId = new SelectList(db.tbl_category, "CategoryId", "Ad");
            string[] etikets = etiket.Split(',');
            foreach (var e in etikets)
            {
                tbl_etiket etk = db.tbl_etiket.FirstOrDefault(x => x.Ad.ToLower() == e.ToLower().Trim());
                if (etk == null)
                {
                    etk    = new tbl_etiket();
                    etk.Ad = e;
                    db.tbl_etiket.Add(etk);
                    db.SaveChanges();
                }
                post.tbl_etiket.Add(etk);
                db.SaveChanges();
            }

            Image  img        = Image.FromStream(sekil.InputStream);
            Bitmap boyuksekil = new Bitmap(img, Settings.SekilBoyukBoy);
            Bitmap kiciksekil = new Bitmap(img, Settings.SekilKicikBoy);
            Bitmap ortasekil  = new Bitmap(img, Settings.SekilOrtaBoy);

            boyuksekil.Save(Server.MapPath("/Upload/Sekiller/boyuk" + sekil.FileName));
            kiciksekil.Save(Server.MapPath("/Upload/Sekiller/balaca" + sekil.FileName));
            ortasekil.Save(Server.MapPath("/Upload/Sekiller/orta" + sekil.FileName));
            tbl_sekil skl = new tbl_sekil();

            skl.Boyuk = "/Upload/Sekiller/boyuk" + sekil.FileName;
            db.tbl_sekil.Add(skl);
            db.SaveChanges();
            post.PhotoId     = skl.PhotoId;
            post.QebulEdildi = false;
            post.Tarixi      = DateTime.Now;
            post.Baxis       = 0;
            post.Beyenme     = 0;
            int yzrId = db.tbl_users.FirstOrDefault(x => x.Login == User.Identity.Name).UserId;

            post.MuellifId = yzrId;
            db.tbl_post.Add(post);
            db.SaveChanges();
            return(View());
        }
        public ActionResult Create([Bind(Include = "PostId,Baslig,Context,Tarixi,PostTypeId,CategoryId,MuellifId,SekilId,Baxis,Beyen,Aktiv")] tbl_post tbl_post, HttpPostedFileBase Sekil, string etiketler)
        {
            if (ModelState.IsValid)
            {
                if (tbl_post != null)
                {
                    tbl_users aktiv = Session["Istifadeci"] as tbl_users;
                    tbl_post.Tarixi     = DateTime.Now;
                    tbl_post.PostTypeId = 1;
                    tbl_post.MuellifId  = aktiv.MuellifId;
                    tbl_post.SekilId    = SekilYukle(Sekil);
                    db.tbl_post.Add(tbl_post);
                    db.SaveChanges();

                    string[] etikets = etiketler.Split(',');
                    foreach (string etiket in etikets)
                    {
                        tbl_etiket etk = db.tbl_etiket.FirstOrDefault(x => x.Ad.ToLower() == etiket.ToLower().Trim());
                        if (etk != null)
                        {
                            etk    = new tbl_etiket();
                            etk.Ad = etiket;
                            db.tbl_etiket.Add(etk);
                            db.SaveChanges();
                        }
                        tbl_post.tbl_etiket.Add(etk);
                        db.SaveChanges();
                    }
                }

                db.tbl_post.Add(tbl_post);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.CategoryId = new SelectList(db.tbl_category, "CategoryId", "Ad", tbl_post.CategoryId);
            ViewBag.MuellifId  = new SelectList(db.tbl_users, "MuellifId", "Adi", tbl_post.MuellifId);
            ViewBag.PostTypeId = new SelectList(db.tbl_post_type, "PostTypeId", "Adi", tbl_post.PostTypeId);
            ViewBag.SekilId    = new SelectList(db.tbl_sekil, "SekilId", "Balacasekil", tbl_post.SekilId);
            return(View(tbl_post));
        }