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