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)); }