public Guid UpdateAssistent(Guid Id, AssistentUpdateRequest assistent)
{
Guid AssistentId = Guid.NewGuid();
Create();
using (connection)
{
SqlCommand Usercommand = new SqlCommand("Select AssistentId From [dbo].[User] WHERE ID = @Id ", connection);
Usercommand.Parameters.Add("@Id", SqlDbType.UniqueIdentifier);
Usercommand.Parameters["@Id"].Value = Id;
using (var reader = Usercommand.ExecuteReader())
{
while (reader.Read())
{
AssistentId = Guid.Parse(reader["StudentId"].ToString());
}
}
SqlCommand command = new SqlCommand("UPDATE dbo.Assistent SET University =@University, AreaOfStudy =@AreaOfStudy,Department =@Department,LastUpdatedAt=@LastUpdatedAt WHERE ID = @Id ", connection);
command.Parameters.Add("@Id", SqlDbType.UniqueIdentifier);
command.Parameters["@Id"].Value = AssistentId;
command.Parameters.Add("@Department", SqlDbType.VarChar);
command.Parameters["@Department"].Value = assistent.Department;
command.Parameters.Add("@University", SqlDbType.VarChar);
command.Parameters["@University"].Value = assistent.University;
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.ExecuteNonQuery();
connection.Close();
}
return(AssistentId);
}
public AsisstentResponse Update(Guid Id, AssistentUpdateRequest request)
{
AsisstentResponse user = _assistentDao.GetById(Id);
if (!string.IsNullOrWhiteSpace(request.Department))
{
user.Department = request.Department;
}
if (!string.IsNullOrWhiteSpace(request.University))
{
user.University = request.University;
}
if (!string.IsNullOrWhiteSpace(request.AreaOfStudy))
{
user.AreaOfStudy = request.AreaOfStudy;
}
Guid ID = _assistentDao.UpdateAssistent(Id, _mapper.Map <AssistentUpdateRequest>(user));
var response = new AsisstentResponse(_userService.UpdateUser(Id, request), ID, request.University, request.Department, request.AreaOfStudy);
return(response);
}
public AsisstentResponse Put(Guid id, [FromBody] AssistentUpdateRequest request)
{
return(_assitentService.Update(id, request));
}
