public Response UpdateAssignment(AssignmentUpdateRequest request) { var club = clubQuery.GetClub(request.ClubId); if (club == null) { return(Response.CreateResponse(new EntityNotFoundException("The specified club does not exist"))); } var assignment = assignmentQuery.GetAssignment(request.ClubId, request.AssignmentId); if (assignment == null) { return(Response.CreateResponse(new EntityNotFoundException("The specified assignment does not exist"))); } else if (assignment.ClubId != request.ClubId) { return(Response.CreateResponse(new IllegalOperationException("The specified assignment does not belong to this club"))); } //if(request.DueDate != assignment.DueDate) // return Response.CreateResponse(new IllegalOperationException("Due Date must be greater than today's date")); try { assignmentRepository.UpdateAssignment(request); return(Response.CreateSuccessResponse()); } catch (Exception ex) { return(Response.CreateResponse(ex)); } }
public HttpResponseMessage UpdateAssignment(AssignmentUpdateRequest model, int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } model.Id = id; SuccessResponse response = new SuccessResponse(); AssignmentService.UpdateAssignment(model); return(Request.CreateResponse(response)); }
public static void UpdateAssignment(AssignmentUpdateRequest model) { DataProvider.ExecuteNonQuery(GetConnection, "dbo.UpdateAssignment" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", model.Id); paramCollection.AddWithValue("@AssignmentName", model.AssignmentName); paramCollection.AddWithValue("@AssignmentTypeId", model.AssignmentTypeId); paramCollection.AddWithValue("@TotalPoints", model.TotalPoints); paramCollection.AddWithValue("@Period", model.Period); }, returnParameters : delegate(SqlParameterCollection param) { } ); }
public void UpdateAssignment(AssignmentUpdateRequest request) { var sql = @"UPDATE Assignments SET DueDate = @DueDate, Instructions = @Instructions, Title = @Title WHERE Guid = @AssignmentGuid AND ClubId = (SELECT ClubId FROM Clubs WHERE Guid = @ClubGuid); DELETE AssignmentTrainingMaterials WHERE AssignmentId = (SELECT AssignmentId FROM Assignments WHERE Guid = @AssignmentGuid); "; var parameters = new DynamicParameters(); parameters.Add("@AssignmentGuid", request.AssignmentId); parameters.Add("@ClubGuid", request.ClubId); parameters.Add("@Instructions", request.Instructions); parameters.Add("@Title", request.Title); parameters.Add("@DueDate", request.DueDate); parameters.Add("@DueDate", request.DueDate); using (var connection = factory.Connect()) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { connection.Execute(sql, parameters, transaction); AddTrainingMaterials(request.AssignmentId, request.TrainingMaterials, connection, transaction); transaction.Commit(); }catch (Exception ex) { transaction.Rollback(); throw ex; } } } }