public ActionResult DeleteConfirmed(int id) { publications publications = db.publications.Find(id); db.publications.Remove(publications); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "id,name,text,rating,date,user,theme")] publications publications) { if (ModelState.IsValid) { db.Entry(publications).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.theme = new SelectList(db.themes, "id", "name", publications.theme); ViewBag.user = new SelectList(db.users, "id", "name", publications.user); return(View(publications)); }
public ActionResult AddNew([Bind(Include = "id,name,text,rating,date,user,theme")] publications publications, int?id) { if (ModelState.IsValid) { db.publications.Add(publications); db.SaveChanges(); return(RedirectToAction("Index", "themes")); } ViewBag.theme = id; ViewBag.user = db.users.Where(u => u.name == HttpContext.User.Identity.Name).ToList()[0].id; return(View(publications)); }
// GET: Publications/Edit/5 public ActionResult Edit(int?id) { string localMessage = "Произошла непредвиденная ошибка."; if (id != null) { publications targetPublication = db.publications.Find(id); if (targetPublication != null) { return(RedirectToAction("/Index", new { i = 1, id = id, update = true })); } } return(RedirectToAction("/Index", new { i = 1, message = localMessage })); }
// GET: publications/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } publications publications = db.publications.Find(id); if (publications == null) { return(HttpNotFound()); } return(View(publications)); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } publications publications = db.publications.Find(id); if (publications == null) { return(HttpNotFound()); } ViewBag.theme = new SelectList(db.themes, "id", "name", publications.theme); ViewBag.user = new SelectList(db.users, "id", "name", publications.user); return(View(publications)); }
public ActionResult CreatePS(string Sources, string Publications) { string localMessage = "Произошла ошибка или запись уже есть."; sources a = db.sources.Where(x => x.item_title == Sources).FirstOrDefault(); publications p = db.publications.Where(x => x.title == Publications).FirstOrDefault(); if (a != null && p != null && !p.sources.Contains(a)) { a.publications.Add(p); p.sources.Add(a); db.SaveChanges(); localMessage = $"Связь между источником: {a.item_title} и публикацией: {p.title} успешно добавлена."; } return(RedirectToAction("/Index", new { message = localMessage })); }
public ActionResult CreateAP(string Authors, string[] Publications) { string localMessage = "Произошла ошибка или запись уже есть."; string Publications2 = Publications[0]; authors a = db.authors.Where(x => x.initials == Authors).FirstOrDefault(); publications p = db.publications.Where(x => x.title == Publications2).FirstOrDefault(); if (a != null && p != null && !p.authors.Contains(a)) { a.publications.Add(p); p.authors.Add(a); db.SaveChanges(); localMessage = $"Связь между автором: {a.initials} и публикацией: {p.title} успешно добавлена."; } return(RedirectToAction("/Index", new { message = localMessage })); }
public ActionResult CreatePK(string Keywords, string Publications) { string localMessage = "Произошла ошибка или запись уже есть."; keywords a = db.keywords.Where(x => x.keyword == Keywords).FirstOrDefault(); publications p = db.publications.Where(x => x.title == Publications).FirstOrDefault(); if (a != null && p != null && !p.keywords.Contains(a)) { a.publications.Add(p); p.keywords.Add(a); db.SaveChanges(); localMessage = $"Связь между словом: {a.keyword} и публикацией: {p.title} успешно добавлена."; } return(RedirectToAction("/Index", new { message = localMessage })); }
// GET: Publications/Delete/5 public ActionResult Delete(int?id) { string localMessage = null; if (id != null) { try { publications targetPublication = db.publications.Find(id); if (targetPublication != null) { db.publications.Remove(targetPublication); db.SaveChanges(); localMessage = $"Запись {targetPublication.title} была успешно удалена."; return(RedirectToAction("/Index", new { i = 1, message = localMessage })); } } catch { } } localMessage = "Произошла непредвиденная ошибка."; return(RedirectToAction("/Index", new { i = 1, message = localMessage })); }
public ActionResult Index(string searchText, string message, List <publications> list, int?i, bool update = false, int id = 0, int minYear = 1, int auNum = -1, string soString = "Empty", string typeString = "NoType", string word = "") { if (searchText != null) { searchText = searchText.ToLower(); } ViewData["Titlesss"] = ""; string messageType = null; if (update && db.publications.Count((a) => a.id == id) == 1) { publications targetPublication = db.publications.Find(id); if (targetPublication != null) { ViewData["Titlesss"] = targetPublication.title; ViewData["Year"] = targetPublication.year; ViewData["Update"] = update; ViewData["Id"] = id; var queryUnique = from pub in db.publications where pub.authors.Count != 0 && pub.sources.Count != 0 && pub.id == id orderby pub.title select new { Title = pub.title, Authors = from p in db.publications from author in p.authors where p.id == pub.id && p.authors.Count() != 0 orderby author.initials select author.initials, Sources = from p in db.publications from sourc in p.sources where p.id == pub.id && p.sources.Count() != 0 orderby sourc.item_title select sourc.item_title, Issue = from p in db.publications from sourc in p.sources where p.id == pub.id && p.sources.Count() != 0 orderby sourc.journal_issue select sourc.journal_issue, Volume = from p in db.publications from sourc in p.sources where p.id == pub.id && p.sources.Count() != 0 orderby sourc.journal_volume select sourc.journal_volume, Year = pub.year, Words = pub.keywords.Select(x => x.keyword) }; DataTable result = LINQResultToDataTable(queryUnique); ViewBag.QueryResult = result; } } if (message != null) { if (message == "Произошла ошибка или запись уже есть." || message == "Произошла непредвиденная ошибка." || message == "Произошла непредвиденная ошибка или такая публикация уже есть.") { messageType = "danger"; } else { messageType = "success"; } ViewData["messageType"] = messageType; ViewData["message"] = message; } var authors = from au in db.authors orderby au.initials select au.initials; ViewBag.authors = authors; var source = from s in db.sources orderby s.item_title select s.item_title; ViewBag.source = source; var type = from t in db.types orderby t.type_name select t.type_name; ViewBag.type = type; return(View((db.publications.Where(publications => (publications.title.ToLower().Contains(searchText) || searchText == null) && (publications.year == minYear || minYear == 1) && (publications.authors.Count() == auNum || auNum == -1)).OrderBy(x => x.title).ToList().ToPagedList(i ?? 1, 10)))); }
public ActionResult Update(string titleInput, int idInput, int yearInput, string[] Authors, string Words, string Source, string Type, int issueInput = 0, int volumeInput = 0) { List <int> authorId = GetAuthors(Authors); string[] words = GetKeywords(Words); string localMessage = "Произошла непредвиденная ошибка или такая публикация уже есть."; try { if (ModelState.IsValid && db.publications.Count((a) => a.id == idInput) == 1 && db.publications.Count((a) => (a.title == titleInput) && (a.year == yearInput)) == 0) { publications targetPublication = db.publications.Find(idInput); localMessage = $"Запись {targetPublication.title} успешно изменена на {titleInput}."; targetPublication.title = titleInput; targetPublication.year = Convert.ToInt16(yearInput); foreach (authors au in targetPublication.authors) { au.publications.Remove(targetPublication); } targetPublication.authors.Clear(); foreach (int authorid in authorId) { authors a = db.authors.Find(authorid); if (a != null) { targetPublication.authors.Add(a); a.publications.Add(targetPublication); } } foreach (keywords kw in targetPublication.keywords) { kw.publications.Remove(targetPublication); } targetPublication.keywords.Clear(); foreach (string keyword in words) { keywords k = db.keywords.Where(x => x.keyword == keyword).FirstOrDefault(); if (k == null) { int k_id = db.keywords.Count(); while (db.keywords.Count((a) => a.id == k_id) == 1) { k_id++; } k = new keywords(); k.id = k_id; k.keyword = keyword; db.keywords.Add(k); db.SaveChanges(); } targetPublication.keywords.Add(k); k.publications.Add(targetPublication); } foreach (sources so in targetPublication.sources) { so.publications.Remove(targetPublication); } targetPublication.sources.Clear(); sources s = db.sources.Where(x => x.item_title == Source).FirstOrDefault(); if (s != null) { targetPublication.sources.Add(s); if (issueInput > 0 && volumeInput > 0) { s.journal_issue = issueInput; s.journal_volume = volumeInput; } else { s.journal_issue = null; s.journal_volume = null; } s.publications.Add(targetPublication); } foreach (types ty in targetPublication.types) { ty.publications.Remove(targetPublication); } targetPublication.types.Clear(); types t = db.types.Where(x => x.type_name == Type).FirstOrDefault(); if (t != null) { targetPublication.types.Add(t); t.publications.Add(targetPublication); } db.Entry(targetPublication).State = EntityState.Modified; db.SaveChanges(); } } catch { } return(RedirectToAction("/Index", new { i = 1, message = localMessage })); }
public ActionResult Create(string titleInput, int yearInput, string[] Authors, string Words, string Source, string Type, int issueInput = 0, int volumeInput = 0) { string localMessage = "Произошла ошибка или запись уже есть."; List <int> authorId = GetAuthors(Authors); string[] words = GetKeywords(Words); try { if (ModelState.IsValid && db.publications.Count((a) => a.title == titleInput) == 0 && authorId.Count != 0) { int current_id = db.publications.Count(); while (db.publications.Count((a) => a.id == current_id) == 1) { current_id++; } publications newPublication = new publications(); newPublication.id = current_id; newPublication.title = titleInput; newPublication.year = Convert.ToInt16(yearInput); foreach (int authorid in authorId) { authors a = db.authors.Find(authorid); if (a != null) { newPublication.authors.Add(a); a.publications.Add(newPublication); } } foreach (string keyword in words) { keywords k = db.keywords.Where(x => x.keyword == keyword).FirstOrDefault(); if (k == null) { int k_id = db.keywords.Count(); while (db.keywords.Count((a) => a.id == k_id) == 1) { k_id++; } k = new keywords(); k.id = k_id; k.keyword = keyword; db.keywords.Add(k); db.SaveChanges(); } newPublication.keywords.Add(k); k.publications.Add(newPublication); } sources s = db.sources.Where(x => x.item_title == Source).FirstOrDefault(); if (s != null) { newPublication.sources.Add(s); if (issueInput > 0 && volumeInput > 0) { s.journal_issue = issueInput; s.journal_volume = volumeInput; } else { s.journal_issue = null; s.journal_volume = null; } s.publications.Add(newPublication); } types t = db.types.Where(x => x.type_name == Type).FirstOrDefault(); if (t != null) { newPublication.types.Add(t); t.publications.Add(newPublication); } db.publications.Add(newPublication); db.SaveChanges(); localMessage = $"Запись {titleInput} успешно добавлена."; } } catch { } return(RedirectToAction("/Index", new { i = 1, message = localMessage })); }