Beispiel #1
0
        public PromotionStudentRepsonse EnrollStudentPromotions(EnrollStudentPromotions promotion)
        {
            using (var connection = new SqlConnection("Data Source=db-mssql.pjwstk.edu.pl;Initial Catalog=s16578;Integrated Security=True"))
                using (var command = connection.CreateCommand())
                    using (var transaction = new TransactionScope())
                    {
                        var insertedData = new PromotionStudentRepsonse();
                        try
                        {
                            connection.Open();
                            command.CommandText = "EXEC PromoteStudents @Studies = @studies, @Semester = @semester";
                            command.Parameters.AddWithValue("@studies", promotion.Studies);
                            command.Parameters.AddWithValue("@semester", promotion.Semester);

                            using (var dataReader = command.ExecuteReader())
                            {
                                if (dataReader.Read())
                                {
                                    insertedData.IdEnrollment = dataReader.GetInt32(0);
                                    insertedData.Semester     = dataReader.GetInt32(2);
                                    insertedData.IdStudy      = dataReader.GetInt32(1);
                                    insertedData.StartDate    = dataReader.GetDateTime(3);
                                }
                            }
                        }
                        catch (SqlException sqlerror)
                        {
                            throw new InvalidOperationException(sqlerror.Message);
                        }
                        return(insertedData);
                    }
        }
Beispiel #2
0
 public IActionResult EnrollStudentPromotions(EnrollStudentPromotions promotion)
 {
     try
     {
         var enrollment = _service.EnrollStudentPromotions(promotion);
         var result     = new ObjectResult(enrollment);
         result.StatusCode = (int)HttpStatusCode.Created;
         return(result);
     }
     catch (InvalidOperationException invalidOperation)
     {
         return(BadRequest(invalidOperation.Message));
     }
     catch (Exception execption)
     {
         var result = new StatusCodeResult((int)HttpStatusCode.InternalServerError);
         return(result);
     }
 }