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());
}
