public Guid InsertProfessor(ProfessorCreateRequest professor) { Create(); Guid ID = Guid.NewGuid(); using (connection) { SqlCommand command = new SqlCommand("INSERT INTO dbo.Professor VALUES(@ID,@CreatedAt,@CreatedBy,@LastUpdatedAt,@LastUpdatedBy,@University,@Department,@Vocation)", connection); command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier); command.Parameters["@ID"].Value = ID; command.Parameters.Add("@University", SqlDbType.VarChar); command.Parameters["@University"].Value = professor.University; command.Parameters.Add("@Department", SqlDbType.VarChar); command.Parameters["@Department"].Value = professor.Department; command.Parameters.Add("@Vocation", SqlDbType.VarChar); command.Parameters["@Vocation"].Value = professor.Vocation; command.Parameters.Add("@LastUpdatedAt", SqlDbType.DateTime); command.Parameters["@LastUpdatedAt"].Value = DateTime.Now; command.Parameters.Add("@CreatedAt", SqlDbType.DateTime); command.Parameters["@CreatedAt"].Value = DateTime.Now; command.Parameters.Add("@LastUpdatedBy", SqlDbType.VarChar); command.Parameters["@LastUpdatedBy"].Value = "ivona"; command.Parameters.Add("@CreatedBy", SqlDbType.VarChar); command.Parameters["@CreatedBy"].Value = "ivona"; command.ExecuteNonQuery(); connection.Close(); } return(ID); }
public ProfessorResponse Create(ProfessorCreateRequest request) { Guid ID = _professorDao.InsertProfessor(request); var response = new ProfessorResponse(_userService.Create(request, ID), ID, request.University, request.Department, request.Vocation); return(response); }
public ProfessorResponse Create(ProfessorCreateRequest request) { return(_professorService.Create(request)); }