/// <summary> /// Update a New /// </summary> /// <param name="e"></param> /// <returns></returns> public bool Update(Enews e) { bool res = false; try { using (var db = new DataAccess.Models.NewsDBContext()) { var query = (from x in db.News where x.IdNews == e.IdNews select x).FirstOrDefault(); if (query != null) { query.Title = e.Tittle; query.Description = e.Description; db.News.Update(query); db.SaveChanges(); res = true; } } } catch (Exception) { throw; } return(res); }
/// <summary> /// Create a category /// </summary> /// <param name="e"></param> /// <returns></returns> public int Create(ECategories e) { int res = 0; try { using (var db = new DataAccess.Models.NewsDBContext()) { DataAccess.Models.Categories obj = new Categories(); obj.Name = e.Name; obj.Description = e.Description; db.Categories.Add(obj); db.SaveChanges(); res = obj.IdCategory; } } catch (Exception) { throw; } return(res); }
/// <summary> /// update a category created /// </summary> /// <param name="e"></param> /// <returns></returns> public bool Update(ECategories e) { bool res = false; try { using (var db = new DataAccess.Models.NewsDBContext()) { var query = (from x in db.Categories where x.IdCategory == e.IdCategory select x).FirstOrDefault(); query.Name = e.Name; query.Description = e.Description; db.Categories.Update(query); db.SaveChanges(); res = true; } } catch (Exception) { throw; } return(res); }
/// <summary> /// Detele a news by ID /// </summary> /// <param name="id"></param> /// <returns></returns> public bool Delete(int id) { var res = false; try { using (var db = new DataAccess.Models.NewsDBContext()) { var q = (from x in db.News where x.IdCategory == id select x).FirstOrDefault(); if (q != null) { db.News.Remove(q); db.SaveChanges(); res = true; } } } catch (Exception) { throw; } return(res); }
/// <summary> /// Create a News /// </summary> /// <param name="e"></param> /// <returns></returns> public int Create(Enews e) { var res = 0; try { using (var db = new DataAccess.Models.NewsDBContext()) { var obj = new DataAccess.Models.News(); obj.Title = e.Tittle; obj.Description = e.Description; db.News.Add(obj); db.SaveChanges(); res = obj.IdNews; } } catch (Exception) { throw; } return(res); }