public GatheringHall AddGatheringHall(GatheringHall gatheringHallToAdd)
{
var sql1 = @"
insert into [MessageBoard](BoardName, BoardDescription)
output inserted.*
values(@BoardName, @BoardDescription);
";
var sql2 = @"
insert into [GatheringHall](UserId, GatheringHallName, GatheringHallDescription, BoardId)
output inserted.*
values(@UserId, @GatheringHallName, @GatheringHallDescription, @BoardId)
";
using (var db = new SqlConnection(connectionString))
{
var parameters1 = new { BoardName = gatheringHallToAdd.GatheringHallName, BoardDescription = gatheringHallToAdd.GatheringHallDescription };
var result1 = db.QueryFirstOrDefault <MessageBoard>(sql1, parameters1);
var parameters2 = new
{
UserId = gatheringHallToAdd.UserId,
GatheringHallName = gatheringHallToAdd.GatheringHallName,
GatheringHallDescription = gatheringHallToAdd.GatheringHallDescription,
BoardId = result1.MessageBoardId
};
var result2 = db.QueryFirstOrDefault <GatheringHall>(sql2, parameters2);
var newMember = new GatheringHallMember {
UserId = gatheringHallToAdd.UserId, GatheringHallId = result2.GatheringHallId
};
AddMember(newMember);
return(result2);
}
}
public IActionResult CreateNewGatheringHall(GatheringHall gatheringHallToAdd)
{
var gatheringHall = _gatheringHallsRepository.AddGatheringHall(gatheringHallToAdd);
return(Created("", gatheringHall));
}
