public virtual void Add(T entity) { var ctx = new ProjeHaberDbEntities(); ctx.Set <T>().Add(entity); ctx.SaveChanges(); }
public virtual void Update(T entity) { var ctx = new ProjeHaberDbEntities(); ctx.Set <T>().Attach(entity); ctx.Entry(entity).State = EntityState.Modified; ctx.SaveChanges(); }
public ActionResult News(string SearchString) { var db = new ProjeHaberDbEntities(); var kayitlar = from a in db.HaberTbl select a; if (!String.IsNullOrEmpty(SearchString)) { kayitlar = kayitlar.Where(a => a.title.Contains(SearchString) || a.content.Contains(SearchString)); } return(View(kayitlar.ToList())); }
public virtual void Remove(int entityId) { var ctx = new ProjeHaberDbEntities(); T Entity = ctx.Set <T>().Find(entityId); ctx.SaveChanges(); if (ctx.Entry(Entity).State == EntityState.Detached) { ctx.Set <T>().Attach(Entity); } ctx.Set <T>().Remove(Entity); ctx.SaveChanges(); }
public ActionResult Update(int id) { ProjeHaberDbEntities db = new ProjeHaberDbEntities(); List <SelectListItem> degerler = (from i in db.Editor.ToList() select new SelectListItem { Text = i.Name, Value = i.Id.ToString() }).ToList(); ViewBag.dgr = degerler; return(View(_rep.FindById(id))); }
public void ReadCount(int id) { var ctx = new ProjeHaberDbEntities(); HaberTbl haberTbl = ctx.HaberTbl.FirstOrDefault(c => c.Id == id); if (haberTbl.ReadCount == null) { haberTbl.ReadCount = 1; } else { haberTbl.ReadCount++; } ctx.SaveChanges(); }
public ActionResult Login(LoginViewModel model) { var ctx = new ProjeHaberDbEntities(); var usr = ctx.Editor.FirstOrDefault(c => c.Name == model.Name && c.Password == model.Password); if (usr != null) { Session["user"] = usr; return(RedirectToAction("NewsList", "News")); } else { model.Hata = "Name veya Password Hatalı"; return(View("Login", model)); } }
public ActionResult Update(HaberTbl hbr, HttpPostedFileBase file) { if (Session["user"] == null) { return(RedirectToAction("News", "News")); } ProjeHaberDbEntities db = new ProjeHaberDbEntities(); var ktg = db.Editor.Where(m => m.Id == hbr.EditorId).FirstOrDefault(); hbr.EditorId = ktg.Id; hbr.CreateDate = ktg.CreateDate; int result = AddNewsImage(file); hbr.ImageId = result == 0 ? ktg.ImageId : result; _rep.Update(hbr); return(RedirectToAction("NewsList")); }
public ActionResult AddNews() { if (Session["user"] == null) { return(RedirectToAction("News", "News")); } ProjeHaberDbEntities db = new ProjeHaberDbEntities(); List <SelectListItem> degerler = (from i in db.Editor.ToList() select new SelectListItem { Text = i.Name, Value = i.Id.ToString() }).ToList(); ViewBag.dgr = degerler; NewsViewModel newsViewModel = new NewsViewModel(); return(View(newsViewModel)); }
public override List <HaberTbl> List() { MemoryCache mCache = MemoryCache.Default; List <HaberTbl> model = new List <HaberTbl>(); if (!mCache.Contains("newsList")) { model = new ProjeHaberDbEntities().Set <HaberTbl>().ToList(); mCache.Add("newsList", model, DateTimeOffset.Now.AddSeconds(30)); } else { model = (List <HaberTbl>)mCache.Get("newsList"); } return(model); }
public int UploadImageInDataBase(HttpPostedFileBase file, Image image) { image.Data = ConvertToBytes(file); var images = new Image { Name = image.Name, FileUrl = image.FileUrl, Data = image.Data }; var ctx = new ProjeHaberDbEntities(); ctx.Image.Add(images); int i = ctx.SaveChanges(); if (i == 1) { return(1); } else { return(0); } }
public ActionResult AddNews(NewsViewModel hbr, HttpPostedFileBase file) { if (Session["user"] == null) { return(RedirectToAction("News", "News")); } var newsEntity = new HaberTbl(); newsEntity.Id = hbr.Id; newsEntity.spot = hbr.spot; newsEntity.title = hbr.title; newsEntity.content = hbr.content; newsEntity.ImageId = AddNewsImage(file); ProjeHaberDbEntities db = new ProjeHaberDbEntities(); var ktg = db.Editor.Where(m => m.Id == hbr.EditorId).FirstOrDefault(); newsEntity.EditorId = ktg.Id; _rep.Add(newsEntity); return(RedirectToAction("News")); }
public virtual T FindById(int EntityId) { var ctx = new ProjeHaberDbEntities(); return(ctx.Set <T>().Find(EntityId)); }
public virtual List <T> List() { var ctx = new ProjeHaberDbEntities(); return(ctx.Set <T>().ToList()); }