public Topics GetTopic(int id) { using (var db = new NewsDb()) { return(db.Topics.FirstOrDefault(t => t.Id == id)); } }
public Users GetUser(string username, string password) { using (var db = new NewsDb()) { return(db.Users.FirstOrDefault(u => u.Username.ToLower() == username.ToLower() && u.Password == password)); } }
public void CreateNew(string title) { using (var db = new NewsDb()) { // do validations // 0. Topic title must be defined if (String.IsNullOrEmpty(title)) { throw new LogicException("Title can't be empty!"); } // 1. Topic title should be unique var sameTitle = db.Topics.FirstOrDefault(t => t.Title.ToLower() == title.ToLower()); if (sameTitle != null) { throw new LogicException("Topic already exists!"); } db.Topics.Add(new Topics() { Title = title, }); db.SaveChanges(); } }
public Articles GetById(int id) { using (var db = new NewsDb()) { return(db.Articles.FirstOrDefault(a => a.Id == id)); } }
public ViewResult ShowPost( int id = 1, int page = 1, int row = 20 ) { var areaDb = new AreaDb(); var listArea = areaDb.GetAll(); ViewBag.listArea = listArea; var listAreaChild = areaDb.GetListAreaById(1); ViewBag.listAreaChild = listAreaChild; var menuListModel = new MenuListModels(); if (Session["ListOfPost"] != null) { menuListModel = (MenuListModels)Session["ListOfPost"]; } var newsDb = new NewsDb(); var menuDb = new MenuDb(); int intCount; menuListModel.MenuId = id; menuListModel.MenuName = menuDb.GetMenuById(id).Name; menuListModel.newsModel = newsDb.SearchNews(out intCount, menuListModel.TinhThanhId, menuListModel.QuanHuyenId, menuListModel.Title, menuListModel.Price, page, row, id); ViewBag.NumberOfPages = intCount / row + (intCount % row > 0 ? 1 : 0); ViewBag.CurrentPage = page; ViewBag.MenuId = id; return(View(menuListModel)); }
public ViewResult MyPost( int id = 1, int page = 1, int row = 20) { var areaDb = new AreaDb(); var listArea = areaDb.GetAll(); ViewBag.listArea = listArea; var listAreaChild = areaDb.GetListAreaById(1); ViewBag.listAreaChild = listAreaChild; var menuListModel = new MenuListModels(); if (Session["ListOfMyPost"] != null) { menuListModel = (MenuListModels)Session["ListOfMyPost"]; } var newsDb = new NewsDb(); int intCount; id = new UserDb().GetUserInfo(User.Identity.Name).Id; menuListModel.newsModel = newsDb.SearchMyPost(out intCount, menuListModel.TinhThanhId, menuListModel.QuanHuyenId, menuListModel.Title, menuListModel.Price, page, row, id); ViewBag.NumberOfPages = intCount / row + (intCount % row > 0 ? 1 : 0); ViewBag.CurrentPage = page; return(View(menuListModel)); }
public List <Articles> GetAll() { using (var db = new NewsDb()) { return(db.Articles.OrderByDescending(a => a.PublishedOn).ToList()); } }
//3. Create UserManager with method Register(string username, string email, string password) : public void Register(string username, string email, string password) { using (var db = new NewsDb()) { //3.1. Check if there isn't a user with the same username already var existingUser = db.Users.FirstOrDefault(u => u.Username.ToLower() == username.ToLower()); if (existingUser != null) { throw new LogicException("That username is already in use!"); } //3.2. Check if there isn't a user with the same e-mail already existingUser = db.Users.FirstOrDefault(u => u.Email.ToLower() == email.ToLower()); if (existingUser != null) { throw new LogicException("That e-mail is already in use!"); } //3.3. (Optional) Check if password is at least 6 symbols if (!password.IsPasswordOk()) { throw new LogicException("Password should be at least 6 symbols!"); } //3.4. Add user if all OK db.Users.Add(new Users() { Email = email, Password = password, Username = username, }); db.SaveChanges(); } }
public List <Articles> GetLatestNews(int count = 6) { using (var db = new NewsDb()) { // SELECT TOP 6 * FROM Articles ORDER BY PublishedOn DESC return(db.Articles.OrderByDescending(a => a.PublishedOn).Take(count).ToList()); } }
public static void MarksNewsAsRead(List <OrderedItemInfo> newItems) { for (int i = 0; i < newItems.Count; i++) { NewsDb item = DbTypeConvertor.FromNewsData(newItems[i]); DatabaseManager.AddNewsItems(item); } }
public ActionResult DetailPost(int Id = 1, int menuId = 1) { var newsDb = new NewsDb(); var newsModel = new NewsModels(); newsModel = newsDb.GetDetailNews(Id); return(View(newsModel)); }
public List <Topics> GetAllTopics() { //returns Topics, ordered by Title ASC using (var db = new NewsDb()) { // SELECT * FROM Topics ORDER BY Title return(db.Topics.OrderBy(t => t.Title).ToList()); } }
public void Delete(int id) { using (var db = new NewsDb()) { var topic = db.Topics.FirstOrDefault(t => t.Id == id); db.Topics.Remove(topic); db.SaveChanges(); } }
public void Delete(int id) { using (var db = new NewsDb()) { var article = db.Articles.FirstOrDefault(a => a.Id == id); db.Articles.Remove(article); db.SaveChanges(); } }
private static void AddNewsItems(NewsDb item) { try { DatabaseManager.db.Insert(item); } catch (Exception ex) { FMLogger.Log("add news fail. " + ex.Message); } }
public List <Articles> GetByTopic(int topicId) { using (var db = new NewsDb()) { return(db.Articles // under specific topic .Where(a => a.TopicId == topicId) // latest first .OrderByDescending(a => a.PublishedOn) .ToList()); } }
public void Update(int id, string title) { using (var db = new NewsDb()) { // find the topic var topic = db.Topics.FirstOrDefault(t => t.Id == id); // modify it's data topic.Title = title; // save changes db.SaveChanges(); } }
public ActionResult EditPost(NewsModels model, string CaptchaText) { var areaDb = new AreaDb(); var listArea = areaDb.GetAll(); ViewBag.listArea = listArea; var listAreaChild = areaDb.GetListAreaById(1); ViewBag.listAreaChild = listAreaChild; if (model.MenuId == 0) { ModelState.AddModelError("MenuId", "Vui lòng chọn chuyên mục."); } if (model.QuanHuyenId == 0) { ModelState.AddModelError("QuanHuyenId", "Vui lòng chọn quận huyện."); } if (model.TinhThanhId == 0) { ModelState.AddModelError("TinhThanhId", "Vui lòng chọn tỉnh thành."); } if (this.Session["CaptchaImageText"].ToString() != CaptchaText) { ModelState.AddModelError("CaptchaText", "Mã xác nhận không đúng"); } if (!ModelState.IsValid) { return(View(model)); } var newsDb = new NewsDb(); var userId = new UserDb().GetUserInfo(User.Identity.Name).Id; if (model.UserId == userId) { newsDb.Update(model); Session["AddNewsSuccessMessage"] = "Sửa bài viết thành công!"; return(RedirectToAction("EditPost", "News", new { @Id = model.Id })); } else { return(RedirectToAction("MyPost", "News")); } }
public ActionResult EditPost(int Id = 1) { var newsDb = new NewsDb(); var model = newsDb.GetNewsById(Id); var areaDb = new AreaDb(); var listArea = areaDb.GetAll(); ViewBag.listArea = listArea; var listAreaChild = areaDb.GetListAreaById(1); ViewBag.listAreaChild = listAreaChild; return(View(model)); }
public JsonResult DeletePost(int Id = 0, int UserId = 0) { var newsDb = new NewsDb(); var newsModel = newsDb.GetDetailNews(Id); var userId = new UserDb().GetUserInfo(User.Identity.Name).Id; if (newsModel.UserId == userId) { newsDb.Delete(Id); return(Json("Xóa thành công", JsonRequestBehavior.AllowGet)); } else { return(Json("Bạn không có quyền xóa item này", JsonRequestBehavior.AllowGet)); } }
/// <summary> /// Добавляет новость в БД /// </summary> /// <param name="news">Модель новости</param> /// <returns>Код ответа Create и добавленную модель</returns> public async Task <string> Add(NewsDb news) { try { news.CreatedDate = DateTime.UtcNow; _context.News.Add(news); await _context.SaveChangesAsync(); return(_context.News.Last().NewsId); } catch (Exception) { return("Exception Data"); } }
public void Create(int topicId, string title, string text, string author, string image = "") { using (var db = new NewsDb()) { db.Articles.Add(new Articles() { Author = author, PublishedOn = DateTime.Now, Text = text, Title = title, TopicId = topicId, Image = image, }); db.SaveChanges(); } }
// CRUD operations (Create-Read-Update-Delete) public void Update(int id, int topicId, string title, string text, string author, string image = "") { using (var db = new NewsDb()) { // I - Retrieve var data = db.Articles.FirstOrDefault(a => a.Id == id); // II - Modify data.Author = author; data.Text = text; data.Title = title; data.TopicId = topicId; if (!String.IsNullOrEmpty(image)) { data.Image = image; } // III - Commit db.SaveChanges(); } }
public static NewsDb FromNewsData(OrderedItemInfo item) { NewsDb newsDb = new NewsDb(); newsDb.Id = item.id; int newsType = -1; OrderedItemType itemType = item.itemType; if (itemType != OrderedItemType.PromoPic) { if (itemType == OrderedItemType.ExternalLink) { newsDb.NewsType = 1; } } else { newsDb.NewsType = 0; } newsDb.NewsType = newsType; return(newsDb); }
static void Main(string[] args) { Console.WriteLine("Application started."); using (var context = new NewsDb()) { var news = context.News.ToList(); var count = 1; news.ForEach(n => { Console.WriteLine("{0}. {1}", count, n.Content); count++; }); var continueReading = true; while (continueReading) { Console.WriteLine("Enter news content:"); var content = Console.ReadLine(); var newNews = new News() { Content = content }; context.News.Add(newNews); try { context.SaveChanges(); continueReading = false; Console.WriteLine("Changes successfully saved in the DB."); } catch (DbUpdateConcurrencyException ex) { Console.WriteLine("Conflict! Text from DB: {0}", content); } } } }
/// <summary> /// Автоматически добавляет новость в БД /// </summary> /// <param name="news">Модель новости</param> /// <returns>Код ответа Create и добавленную модель</returns> public async Task AddAutoNews(NewsDb news) { news.CreatedDate = DateTime.UtcNow; _context.News.Add(news); await _context.SaveChangesAsync(); }
public NewsController(NewsDb context, IHostingEnvironment hosting) { db = context; host = hosting; }
public anahabersController(NewsDb context, IHostingEnvironment hostin) { _context = context; host = hostin; }
public defaultController(NewsDb database) { db = database; }
/// <summary> /// Конструктор класса /// </summary> public NewsRepository() { context = new NewsDb(); }