Пример #1
0
        public (Guid Guid, Response Response) CreateReportCardDesign(NewReportDesignRequest request)
        {
            var validationResult = newReportCardDesignValidator.Validate(request);

            if (!validationResult.IsValid)
            {
                return(Guid.Empty, Response.CreateResponse(validationResult.Messages));
            }

            var club = clubQuery.GetClub(request.ClubId);

            if (club == null)
            {
                return(Guid.Empty, Response.CreateResponse(new EntityNotFoundException("The specified club does not exist")));
            }

            var designs = reportDesignerQuery.GetReportCardDesigns(request.ClubId, request.Name);

            if (designs.Count() > 0)
            {
                return(Guid.Empty, Response.CreateResponse(new IllegalOperationException("There is already a report design with this name")));
            }

            try {
                var design = new ReportCardDesign(request.ClubId)
                {
                    DesignName = request.Name
                };
                reportDesignerRepository.AddReportDesign(design);
                return(design.Guid.Value, Response.CreateSuccessResponse());
            } catch (Exception ex) {
                return(Guid.Empty, Response.CreateResponse(ex));
            }
        }
Пример #2
0
        public void AddReportDesign(ReportCardDesign reportDesign)
        {
            string sql = @"INSERT INTO ReportCardDesigns(Guid, Name, ClubId) 
                    VALUES( @ReportCardDesignGuid, @Name, 
                            (SELECT ClubId FROM Clubs WHERE Guid = @ClubGuid))";

            DynamicParameters p = new DynamicParameters();

            p.Add("@ReportCardDesignGuid", reportDesign.Guid.ToString());
            p.Add("@Name", reportDesign.DesignName);
            p.Add("@ClubGuid", reportDesign.ClubId.ToString());

            using (var connection = connectionFactory.Connect())
            {
                connection.Open();
                connection.Execute(sql, p);
            }
        }