public void Delete(Invitation invitation) { Log("Begin deleting Invitation User to Meeting in database.", invitation); DatabaseConnector.PushCommandToDatabase (sqlConnection, CommandList.Build_DeleteInvitationUserToMeetingCommand(invitation)); Log("End deleting Invitation User to Meeting in database.", invitation); }
public bool IsExist(Invitation invitation) { Log("Begin receiving Invitation User to Meeting in database.", invitation); Invitation resultInvitation = DatabaseConnector.GetDataFromDatabase<Invitation> (sqlConnection, CommandList.Build_GetInvitationUserToMeetingCommand(invitation), new InvitationBuilder()); Log("End receiving Invitation User to Meeting in database.", invitation); return resultInvitation != null; }
void Log(String logMessage, Invitation invitation) { if (invitation != null) { _logger.Debug("{0} MeetingID = {1}, UserID = {2}.", logMessage, invitation.MeetingID, invitation.UserID); } else { _logger.Debug("{0} Invitation is null.", logMessage); } }
public IHttpActionResult Create(Invitation invitation) { Guid requestId = Guid.NewGuid(); Log("Received create invitation user to meeting POST HTTP-request. Meeting ID = " + invitation.MeetingID + ". User ID = " + invitation.UserID, requestId); User user = _userRepository.GetUser(invitation.UserID); Meeting meeting = _meetRepository.GetMeeting(invitation.MeetingID); if (user == null) { Log("Send NotFoundWithMessageResult(404) response to create invitation user to meeting POST HTTP-request." + "Message: User not found.", requestId); return new NotFoundWithMessageResult("User not found."); } if (meeting == null) { Log("Send NotFoundWithMessageResult(404) response to create invitation user to meeting POST HTTP-request." + "Message: Meeting not found.", requestId); return new NotFoundWithMessageResult("Meeting not found."); } if (meeting.InvitedPeople.ContainsKey(invitation.UserID)) { Log("Send ErrorMessageResult(400) response to create invitation user to meeting POST HTTP-request. " + "Message: User already invited.", requestId); return BadRequest("User already invited."); } _invitationRepository.Create(invitation); Log("Send OkResult(200) response to create invitation user to meeting POST HTTP-request.", requestId); return Ok(); }
public IHttpActionResult Delete(Guid MeetingID, Guid UserID) { Guid requestId = Guid.NewGuid(); Invitation invitation = new Invitation(); invitation.MeetingID = MeetingID; invitation.UserID = UserID; Log("Received delete invitation DELETE HTTP-request. Meeting ID = " + invitation.MeetingID + ". User ID = " + invitation.UserID, requestId); if (_invitationRepository.IsExist(invitation)) { _invitationRepository.Delete(invitation); Log("Send OkREsult(200) response to delete invitation DELETE HTTP-request.", requestId); return Ok(); } Log("Send NotFoundWithMessageResult(404) response to delete invitation DELETE HTTP-request." + "Message: Invitation not found.", requestId); return new NotFoundWithMessageResult("Invitation not found."); }
void Log(String logMessage, Invitation invitation, Guid requestId) { if (invitation != null) { _logger.Info("{3} {0} Attached invitation object: " + "MeetingID = {1}, UserID = {2}.", logMessage, invitation.MeetingID, invitation.UserID, requestId); } else { _logger.Info("{1} Received {0} request. Attached invitation object is null.", logMessage, requestId); } }
public IHttpActionResult Get(Guid MeetingID, Guid UserID) { Guid requestId = Guid.NewGuid(); Invitation invitation = new Invitation(); invitation.MeetingID = MeetingID; invitation.UserID = UserID; Log("Received get invitation GET HTTP-request. Meeting ID = " + invitation.MeetingID + ". User ID = " + invitation.UserID, requestId); if (_invitationRepository.IsExist(invitation)) { Log("Send OkREsult(200) response to get invitation GET HTTP-request.", requestId); return Ok(); } Log("Send NotFound(200) response to get invitation user to meeting GET HTTP-request.", requestId); return new NotFoundWithMessageResult("Invitation not found."); }
public Task<HttpResponseMessage> CreateInvitation(Invitation invitation) { return _crudHandler.Create("Invitation", invitation); }
public Task<HttpResponseMessage> CheckInvitation(Invitation invitation) { return _crudHandler.Get("Invitation", invitation.MeetingID.ToString(), invitation.UserID.ToString()); }
public Task<HttpResponseMessage> CancelInvitation(Invitation invitation) { return _crudHandler.Delete("Invitation", invitation.MeetingID.ToString(), invitation.UserID.ToString()); }
public static SqlCommand Build_DeleteInvitationUserToMeetingCommand(Invitation invitation) { SqlCommand command = new SqlCommand(); Log("delete invitation user to meeting"); command.CommandText = "delete from [dbo].[Invitations] where MeetingID = @MeetingID and UserID = @UserID"; command.Parameters.AddWithValue("@MeetingID", invitation.MeetingID); command.Parameters.AddWithValue("@UserID", invitation.UserID); Log("delete invitation user to meeting", command); return command; }
public static SqlCommand Build_InviteUserToMeetingCommand(Invitation invitation) { SqlCommand command = new SqlCommand(); Log("invite user to meeting"); command.CommandText = "insert into [dbo].[Invitations] (MeetingID, UserID) values (@MeetingID, @UserID)"; command.Parameters.AddWithValue("@MeetingID", invitation.MeetingID); command.Parameters.AddWithValue("@UserID", invitation.UserID); Log("invite user to meeting", command); return command; }