public /*async*/ ActionResult <RetroItem> PublishItem([FromBody] RetroItem value) { value.Id = Retro.Items.Count; Retro.Items.Add(value); Retro.LastPublished = DateTime.Now; return(value); }
//TODO - convert to Using commands public ArrayList getPodsFromRetro(int retroId) { string query = "SELECT p.ShortName AS Podcasts, p.ProductionCode, " + "p.Runtime, p.DateRecorded, p.DateReleased, p.Hosts, p.Editor, pt.Type AS Podcast_Type " + "FROM Retrospective AS r, Podcast AS p, Podcast_Type AS pt " + "WHERE " + retroId.ToString() + " = r.ID AND " + retroId.ToString() + " = p.RetrospectiveId AND p.TypeId = pt.ID " + "ORDER BY p.DateReleased;"; int i = 0; RetroItem retroItem; ArrayList retrospective = new ArrayList(); conn2.Open(); MySqlCommand command = new MySqlCommand(query, conn2); MySqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { retroItem = new RetroItem(); retroItem.shortName = reader[0].ToString(); retroItem.prodCode = reader[1].ToString(); retroItem.runtime = reader[2].ToString(); retroItem.dateRec = reader[3].ToString(); retroItem.dateRel = reader[4].ToString(); retroItem.hosts = reader[5].ToString(); retroItem.editor = reader[6].ToString(); retroItem.podType = reader[7].ToString(); retrospective.Add(retroItem); } conn2.Close(); return(retrospective); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } RetroItem = await _context.RetroItem.FirstOrDefaultAsync(m => m.Id == id); if (RetroItem == null) { return(NotFound()); } return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } RetroItem = await _context.RetroItem.FindAsync(id); if (RetroItem != null) { _context.RetroItem.Remove(RetroItem); await _context.SaveChangesAsync(); } return(RedirectToPage("./Index")); }
public async Task <IActionResult> OnGetAsync(int?id) { if (id == null) { return(NotFound()); } RetroItem = await _context.RetroItem .Include(r => r.RetroBoard).FirstOrDefaultAsync(m => m.Id == id); if (RetroItem == null) { return(NotFound()); } ViewData["RetroBoardRefId"] = new SelectList(_context.RetroBoard, "ID", "ID"); return(Page()); }
public async Task <IActionResult> OnPostAsync(int?id) { if (id == null) { return(NotFound()); } RetroItem = await _context.RetroItem.FindAsync(id); if (RetroItem != null) { _context.RetroItem.Remove(RetroItem); await _context.SaveChangesAsync(); } var retroItemId = RetroItem.RetroBoardRefId; return(Redirect($"/RetroItems1?id={retroItemId}")); }
public static void Initialize(TSD_RetroHelperContext context) { //if (context.RetroBoard.Any()) //{ // return; // DB has been seeded //} var items = new RetroItem[] { new RetroItem { Id = 2345, Rating = 10, Name = "FirstItem", Comment = "Empty", RetroBoardRefId = 1234, ColumnId = 1 }, new RetroItem { Id = 2346, Rating = 5, Name = "SecondItem", Comment = "Empty", RetroBoardRefId = 1234, ColumnId = 2 }, new RetroItem { Id = 2347, Rating = 7, Name = "ThirdItem", Comment = "Empty", RetroBoardRefId = 1234, ColumnId = 3 } }; foreach (var item in items) { context.RetroItem.Add(item); } context.SaveChanges(); //var ColgateRetroItemsList = new List<RetroItem> { 1, 2, 3 }; var boards = new RetroBoard[] { new RetroBoard { RetroDate = DateTime.Parse("2005-09-01"), Name = "TestTeam", ID = 1234, RetroItems = items } }; foreach (var board in boards) { context.RetroBoard.Add(board); } context.SaveChanges(); }