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 GatheringHallMember AddMember(GatheringHallMember gatheringHallMemberToAdd)
{
var sql = @"
insert into [GatheringHallMember](UserId, GatheringHallId)
output inserted.*
values(@UserId,@GatheringHallId);
";
using (var db = new SqlConnection(connectionString))
{
var parameters = new { UserId = gatheringHallMemberToAdd.UserId, GatheringHallId = gatheringHallMemberToAdd.GatheringHallId };
var result = db.QueryFirstOrDefault <GatheringHallMember>(sql, parameters);
return(result);
}
}
public IActionResult AddNewMemberToCircle(GatheringHallMember gatheringHallMemberToAdd)
{
var member = _gatheringHallsRepository.AddMember(gatheringHallMemberToAdd);
return(Created("", member));
}
