public void CreateStudent(StudentCreateDto dto, int studiesId)
{
using var client = new SqlConnection(_configuration["ConnectionString"]);
client.Open();
using var transaction = client.BeginTransaction();
try
{
var enrollmentId = GetEnrollmentByStudyIdAndSemester(studiesId, 1);
if (!enrollmentId.HasValue)
{
using var commandFindLatestId =
new SqlCommand("SELECT MAX([IdEnrollment]) FROM [Enrollment];", client, transaction);
var latestId = (int)commandFindLatestId.ExecuteScalar();
using var createEnrollmentCommand = new SqlCommand(@"
INSERT INTO [Enrollment](IdEnrollment, Semester, IdStudy, StartDate)
VALUES (@Id, 1, @IdStudy, GETDATE());
", client, transaction);
createEnrollmentCommand.Parameters.Add(new SqlParameter("Id", latestId + 1));
createEnrollmentCommand.Parameters.Add(new SqlParameter("IdStudy", studiesId));
createEnrollmentCommand.ExecuteNonQuery();
enrollmentId = latestId + 1;
}
var dateSplitted = dto.BirthDate.Split('.');
var day = int.Parse(dateSplitted[0]);
var month = int.Parse(dateSplitted[1]);
var year = int.Parse(dateSplitted[2]);
var parsedDate = new DateTime(year, month, day);
using var commandCreateStudent =
new SqlCommand(@"
INSERT INTO [Student]([IndexNumber],[FirstName],[LastName],[BirthDate],[IdEnrollment])
VALUES (@IndexNumber, @FirstName, @LastName, @BirthDate, @EnrolId);
", client, transaction);
commandCreateStudent.Parameters.AddRange(new []
{
new SqlParameter("@IndexNumber", dto.IndexNumber),
new SqlParameter("@FirstName", dto.FirstName),
new SqlParameter("@LastName", dto.LastName),
new SqlParameter("@BirthDate", parsedDate),
new SqlParameter("@EnrolId", enrollmentId)
});
commandCreateStudent.ExecuteNonQuery();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
}
finally
{
client.Close();
}
}
public async Task <string> CreateStudent(StudentCreateDto studentCreateDto)
{
var studentModel = _mapper.Map <Student>(studentCreateDto);
_repository.CreateStudent(studentModel);
var studentModel1 = _mapper.Map <StudentReadDto>(studentModel);
HttpClient client = new HttpClient();
//ADD your ngrok url
client.BaseAddress = new Uri("https://3a5e06b6ad12.ngrok.io");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
//GET Method
var body = JsonConvert.SerializeObject(studentModel1, Formatting.Indented, new JsonSerializerSettings
{
PreserveReferencesHandling = PreserveReferencesHandling.All
});
var content = new StringContent(body, Encoding.UTF8, "application/json");
HttpResponseMessage response = await client.PostAsync("api/notify", content);
if (response.IsSuccessStatusCode)
{
// Get the URI of the created resource.
Uri returnUrl = response.Headers.Location;
Console.WriteLine(returnUrl);
}
var studentReadDto = _mapper.Map <StudentReadDto>(studentModel);
return("success");
}
public IActionResult Post(StudentCreateDto dto)
{
if (string.IsNullOrWhiteSpace(dto.IndexNumber) ||
string.IsNullOrWhiteSpace(dto.FirstName) ||
string.IsNullOrWhiteSpace(dto.LastName) ||
string.IsNullOrWhiteSpace(dto.BirthDate) ||
!new Regex("^\\d{1,2}\\.\\d{1,2}\\.\\d{4}$").IsMatch(dto.BirthDate))
{
return(BadRequest("Format danych jest nieprawidłowy"));
}
var studiesId = _dbService.GetStudiesIdByName(dto.Studies);
if (!studiesId.HasValue)
{
return(BadRequest($"Nie znaleziono studiów o nazwie = {dto.Studies}"));
}
if (!_dbService.IsIndexNumberUnique(dto.IndexNumber))
{
return(BadRequest("Student o podanym id już istnieje"));
}
_dbService.CreateStudent(dto, studiesId.Value);
return(Created("", ""));
}
public async Task <StudentDto> Create(StudentCreateDto student)
{
var studentModel = student.Adapt <Student>();
var newStudent = await this.studentRepository.Create(studentModel);
await this.AddRelatedEntities(newStudent);
return(newStudent.Adapt <StudentDto>());
}
public ActionResult <StudentReadDto> CreateStudent(StudentCreateDto studentCreateDto)
{
var studentModel = _mapper.Map <Student>(studentCreateDto);
_repository.CreateStudent(studentModel);
_repository.SaveChanges();
var studentReadDto = _mapper.Map <StudentReadDto>(studentModel);
return(CreatedAtRoute(nameof(GetStudentById), new { StudentID = studentReadDto.StudentId }, studentReadDto));
}
public ActionResult <StudentReadDto> CreateStudent(StudentCreateDto std)
{
Student StudentModel = _mapper.Map <Student>(std);
_repository.CreateStudent(StudentModel);
_repository.SaveChanges();
StudentReadDto _StudentReadDto = _mapper.Map <StudentReadDto>(StudentModel);
return(CreatedAtRoute(nameof(GetStudentById), new { id = _StudentReadDto.id }, _StudentReadDto));
}
public ActionResult <StudentReadDto> CreateCommand(StudentCreateDto student)
{
var commandModel = _mapper.Map <Student>(student);
_repository.CreateStudent(commandModel);
_repository.SaveChanges();
var commandReadDto = _mapper.Map <StudentReadDto>(commandModel);
return(CreatedAtRoute(nameof(GetStudentById), new { Id = commandReadDto.Id }, commandReadDto));
}
public ActionResult CreateStudent(StudentCreateDto StudentCreateDto)
{
var StudentModel = _mapper.Map <User>(StudentCreateDto);
_repo.CreateStudent(StudentModel);
_repo.SaveChanges();
return(NoContent());
// return Ok(StudentModel);
}
public virtual async Task <StudentDto> CreateAsync(StudentCreateDto input)
{
var newStudent = ObjectMapper.Map <StudentCreateDto, Student>(input);
newStudent.TenantId = CurrentTenant.Id;
var student = await _studentRepository.InsertAsync(newStudent);
await CurrentUnitOfWork.SaveChangesAsync();
return(ObjectMapper.Map <Student, StudentDto>(student));
}
public void CreateStudent(StudentCreateDto dto, int studiesId)
{
using var transaction = _context.Database.BeginTransaction();
try
{
var enrollmentId = GetEnrollmentByStudyIdAndSemester(studiesId, 1);
if (!enrollmentId.HasValue)
{
var latest = _context.Enrollments.Max(e => e.IdEnrollment);
_context.Enrollments.Add(new Enrollment
{
IdEnrollment = latest + 1,
Semester = 1,
IdStudy = studiesId,
StartDate = DateTime.Now
});
enrollmentId = latest + 1;
}
var dateSplitted = dto.BirthDate.Split('.');
var day = int.Parse(dateSplitted[0]);
var month = int.Parse(dateSplitted[1]);
var year = int.Parse(dateSplitted[2]);
var parsedDate = new DateTime(year, month, day);
_context.Students.Add(new Student()
{
IndexNumber = dto.IndexNumber,
FirstName = dto.FirstName,
LastName = dto.LastName,
BirthDate = parsedDate,
IdEnrollment = enrollmentId.Value
});
_context.SaveChanges();
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
}
}
public ActionResult UpdateStudent(int id, StudentCreateDto studentCreateDto)
{
var student = _repository.GetStudentById(id);
if (student == null)
{
return(NotFound());
}
_mapper.Map(studentCreateDto, student);
_repository.UpdateStudent(student);
_repository.SaveChanges();
return(NoContent());
}
public IActionResult CreateStudent(StudentCreateDto StudentCreateDto)
{
if (StudentCreateDto == null)
{
return(BadRequest(ModelState));
}
if (_studentRepo.isStudentExists(StudentCreateDto.Name))
{
ModelState.AddModelError("", $"Teacher is exists!");
return(StatusCode(404, ModelState));
}
var studentObj = _mapper.Map <Student>(StudentCreateDto);
if (!_studentRepo.CreateStudent(studentObj))
{
ModelState.AddModelError("", $"Something went wrong when saving the record {studentObj.Name}");
return(StatusCode(500, ModelState));
}
return(CreatedAtRoute(nameof(GetStudent), new { studentId = studentObj.Id }, studentObj));
}
public Task <StudentWithDetailsDto> CreateAsync(StudentCreateDto StudentCreate)
{
return(this.StudentCrudAppService.CreateAsync(StudentCreate));
}
public async Task <StudentDto> Create([FromBody] StudentCreateDto student)
{
return(await this.studentServices.Create(student));
}