public UpdateToolsMasterResponseDto UpdateToolsMaster(UpdateToolsMasterRequestDto updateToolsMasterRequestDto) { var cModel = new UpdateToolsMasterCM() { ToolCode = updateToolsMasterRequestDto.ToolCode, Description = updateToolsMasterRequestDto.Description }; var response = toolsMastersRepository.UpdateToolsMaster(cModel); return(new UpdateToolsMasterResponseDto()); }
public UpdateToolsMasterQM UpdateToolsMaster(UpdateToolsMasterCM updateToolsMasterCM) { using (var connection = new DbConnectionProvider().CreateConnection()) { connection.Open(); var command = new ToolsMasterUpdateCommand { Connection = connection }; command.Execute(updateToolsMasterCM); } return(new UpdateToolsMasterQM()); }
public void Execute(UpdateToolsMasterCM model) { using (var sqlCommand = CreateCommand()) { sqlCommand.Connection = Connection; sqlCommand.CommandText = "[dbo].uspUpdateToolsMaster"; sqlCommand.CommandType = CommandType.StoredProcedure; sqlCommand.Parameters.Add(AddParameter("@ToolCode", SsDbType.Decimal, ParameterDirection.Input, Convert.ToInt32(model.ToolCode))); sqlCommand.Parameters.Add(AddParameter("@Description", SsDbType.VarChar, ParameterDirection.Input, model.Description)); sqlCommand.Parameters.Add(AddParameter("@UpdatedBy", SsDbType.UniqueIdentifier, ParameterDirection.Input, new Guid())); sqlCommand.Parameters.Add(AddParameter("@UpdatedDateTime", SsDbType.DateTime, ParameterDirection.Input, DateTime.UtcNow)); sqlCommand.ExecuteNonQuery(); } }