public Guid InsertAssistent(AssistentCreateRequest assistent)
{
Create();
Guid ID = Guid.NewGuid();
using (connection)
{
SqlCommand command = new SqlCommand("INSERT INTO dbo.Assistent VALUES(@ID,@CreatedAt,@CreatedBy,@LastUpdatedAt,@LastUpdatedBy,@University,@Department,@AreaOfStudy)", connection);
command.Parameters.Add("@ID", SqlDbType.UniqueIdentifier);
command.Parameters["@ID"].Value = ID;
command.Parameters.Add("@University", SqlDbType.VarChar);
command.Parameters["@University"].Value = assistent.University;
command.Parameters.Add("@Department", SqlDbType.VarChar);
command.Parameters["@Department"].Value = assistent.Department;
command.Parameters.Add("@AreaOfStudy", SqlDbType.VarChar);
command.Parameters["@AreaOfStudy"].Value = assistent.AreaOfStudy;
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 AsisstentResponse Create(AssistentCreateRequest request)
{
Guid ID = _assistentDao.InsertAssistent(request);
var response = new AsisstentResponse(_userService.Create(request, ID), ID, request.University, request.Department, request.AreaOfStudy);
return(response);
}
public AsisstentResponse Create(AssistentCreateRequest request)
{
return(_assitentService.Create(request));
}
