public IActionResult Post(Guid rosterId, [FromBody] Roster item)
{
if (item == null || item.Id != rosterId)
{
return(BadRequest());
}
var serverRoster = ServerRoster.FromRoster(item);
_context.Rosters.Add(serverRoster);
_context.SaveChanges();
return(CreatedAtRoute(new { id = item.Id }, serverRoster));
}
public void TestUpsert()
{
using (var context = new CalendarContext("Data Source=localhost;Initial Catalog=StaffCalendars;Integrated Security=True"))
{
var cons = context.Rosters.FirstOrDefault();
if (cons == null)
{
cons = new ServerRoster
{
Id = Guid.Parse("D43880FF-6368-442D-85D6-01BB5CC6523C"),
DepartmentName = "SS PICU",
RosterName = "Consultants",
Secret = HexadecimalStringToByteArray_Original("2CBC90D518D6066F579EC5E85F77C366D63FEF1616A4DD9D6646ED42BFC16C694B53221DB55627305213B3280F591EEB171610EE7013C20F76AB5057EA36A59E") //Convert.FromBase64String("hJ4blpw8qTI5PEFpdzM2cNpnf6qTNzSBys+x8zQjjojcrVLvPPrXbmpg1ICXgYAg7AprMxz5EiOId9qOR8avzw==") // 0x2CBC90D518D6066F579EC5E85F77C366D63FEF1616A4DD9D6646ED42BFC16C694B53221DB55627305213B3280F591EEB171610EE7013C20F76AB5057EA36A59E
};
context.Rosters.Add(cons);
context.SaveChanges();
}
context.Upsert(new[] {
new ServerStaffMember { /*Id = Guid.Parse("632036E2-C3CF-4116-B9B9-59AB075AB0DA"), */
FullName = "Alex Hussey", Roster = cons, StaffMemberCode = "AH"
},
new ServerStaffMember { /*Id = Guid.Parse("1B435B77-0062-411F-9B6B-1B3C154D2E6D"), */
FullName = "Anusha Ganeshalingham", Roster = cons, StaffMemberCode = "AG"
},
new ServerStaffMember { /*Id = Guid.Parse("BFE2AE9C-2C9A-4730-8D20-4BBC370461AB"), */
FullName = "Brent McSharry", Roster = cons, StaffMemberCode = "BM"
},
new ServerStaffMember { /*Id = Guid.Parse("A1F39FFD-1161-4474-8823-8BB441395A2A"), */
FullName = "Fiona Miles", Roster = cons, StaffMemberCode = "M"
},
new ServerStaffMember { /*Id = Guid.Parse("F4DE1C5A-AA18-4A99-B300-6183000CDC93"), */
FullName = "Gabrielle Nuthall", Roster = cons, StaffMemberCode = "N"
},
new ServerStaffMember { /*Id = Guid.NewGuid(),*/
FullName = "Dave Buckley", Roster = cons, StaffMemberCode = "BU"
},
new ServerStaffMember { /*Id = Guid.NewGuid(),*/
FullName = "John Beca", Roster = cons, StaffMemberCode = "BE"
},
new ServerStaffMember { /*Id = Guid.NewGuid(),*/
FullName = "Brian Anderson", Roster = cons, StaffMemberCode = "A"
},
new ServerStaffMember { /*Id = Guid.NewGuid(),*/
FullName = "Liz Segedin", Roster = cons, StaffMemberCode = "S"
}
});
}
}
public IActionResult Put(Guid rosterId, [FromBody] Roster item)
{
if (item == null || item.Id != rosterId)
{
return(BadRequest());
}
var existing = _context.Rosters.Find(rosterId);
if (existing == null)
{
return(NotFound());
}
var serverRoster = ServerRoster.FromRoster(item);
_context.Entry(existing).CurrentValues.SetValues(serverRoster);
_context.SaveChanges();
return(new NoContentResult());
}
