public async Task <JsonResult> AddPersonId(int id, int type, Guid sessionid)
{
ActivityLogPersonModel person = await ActivityService.FindPersonById(id);
if (person == null)
{
return(Json(new
{
Success = false,
Message = "Person not found"
}));
}
ActivityLogParticipantModel participant = new ActivityLogParticipantModel()
{
Person = person,
Type = (ActivityLogParticipantTypes)type
};
ActivityService.AddParticipantToSession(Session, sessionid, participant);
return(Json(new
{
Success = true,
Message = string.Empty
}));
}
public async Task <JsonResult> RemovePersonId(int id, Guid sessionId)
{
ActivityLogPersonModel person = await ActivityService.FindPersonById(id);
if (person == null)
{
return(Json(new
{
Success = false,
Message = "Person not found"
}));
}
ActivityLogParticipantModel participant = new ActivityLogParticipantModel()
{
Person = person
};
ActivityService.RemoveParticipantFromSession(Session, sessionId, participant);
return(Json(new
{
Success = true,
Message = string.Empty
}));
}
public async Task <int> CreatePerson(ActivityLogPersonCreateViewModel createModel)
{
ActivityLogPersonModel model = new ActivityLogPersonModel()
{
FullName = createModel.FullName,
Email = Formatter.SanitizeEmail(createModel.Email),
Description = createModel.Description,
PhoneNumber = createModel.PhoneNumber,
SessionId = createModel.SessionId
};
return(await ActivityLogPersonRepository.CreatePerson(model));
}
public async Task <int> CreatePerson(ActivityLogPersonModel model)
{
const string sql = @"
INSERT INTO [dbo].[ActivityLogPerson]
([FullName], [Description], [Phone], [Email])
OUTPUT INSERTED.Id
VALUES
(@FullName, @Description, @PhoneNumber, @Email)";
try
{
return((await UnitOfWork.Context().QueryAsync <int>(sql, model)).Single());
}
catch (Exception e)
{
e.Data["SQL"] = sql;
ErrorStore.LogException(e, HttpContext.Current);
throw e;
}
}