public JsonResult AddPersonToParty([FromBody] GuestlistModel guestlist)
{
var result = _partyservice.AddPersonToParty(guestlist);
if (!result)
{
return(new JsonResult("Person could not be added To Party"));
}
return(new JsonResult("Person Added To Party"));
}
public bool AddPersonToParty(GuestlistModel guestlist)
{
string sqlDataSource = _configuration.GetConnectionString("PartyAppCon");
using (SqlConnection myCon = new SqlConnection(sqlDataSource))
{
myCon.Open();
using (SqlCommand myCommand = new SqlCommand(StoredProcedures.ADD_PERSON_TO_PARTY, myCon))
{
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add(Parameters.PARTY_ID, SqlDbType.Int).Value = guestlist.PartyId;
myCommand.Parameters.Add(Parameters.PERSON_ID, SqlDbType.Int).Value = guestlist.PersonId;
myCommand.Parameters.Add(Parameters.DRINK_ID, SqlDbType.Int).Value = guestlist.DrinkId;
myCommand.ExecuteNonQuery();
myCon.Close();
}
return(true);
}
}